biuan SAP® BUSINESS ONE SDK
API BOX2
BOX2 - Box Definition - Accounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BoxCode KEY UNIQUEGroup CodenVarChar
30
PRIMARYYes
ReportTypeReport TypeVarChar
B)
S)
1
B
AccountAccountnVarChar
15OACT
G/L Accounts
SeqNumSequence NumberInt
11
EffecDateEffective FromDate
8
BosCodeBox Set CodeInt
11OBOS
Box Set Definition

Table relationship map

SELECT statement

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

Related information


G/L Accounts OACT SQL Table

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