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. CUSTORDERCHG.ctrCode
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. TRADUNIT.strTradeCode

Primary Key: CTRCODE