ORDERITEMS

Each row of this table represents an order item in an order.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLGenerated unique key.
STOREENT_IDINTEGER NOT NULLThe store entity the order (this order item is part of) is part of. This is normally a store unless STATUS is Q, in which case it is normally a store group.
ORDERS_IDBIGINT NOT NULLThe order of which this order item is part.
TERMCOND_IDBIGINTThe TermAndCondition, if known, that determined the price for this order item.
TRADING_IDBIGINTThe TradingAgreement, if known, that determines the TermAndCondition objects (including how the price is determined) that apply to this order item.
ITEMSPC_IDBIGINTThe specified item to be allocated from available inventory and shipped to the customer.
CATENTRY_IDBIGINTThe catalog entry, if any, of the product being purchased.
PARTNUMVARCHAR (64)The part number of the catalog entry(CATENTRY.PARTNUMBER) for the product.
SHIPMODE_IDINTEGERThe shipping mode, if still known.
FFMCENTER_IDINTEGERThe fulfillment center, if known, from which the product will ship.
MEMBER_IDBIGINT NOT NULLThe customer of the order item (which is the same as the customer of the order).
ADDRESS_IDBIGINTThe shipping address, if any, for this order item.
ALLOCADDRESS_IDBIGINTThe shipping address used when inventory for this order item was allocated or backordered.
PRICEDECIMAL (20,5)The price for the nominal quantity of the product (CATENTSHIP.NOMINALQUANTITY).
LINEITEMTYPECHAR (4)If specified, indicates the type of the order item. ALT = the order item represents an alternative item (might not be exactly what the customer requested).
STATUSCHAR (1) NOT NULLThe status for the order item. It may not be the same as the status in the order.
OUTPUTQ_IDBIGINTReserved for IBM internal use.
INVENTORYSTATUSCHAR (4) NOT NULL DEFAULT 'NALC'The allocation status of inventory for this order item:
NALC
Inventory is not allocated nor on back-order.
BO
Inventory is on back-order.
ALLC
Inventory is allocated.
FUL
Inventory has been released for fulfillment.
AVL
Inventory is available.
LASTCREATETIMESTAMPThe time this order item was created.
LASTUPDATETIMESTAMPThe most recent time this order item was updated. Changing inventory allocation related information does not cause this timestamp to be updated (refer to the LASTALLOCUPDATE column).
FULFILLMENTSTATUSCHAR (4) NOT NULL DEFAULT 'INT'The fulfillment status of the order item: INT = not yet released for fulfillment. OUT = released for fulfillment. SHIP = shipment confirmed. HOLD = a temporary status between INT and OUT status.
LASTALLOCUPDATETIMESTAMPThe most recent time inventory was checked (for unallocated order items), allocated, or backordered, for this order item.
OFFER_IDBIGINTThe offer, if any, and if it still exists, from which PRICE was obtained.
TIMERELEASEDTIMESTAMPThe time this order item was released for fulfillment.
TIMESHIPPEDTIMESTAMPThe time this order item was manifested for shipment.
CURRENCYCHAR (10)The currency of order item monetary amounts other than BASEPRICE. This is the same as the currency of the order, ORDERS.CURRENCY. This is a currency code according to ISO 4217 standards.
COMMENTSVARCHAR (254)Comments from the customer, such as a greeting for a gift.
TOTALPRODUCTDECIMAL (20,5) DEFAULT 0PRICE times QUANTITY.
QUANTITYDOUBLE NOT NULLThe result of multiplying QUANTITY by CATENTSHIP.NOMINALQUANTITY must be a multiple of CATENTSHIP.QUANTITYMULTIPLE. And it represents the actual quantity being purchased, in the unit of measurement specified by CATENTSHIP.QUANTITYMEASURE.
TAXAMOUNTDECIMAL (20,5)The total sales taxes associated with this order item, in the currency specified by CURRENCY.
TOTALADJUSTMENTDECIMAL (20,5) DEFAULT 0The total of the monetary amounts of the order item adjustments for this order item, in the currency specified by CURRENCY. This column also includes all kinds of shipping charge adjustments like discount, coupon, shipping adjustment and surcharge.
SHIPTAXAMOUNTDECIMAL (20,5)The total shipping taxes associated with this order item, in the currency specified by CURRENCY.
ESTAVAILTIMETIMESTAMPAn estimate of when sufficient inventory will be available to fulfill this order item. This estimate does not include the shipping offset.
FIELD1INTEGERCustomizable.
DESCRIPTIONVARCHAR (254)A mnemonic description of the order Item, suitable for display to the customer. This field is usually NULL when CATENTRY_ID is not NULL, since in that case the CatalogEntry description can be displayed.
FIELD2VARCHAR (254)Customizable.
ALLOCATIONGROUPBIGINTReserved for IBM internal use.
SHIPCHARGEDECIMAL (20,5)The base shipping charge associated with the order item, in the currency specified by CURRENCY, it is the shipping charge before any adjustments. The shipping charge adjustment will be persisted in the ORDERITEMS.TOTALADJUSTMENT column with other adjustments including discount and surcharge. The total shipping charge is the sum of base shipping charge in ORDERITEMS.SHIPCHARGE column and the shipping charge adjustment in ORDERITEMS.TOTALADJUSTMENT column.
BASEPRICEDECIMAL (20,5)If PRICE was converted from a currency different from the order item currency, BASEPRICE is the price that was converted to determine the PRICE.
BASECURRENCYCHAR (3)The currency of BASEPRICE.
TRACKNUMBERVARCHAR (64)Reserved for IBM internal use.
TRACKDATETIMESTAMPReserved for IBM internal use.
PREPAREFLAGSINTEGER NOT NULL DEFAULT 0Contains the following bit flags indicating special processing associated with this order item:
1
generated

