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 Descriptions:

ORDISTAT_IDBIGINT NOT NULLOrderItem status reference number. This is a primary key for this table.
ORDERS_IDBIGINTHCL Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS time.
OSMORDERCHAR (30)Order number generated by the backend system.
ORDERITMES_IDBIGINTHCL Commerce OrderItem reference number. Foreign key that references the ORDERITEMS_ID column in the ORDERITEMS table.
OIMITEMCHAR (30)OrderItem number generated by a backend system.
PARTNUMBERCHAR (64)Part number or SKU.
OIUOFMCHAR (20)Unit of measure for the OrderItem.
OIQTREQUESTINTEGERQuantity of items requested.
OIQTCONFIRMINTEGERQuantity of items confirmed.
OIQTSHIPINTEGERQuantity of items shipped.
OICPCURCHAR (10)Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.
OIUNPRCDECIMAL (20,5)Unit price for the OrderItem.
OIPRTOTDECIMAL (20,5)Total product price for the OrderItem.
OITXTOTDECIMAL (20,5)Total tax for the OrderItem.
OISHTOTDECIMAL (20,5)Total shipping charges for the OrderItem.
OISHTXTOTDECIMAL (20,5)Total tax on shipping charges for the OrderItem.
OISTATUSCHAR (32)Status of the OrderItem.
OIPLTIMETIMESTAMPThe time stamp when the OrderItem was placed.
OIRSTIMETIMESTAMPThe time stamp when shipping was requested for the OrderItem.
OISSTIMETIMESTAMPThe time stamp for the scheduled shipping of the OrderItem.
OIASTIMETIMESTAMPThe actual shipping time stamp for the OrderItem.
OIINVTIMETIMESTAMPInvoice time stamp for OrderItem.
OIINVVALDECIMAL (20,5)Net value of the invoice for an OrderItem.
OIVERNBRINTEGEROrder 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.
OISCONDCHAR (2)Code indicating if partial shipment of the order is accepted. Valid values: SC = ship complete order or SP = ship partial order.
OICMNTVARCHAR (254)Comment to the status of this OrderItem.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
SUPPLIERDATAVARCHAR (254)This column is not populated or used by WebSphere Commerce. The value for this column can be generated and used by the external system that originates an order. This value can be returned with a quotation, and sent when an order is placed on an external system. For example, this column can be used to contain a supplier distribution center ID. This field is not supported within the Order Noun for component services.
ORDSTAT_IDBIGINTThe OrderStatus record this OrderItemStatus is part of.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000659ORDSTAT_IDNon-Unique Index
I0000660ORDERITMES_IDNon-Unique Index
I0000661ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType