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 Name | Column Type | Column Description |
---|---|---|
FIELD1 | INTEGER NULL |
Customizable. |
FIELD2 | DECIMAL (20,5) NULL |
Customizable. |
FIELD3 | VARCHAR (254) NULL |
Customizable. |
OIASTIME | TIMESTAMP NULL |
The actual shipping time stamp for the OrderItem. |
OICMNT | VARCHAR (254) NULL |
Comment to the status of this OrderItem. |
OICPCUR | CHARACTER (10) NULL |
Currency in which the price is expressed. This is a currency code as per ISO 4217 standards. |
OIINVTIME | TIMESTAMP NULL |
Invoice time stamp for OrderItem. |
OIINVVAL | DECIMAL (20,5) NULL |
Net value of the invoice for an OrderItem. |
OIMITEM | CHARACTER (30) NULL |
OrderItem number generated by a backend system. |
OIPLTIME | TIMESTAMP NULL |
The time stamp when the OrderItem was placed. |
OIPRTOT | DECIMAL (20,5) NULL |
Total product price for the OrderItem. |
OIQTCONFIRM | INTEGER NULL |
Quantity of items confirmed. |
OIQTREQUEST | INTEGER NULL |
Quantity of items requested. |
OIQTSHIP | INTEGER NULL |
Quantity of items shipped. |
OIRSTIME | TIMESTAMP NULL |
The time stamp when shipping was requested for the OrderItem. |
OISCOND | CHARACTER (2) NULL |
Code indicating if partial shipment of the order is accepted. Valid
values: SC = ship complete order or SP = ship partial order. |
OISHTOT | DECIMAL (20,5) NULL |
Total shipping charges for the OrderItem. |
OISHTXTOT | DECIMAL (20,5) NULL |
Total tax on shipping charges for the OrderItem. |
OISSTIME | TIMESTAMP NULL |
The time stamp for the scheduled shipping of the OrderItem. |
OISTATUS | CHARACTER (32) NULL |
Status of the OrderItem. |
OITXTOT | DECIMAL (20,5) NULL |
Total tax for the OrderItem. |
OIUNPRC | DECIMAL (20,5) NULL |
Unit price for the OrderItem. |
OIUOFM | CHARACTER (20) NULL |
Unit of measure for the OrderItem. |
OIVERNBR | 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. |
ORDERITMES_ID | BIGINT NULL |
WebSphere Commerce OrderItem reference number. Foreign key that references the ORDERITEMS_ID column in the ORDERITEMS table. |
ORDERS_ID | BIGINT NULL |
WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS time. |
ORDISTAT_ID | BIGINT NOT NULL |
OrderItem status reference number. This is a primary key for this table. |
ORDSTAT_ID | BIGINT NULL |
The OrderStatus record this OrderItemStatus is part of. |
OSMORDER | CHARACTER (30) NULL |
Order number generated by the backend system. |
PARTNUMBER | CHARACTER (64) NULL |
Part number or SKU. |
SUPPLIERDATA | VARCHAR (254) NULL |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035020370 | ORDISTAT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_940 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
F_941 | ORDERITMES_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_942 | ORDSTAT_ID | ORDSTAT | ORDSTAT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|