biuan SAP® BUSINESS ONE SDK
API GBI7
GBI7 - GBI Row 7 - Accounting Vouchers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
HistoryId KEY UNIQUEHistory KeyInt
11OGBI
GB Interface: Common Info
PRIMARYYes
RowIdRow NumberInt
11
DocDateDocument DatenVarChar
8
DocTypeDocument TypenVarChar
12
JrnEntryNoJournal Entry NumbernVarChar
20
LnNoLine NumberInt
11
RemarkDetails of Each LinenVarChar
50
AcctNoG/L Account NumbernVarChar
15
CurrencyTransaction CurrencynVarChar
3
DebitDebit AmountNum
20
CreditCredit AmountNum
20
FCDebitDebit Foreign Currency AmountNum
20
FCCreditCredit Foreign Currency AmountNum
20
RateExchange RateNum
20
QuantityQuantityNum
20
UnitPriceUnit PriceNum
20
EvaGrpEvaluation GroupnVarChar
127
SettMethSettlement MethodnVarChar
20
BillTypeBill TypenVarChar
20
BillNoBill NumbernVarChar
30
BillDateBill DatenVarChar
8
AttmtNumNumber of AttachmentsInt
6
CreatorCreator of the VouchernVarChar
127
ApproverApprover of the VouchernVarChar
127
BookkeeperBookkeepernVarChar
127
CashierCashiernVarChar
127
PostedPosted SignVarChar
1)
0
1
1
ReversedReversed SignVarChar
1)
0
1
0
DocNumDocument NumbernVarChar
20

SELECT statement

SELECT GBI7.HistoryId AS 'History Key', GBI7.RowId AS 'Row Number', GBI7.DocDate AS 'Document Date', GBI7.DocType AS 'Document Type', GBI7.JrnEntryNo AS 'Journal Entry Number', GBI7.LnNo AS 'Line Number', GBI7.Remark AS 'Details of Each Line', GBI7.AcctNo AS 'G/L Account Number', GBI7.Currency AS 'Transaction Currency', GBI7.Debit AS 'Debit Amount', GBI7.Credit AS 'Credit Amount', GBI7.FCDebit AS 'Debit Foreign Currency Amount', GBI7.FCCredit AS 'Credit Foreign Currency Amount', GBI7.Rate AS 'Exchange Rate', GBI7.Quantity AS 'Quantity', GBI7.UnitPrice AS 'Unit Price', GBI7.EvaGrp AS 'Evaluation Group', GBI7.SettMeth AS 'Settlement Method', GBI7.BillType AS 'Bill Type', GBI7.BillNo AS 'Bill Number', GBI7.BillDate AS 'Bill Date', GBI7.AttmtNum AS 'Number of Attachments', GBI7.Creator AS 'Creator of the Voucher', GBI7.Approver AS 'Approver of the Voucher', GBI7.Bookkeeper AS 'Bookkeeper', GBI7.Cashier AS 'Cashier', GBI7.Posted AS 'Posted Sign', GBI7.Reversed AS 'Reversed Sign', GBI7.DocNum AS 'Document Number' FROM GBI7 AS GBI7

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