Home > Technical > Table Definitions > TFRREQDET

TFRREQDET

This table is used as part of the Transfer mechanism (Request and Send) used in external transfers that is from location A to location B. This table stores the items which were requested as part of a transfer. The header record for the transfer is stored in TFRREQHDR.

Column Type Description

LINTREQUESTCODE

INT(4)

Request code

link.gif (858 bytes) 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.

link.gif (858 bytes) 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.

 

Primary Key: LINTREQUESTCODE + CTRCODE

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