BinLocation

Bin Location

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
 

 

Fields

Name

Type

Description

WhsCode

Edm.String(20)

Entity Relation: WareHouse -> WhsCode

Database: '01'

AreaCode

Edm.String(20)

beas: Area Code (BEAS_WHSAREA)

SAP: 1

WMS: Zone

Database: '1'

BinCode

Edm.String(228)

Bin Location Code (visible code)

Database: '1'

InternalBinCode

Edm.String(20)

Database: '1'

BinName

Edm.String(100)

Database: ''

Dimension1

Edm.String(20)

Description Dimension 1...4

beas: Defined in Warehouse Area (BEAS_WHSAREA)

SAP: Defined in SETUP -> Inventory - BinLocaton -> Warehouse Sublevels

Database: ''

Dimension2

Edm.String(20)

Database: ''

Dimension3

Edm.String(20)

Database: ''

Dimension4

Edm.String(20)

Database: ''

IssueLocked

Edm.Boolean

Database: 0

ReceiptLocked

Edm.Boolean

Database: 0

IssueSort

Edm.String(10)

Database: ''

ReceiptSort

Edm.String(10)

Database: ''

BinColor

Edm.Int32

Database: 0

Active

Edm.Decimal

Database: 'Y'

OnHand

Edm.Decimal

Database: 0

FirstItemCode

Edm.String(50)

First item code on this Bin location

Database: ''

FirstItemCodeOnHand

Edm.Decimal

Stock of first Item on this Bin Location

beas use this for Dropdown $mask1

Database: 0

BinWeight

Edm.Decimal

Database: 0

BinVolume

Edm.Decimal

Database: 0

CurrentWeight

Edm.Decimal

Database: 0

CurrentVolume

Edm.Decimal

Database: 0

WeightPercent

Edm.Decimal

Database: 0

VolumePercent

Edm.Decimal

Database: 0

ItemCode

Edm.String(50)

Database:

 

Relations

Join to Entiy Object

Relation

WareHouseArea


WareHouse

WhsCode

 

 

hmtoggle_plus1Related Table Structure in background

 

Description

beas Whs

SAP Whs

Warehouse

BEAS_BIN.WhsCode

OBIN.WhsCode

Area / Zone

BEAS_BIN.AREACODE

1

Location

BEAS_BIN.BinCode

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.

 

IssueLocked

BEAS_BIN.REMOVELOCKED J/N


ReceiptLocked

BEAS_BIN.STORAGELOCKED J/N


Active

Y

OBIN.Disabled (N=Active)

MaxWeight

BEAS_BIN.BINWEIGHT

OBIN.MaxWeight1

MaxQuantity

0

OBIN.MaxLevel

MinQuantity

0

OBIN.MinLevel

RestrictedItemType


OBIN.ItmRtrictT

RestrictedTransType


OBIN.RtrictType

RestrictedUoMType


OBIN.??

RestrictionReason


OBIN.RtrictResn

SpecificItem


OBIN.SpcItmCode

SpecificItemGroup


OBIN.SpcItmGrpC

SpecificUoM


OBIN.SpecificUoMGroup

SpecificUoMGroup


OBIN.SpecificUoMGroup