biuan SAP® BUSINESS ONE SDK
API BOX4
BOX4 - Box Definition - Contra Accounts of Accounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ReportTypeReport TypeVarChar
B)
S)
1
B
EffecDateEffective FromDate
8
BoxCode KEY UNIQUEGroup CodenVarChar
30
PRIMARYYes
AccountAccountnVarChar
15
ContraActOffset AccountnVarChar
15
SeqNumSequence NumberInt
11
BosCodeBox Set CodeInt
11OBOS
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


Box Set Definition OBOS SQL Table



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