biuan SAP® BUSINESS ONE SDK
SQL Finance / GBI Row 1 - Electronic Account Book
API GBI1
GBI1 - GBI Row 1 - Electronic Account Book Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info		PRIMARYYes
RowIdRow NumberInt
11
AcctBkNoElectronic Account Book No.nVarChar
5
AcctBkNameElectronic Account Book NamenVarChar
30
OrgCodeOrganizational CodenVarChar
20
CompTypeCompany TypenVarChar
8
IndustryIndustrynVarChar
20
SoftVenderAccounting Software ProvidernVarChar
60
VersionAccounting Software VersionnVarChar
20
FisYearFiscal YearnVarChar
4
LocCurrLocal CurrencynVarChar
3
AcctStructAccount StructurenVarChar
30

SELECT statement

SELECT GBI1.HistoryId AS 'History Key', GBI1.RowId AS 'Row Number', GBI1.AcctBkNo AS 'Electronic Account Book No.', GBI1.AcctBkName AS 'Electronic Account Book Name', GBI1.OrgCode AS 'Organizational Code', GBI1.CompType AS 'Company Type', GBI1.Industry AS 'Industry', GBI1.SoftVender AS 'Accounting Software Provider', GBI1.Version AS 'Accounting Software Version', GBI1.FisYear AS 'Fiscal Year', GBI1.LocCurr AS 'Local Currency', GBI1.AcctStruct AS 'Account Structure' FROM GBI1 AS GBI1

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