The order item was generated during a previous execution of the OrderPrepare command. The next time the OrderPrepare command is run, it first removes all generated order items so that they can be re-generated when applicable.

2
priceOverride

The price of the order item (ORDERITEMS.PRICE) has been manually entered and will not be changed by customer commands.

4
fulfillmentCenterOverride

The fulfillment center has been manually specified and will not be changed by customer commands.

8
directCalculationCodeAttachment

CalculationCodes may be directly attached to the order item. The default CalculationCodeCombineMethod will not look for direct attachments unless this flag is true.

16
shippingChargeByCarrier

The contract for this order item indicates that no shipping charge will be calculated by WebSphere Commerce. It may be calculated and charged by the carrier on fulfillment.

32
quotation

The order item was obtained from a quotation. The price will not be automatically refreshed by customer commands.

64
notConfigured

Price lookup and inventory allocation for this order item is not done using the component items found in the OICOMPddST table. This flag does not need to be set for order items whose CONFIGURATIONID column value is null.

128
autoAdd

This order item, such as a free gift, was automatically added to the order by the OrderCalculate command. This flag is for information-display purposes only and does not affect price calculations.

256
hasPersonalizationAttributes

The order item contains personalization attributes.

512
skipRepricing

The order item was marked as not to be repriced. For example, it is set as skipRepricing when a quote is generated into an order if the quote has not expired.

1024
shippingAdjusted

The order items shipping charge is manually adjusted.

2048
priceRefreshed

The order items price has already been refreshed.

