Database Table: ORDISTAT

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035020370 ORDISTAT_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable