Home > Technical > Table Definitions > TFRSENDDET

TFRSENDDET

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 sent as part of a transfer. The header record for the transfer is stored in TFRSENDHDR.

Column Type Description

LINTSENDCODE

INT(4)

Send code.

link.gif (858 bytes) TFRSENDHDR.ctrCode

CTRCODE

INT(4)

Internal counter assigned automatically – 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 used.

STRDESCRIPTION

VARCHAR(100)

Item description from ITEM.STRDESCRIPTION.

STRPOS20DESCRIPTION

VARCHAR(20)

POS item description from ITEM.STRPOS20DESCRIPTION.

INTCARTONSIZE

DECIMAL

Count of items in a carton.

DBLUNITS

DECIMAL(19,4)

Count of units requested.

DBLUNITSRECEIVED

DECIMAL(19,4)

Count of units sent.

CURCOST

DECIMAL(19,4)

Average unit cost of the item when picked.

DBLCARTONS

DECIMAL(19,4)

Count of cartons requested

DBLCARTONSRECEIVED

DECIMAL(19,4)

Count of cartons sent.

STRORDERCODE

VARCHAR(20)

Order code for the item.

CURREBATES

DECIMAL(19,4)

Rebates applied to this line.

STRREFERENCE

VARCHAR(20)

Reference for this item entered on the transfer send.

STRSTATUS

VARCHAR(10)

Status of this line item.

CURCHARGES

DECIMAL(19,4)

Charges for this line item.

INTGROUPNUM

INT(4)

Internal counter assigned automatically.  It is used to track updates made at the same time when not all items in a send are processed.

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: LINTSENDCODE + CTRCODE

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