Each row of this table represents an order item in an order.
Column Descriptions
| Column Name
| Column Type
| Description
|
| ORDERITEMS_ID
| BIGINT NOT NULL
| Generated unique key.
|
| STOREENT_ID
| INTEGER NOT NULL
| The 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_ID
| BIGINT NOT NULL
| The order of which this order item is part.
|
| TERMCOND_ID
| BIGINT
| The TermAndCondition, if known, that determined the price for this order item.
|
| TRADING_ID
| BIGINT
| The TradingAgreement, if known, that determines the TermAndCondition objects (including how the price is determined) that apply to this order item.
|
| ITEMSPC_ID
| BIGINT
| The specified item to be allocated from available inventory and shipped to the customer.
|
| CATENTRY_ID
| BIGINT
| The catalog entry, if any, of the product being purchased.
|
| PARTNUM
| VARCHAR(64)
| The part number of the catalog entry(CATENTRY.PARTNUMBER) for the product.
|
| SHIPMODE_ID
| INTEGER
| The shipping mode, if still known.
|
| FFMCENTER_ID
| INTEGER
| The fulfillment center, if known, from which the product will ship.
|
| MEMBER_ID
| BIGINT NOT NULL
| The customer of the order item (which is the same as the customer of the order).
|
| ADDRESS_ID
| BIGINT
| The shipping address, if any, for this order item.
|
| ALLOCADDRESS_ID
| BIGINT
| The shipping address used when inventory for this order item was allocated or backordered.
|
| PRICE
| DECIMAL (20,5)
| The price for the nominal quantity of the product (CATENTSHIP.NOMINALQUANTITY).
|
| LINEITEMTYPE
| CHAR(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).
|
| STATUS
| CHAR(1) NOT NULL
| The status for the order item. It may not be the same as the status in the order.
|
| OUTPUTQ_ID
| BIGINT
| Reserved for IBM internal use.
|
| INVENTORYSTATUS
| CHAR(4) NOT NULL DEFAULT 'NALC'
| The allocation status of inventory for this order item:
NALC = inventory is neither allocated nor backordered.
BO = inventory is backordered.
ALLC = inventory is allocated.
FUL = inventory has been released for fulfillment.
|
| LASTCREATE
| TIMESTAMP
| The time this order item was created.
|
| LASTUPDATE
| TIMESTAMP
| The 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).
|
| FULFILLMENTSTATUS
| CHAR(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.
|
| LASTALLOCUPDATE
| TIMESTAMP
| The most recent time inventory was checked (for unallocated order items), allocated, or backordered, for this order item.
|
| OFFER_ID
| BIGINT
| The offer, if any, and if it still exists, from which PRICE was obtained.
|
| TIMERELEASED
| TIMESTAMP
| The time this order item was released for fulfillment.
|
| TIMESHIPPED
| TIMESTAMP
| The time this order item was manifested for shipment.
|
| CURRENCY
| CHAR(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.
|
| COMMENTS
| VARCHAR(254)
| Comments from the customer, such as a greeting for a gift.
|
| TOTALPRODUCT
| DECIMAL (20,5) DEFAULT 0
| PRICE times QUANTITY.
|
| QUANTITY
| DOUBLE NOT NULL
| The 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.
|
| TAXAMOUNT
| DECIMAL (20,5)
| The total sales taxes associated with this order item, in the currency specified by CURRENCY.
|
| TOTALADJUSTMENT
| DECIMAL (20,5) DEFAULT 0
| The 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.
|
| SHIPTAXAMOUNT
| DECIMAL (20,5)
| The total shipping taxes associated with this order item, in the currency specified by CURRENCY.
|
| ESTAVAILTIME
| TIMESTAMP
| An estimate of when sufficient inventory will be available to fulfill this order item. This estimate does not include the shipping offset.
|
| FIELD1
| INTEGER
| Customizable.
|
| DESCRIPTION
| VARCHAR(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.
|
| FIELD2
| VARCHAR(254)
| Customizable.
|
| ALLOCATIONGROUP
| BIGINT
| Reserved for IBM internal use.
|
| SHIPCHARGE
| DECIMAL (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.
|
| BASEPRICE
| DECIMAL (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.
|
| BASECURRENCY
| CHAR(3)
| The currency of BASEPRICE.
|
| TRACKNUMBER
| VARCHAR(64)
| Reserved for IBM internal use.
|
| TRACKDATE
| TIMESTAMP
| Reserved for IBM internal use.
|
| PREPAREFLAGS
| INTEGER NOT NULL DEFAULT 0
| Contains the following bit flags indicating special processing to be performed by the OrderPrepare command as follows:
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 they can be re-generated if and as applicable.
2 = priceOverride - the price of the order item has been manually entered, and will not be changed by shopper commands.
4 = fulfillmentCenterOverride - the fulfillment center has been manually specified, and will not be changed by shopper commands.
8 = directCalculationCodeAttachment - calculation codes can be directly attached to the OrderItem. The default CalculationCodeCombineMethod will not look for direct attachments unless this flag is true.
16 = Reserved for IBM Internal Use.
32 = quotation - the order item was obtained from a quotation. The price will not be automatically refreshed by shopper commands.
64 = notConfigured - Price lookup and inventory allocation for this order item should not be done using the component items found in the OICOMPLIST table for this order item. For backward compatibility, this flag does not need to be set for order items whose configurationId column value is null.
128 = autoAdd - order item was added
|
| CORRELATIONGROUP
| BIGINT
| Normally 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.
|
| PROMISEDAVAILTIME
| TIMESTAMP
| When 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.
|
| SHIPPINGOFFSET
| INTEGER NOT NULL DEFAULT 0
| An estimate of how many seconds it will take to ship this item once the order is placed and inventory has been allocated.
|
| NEEDEDQUANTITY
| INTEGER NOT NULL DEFAULT 0
| Quantity 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.
|
| ALLOCQUANTITY
| INTEGER NOT NULL DEFAULT 0
| Quantity 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_ID
| INTEGER
| The fulfillment center from which inventory for this order item is allocated or backordered.
|
| ORDRELEASENUM
| INTEGER
| The associated order release, if any.
|
| CONFIGURATIONID
| VARCHAR(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.
|
| SUPPLIERDATA
| VARCHAR(254)
| Opaque to WebSphere Commerce. This attribute can be returned with a quotation, and sent when an order is placed on an external system. For example, it could contain a supplier distribution center ID.
|
| SUPPLIERPARTNUMBER
| VARCHAR(254)
| The supplier part number, if known. Suitable for display to the customer.
|
| AVAILQUANTITY
| INTEGER
| If specified, indicates the quantity available for purchase.
|
| ISEXPEDITED
| CHAR(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).
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| REQUESTEDSHIPDATE
| TIMESTAMP
| The 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.
|
| TIECODE
| SMALLINT
| TieCode used for items that are shipping at the same time (Ship Together).
|