Home > Technical > Table Definitions > TFRSENDHDR

TFRSENDHDR

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 a header for each transfer sent to another store. TFRSENDDET contains details about the actual items which were sent.

Column Type Description

CTRCODE

INT(4)

Send code – internal counter assigned automatically.

STRREQUESTLOCATION

VARCHAR(10)

Location requesting the item(s).

link.gif (858 bytes) TRADUNIT.strTradeCode

STRSENDLOCATION

VARCHAR(10)

Location the items are to be sent from.

link.gif (858 bytes) TRADUNIT.strTradeCode

STRSTATUS

VARCHAR(10)

Status of the request – ‘New’, ‘Requested’, ‘In Transit’, ‘Sent’, ‘Cancelled’.

DTMWHEN

DATETIME(8)

Creation date.

STRWHO

VARCHAR(20)

ID of the user who created the send

DTMSTATUS

DATETIME(8)

Date / time the status was last changed – now obsolete replaced with dtmStatusChanged.

CURBATCHVALUE

DECIMAL9 (19, 4)

Not used.

LINTREQUESTCODE

INT(4)

Request code of the associated Transfer Request (TFRREQHDR.CTRCODE)

MEMCOMMENTS

TEXT(16)

Field for general comments for the transfer – not included on the transfer report.

MEMSPECINSTRUCT

TEXT(16)

Special instructions comment field – included on the transfer send report.

DTMTAXINVOICE

DATETIME(8)

Date / time a tax invoice was produced.

DTMSTATUSCHANGED

DATETIME(8)

Date / time the status was last changed.

STRAUTHORISEDBY

VARCHAR(20)

User who authorised the request.

INTCHANGEFLAG

INT(4)

Internal counter tracking changes.

INTNEWFLAG

INT(4)

Internal counter tracking changes.

INTACCEPTED

INT(4)

Internal counter tracking changes.

LINTSTOCKADJCODE

INT(4)

Code identifying a stock adjustment to account for variances between the amounts recorded as sent by the sending location and the amounts received by the re-questing location. Maps to TRANSFERHEADER .LINTTRANSFERCODE.

YSNCHARGETAX

VARCHAR(1)

Should tax be included in the transfer totals?

MEMSPECINSTRUCTREQ

TEXT(16)

Special instructions comment field from the REQUEST object – not included on the transfer send report.

DTMREQUESTED

DATETIME

Date / time the request was marked as Requested.

DTMTRANSIT

DATETIME

Date / time the request was marked as In Transit.

DTMSENT

DATETIME

Date / time the request was marked as Sent.

DTMCANCELLED

DATETIME

Date / time the request was marked as Cancelled.

 

Primary Key: CTRCODE

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