biuan SAP® BUSINESS ONE SDK
API BOX1
BOX1 - Box Definition - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BoxCode KEY UNIQUEGroup CodenVarChar
30
PRIMARYYes
BoxMemberBox CodenVarChar
30OBOX
Box Definition
VATMemberVAT GroupnVarChar
8OVTG
Tax Definition
SeqNumSequence NumberInt
11
FormulSignFormula SignVarChar
P) +
M) -
1
P
ReportTypeReport TypeVarChar
B) Box Declaration
S) BAS Reporting
1
B
EffecDateEffective FromDate
8
TaxTypeAcquisition / Reverse Tax TypeVarChar
I) Input Tax
O) Output Tax
B) Input Tax and Output Tax
1
B
BosCodeBox Set CodeInt
11OBOS
Box Set Definition

Table relationship map

SELECT statement

SELECT BOX1.BoxCode AS 'Group Code', BOX1.BoxMember AS 'Box Code', BOX1.VATMember AS 'VAT Group', BOX1.SeqNum AS 'Sequence Number', BOX1.FormulSign AS 'Formula Sign', BOX1.ReportType AS 'Report Type', BOX1.EffecDate AS 'Effective From', BOX1.TaxType AS 'Acquisition / Reverse Tax Type', BOX1.BosCode AS 'Box Set Code' FROM BOX1 AS BOX1

Related information


Box Set Definition OBOS SQL Table

Box Definition OBOX SQL Table

Tax Definition OVTG 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