ORDER_CREATE_HDR010_DATA

The Order Create message includes the ORDER_CREATE_HDR010_DATA segment. This data segment consists of order specifications for the Order Create message.

The format and the source of the fields for ORDER_CREATE_HDR010_DATA are described in the following table. For a description of the database column, follow the link to its associated table.

Field Name Field Type Table Name Column Name Description
NC_HDR010 Version Number CHAR (2) N/A N/A Fixed value of 01.
NC_Order RefNumber CHAR (10) ORDERS ORDERS_ID Unique order reference number, internally generated. This is a primary key.
NC_Order Date CHAR (8) ORDERS TIMEPLACED Date the order was placed, in the format YYYYMMDD.
NC_Order Time CHAR (6) ORDERS TIMEPLACED Time the order was placed, in the format HHMMSS.
NC_Currency Type CHAR (10) ORDERS CURRENCY Currency in which the price is expressed. The format of the currency must adhere to ISO 4217 standards.
NC_Total Price CHAR (16) ORDERS TOTALPRODUCT Total product price for the order.
NC_Total TaxPrice CHAR (16) ORDERS TOTALTAX Total sales tax for the order.
NC_Total ShippingPrice CHAR (16) ORDERS TOTALSHIPPING Total shipping charges for the order.
NC_Total TaxShipping Price CHAR (16) ORDERS TOTALTAXSHIPPING Total tax on shipping charges for the order.
NC_Shopper RefNumber CHAR (10) ORDERS MEMBER_ID Shopper reference number.
NC_Merchant RefNumber CHAR (10) ORDERS STOREENT_ID Merchant reference number.
NC_Merchant OrderNumber CHAR (30) ORDERS ORMORDER Unique order reference number generated by the merchant
NC_BillTo RefNumber CHAR (10) ORDERS ADDRESS_ID Billing address reference number.
NC_Order CustField1 CHAR (10) ORDERS FIELD1 Reserved for merchant customization.
NC_Order CustField2 CHAR (16) ORDERS FIELD2 Reserved for merchant customization.
NC_Order CustField3 CHAR (254) ORDERS FIELD3 Reserved for merchant customization.