BOX4 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Finance / Box Definition - Contra Accounts of Accounts

API BOX4

BOX4 - Box Definition - Contra Accounts of Accounts Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
ReportType	Report Type	VarChar	B) S)	1		B
EffecDate	Effective From	Date		8
BoxCode ^KEY ^UNIQUE	Group Code	nVarChar		30			PRIMARY	Yes
Account	Account	nVarChar		15
ContraAct	Offset Account	nVarChar		15
SeqNum	Sequence Number	Int		11
BosCode	Box Set Code	Int		11	OBOS Box Set Definition

SELECT statement

SELECT
   BOX4.ReportType AS 'Report Type', 
   BOX4.EffecDate AS 'Effective From', 
   BOX4.BoxCode AS 'Group Code', 
   BOX4.Account AS 'Account', 
   BOX4.ContraAct AS 'Offset Account', 
   BOX4.SeqNum AS 'Sequence Number', 
   BOX4.BosCode AS 'Box Set Code'
FROM BOX4 AS BOX4

Related information

OBOS SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates