ORDSTAT

This table contains information about the status of an order for an Order Status Update inbound message. Each row in the table contains information about a single order.

Column Descriptions:

NameTypeDescription
ORDSTAT_IDBIGINT NOT NULLOrder status reference number. This is the primary key for this table.
ORDERS_IDBIGINTHCL Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table.
OSMORDERCHAR (30)Order number generated by the backend system.
OSCPCURCHAR (10)Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.
OSPRTOTDECIMAL (20,5)Total product price for the order.
OSTXTOTDECIMAL (20,5)Total tax for the order.
OSSHTOTDECIMAL (20,5)Total shipping charges for the order.
OSSHTXTOTDECIMAL (20,5)Total tax on shipping charges for the order.
OSSTATUSCHAR (32)Status of the order.
OSPLTIMETIMESTAMPOrder placed time stamp.
OSRSTIMETIMESTAMPRequested shipping time stamp.
OSSSTIMETIMESTAMPScheduled shipping time stamp.
OSASTIMETIMESTAMPActual shipping time stamp.
OSINVTIMETIMESTAMPInvoice time stamp.
OSINVVALDECIMAL (20,5)Net value of the invoice.
OSSCONDCHAR (2)Code indicating if partial shipment of the order is accepted. Valid values: SC = ship complete order SP = ship partial order
OSSMFLAGCHAR (1)Code indicating the level for the shipping address and shipping mode. Valid values: O = order level I = item level
OSVERNBRINTEGEROrder status version number. A value of "0" (zero) indicates the most recent version of the order. The highest value indicates the second most recent version of the order.
OSUPDTIMETIMESTAMPLast update time stamp for the order.
OSSEQNUMVARCHAR (64)Order status sequence number for serialization.
OSCMNTVARCHAR (254)Comments for this order status.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
OSCODECHAR (20)Error code for the order.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDSTAT_IDPrimary Key
I0000368ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_939ORDERS_IDORDERSORDERS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_942ORDSTAT_IDORDISTATORDSTAT_IDCascade