Home > Technical > Table Definitions > STOCKBATCH

STOCKBATCH

Column Type Description

LINTITEMNUMBER

INT(4)

 

STRSTORECODE

VARCHAR(10)

 

STRGUID

VARCHAR(38)

 

STRSOURCE

VARCHAR(5)

 

LINTREFERENCE

BIGINT(8)

 

DTMRECEIVED

DATETIME(8)

 

DTMUSEBYDATE

DATETIME(8)

 

STRBATCHID

VARCHAR(50)

 

DBLQTY

DECIMAL(19,6)

 

DBLCURRENTQTY

DECIMAL(19,6)

 

CURCOST

DECIMAL(19,6)

 

CURREBATE

DECIMAL(19,6)

 

DBLALLOCATEDQTY

DECIMAL(19,6)

 

DBLRETURNEDQTY

DECIMAL(19,6)

 

DBLINTRANSITQTY

DECIMAL(19,6)

 

 

Primary Key: STRGUID

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