Support beas bin location (BEAS_WHSBINxxx tables) and SAP Bin Location (OBIN/OBQx) and boyum WMS solution
It is not possible to return Bin Location from different Warehouses in one command, because the backend sql
command is related to used warehouse
Property
Description
Table
BEAS_DUMMY
Primary key
WhsCode/c,BinCode/c Mandatory: WhsCode
$transaction
no
$branch
no
$mask
For dropdown you can use follow mask definition:
1: BinCode,AreaCode,FirstItemCode,FirstItemCodeOnHand,BinColor
2: BinCode,FirstItemCode,VolumePercent,BinColor
3: BinCode,FirstItemCode,WeightPercent,BinColor
OBIN.BinCode
(with WareHouse Code + All Sub Levels)
Internal BinCode
BEAS_BIN.BINCODE
OBIN.AbsEntry
Default Bin
OBIN.SysBin Y/N
Description
BEAS_BIN.INFO
OBIN.Descr
Barcode
BEAS_BIN.BINCODE
OBIN.Barcode
Deleted
'N'
OBIN.Deleted
IssueSort
BEAS_BIN.REMOVESORT
Related to OWHS.AutoIssMtd
0=SingleChoice
1=Bin Location Code Order
2=Alternative Sort Code Order OBIN.AltSortCod
3=Descenging Quantity
4=Ascending Quantity
7=Ascending Quantity - Single Bin Prefered
5=Fifo
6=Liwo
ReceiptSort
BEAS_BIN.STORAGESORT
Related to OIWHS.AutoRecvMd
0=Default Bin Location
1=Item's current Bin Locations
2=Items Current and Historical Bin Locations
Receive up to Max Qty RecVMaxQty.
Attention: Default locations have higher priority.
From the three default bin locations, the priority is set as follows:
Default Bin Location of the Item > Default Bin Location of the Item Group > Default Bin Location of the Warehouse
Therefore, if you have specified a default bin location for the item or item group, the enforced default bin location on the warehouse level is not in effect.