|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GBI Row 7 - Accounting Vouchers
Table Name: GBI7
Table Description: GBI Row 7 - Accounting Vouchers
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| HistoryId | History Key | Int | 11 | OGBI | Â | Â | Â |
| 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 | 19.6 | - | Â | Â | Â |
| Credit | Credit Amount | Num | 19.6 | - | Â | Â | Â |
| FCDebit | Debit Foreign Currency Amount | Num | 19.6 | - | Â | Â | Â |
| FCCredit | Credit Foreign Currency Amount | Num | 19.6 | - | Â | Â | Â |
| Rate | Exchange Rate | Num | 19.6 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| UnitPrice | Unit Price | Num | 19.6 | - | Â | Â | Â |
| EvaGrp | Evaluation Group | nVarChar | 254 | - | Â | Â | Â |
| 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 | 155 | - | Â | Â | Â |
| Approver | Approver of the Voucher | nVarChar | 155 | - | Â | Â | Â |
| Bookkeeper | Bookkeeper | nVarChar | 155 | - | Â | Â | Â |
| Cashier | Cashier | nVarChar | 155 | - | Â | Â | Â |
| Posted | Posted Sign | VarChar | 1 | - | 1 | 1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Reversed | Reversed Sign | VarChar | 1 | - | 0 | 1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| DocNum | Document Number | nVarChar | 20 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | HistoryId |
| Â | Â | RowId |