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