This table contains information about the items within a single order for an Order Status Update inbound message. Each row contains information about a single item.
Column Description(s):
Column Name | Column Type | Description |
ORDISTAT_ID |
BIGINT NOT NULL |
OrderItem status reference number. This is a primary key for this table. |
ORDERS_ID |
BIGINT |
WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS time. |
OSMORDER |
CHAR(30) |
Order number generated by the backend system. |
ORDERITMES_ID |
BIGINT |
WebSphere Commerce OrderItem reference number. Foreign key that references the ORDERITEMS_ID column in the ORDERITEMS table. |
OIMITEM |
CHAR(30) |
OrderItem number generated by a backend system. |
PARTNUMBER |
CHAR(64) |
Part number or SKU. |
OIUOFM |
CHAR(20) |
Unit of measure for the OrderItem. |
OIQTREQUEST |
INTEGER |
Quantity of items requested. |
OIQTCONFIRM |
INTEGER |
Quantity of items confirmed. |
OIQTSHIP |
INTEGER |
Quantity of items shipped. |
OICPCUR |
CHAR(10) |
Currency in which the price is expressed. This is a currency code as per ISO 4217 standards. |
OIUNPRC |
DECIMAL (20,5) |
Unit price for the OrderItem. |
OIPRTOT |
DECIMAL (20,5) |
Total product price for the OrderItem. |
OITXTOT |
DECIMAL (20,5) |
Total tax for the OrderItem. |
OISHTOT |
DECIMAL (20,5) |
Total shipping charges for the OrderItem. |
OISHTXTOT |
DECIMAL (20,5) |
Total tax on shipping charges for the OrderItem. |
OISTATUS |
CHAR(32) |
Status of the OrderItem. |
OIPLTIME |
TIMESTAMP |
The time stamp when the OrderItem was placed. |
OIRSTIME |
TIMESTAMP |
The time stamp when shipping was requested for the OrderItem. |
OISSTIME |
TIMESTAMP |
The time stamp for the scheduled shipping of the OrderItem. |
OIASTIME |
TIMESTAMP |
The actual shipping time stamp for the OrderItem. |
OIINVTIME |
TIMESTAMP |
Invoice time stamp for OrderItem. |
OIINVVAL |
DECIMAL (20,5) |
Net value of the invoice for an OrderItem. |
OIVERNBR |
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. |
OISCOND |
CHAR(2) |
Code indicating if partial shipment of the order is accepted. Valid values:
SC = ship complete order or SP = ship partial order. |
OICMNT |
VARCHAR(254) |
Comment to the status of this OrderItem. |
FIELD1 |
INTEGER |
Customizable. |
FIELD2 |
DECIMAL (20,5) |
Customizable. |
FIELD3 |
VARCHAR(254) |
Customizable. |
SUPPLIERDATA |
VARCHAR(254) |
Opaque to WebSphere Commerce. This attribute can be returned with a status update. For example, it could contain a supplier part number and perhaps a distribution center ID. |
ORDSTAT_ID |
BIGINT |
The OrderStatus record this OrderItemStatus is part of. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |