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. |