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