Home > Technical > Table Definitions > TFRREQHDR

TFRREQHDR

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 request made at a store. TFRREQDET contains details about the actual items which were requested.

Column Type Description

CTRCODE

INT(4)

Request 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) TRADUNITLIST.strTradeCode

STRSTATUS

VARCHAR(10)

Status of the request:

New = newly created
Sent = Send button clicked and corresponding Send object created.
In Transit = items have been sent from the other send location.
Received = items have been received at the requesting store.
Cancelled.

DTMWHEN

DATETIME(8)

Creation date.

STRWHO

VARCHAR(20)

ID of the user who created the request.

DTMSTATUS

DATETIME(8)

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

LINTSENDCODE

INT(4)

Send code of the associated Transfer Send (TFRSENDHDR.CTRCODE)

CURBATCHVALUE

DECIMAL(19,4)

Not used.

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 report.

DTMTAXINVOICE

DATETIME(8)

Date / time a tax invoice was produced.

DTMSTATUSCHANGED

DATETIME(8)

Date / time the status was last changed.

STRAUTHORISEDY

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 requesting location. Maps to TRANSFERHEADER .LINTTRANSFERCODE.

YSNCHARGETAX

VARCHAR(1)

Should tax be included in the transfer totals?

MEMSPECINSTRUCTSENDER

TEXT(16)

Special instructions comment field from the SEND object – not included on the transfer request report.

DTMSENT

DATETIME

Date / time the request was marked as Sent.

DTMTRANSIT

DATETIME

Date / time the request was marked as In Transit.

DTMRECEIVED

DATETIME

Date / time the request was marked as Received.

DTMCANCELLED

DATETIME

Date / time the request was marked as Cancelled.

 

Primary Key: CTRCODE

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