|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Opening Balances
Table Name: OBAL
Table Description: Opening Balances
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| PeriodID | Period Indicator | Int | 11 | BAL2 | Â | Â | Â |
| EvalSystem | Valuation Method | VarChar | 1 | - | W | A | Moving Average |
| Â | Â | Â | Â | Â | Â | F | FIFO |
| Â | Â | Â | Â | Â | Â | W | Weighted Average |
| DtSorting | Date Sorting Method | VarChar | 1 | - | P | S | System Date |
| Â | Â | Â | Â | Â | Â | P | Posting Date |
| Â | Â | Â | Â | Â | Â | E | Effective Posting Date |
| LayerID | Layer ID | Int | 11 | - | -1 | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| SECONDARY | Yes | ItemCode |
| Â | Â | WhsCode |
| Â | Â | PeriodID |
| Â | Â | EvalSystem |
| Â | Â | DtSorting |
| Â | Â | LayerID |