|
|
DTW Inventory / Bin Locations / Bin Location
API Bin Locations Service / Bin Location
OBIN - Bin Location Table
Bin Location BinLocation Object· Table: OBIN
Parent: Bin Locations Service BinLocationsService Service· Table: OBIN
Bin Locations Service BinLocationsService Service· Table: OBIN
OBIN SQL Table
Bin Location Attribute OBAT SQL Table
Warehouse Sublevel OBSL SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
Users OUSR SQL Table
Weight Units OWGT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BinCode KEY UNIQUE | Bin Location Code | nVarChar | 127 | BIN_CODE | Yes | |||
| WhsCode KEY | Warehouse Code | nVarChar | 8 | OWHS Warehouses | BUSINESS_K | No | ||
| SysBin | System Bin | VarChar | Y) Yes N) No | 1 | N | |||
| SL1Abs | Sublevel-1 Internal Number | Int | 11 | OBSL Warehouse Sublevel | ||||
| SL1Code | Sublevel-1 Code | nVarChar | 50 | |||||
| SL2Abs | Sublevel-2 Internal Number | Int | 11 | OBSL Warehouse Sublevel | ||||
| SL2Code | Sublevel-2 Code | nVarChar | 50 | |||||
| SL3Abs | Sublevel-3 Internal Number | Int | 11 | OBSL Warehouse Sublevel | ||||
| SL3Code | Sublevel-3 Code | nVarChar | 50 | |||||
| SL4Abs | Sublevel-4 Internal Number | Int | 11 | OBSL Warehouse Sublevel | ||||
| SL4Code | Sublevel-4 Code | nVarChar | 50 | |||||
| Attr1Abs | Attribute-1 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr1Val | Attribute-1 Value | nVarChar | 20 | |||||
| Attr2Abs | Attribute-2 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr2Val | Attribute-2 Value | nVarChar | 20 | |||||
| Attr3Abs | Attribute-3 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr3Val | Attribute-3 Value | nVarChar | 20 | |||||
| Attr4Abs | Attribute-4 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr4Val | Attribute-4 Value | nVarChar | 20 | |||||
| Attr5Abs | Attribute-5 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr5Val | Attribute-5 Value | nVarChar | 20 | |||||
| Attr6Abs | Attribute-6 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr6Val | Attribute-6 Value | nVarChar | 20 | |||||
| Attr7Abs | Attribute-7 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr7Val | Attribute-7 Value | nVarChar | 20 | |||||
| Attr8Abs | Attribute-8 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr8Val | Attribute-8 Value | nVarChar | 20 | |||||
| Attr9Abs | Attribute-9 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr9Val | Attribute-9 Value | nVarChar | 20 | |||||
| Attr10Abs | Attribute-10 Internal Number | Int | 11 | OBAT Bin Location Attribute | ||||
| Attr10Val | Attribute-10 Value | nVarChar | 20 | |||||
| Disabled | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| Descr | Description | nVarChar | 50 | |||||
| BarCode | Bar Code | nVarChar | 100 | |||||
| AltSortCod | Alternative Sort Code | nVarChar | 50 | |||||
| ItmRtrictT | Item Restriction Type | Int | 0 1) Specific Item 2) Single Item Only 3) Specific Item Group 4) Single Item Group Only | 6 | 0 | |||
| SpcItmCode | Specific Item Code | nVarChar | 20 | OITM Items | ||||
| SpcItmGrpC | Specific Item Group Code | Int | 6 | OITB Item Groups | ||||
| SngBatch | Batch Restriction | VarChar | N) None Y) Single Batch | 1 | N | |||
| RtrictType | Restricted Transactions Type | Int | 0 1) All Transactions 2) Inbound Transactions 3) Outbound Transactions 4) All Except Inventory Transfer and Counting Transactions | 6 | 0 | |||
| RtrictResn | Reason for Restriction | nVarChar | 127 | |||||
| RtrictDate | Last Updated On | Date | 8 | |||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| 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 Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| Deleted | Deleted | VarChar | 1 | N | ||||
| MinLevel | Minimum Qty | Num | 20 | |||||
| MaxLevel | Maximum Qty | Num | 20 | |||||
| ReceiveBin | Receiving Bin Location | VarChar | Y) Yes N) No | 1 | N | |||
| NoAutoAllc | Excl. fr. Auto Alloc. on Issue | VarChar | Y) Yes N) No | 1 | N | |||
| MaxWeight1 | Maximum Weight 1 | Num | 20 | |||||
| Wght1Unit | Unit of Maximum Weight 1 | Int | 6 | OWGT Weight Units | ||||
| MaxWeight2 | Maximum Weight 2 | Num | 20 | |||||
| Wght2Unit | Unit of Maximum Weight 2 | Int | 6 | OWGT Weight Units |
Table relationship map
SELECT statement
SELECT
OBIN.AbsEntry AS 'Internal Number',
OBIN.BinCode AS 'Bin Location Code',
OBIN.WhsCode AS 'Warehouse Code',
OBIN.SysBin AS 'System Bin',
OBIN.SL1Abs AS 'Sublevel-1 Internal Number',
OBIN.SL1Code AS 'Sublevel-1 Code',
OBIN.SL2Abs AS 'Sublevel-2 Internal Number',
OBIN.SL2Code AS 'Sublevel-2 Code',
OBIN.SL3Abs AS 'Sublevel-3 Internal Number',
OBIN.SL3Code AS 'Sublevel-3 Code',
OBIN.SL4Abs AS 'Sublevel-4 Internal Number',
OBIN.SL4Code AS 'Sublevel-4 Code',
OBIN.Attr1Abs AS 'Attribute-1 Internal Number',
OBIN.Attr1Val AS 'Attribute-1 Value',
OBIN.Attr2Abs AS 'Attribute-2 Internal Number',
OBIN.Attr2Val AS 'Attribute-2 Value',
OBIN.Attr3Abs AS 'Attribute-3 Internal Number',
OBIN.Attr3Val AS 'Attribute-3 Value',
OBIN.Attr4Abs AS 'Attribute-4 Internal Number',
OBIN.Attr4Val AS 'Attribute-4 Value',
OBIN.Attr5Abs AS 'Attribute-5 Internal Number',
OBIN.Attr5Val AS 'Attribute-5 Value',
OBIN.Attr6Abs AS 'Attribute-6 Internal Number',
OBIN.Attr6Val AS 'Attribute-6 Value',
OBIN.Attr7Abs AS 'Attribute-7 Internal Number',
OBIN.Attr7Val AS 'Attribute-7 Value',
OBIN.Attr8Abs AS 'Attribute-8 Internal Number',
OBIN.Attr8Val AS 'Attribute-8 Value',
OBIN.Attr9Abs AS 'Attribute-9 Internal Number',
OBIN.Attr9Val AS 'Attribute-9 Value',
OBIN.Attr10Abs AS 'Attribute-10 Internal Number',
OBIN.Attr10Val AS 'Attribute-10 Value',
OBIN.Disabled AS 'Inactive',
OBIN.Descr AS 'Description',
OBIN.BarCode AS 'Bar Code',
OBIN.AltSortCod AS 'Alternative Sort Code',
OBIN.ItmRtrictT AS 'Item Restriction Type',
OBIN.SpcItmCode AS 'Specific Item Code',
OBIN.SpcItmGrpC AS 'Specific Item Group Code',
OBIN.SngBatch AS 'Batch Restriction',
OBIN.RtrictType AS 'Restricted Transactions Type',
OBIN.RtrictResn AS 'Reason for Restriction',
OBIN.RtrictDate AS 'Last Updated On',
OBIN.DataSource AS 'Data Source',
OBIN.UserSign AS 'User Signature',
OBIN.Transfered AS 'Year Transfer [Y/N]',
OBIN.Instance AS 'Instance',
OBIN.LogInstanc AS 'Log Instance',
OBIN.CreateDate AS 'Create Date',
OBIN.UserSign2 AS 'Updating User',
OBIN.UpdateDate AS 'Date of Update',
OBIN.Deleted AS 'Deleted',
OBIN.MinLevel AS 'Minimum Qty',
OBIN.MaxLevel AS 'Maximum Qty',
OBIN.ReceiveBin AS 'Receiving Bin Location',
OBIN.NoAutoAllc AS 'Excl. fr. Auto Alloc. on Issue',
OBIN.MaxWeight1 AS 'Maximum Weight 1',
OBIN.Wght1Unit AS 'Unit of Maximum Weight 1',
OBIN.MaxWeight2 AS 'Maximum Weight 2',
OBIN.Wght2Unit AS 'Unit of Maximum Weight 2'
FROM OBIN AS OBIN
Related information
Bin Location BinLocation Object· Table: OBIN
A bin location is the smallest addressable unit of space in a warehouse where your goods are stored.
To facilitate bin location management, SAP Business One lets you maintain a master data record for each bin location.
Source table: OBIN.
Parent: Bin Locations Service BinLocationsService Service· Table: OBIN Bin Locations Service BinLocationsService Service· Table: OBIN
The BinLocationsService service enables you to add, look up, update, and remove bin locations.
Source table: OBIN.
OBIN SQL Table
Bin Location Attribute OBAT SQL Table
Warehouse Sublevel OBSL SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
Users OUSR SQL Table
Weight Units OWGT SQL Table
BinLocationsService
Object
BinLocation
Enumeration
Method
Property
AbsEntry
DTW DB
AlternativeSortCode
DTW DB
Attribute1
DTW DB
Attribute10
DTW DB
Attribute2
DTW DB
Attribute3
DTW DB
Attribute4
DTW DB
Attribute5
DTW DB
Attribute6
DTW DB
Attribute7
DTW DB
Attribute8
DTW DB
Attribute9
DTW DB
BarCode
DTW DB
BatchRestrictions
DTW DB
BinCode
DTW DB
DateRestrictionChanged
DTW DB
Description
DTW DB
Inactive
DTW DB
IsSystemBin
DTW DB
MaximumQty
DTW DB
MinimumQty
DTW DB
ReceivingBinLocation
DTW DB
RestrictedItemType
DTW DB
RestrictedTransType
DTW DB
RestrictionReason
DTW DB
SpecificItem
DTW DB
SpecificItemGroup
DTW DB
Sublevel1
DTW DB
Sublevel2
DTW DB
Sublevel3
DTW DB
Sublevel4
DTW DB
Warehouse
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
