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)

AreaCode

Edm.String(20)

BinCode

Edm.String(228)

InternalBinCode

Edm.String(20)

BinName

Edm.String(100)

Dimension1

Edm.String(20)

Dimension2

Edm.String(20)

Dimension3

Edm.String(20)

Dimension4

Edm.String(20)

IssueLocked

Edm.Boolean

ReceiptLocked

Edm.Boolean

IssueSort

Edm.String(10)

ReceiptSort

Edm.String(10)

BinColor

Edm.Int32

Active

Edm.Decimal

OnHand

Edm.Decimal

FirstItemCode

Edm.String(50)

FirstItemCodeOnHand

Edm.Decimal

BinWeight

Edm.Decimal

BinVolume

Edm.Decimal

CurrentWeight

Edm.Decimal

CurrentVolume

Edm.Decimal

WeightPercent

Edm.Decimal

VolumePercent

Edm.Decimal

ItemCode

Edm.String(50)

 

Relations

Join to Entiy Object

Relation

WareHouseArea


WareHouse

WhsCode

 

 

hmtoggle_plus1Related Table Structure in background