Home > Technical > Table Definitions > 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 |
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. |
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) |