|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Opening Balance Instances
Table Name: BAL1
Table Description: Opening Balance Instances
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| Instance | Instance | Int | 11 | - | Â | Â | Â |
| OBDate | Date of Opening Balance (first day of next fiscal period) | Date | 8 | - | Â | Â | Â |
| InAmount | Total Received Value | Num | 19.6 | - | Â | Â | Â |
| InQty | Total Received Quantity | Num | 19.6 | - | Â | Â | Â |
| OutQty | Total Issued Quantity | Num | 19.6 | - | Â | Â | Â |
| InAmntLWA | Last Non-zero Total Received Value | Num | 19.6 | - | Â | Â | Â |
| InQtyLWA | Last Non-zero Total Received Quantity | Num | 19.6 | - | Â | Â | Â |
| LastTrnsID | Last Transaction ID | Int | 11 | - | Â | Â | Â |
| WasPrevOB | OB from Start of Fiscal Year | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| CrossPRev | Cross Period Revaluation from Next Period | Num | 19.6 | - | Â | Â | Â |
| WasUpdPrCB | Update previous Closing Balance with cross period revaluations | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | Instance |