ORDERS_ID | BIGINT NOT NULL | Generated unique key. |
ORMORDER | CHAR (30) | A merchant-assigned order reference number, if
any. |
ORGENTITY_ID | BIGINT | The immediate parent organization ID of the
creator. |
TOTALPRODUCT | DECIMAL (20,5) DEFAULT 0 | The sum of ORDERITEMS.TOTALPRODUCT for the
OrderItems in the Order. |
TOTALTAX | DECIMAL (20,5) DEFAULT 0 | The sum of ORDERITEMS.TAXAMOUNT for the
OrderItems in the Order. |
TOTALSHIPPING | DECIMAL (20,5) DEFAULT 0 | The sum of ORDERITEMS.SHIPCHARGE for the
OrderItems in the Order. |
TOTALTAXSHIPPING | DECIMAL (20,5) DEFAULT 0 | The sum of ORDERITEMS.SHIPTAXAMOUNT for the
OrderItems in the Order. |
DESCRIPTION | VARCHAR (254) | A mnemonic description of the order, entered by
the customer, suitable for display to the customer. |
STOREENT_ID | INTEGER NOT NULL | The store entity the order is part of. This is
normally a store unless STATUS is Q, in which case it is normally a
store group. |
CURRENCY | CHAR (10) | The currency for monetary amounts associated with
this order. This is the currency code according to ISO 4217
standards. |
LOCKED | CHAR (1) | Reserved for HCL internal use. |
TIMEPLACED | TIMESTAMP | The time this order was processed by the
OrderProcess command. |
LASTUPDATE | TIMESTAMP | The time this order was most recently
updated. |
SEQUENCE | DOUBLE NOT NULL DEFAULT 0 | Can be used by a user interface to control the
sequence of orders in a list. |
STATUS | VARCHAR (3) | The status of the order. This is similar to order
states. For specific values of status and their descriptions, refer
to the order states page, but omit states 'Y' and 'Z'.
|
MEMBER_ID | BIGINT NOT NULL | The customer that placed the order. |
FIELD1 | INTEGER | Customizable. |
ADDRESS_ID | BIGINT | This column is deprecated. In versions WC 5.6.1
and earlier, this column contained the billing address. In version
WC 6.0 and later, the billing address is part of payment data and
is stored in PPCEXTDATA table as encrypted data. |
FIELD2 | DECIMAL (20,5) | Customizable. |
PROVIDERORDERNUM | INTEGER | Reserved for HCL internal use. |
SHIPASCOMPLETE | CHAR (1) NOT NULL DEFAULT 'Y' | Reserved for HCL internal use. |
FIELD3 | VARCHAR (254) | Customizable. |
TOTALADJUSTMENT | DECIMAL (20,5) DEFAULT 0 | The sum of ORDERITEMS.TOTALADJUSTMENT for the
order items in the order. This column also includes all kinds of
shipping charge adjustments like discount, coupon, shipping
adjustment and surcharge. |
ORDCHNLTYP_ID | BIGINT | Reserved for HCL internal use. |
COMMENTS | VARCHAR (254) | Comments from the customer. |
NOTIFICATIONID | BIGINT | Notification identifier referring to the rows in
the NOTIFY table that store notification attributes. These
attributes override the defaults for notifications related to this
order. |
TYPE | CHAR (3) | For an order, TYPE indicates whether it is a
regular order (ORD), private requisition list order (PRL),
shareable requisition list order (SRL), standing order (STD),
quotation order (QUT), quote (QOT), profile order (QUK), recurring
order (REC), or subscription (SUB). |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
EDITOR_ID | BIGINT | Stores the ID of the person editing the
order. |
BUSCHN_ID | INTEGER | The Business Channel ID of the order. |
SOURCEID | BIGINT | This field indicates the sources from which this
order came, if any. This field is relevant for orders that were
generated from a previously saved quote, for example. In that
situation, the QuoteId would be saved here. |
EXPIREDATE | TIMESTAMP | This entry is only relevant when the row refers
to a quote, type "QOT". This field then indicates the expiration
date for that quote. |
BLOCKED | SMALLINT DEFAULT 0 | Indicates if this order has a block placed
against it or not. |
OPSYSTEM_ID | INTEGER | This field indicates the Order Processing system
for the order. |
TRANSFERSTATUS | SMALLINT | Order transferring status: 0, it is in the
initial status. 1, it is in the transferring status. 2, it is in
the transferred status. null, the same as 0. |
BUYERPO_ID | BIGINT | The Buyer PO Number Id related to an order |