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) |