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:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ORDSTAT_ID | Primary Key |
| I0000368 | ORDERS_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_939 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_942 | ORDSTAT_ID | ORDISTAT | ORDSTAT_ID | Cascade |