Reference > Database > WebSphere Commerce database tables > O


WebSphere Commerce 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 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.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030405350 ORDSTAT_ID Primary Key
I0000368 ORDERS_ID Non-Unique Index

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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search