Home > Technical > Table Definitions > STOCKENTRY

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)