TFRREQDET

LINTREQUESTCODE

INT(4)

Request code

TFRREQHDR.ctrCode

CTRCODE

INT(4)

Internal counter assigned automatically – approximately corresponding to the line on the details screen for the item entry.

LINTITEMNUMBER

INT(4)

Item number.

ITEM.lintItemNumber

DBLAPN

DECIMAL(19,4)

Not currently used.

STRDESCRIPTION

VARCHAR(100)

Item description from ITEM.STRDESCRIPTION.

STRPOS20DESCRIPTION

VARCHAR(20)

POS item description from ITEM.STRPOS20DESCRIPTION.

INTCARTONSIZE

DECIMAL(9,3)

Count of items in a carton.

DBLUNITS

DECIMAL(19,6)

Count of units requested.

DBLUNITSRECEIVED

DECIMAL(19,6)

Count of units received

CURCOST

DECIMAL(19,4)

Average unit cost of the item when picked.

DBLCARTONS

DECIMAL(19,6

Count of cartons requested.

DBLCARTONSRECEIVED

DECIMAL(19,6)

Count of cartons received.

STRORDERCODE

VARCHAR(20)

Order code for the item.

STRREFERENCE

VARCHAR(20)

Reference for this item entered on the transfer send.

CURREBATES

DECIMAL(19,6)

Rebates applied to this request.

DBLUNITSSENT

DECIMAL(19,6)

Count of units sent.

LINTSENDLINECODE

INT(4)

TFRSENDDET.CTRCODE for the corresponding line in the send details. This will only be set when 1 or more items for this entry have been picked and sent by the sending location.

STRSTATUS

VARCHAR(10)

Status of this line item.

CURCHARGES

DECIMAL(19,4)

Charges for this line item.

CURTAXAMT

DECIMAL(19,4)

Tax amount applied to this line.

STRTAXCODE

VARCHAR(10)

Tax code applied to this line.

DTMSTATUS

DATETIME(8)

Date / time the status was updated.