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.

Feedback