ORDER_STATUS_UPDATE_ITM010

ORDER_STATUS_UPDATE_ITM010_DATA

The Order Status Update message includes the ORDER_STATUS_UPDATE_ITM010_DATA segment. This data segment consists of item or product shipping specifications for the Order Status message.
The Order Status Update message supports two sets of application data: Order Status Update version 01 and Order Status Update version 02. Version 02 includes a superset of the data within version 01. Specifically, the ORDER_STATUS_UPDATE_ITM010_DATA segment for version 01 contains a value of 01 for the field NC_HDR010VersionNumber; whereas version 02 contains a value of 02 for NC_HDR010VersionNumber. In addition, Versions 02 also contains some additional fields not within version 01.
The format and the source of the fields for ORDER_STATUS_UPDATE_ITM010_DATA for version 02 are described in the following table. For field lengths, use the table below. For a description of a database column, follow the link to its associated table.

Field Name Field Type Table Name Column Name Note
NC_ITM010
VersionNumber CHAR (2) N/A N/A (fixed value of 02) N/A
NC_Order
RefNumber CHAR (10) ORDISTAT ORDERS_ID WebSphere Commerce order reference number.
NC_Merchant
OrderNumber CHAR (30) ORDISTAT OSMORDER Merchant's order reference number.
NC_Item
RefNumber CHAR (10) ORDISTAT ORDERITMES_ID WebSphere Commerce item reference number.
NC_ItemMerchant
RefNumber CHAR (30) ORDISTAT OIMITEM Merchant item reference number.
NC_Order
ItemStatus CHAR (32) ORDISTAT OISTATUS Order item status.
NC_Item
Schedule
ShipDate CHAR (8) ORDISTAT OISSTIME Scheduled shipping date, in the format YYYYMMDD.
NC_Item
ActualShipDate CHAR (8) ORDISTAT OIASTIME Actual shipping date, in the format YYYYMMDD.
NC_Item
PlaceDate CHAR (8) ORDISTAT OIPLTIME Placing date, in the format YYYYMMDD.
NC_Item
Quantity CHAR (10) ORDISTAT OIQTCONFIRM Quantity of items ordered.
NC_Item
CurrencyType CHAR (10) ORDISTAT OICPCUR Currency in which the price of the item is expressed. The format of the price must adhere to ISO 4217 standards.
NC_Item
UnitPrice CHAR (16) ORDISTAT OIPRTOT Unit price for the item.
NC_Item
TotalPrice CHAR (16) ORDISTAT OITOTPRC Total price for the item.
NC_Item
TotalTaxPrice CHAR (16) ORDISTAT OITXTOT Total sales price for the item.
NC_ItemTotal
ShippingPrice CHAR (16) ORDISTAT OISHTOT Total shipping price for the item.
NC_ItemTotal
TaxShippingPrice CHAR (16) ORDISTAT OISHTXTOT Total tax on the shipping price for the item.
NC_Item
Comment CHAR (250) ORDISTAT OICMNT Comments from the customer regarding the item ordered. For example, a customer can include a greeting message with the ordered gift.

The format and the source of the fields for ORDER_STATUS_UPDATE_ITM010_DATA for version 01 are described in the following table:

Field Name Field Type Table Name Column Name Description
NC_ITM010
VersionNumber CHAR (2) N/A N/A Fixed value of 01.
NC_Order
RefNumber CHAR (10) ORDISTAT ORDERS_ID WebSphere Commerce order reference number.
NC_Item
RefNumber CHAR (10) ORDISTAT ORDERITMES_ID WebSphere Commerce item reference number.
NC_Order
ItemStatus CHAR (32) ORDISTAT OISTATUS Order item status.
NC_Item
Schedule
ShipDate CHAR (8) ORDISTAT OISSTIME Scheduled shipping date, in the format YYYYMMDD.
NC_Item
ActualShipDate CHAR (8) ORDISTAT OIASTIME Actual shipping date, in the format YYYYMMDD.
NC_Item
PlaceDate CHAR (8) ORDISTAT OIPLTIME Placing date, in the format YYYYMMDD.
NC_Item
Quantity CHAR (10) ORDISTAT OIQTCONFIRM Quantity of items ordered.
NC_Item
Comment CHAR (250) ORDISTAT OICMNT Comments from the customer regarding the item ordered. For example, a customer can include a greeting message with the ordered gift.

