Home > Technical > Table Definitions > CUSTORDERED
This table is created by the suggested ordering process to show which customer orders have been processed.
Column |
Type |
Description |
CTRCODE |
BIGINT |
A unique number assigned by the system. |
STRSOURCE |
VARCHAR(5) |
Indicates the transaction type that ordered this item, for example PO=Purchase Order, TFRI=Transfer Request, RS=Required Stock |
LINTREFERENCE |
INT |
The primary key of the source document that was generated for this item. If STRSOURCE='PO', this would be the purchase order number. |
LINTLINENUMBER |
INT |
The line number of the item detail in the purchase order/ transfer request. |
DBLQTY |
DECIMAL(19,6) |
The quantity that was ordered. |
DBLQTYUSED |
DECIMAL(19,6) |
The quantity that was used (currently same as DBLQTY) |
DTMSTATUS |
DATETIME |
The date/time the record was created. |
INTTRANSNUM |
BIGINT |
The transaction of the customer order that this record relates to |
LINTORDERCHGCODE |
BIGINT |
Link to the CUSTORDERCHG record, which generated this
record. |
STRORDER |
VARCHAR(10) |
ORDER if we needed to do a purchase order or TRANSFER if we needed to do a transfer. |
STRTRANSFERTRADECODE |
VARCHAR(10) |
If we were told we needed to transfer the item from another
location, this is the code of that location. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |