Home > Technical > Table Definitions > TRANSFERDETAIL

TRANSFERDETAIL

Used for internal transfers that is when you are move stock internally from one location to another within the same venue. The TRANSFERDETAIL table contains details about the items being transferred, including the store the item is to be transferred 'TO'.

Column

Type

Description

LINTTRANSFERCODE

INT

 

CTRCODE

INT

 

STRSTORETO

VARCHAR(10)

 

LINTITEMNUMBERFROM

INT

 

DBLQTYFROM

DECIMAL(19,6)

 

DBLCARTONSFROM

DECIMAL(19,6)

 

STRUOMFROM

VARCHAR(10)

 

LINTITEMNUMBERTO

INT

 

DBLQTYTO

DECIMAL(19,6)

 

DBLCARTONSTO

DECIMAL(19,6)

 

STRUOMTO

VARCHAR(10)

 

CURTRANSFERVALUE

DECIMAL(19,6)

 

INTCARTONSIZEFROM

DECIMAL(9,3)

 

INTCARTONSIZETO

DECIMAL(9,3)

 

STRDESCRIPTIONFROM

VARCHAR(100)

 

STRDESCRIPTIONTO

VARCHAR(100)

 

STRADJUSTMENTTYPE

VARCHAR(20)

 

STRSTATUS

VARCHAR(10)

 

STRREFERENCE

VARCHAR(50)

 

DBLAPNFROM

DECIMAL(19,4)

 

DBLAPNTO

DECIMAL(19,4)

 

STRORDERCODEFROM

VARCHAR(20)

 

STRORDERCODETO

VARCHAR(20)

 

CURREBATEVALUE

DECIMAL(19,6)

 

MEMCOMMENTS

TEXT(50)

 

CURCHARGES

DECIMAL(19,4)

 

 

Primary Key: LINTTRANSFERCODE + CTRCODE

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