biuan SAP® BUSINESS ONE SDK
API GBI2
GBI2 - GBI Row 2 - G/L Account Master Records Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info
PRIMARYYes
RowIdRow NumberInt
11
AcctCodeAccount CodenVarChar
15
AcctNameAccount NamenVarChar
100
StrucLevelAccount Structure LevelInt
11
EvalSignEvaluation SignVarChar
1
AddFieldPossible Additional FieldsnVarChar
60
AcctTypeAccount TypenVarChar
20
MesurUnitMeasurement UnitnVarChar
10
BlDirectDirection of BalancenVarChar
4

SELECT statement

SELECT GBI2.HistoryId AS 'History Key', GBI2.RowId AS 'Row Number', GBI2.AcctCode AS 'Account Code', GBI2.AcctName AS 'Account Name', GBI2.StrucLevel AS 'Account Structure Level', GBI2.EvalSign AS 'Evaluation Sign', GBI2.AddField AS 'Possible Additional Fields', GBI2.AcctType AS 'Account Type', GBI2.MesurUnit AS 'Measurement Unit', GBI2.BlDirect AS 'Direction of Balance' FROM GBI2 AS GBI2

Related information


GB Interface: Common Info OGBI 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