Related reference
Back-end integration legacy messages
Order Status Update message

Field Name	Field Type	Table Name	Column Name	Note
NC_ITM010 VersionNumber	CHAR (2)	N/A	N/A (fixed value of 02)	N/A
NC_Order RefNumber	CHAR (10)	ORDISTAT	ORDERS_ID	WebSphere Commerce order reference number.
NC_Merchant OrderNumber	CHAR (30)	ORDISTAT	OSMORDER	Merchant's order reference number.
NC_Item RefNumber	CHAR (10)	ORDISTAT	ORDERITMES_ID	WebSphere Commerce item reference number.
NC_ItemMerchant RefNumber	CHAR (30)	ORDISTAT	OIMITEM	Merchant item reference number.
NC_Order ItemStatus	CHAR (32)	ORDISTAT	OISTATUS	Order item status.
NC_Item Schedule ShipDate	CHAR (8)	ORDISTAT	OISSTIME	Scheduled shipping date, in the format YYYYMMDD.
NC_Item ActualShipDate	CHAR (8)	ORDISTAT	OIASTIME	Actual shipping date, in the format YYYYMMDD.
NC_Item PlaceDate	CHAR (8)	ORDISTAT	OIPLTIME	Placing date, in the format YYYYMMDD.
NC_Item Quantity	CHAR (10)	ORDISTAT	OIQTCONFIRM	Quantity of items ordered.
NC_Item CurrencyType	CHAR (10)	ORDISTAT	OICPCUR	Currency in which the price of the item is expressed. The format of the price must adhere to ISO 4217 standards.
NC_Item UnitPrice	CHAR (16)	ORDISTAT	OIPRTOT	Unit price for the item.
NC_Item TotalPrice	CHAR (16)	ORDISTAT	OITOTPRC	Total price for the item.
NC_Item TotalTaxPrice	CHAR (16)	ORDISTAT	OITXTOT	Total sales price for the item.
NC_ItemTotal ShippingPrice	CHAR (16)	ORDISTAT	OISHTOT	Total shipping price for the item.
NC_ItemTotal TaxShippingPrice	CHAR (16)	ORDISTAT	OISHTXTOT	Total tax on the shipping price for the item.
NC_Item Comment	CHAR (250)	ORDISTAT	OICMNT	Comments from the customer regarding the item ordered. For example, a customer can include a greeting message with the ordered gift.

Field Name	Field Type	Table Name	Column Name	Description
NC_ITM010 VersionNumber	CHAR (2)	N/A	N/A	Fixed value of 01.
NC_Order RefNumber	CHAR (10)	ORDISTAT	ORDERS_ID	WebSphere Commerce order reference number.
NC_Item RefNumber	CHAR (10)	ORDISTAT	ORDERITMES_ID	WebSphere Commerce item reference number.
NC_Order ItemStatus	CHAR (32)	ORDISTAT	OISTATUS	Order item status.
NC_Item Schedule ShipDate	CHAR (8)	ORDISTAT	OISSTIME	Scheduled shipping date, in the format YYYYMMDD.
NC_Item ActualShipDate	CHAR (8)	ORDISTAT	OIASTIME	Actual shipping date, in the format YYYYMMDD.
NC_Item PlaceDate	CHAR (8)	ORDISTAT	OIPLTIME	Placing date, in the format YYYYMMDD.
NC_Item Quantity	CHAR (10)	ORDISTAT	OIQTCONFIRM	Quantity of items ordered.
NC_Item Comment	CHAR (250)	ORDISTAT	OICMNT	Comments from the customer regarding the item ordered. For example, a customer can include a greeting message with the ordered gift.