Each row in this table represents an order in a store.
Column Descriptions
| Column Name
| Column Type
| Description
|
| 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 IBM 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 an order.
|
| MEMBER_ID
| BIGINT NOT NULL
| The customer that placed the order.
|
| FIELD1
| INTEGER
| Customizable.
|
| ADDRESS_ID
| BIGINT
| The billing address, if known.
|
| FIELD2
| DECIMAL (20,5)
| Customizable.
|
| PROVIDERORDERNUM
| INTEGER
| Reserved for IBM internal use.
|
| SHIPASCOMPLETE
| CHAR(1) NOT NULL DEFAULT 'Y'
| Reserved for IBM 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 IBM 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 advanced order, TYPE indicates whether it is a regular order, requisition list order, standing order, or profile order.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| 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
|