Database Table: 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 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035024370 ORDSTAT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_939 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_942 ORDSTAT_ID ORDISTAT ORDSTAT_ID Cascade