Home > Technical > Table Definitions > CUSTORDERED

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

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