|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Item - Bin Accumulator
Table Name: OIBQ
Table Description: Item - Bin Accumulator
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| BinAbs | Bin Internal Number | Int | 11 | OBIN | Â | Â | Â |
| OnHandQty | On-Hand Quantity | Num | 19.6 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| Freezed | Item Frozen in Bin Location | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FreezeDoc | Inventory Count Doc. Frozen By | Int | 11 | OINC | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| BUSINESS_K | Yes | ItemCode |
| Â | Â | BinAbs |
| BIN_ABS | No | BinAbs |