DIH Warehouse Bin Location - bin definition

Warehouse bin location definition

Edit bin location definition

BEAS_WHSBIN

Field

Name

M

Type

Description

WhsCode

Warehouse code

X

nchar(8)

Linked to this warehouse

AREACODE

Area code

X

nchar(20)

BINCODE

Bin Location

X

nchar(20)

Unique key for the bin

INFO

Info

nvarchar(255)

DIMENSION1

Dimension 1

nvarchar(20)

DIMENSION2

Dimension 2

nvarchar(20)

DIMENSION3

Dimension 3

nvarchar(20)

DIMENSION4

Dimension 4

nvarchar(20)

LENGTH_IN_M

Length in m

numeric(4)

HEIGHT_IN_M

Height in m

numeric(4)

WIDTH_IN_M

Width in m

numeric(4)

REMOVELOCKED

Block withdraw

nchar(1)

 
Valid values: Yes=J
No=N

STORAGELOCKED

Block storage

nchar(1)

 
Valid values: Yes=J
No=N

REMOVESORT

Withdrawal sorting

nchar(20)

STORAGESORT

Storage sorting

nchar(20)

BINWEIGHT

Max. Wieight in Kg.

numeric(4)

BINVOLUME

Ma. Volume in dm3

numeric(4)

Color

Color

int(4)

POS_X_IN_M

Position X in m - Viewed from lower left

numeric(4)

POS_Y_IN_M

Position Y in m - Viewed from lower left

numeric(4)

POS_LENGTH_IN_M

View Length in m

numeric(4)

POS_HEIGHT_IN_M

View Height in m

numeric(4)

COLORRULE

color rule

int(4)

 
Valid values: Weight in % ..50 green, ,,80 yello, 81... red=1
green:empty, red:on stock=0
 
 

DELETEFLAG

Deleted

nchar(1)

Entry marked as deleted
Valid values: No=N
Yes=J

UDF1

Userfield 1

nvarchar(50)

UDF2

Userfield 2

nvarchar(50)

UDF3

Userfield 3

nvarchar(50)

UDF4

Userfield 4

nvarchar(50)