biuan SAP® BUSINESS ONE SDK
SQL Finance / GBI Row 6 - G/L Account Balance
API GBI6
GBI6 - GBI Row 6 - G/L Account Balance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info		PRIMARYYes
RowIdRow NumberInt
11
AcctCodeAccount CodenVarChar
15
CurrencyAccount CurrencynVarChar
3
EvalGrpGroup for CalculatingnVarChar
127
PerBBalPeriod Begin BalanceNum
20
PerBQtyPeriod Begin QuantityNum
20
PerBFCBalPeriod Begin FC BalanceNum
20
CPDAmtCurrent Period Debit AmountNum
20
CPDQtyCurrent Period Debit QuantityNum
20
CPDFCAmtCurrent Period Debit FC AmountNum
20
CPCAmtCurrent Period Credit AmountNum
20
CPCQtyCurrent Period Credit QuantityNum
20
CPCFCAmtCurrent Period Credit FC AmntNum
20
PerEBalPeriod End BalanceNum
20
PerEQtyPeriod End QuantityNum
20
PerEFCBalPeriod End FC BalanceNum
20
AcctPeriodFiscal MonthnVarChar
2

SELECT statement

SELECT GBI6.HistoryId AS 'History Key', GBI6.RowId AS 'Row Number', GBI6.AcctCode AS 'Account Code', GBI6.Currency AS 'Account Currency', GBI6.EvalGrp AS 'Group for Calculating', GBI6.PerBBal AS 'Period Begin Balance', GBI6.PerBQty AS 'Period Begin Quantity', GBI6.PerBFCBal AS 'Period Begin FC Balance', GBI6.CPDAmt AS 'Current Period Debit Amount', GBI6.CPDQty AS 'Current Period Debit Quantity', GBI6.CPDFCAmt AS 'Current Period Debit FC Amount', GBI6.CPCAmt AS 'Current Period Credit Amount', GBI6.CPCQty AS 'Current Period Credit Quantity', GBI6.CPCFCAmt AS 'Current Period Credit FC Amnt', GBI6.PerEBal AS 'Period End Balance', GBI6.PerEQty AS 'Period End Quantity', GBI6.PerEFCBal AS 'Period End FC Balance', GBI6.AcctPeriod AS 'Fiscal Month' FROM GBI6 AS GBI6

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates