ORDER_CREATE_ITM010_DATA

The Order Create message includes the ORDER_CREATE_ITM010_DATA segment. This data segment consists of item or product shipping specifications for the Order Create message.

The format and the source of the fields for ORDER_CREATE_ITM010_DATA 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 01.
NC_Item LineNumber CHAR (3) N/A N/A (generated as a sequential number) N/A
NC_Item RefNumber CHAR (10) ORDERITEMS ORDERITEMS_ID Unique ship to reference number, internally generated. This is a primary key.
NC_Item ProductRefNumber CHAR (10) ORDERITEMS CATENTRY_ID Item or product reference number. This is not a foreign key.
NC_Item ProductNumber CHAR (64) CATENTRY PARTNUMBER Item SKU or product number.
NC_Item Product ShortDescription CHAR (254) CATENTDESC SHORTDESCRIPTION Short description of the item or product, including its name.
NC_Item UnitPrice CHAR (16) ORDERITEMS PRICE Unit price of the item.
NC_Item CurrencyType CHAR (10) ORDERITEMS CURRENCY Currency in which the price is expressed. The format of the currency must adhere to ISO 4217 standards.
NC_Item ProductQuantity CHAR (10) ORDERITEMS QUANTITY Quantity ordered.
NC_Item ShipToAddr RefNum CHAR (10) ORDERITEMS ADDRESS_ID Address reference number for the shipping address.
NC_Item ShipMode RefNum CHAR (10) ORDERITEMS SHIPMODE_ID Merchant shipping mode reference number
NC_ItemState CHAR (1) ORDERITEMS STATUS Order Status: P - In pending state C - In past state X - canceled I - Inventory update pending M - Ready for authentication
NC_Item ShipTo LastName CHAR (30) ADDRESS LASTNAME Ship to customer's last name.
NC_Item ShipTo MiddleName CHAR (30) ADDRESS MIDDLENAME Ship to customer's middle name.
NC_Item ShipTo FirstName CHAR (30) ADDRESS FIRSTNAME Ship to customer's first name.
NC_Item ShipToAddr1 CHAR (50) ADDRESS ADDRESS1 Ship to customer's address line 1.
NC_Item ShipToAddr2 CHAR (50) ADDRESS ADDRESS2 Ship to customer's address line 2.
NC_Item ShipToAddr3 CHAR (50) ADDRESS ADDRESS3 Ship to customer's address line 3.
NC_Item ShipToCity CHAR (30) ADDRESS CITY Ship to customer's city name.
NC_Item ShipToState CHAR (20) ADDRESS STATE Ship to customer's state, province, or equivalent, abbreviated.
NC_Item ShipToCountry CHAR (30) ADDRESS COUNTRY Ship to customer's country/region.
NC_Item ShipToZipCode CHAR (20) ADDRESS ZIPCODE Ship to customer's zip code or equivalent.
NC_Item ShipToEmail1 CHAR (254) ADDRESS EMAIL1 Ship to customer's primary e-mail or URL address.
NC_Item ShipToEmail2 CHAR (254) ADDRESS EMAIL2 Ship to customer's secondary e-mail or URL address.
NC_Item ShipToPhone1 CHAR (30) ADDRESS PHONE1 Ship to customer's primary phone number.
NC_Item ShipToPhone2 CHAR (30) ADDRESS PHONE2 Ship to customer's secondary phone number.
NC_Item ShipToFax CHAR (30) ADDRESS FAX1 Ship to customer's facsimile number.
NC_Item ShippingCarrier CHAR (30) SHIPMODE CARRIER Carrier identifier, such as Federal Express.
NC_Item ShippingMethod CHAR (30) SHIPMODE CODE Carrier service shipping mode, such as FedEx Express Overnight.
NC_Item ShipToComment CHAR (254) ORDERITEMS COMMENTS Comments from customer, such as a greeting for a gift.
NC_Item Creation Timestamp CHAR (64) ORDERITEMS LASTCREATE Date and time the ship to entry was made.
NC_Item Update Timestamp CHAR (64) ORDERITEMS LASTUPDATE Date and time the ship to entry was last updated.
NC_Item CustField1 CHAR (10) ORDERITEMS FIELD1 Reserved for merchant customization.
NC_Item CustField2 CHAR (254) ORDERITEMS FIELD2 Reserved for merchant customization.