|
|
API GBI7
GBI7 - GBI Row 7 - Accounting Vouchers Table
GB Interface: Common Info OGBI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | HistoryId KEY UNIQUE | History Key | Int | 11 | OGBI GB Interface: Common Info | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RowId | Row Number | Int | 11 | |||||
| DocDate | Document Date | nVarChar | 8 | |||||
| DocType | Document Type | nVarChar | 12 | |||||
| JrnEntryNo | Journal Entry Number | nVarChar | 20 | |||||
| LnNo | Line Number | Int | 11 | |||||
| Remark | Details of Each Line | nVarChar | 50 | |||||
| AcctNo | G/L Account Number | nVarChar | 15 | |||||
| Currency | Transaction Currency | nVarChar | 3 | |||||
| Debit | Debit Amount | Num | 20 | |||||
| Credit | Credit Amount | Num | 20 | |||||
| FCDebit | Debit Foreign Currency Amount | Num | 20 | |||||
| FCCredit | Credit Foreign Currency Amount | Num | 20 | |||||
| Rate | Exchange Rate | Num | 20 | |||||
| Quantity | Quantity | Num | 20 | |||||
| UnitPrice | Unit Price | Num | 20 | |||||
| EvaGrp | Evaluation Group | nVarChar | 127 | |||||
| SettMeth | Settlement Method | nVarChar | 20 | |||||
| BillType | Bill Type | nVarChar | 20 | |||||
| BillNo | Bill Number | nVarChar | 30 | |||||
| BillDate | Bill Date | nVarChar | 8 | |||||
| AttmtNum | Number of Attachments | Int | 6 | |||||
| Creator | Creator of the Voucher | nVarChar | 127 | |||||
| Approver | Approver of the Voucher | nVarChar | 127 | |||||
| Bookkeeper | Bookkeeper | nVarChar | 127 | |||||
| Cashier | Cashier | nVarChar | 127 | |||||
| Posted | Posted Sign | VarChar | 1) 0 | 1 | 1 | |||
| Reversed | Reversed Sign | VarChar | 1) 0 | 1 | 0 | |||
| DocNum | Document Number | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
