biuan SAP® BUSINESS ONE SDK
API OBOX
OBOX - Box Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BoxCode KEY UNIQUECodenVarChar
30
PRIMARYYes
BoxNameNamenVarChar
127
BoxTypeTypeVarChar
V) VAT Group
B) Box
A) Account
M) Manual Input
T) Manual Text Input
F) Formula
S) Single Choice
1
V
SummayFldSummary FieldVarChar
B) Base Amount
T) Tax Amount
Q) EQ Base Amount
E) EQ Tax Amount
N) Non-Deductible Amount
S)
1
S
DbtCrdtDebit/CreditVarChar
D) Debit Side
C) Credit Side
B) Debit Side and Credit Side
S)
1
S
FormulaFormula SyntaxnVarChar
127
SortOrderSort OrderInt
11
AbsolutVaAbsolute ValueVarChar
Y) Yes
N) No
1
N
ReportTypeReport TypeVarChar
B) Box Declaration
S) BAS Report
X) BAS Report - Empty Effective Date Holder
1
B
InactiveInactiveVarChar
Y) Yes
N) No
1
N
EffecDateEffective FromDate
8
DecLocDeclaration LocationVarChar
B)
C) Continent
M) Madeira
A) Azores
1
B
BosCodeBox Set CodeInt
11OBOS
Box Set Definition
PositionPosition in ReportnVarChar
127
PostToActPost-To AccountnVarChar
15OACT
G/L Accounts
PostToOffAPost-To Offset AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OBOX.BoxCode AS 'Code', OBOX.BoxName AS 'Name', OBOX.BoxType AS 'Type', OBOX.SummayFld AS 'Summary Field', OBOX.DbtCrdt AS 'Debit/Credit', OBOX.Formula AS 'Formula Syntax', OBOX.SortOrder AS 'Sort Order', OBOX.AbsolutVa AS 'Absolute Value', OBOX.ReportType AS 'Report Type', OBOX.Inactive AS 'Inactive', OBOX.EffecDate AS 'Effective From', OBOX.DecLoc AS 'Declaration Location', OBOX.BosCode AS 'Box Set Code', OBOX.Position AS 'Position in Report', OBOX.PostToAct AS 'Post-To Account', OBOX.PostToOffA AS 'Post-To Offset Account' FROM OBOX AS OBOX

Related information


OBOX SQL Table

Box Set Definition OBOS SQL Table

G/L Accounts OACT SQL Table



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