|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bin Location - History
Table Name: ABIN
Table Description: Bin Location - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| BinCode | Bin Location Code | nVarChar | 228 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| SysBin | System Bin | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SL1Abs | Sublevel-1 Internal Number | Int | 11 | OBSL | Â | Â | Â |
| SL1Code | Sublevel-1 Code | nVarChar | 50 | - | Â | Â | Â |
| SL2Abs | Sublevel-2 Internal Number | Int | 11 | OBSL | Â | Â | Â |
| SL2Code | Sublevel-2 Code | nVarChar | 50 | - | Â | Â | Â |
| SL3Abs | Sublevel-3 Internal Number | Int | 11 | OBSL | Â | Â | Â |
| SL3Code | Sublevel-3 Code | nVarChar | 50 | - | Â | Â | Â |
| SL4Abs | Sublevel-4 Internal Number | Int | 11 | OBSL | Â | Â | Â |
| SL4Code | Sublevel-4 Code | nVarChar | 50 | - | Â | Â | Â |
| Attr1Abs | Attribute-1 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr1Val | Attribute-1 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr2Abs | Attribute-2 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr2Val | Attribute-2 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr3Abs | Attribute-3 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr3Val | Attribute-3 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr4Abs | Attribute-4 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr4Val | Attribute-4 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr5Abs | Attribute-5 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr5Val | Attribute-5 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr6Abs | Attribute-6 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr6Val | Attribute-6 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr7Abs | Attribute-7 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr7Val | Attribute-7 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr8Abs | Attribute-8 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr8Val | Attribute-8 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr9Abs | Attribute-9 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr9Val | Attribute-9 Value | nVarChar | 20 | - | Â | Â | Â |
| Attr10Abs | Attribute-10 Internal Number | Int | 11 | OBAT | Â | Â | Â |
| Attr10Val | Attribute-10 Value | nVarChar | 20 | - | Â | Â | Â |
| Disabled | Inactive | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Descr | Description | nVarChar | 50 | - | Â | Â | Â |
| BarCode | Bar Code | nVarChar | 100 | - | Â | Â | Â |
| AltSortCod | Alternative Sort Code | nVarChar | 50 | - | Â | Â | Â |
| ItmRtrictT | Item Restriction Type | Int | 6 | - | 0 | 0 | None |
| Â | Â | Â | Â | Â | Â | 1 | Specific Item |
| Â | Â | Â | Â | Â | Â | 2 | Single Item Only |
| Â | Â | Â | Â | Â | Â | 3 | Specific Item Group |
| Â | Â | Â | Â | Â | Â | 4 | Single Item Group Only |
| SpcItmCode | Specific Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| SpcItmGrpC | Specific Item Group Code | Int | 6 | OITB | Â | Â | Â |
| SngBatch | Batch Restriction | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | Y | Single Batch |
| RtrictType | Restricted Transactions Type | Int | 6 | - | 0 | 0 | None |
| Â | Â | Â | Â | Â | Â | 1 | All Transactions |
| Â | Â | Â | Â | Â | Â | 2 | Inbound Transactions |
| Â | Â | Â | Â | Â | Â | 3 | Outbound Transactions |
| Â | Â | Â | Â | Â | Â | 4 | All Except Inventory Transfer and Counting Transactions |
| RtrictResn | Reason for Restriction | nVarChar | 254 | - | Â | Â | Â |
| RtrictDate | Last Updated On | Date | 8 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Transfered | Year Transfer [Y/N] | VarChar | 1 | - | N | Â | Â |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| Deleted | Deleted | VarChar | 1 | - | N | Â | Â |
| MinLevel | Minimum Qty | Num | 19.6 | - | Â | Â | Â |
| MaxLevel | Maximum Qty | Num | 19.6 | - | Â | Â | Â |
| ReceiveBin | Receiving Bin Location | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| NoAutoAllc | Excl. fr. Auto Alloc. on Issue | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MaxWeight1 | Maximum Weight 1 | Num | 19.6 | - | Â | Â | Â |
| Wght1Unit | Unit of Maximum Weight 1 | Int | 6 | OWGT | Â | Â | Â |
| MaxWeight2 | Maximum Weight 2 | Num | 19.6 | - | Â | Â | Â |
| Wght2Unit | Unit of Maximum Weight 2 | Int | 6 | OWGT | Â | Â | Â |
| UoMRtrict | UoM Restriction | Int | 6 | - | 0 | 0 | None |
| Â | Â | Â | Â | Â | Â | 1 | Specific UoM |
| Â | Â | Â | Â | Â | Â | 2 | Single UoM Only |
| Â | Â | Â | Â | Â | Â | 3 | Specific UoM Group |
| Â | Â | Â | Â | Â | Â | 4 | Single UoM Group Only |
| SpcUoMCode | Specified UoM Code | Int | 11 | OUOM | Â | Â | Â |
| SpcUGPCode | Specified UoM Group Code | Int | 11 | OUGP | Â | Â | Â |
| SngUoMCode | Single UoM Code | Int | 11 | OUOM | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |