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 Name | Column Type | Description |
---|---|---|
ORDSTAT_ID | BIGINT NOT NULL | Order status reference number. This is the primary key for this table. |
ORDERS_ID | BIGINT | WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table. |
OSMORDER | CHAR(30) | Order number generated by the backend system. |
OSCPCUR | CHAR(10) | Currency in which the price is expressed. This is a currency code as per ISO 4217 standards. |
OSPRTOT | DECIMAL (20,5) | Total product price for the order. |
OSTXTOT | DECIMAL (20,5) | Total tax for the order. |
OSSHTOT | DECIMAL (20,5) | Total shipping charges for the order. |
OSSHTXTOT | DECIMAL (20,5) | Total tax on shipping charges for the order. |
OSSTATUS | CHAR(32) | Status of the order. |
OSPLTIME | TIMESTAMP | Order placed time stamp. |
OSRSTIME | TIMESTAMP | Requested shipping time stamp. |
OSSSTIME | TIMESTAMP | Scheduled shipping time stamp. |
OSASTIME | TIMESTAMP | Actual shipping time stamp. |
OSINVTIME | TIMESTAMP | Invoice time stamp. |
OSINVVAL | DECIMAL (20,5) | Net value of the invoice. |
OSSCOND | CHAR(2) | Code indicating if partial shipment of the order is accepted. Valid values: SC = ship complete order SP = ship partial order |
OSSMFLAG | CHAR(1) | Code indicating the level for the shipping address and shipping mode. Valid values: O = order level I = item level |
OSVERNBR | INTEGER | Order 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. |
OSUPDTIME | TIMESTAMP | Last update time stamp for the order. |
OSSEQNUM | VARCHAR(64) | Order status sequence number for serialization. |
OSCMNT | VARCHAR(254) | Comments for this order status. |
FIELD1 | INTEGER | Customizable. |
FIELD2 | DECIMAL (20,5) | Customizable. |
FIELD3 | VARCHAR(254) | Customizable. |
OSCODE | CHAR(20) | Error code for the order. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031250620 | ORDSTAT_ID | Primary Key |
I0000368 | ORDERS_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_939 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_942 | ORDSTAT_ID | ORDISTAT | ORDSTAT_ID | Cascade |