Home > Technical > Table Definitions > 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) |