CORRELATIONGROUPBIGINTNormally this is the same as ORDERITEMS_ID, except: 1. When an order item is split by the AllocateInventory task command, the newly created OrderItem inherits the CORRELATIONGROUP value from the original order item. 2. When the PREPAREFLAGS column indicates "quotation", the OrderItem inherits the CORRELATIONGROUP value from the corresponding OrderItem in the parent order.
PROMISEDAVAILTIMETIMESTAMPWhen an order is placed (using the OrderProcess command), this would be set to EstAvailTime. After that it would normally not be updated, although a CSR could manually update this to reflect a verbal commitment made to the customer.
SHIPPINGOFFSETINTEGER NOT NULL DEFAULT 0An estimate of how many seconds it will take to ship this item once the order is placed and inventory has been allocated.
NEEDEDQUANTITYINTEGER NOT NULL DEFAULT 0Quantity needed for fulfillment. If CATENTRY is not NULL, this is QUANTITY times CATENTSHIP.NOMINALQUANTITY, converted from CATENTSHIP.QUANTITYMEASURE to BASEITEM.QUANTITYMEASURE, divided by BASEITEM.QUANTITYMULTIPLE and rounded to the nearest integer.
ALLOCQUANTITYINTEGER NOT NULL DEFAULT 0Quantity allocated or backordered for this order item. The quantity in BASEITEM.QUANTITYMEASURE units can be calculated by multiplying this value by BASEITEM.QUANTITYMULTIPLE, for the base item of the specified item indicated by ITEMSPC_ID.
ALLOCFFMC_IDINTEGERThe fulfillment center from which inventory for this order item is allocated or backordered.
ORDRELEASENUMINTEGERThe associated order release, if any.
CONFIGURATIONIDVARCHAR (128)The identifier that is provided by an external product configurator. This identifier represents a list of order item components that are stored in the OICOMPLIST table.
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.
SUPPLIERPARTNUMBERVARCHAR (254)The supplier part number, if known. Suitable for display to the customer. This field is not supported within the Order Noun for component services.
AVAILQUANTITYINTEGERIf specified, indicates the quantity available for purchase.
ISEXPEDITEDCHAR (1) NOT NULL DEFAULT 'N'Indicates that the item should receive expedited handling in fulfillment. Y indicates that it should receive expedited handling. N indicates that it should not (this is the default).
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
REQUESTEDSHIPDATETIMESTAMPThe ship date that has been requested for the order item. When no date (null) is specified, the ship date will be whenever the item is available to be shipped. When a date is specified, the ship date will be no sooner than the requested date. This is because a backorder could delay the ship date beyond the requested date. See the definition of ALLOCATIONOFFSET and MAXFOOFFSET in the STORE table.
TIECODESMALLINTTieCode used for items that are shipping at the same time (Ship Together).

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERITEMS_IDPrimary Key
I0000173 ORDERITEMS_ID+TIMERELEASED+TIMESHIPPED+INVENTORYSTATUSNon-Unique Index
I0000360ORDERITEMS_ID+ORDRELEASENUM+ORDERS_IDNon-Unique Index
I0000369STOREENT_IDNon-Unique Index
I0000639ALLOCADDRESS_IDNon-Unique Index
I0000640TRADING_IDNon-Unique Index
I0000641TERMCOND_IDNon-Unique Index
I0000642SHIPMODE_IDNon-Unique Index
I0000643FFMCENTER_IDNon-Unique Index
I0000644OFFER_IDNon-Unique Index
I0000645CATENTRY_IDNon-Unique Index
I0000646MEMBER_IDNon-Unique Index
I0000647ADDRESS_IDNon-Unique Index
I0000648ITEMSPC_IDNon-Unique Index
I0000649ALLOCFFMC_IDNon-Unique Index
I172138 ORDERS_ID+ORDRELEASENUM+STOREENT_ID+FFMCENTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_496ORDERS_IDORDERSORDERS_IDCascade
F_497TERMCOND_IDTERMCONDTERMCOND_IDCascade
F_498TRADING_IDTRADINGTRADING_IDCascade
F_499ALLOCADDRESS_IDADDRESSADDRESS_IDCascade
F_500ALLOCFFMC_IDFFMCENTERFFMCENTER_IDCascade
F_501OUTPUTQ_IDOUTPUTQOUTPUTQ_IDCascade
F_502ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_503ADDRESS_IDADDRESSADDRESS_IDCascade
F_504MEMBER_IDMEMBERMEMBER_IDCascade
F_505CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_506OFFER_IDOFFEROFFER_IDCascade
F_507STOREENT_IDSTOREENTSTOREENT_IDCascade
F_508FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_509SHIPMODE_IDSHIPMODESHIPMODE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1077ORDERITEMS_IDORDITPROMOCDORDERITEMS_IDCascade
F_1228ORDERITEMS_IDOICOMPRELORDERITEMS_IDCascade
F_125ORDERITEMS_IDBKORDALLOCORDERITEMS_IDCascade
F_126ORDERITEMS_IDBKORDITEMORDERITEMS_IDCascade
F_261ORDERITEMS_IDCPITMAPORDERITEMS_IDCascade
F_3474ORDERITEMS_IDORDITEMCONFORDERITEMS_IDCascade
F_3641ORDERITEMS_IDORDERRELPARENTORDERITEM_IDCascade
F_3648ORDERITEMS_IDSUBSCRIPTIONORDERITEMS_IDCascade
F_3712ORDERITEMS_IDOICONFIGORDERITEMS_IDCascade
F_3778ORDERITEMS_IDORDITEMEXTATTRORDERITEMS_IDCascade
F_476ORDERITEMS_IDOICOMPLISTORDERITEMS_IDCascade
F_520ORDERITEMS_IDORDIADJUSTORDERITEMS_IDCascade
F_523ORDERITEMS_IDORDICALCDORDERITEMS_IDCascade
F_524ORDERITEMS_IDORDIMEEXTNORDERITEMS_IDCascade
F_526ORDERITEMS_IDORDIOFFERORDERITEMS_IDCascade
F_527ORDERITEMS_IDORDIPROFORDERITEMS_IDCascade
F_528ORDERITEMS_IDORDITAXORDERITEMS_IDCascade
F_531ORDERITEMS_IDORDITRDORDERITEMS_IDCascade
F_545ORDERITEMS_IDORDPICKHSTORDERITEMS_IDCascade
F_549ORDERITEMS_IDORDSHIPHSTORDERITEMS_IDCascade
F_654ORDERITEMS_IDRABACKALLOORDERITEMS_IDCascade
F_710ORDERITEMS_IDRMAITEMORDERITEMS_IDCascade
F_827ORDERITEMS_IDTCPITMAPORDERITEMS_IDCascade
F_870ORDERITEMS_IDTRDDEPAMTORDERITEMS_IDCascade
F_876ORDERITEMS_IDTRDPURAMTORDERITEMS_IDCascade
F_941ORDERITEMS_IDORDISTATORDERITMES_IDCascade
F_987ORDERITEMS_IDPATTRVALUEORDERITEMS_IDCascade