Home > Technical > Table Definitions > REQUIREDSTOCKDTL

REQUIREDSTOCKDTL

Column Type Description

LINTSTOCKCODE

INT(4)

 

CTRCODE

INT(4)

 

LINTITEMNUMBER

INT(4)

 

STRORDER

VARCHAR(10)

 

DBLQUANTITY

DECIMAL9(19,4)

 

DBLCARTONS

DECIMAL9(19,4)

 

DBLACTUALQTY

DECIMAL9(19,4)

 

DBLACTUALCARTONS

DECIMAL9(19,4)

 

DBLMINQTY

DECIMAL9(19,4)

 

DBLREQUIREDQTY

DECIMAL9(19,4)

 

STRORDERMETHOD

VARCHAR(10)

 

STRSUPPLIERCODE

VARCHAR(10)

 

YSNORDERED

VARCHAR(1)

 

YSNREORDERED

VARCHAR(1)

 

DBLSTOCKONHAND

DECIMAL9(19,4)

 

DBLORDEREDQTY

DECIMAL9(19,4)

 

DBLALLOCATEDQTY

DECIMAL9(19,4)

 

DBLRETURNEDQTY

DECIMAL9(19,4)

 

DBLINTRANSITQTY

DECIMAL9(19,4)

 

DBLMINSTOCKQTY

DECIMAL9(19,4)

 

DBLMAXSTOCKQTY

DECIMAL9(19,4)

 

DBLREORDERQTY

DECIMAL9(19,4)

 

STRSOURCE

VARCHAR(5)

 

LINTREFERENCE

INT(4)

 

DBLCARTONSIZE

DECIMAL9(19,4)

 

DBLMINORDER

DECIMAL9(19,4)

 

STRORDERCODE

VARCHAR(20)

 

DBLRATEOFSALE

DECIMAL9(19,4)

 

DBLMINSTOCKCOVER

DECIMAL9(19,4)

 

DBLMAXSTOCKCOVER

DECIMAL9(19,4)

 

STRTRANSFERTRADECODE

VARCHAR(10)

 

DBLREQUESTEDQTY

DECIMAL9(19,6)

 

DBLSPECIALORDERQTY

DECIMAL9(19,6)

 

 

Primary Key: LINTSTOCKCODE + LINTITEMNUMBER

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)