|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GBI Row 6 - G/L Account Balance
Table Name: GBI6
Table Description: GBI Row 6 - G/L Account Balance
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| HistoryId | History Key | Int | 11 | OGBI | Â | Â | Â |
| RowId | Row Number | Int | 11 | - | Â | Â | Â |
| AcctCode | Account Code | nVarChar | 15 | - | Â | Â | Â |
| Currency | Account Currency | nVarChar | 3 | - | Â | Â | Â |
| EvalGrp | Group for Calculating | nVarChar | 254 | - | Â | Â | Â |
| PerBBal | Period Begin Balance | Num | 19.6 | - | Â | Â | Â |
| PerBQty | Period Begin Quantity | Num | 19.6 | - | Â | Â | Â |
| PerBFCBal | Period Begin FC Balance | Num | 19.6 | - | Â | Â | Â |
| CPDAmt | Current Period Debit Amount | Num | 19.6 | - | Â | Â | Â |
| CPDQty | Current Period Debit Quantity | Num | 19.6 | - | Â | Â | Â |
| CPDFCAmt | Current Period Debit FC Amount | Num | 19.6 | - | Â | Â | Â |
| CPCAmt | Current Period Credit Amount | Num | 19.6 | - | Â | Â | Â |
| CPCQty | Current Period Credit Quantity | Num | 19.6 | - | Â | Â | Â |
| CPCFCAmt | Current Period Credit FC Amnt | Num | 19.6 | - | Â | Â | Â |
| PerEBal | Period End Balance | Num | 19.6 | - | Â | Â | Â |
| PerEQty | Period End Quantity | Num | 19.6 | - | Â | Â | Â |
| PerEFCBal | Period End FC Balance | Num | 19.6 | - | Â | Â | Â |
| AcctPeriod | Fiscal Month | nVarChar | 2 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | HistoryId |
| Â | Â | RowId |