WebSphere Commerce database table: ORDSTAT

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 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 NOT NULL DEFAULT 0 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

Related reference
Messaging data model

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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDSTAT_ID	Primary Key
I0000368	ORDERS_ID	Non-Unique Index