Home > Technical > Table Definitions > STOCKENTRY
Contains a record for each item entered from a PDE or CSV file for an inventory transaction.
| Column | Type | Description |
|
STRSOURCE |
VARCHAR(5) |
A code identifying the inventory transaction type, for example TFRI=Transfer Request, TFRO=Transfer Send, STK=Stocktake |
|
LINTREFERENCE |
INT(4) |
The number of the actual inventory transaction, for example transfer number, stocktake number, and so on. |
|
CTRCODE |
INT(4) |
Unique number created by the system. |
|
STRWHO |
VARCHAR(20) |
The user who imported the data USERCODE.strUserCode |
|
STRAPN |
VARCHAR(20) |
The APN entered from the PDE or CSV file. |
|
STRITEMNUMBER |
VARCHAR(10) |
The IPN entered from the PDE or CSV file. |
|
LINTITEMNUMBER |
INT(4) |
The strItemNumber converted to a number. |
|
STRORDERCODE |
VARCHAR(20) |
The order code entered from the PDE or CSV file. |
|
STRQTY |
VARCHAR(10) |
The quantity entered from the PDE or CSV file. |
|
STRREFERENCE |
VARCHAR(20) |
|
|
STRTRADECODE |
VARCHAR(10) |
|
|
STRTRADECODEFROM |
VARCHAR(10) |
|
|
STRDATE |
VARCHAR(10) |
|
|
YSNCONVERTAPN |
VARCHAR(1) |
|
|
YSNCONVERTQTY |
VARCHAR(1) |
|
|
YSNFOUND |
VARCHAR(1) |
|
|
YSNSTOCKED |
VARCHAR(1) |
|
|
YSNSTOCKTAKE |
VARCHAR(1) |
|
|
YSNCONVERTITEM |
VARCHAR(1) |
|
|
YSNMULTIPLEERR |
VARCHAR(1) |
|
|
LINTLASTITEM1 |
INT(4) |
|
|
LINTLASTITEM2 |
INT(4) |
|
|
LINTLASTITEM3 |
INT(4) |
|
|
DBLQTY |
DECIMAL9(19,6) |
|
|
STRERROR |
VARCHAR(60) |
|
|
STRCARTONS |
VARCHAR(10) |
|
|
DBLCARTONS |
DECIMAL9(19,6) |
|
|
STRBATCHCODE |
VARCHAR(38) |
|
|
STRSERIALNUMBER |
VARCHAR(38) |
|
|
STREXPIRYDATE |
VARCHAR(20) |
|
|
DTMEXPIRYDATE |
DATETIME(8) |
|
|
YSNCONVERTEXPIRY |
VARCHAR(1) |
|
|
YSNPROCESSED |
VARCHAR(1) |
|
|
INTZONE |
INT(4) |
|
|
YSNCOMPOSITEQTY |
VARCHAR(1) |
|
Primary Key: STRSOURCE + LINTREFERENCE + CTRCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |