📚 SAP Business One SDK Help

Table Name: OBIN

Table Description: Bin Location

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
BIN_CODE Yes BinCode
WHS_CODE No WhsCode
    SysBin
BUSINESS_K No WhsCode
    SL1Code
    SL2Code
    SL3Code
    SL4Code