|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bin Allocation Data - History
Table Name: ADO19
Table Description: Bin Allocation Data - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | ADOC | Â | Â | Â |
| BinAllocSe | Bin Allocation Sequence | Int | 11 | - | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| SubLineNum | Subline Number | Int | 11 | - | -1 | Â | Â |
| SnBType | SnB Type | Int | 11 | - | -1 | Â | Â |
| SnBMDAbs | SnB Master Data Internal No. | Int | 11 | - | -1 | Â | Â |
| BinAbs | Bin Internal Number | Int | 11 | OBIN | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| AllowNeg | Allow Negative Entry [Y/N] | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BinActTyp | Bin Action Type | Int | 6 | - | Â | 1 | Transaction In |
| Â | Â | Â | Â | Â | Â | 2 | Transaction Out |
| Â | Â | Â | Â | Â | Â | 4 | SnB Complete |
| Â | Â | Â | Â | Â | Â | 8 | Bin First Then SnB |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | BinAllocSe |
| Â | Â | LogInstanc |
| Â | Â | ObjType |