This section describes the fields that are created by an order export, as discussed in Exporting Orders. An order export generates four main files:
· Order File
· Person File
· Order Line File
· Payment File
Where a field is in bold it means that it is referenced by other fields in the other tables.
|
Field Heading |
Explanation (where required) |
|
Order Sequence Number |
Unique number allocated sequentially to each order in turn. This is a key field referred to by some of the other tables |
|
Order Number |
The order number |
|
Parent Sequence Number |
Only used if this is a back order |
|
Back Order Number |
Only used if this order has back orders related to it |
|
PO Number |
PO = Parent Order number (if this is a back order) |
|
Invoice Contact ID |
Number that refers to a specific contact record in persons.csv |
|
Deliver Contact ID |
Number that refers to a specific contact record in persons.csv |
|
Status |
Status of record |
|
Currency |
International monetary symbol for order's currency |
|
Payment Option |
Payment Option
Selected |
|
Movement |
1 =
moving in next month |
|
User Definable 1 |
Answer to 'How did you find our site?' (or equivalent) |
|
User Definable 2 |
Answer to 'What was your reason for buying?' (or equivalent) |
|
Invoice Print Status |
The invoice print-status: |
|
Bill of Materials Print Status |
Packing List print-status: |
|
Total Cost |
Total cost of all the products (before discount) in number form |
|
Discount Percent |
The amount of discount given (in percent) |
|
Discount Cost |
The amount of discount given (in number form) |
|
Sub-heading Cost |
Cost of products less cost of discount |
|
Shipping Total Cost |
Amount of shipping charged on the order |
|
Tax Percent 1 |
Amount of tax 1 charged as a percentage |
|
Tax Total Cost 1 |
Total cost amount of tax 1 charged |
|
Tax Percent 2 |
Amount of tax 2 charged as a percentage |
|
Tax Total Cost 2 |
Total cost amount of tax 2 charged |
|
Order Total Cost |
Total cost including everything |
|
Total Lines |
Total number of order detail lines |
|
Total Lines Shipped |
Number of lines shipped |
|
Total Lines Cancelled |
Number of lines cancelled |
|
Total Lines Back-ordered |
Number of lines back-ordered |
|
Credit Card Number |
Credit card number provided with the order - YYYY/mm |
|
Credit Card Expiry Date |
Credit card expiry date provided with the order - YYYY/mm |
|
Credit Card Type |
The type of card used |
|
CC Authorization code |
The credit card authorization code (or transaction number) |
|
Credit Card Issue Number |
Credit card issue number provided with the order |
|
Credit Card Start Date |
Credit card start date provided with the order |
|
Date Ordered |
Date the order was placed at the website, YYYY/mm/dd hh:mm |
|
Date Received |
The date and time Actinic received the order into the application, YYYY/mm/dd hh:mm |
|
Date Order Shipped |
The date and time that the order was marked as shipped in the application, YYYY/mm/dd hh:mm |
|
Adjustment Message |
Message provided when an adjustment was made to the order. |
|
Report Number |
The number of the report that this order appears on. Used to regenerate the report |
|
Date CC details Printed |
The date and time that Catalog printed the credit card schedule, YYYY/mm/dd hh:mm |
|
Shipping Tax Cost 1 |
The cost of tax 1 applied to the shipping charge |
|
Shipping Tax Cost 2 |
The cost of tax 2 applied to the shipping charge |
|
Shipping Tax Treatment |
The tax treatment for the shipping cost. |
|
Reference Number |
The order reference number retrieved from the external script |
|
User Definable 3 |
Text entered by the customer for User Definable 3. This is normally used by Referrer.pl |
|
User Definable Payment |
Text entered in user definable field in payment phase |
|
User Definable Shipping |
Text entered in user definable field in shipping phase ('Any Special Delivery Instructions') |
|
User Definable Tax |
Text entered in user definable field in tax phase (often a VAT registration number) |
|
Opaque Shipping Data |
Details about the shipping details: the shipping zone and shipping class, the weight of the order and the cost of the shipping. |
|
Shipping Description |
Description of selected class of shipping |
|
Payment Status |
Status of payment |
|
Delivery Country Code |
Country code |
|
Delivery Region Code |
State/province code |
|
Invoice Country Code |
Country code |
|
Invoice Region Code |
State/province code (** indicates undefined region) |
|
Opaque Handling Data |
The handling charge made on the order |
|
Handling Description |
The description of the handling change (controlled in 'Design | Text') |
|
Tax Model Data |
The v6.0 tax data is the system by which Actinic calculates the entire tax for the order. Band ID=Band Rate=Custom Rate=Band Name Band ID - string for the band ID Band Rate - string for the band rate Custom Rate - string for the custom rate Band Name - string for the band name |
|
Original Tax Model Data |
The tax data is the system by which Actinic calculated the original entire tax for the order |
|
V4Tax 1 Data |
The tax data is the system by which Actinic calculates the final tax 1 for the order |
|
Original 4 Tax 1 Data |
The tax data is the system by which Actinic calculated the original tax 1 for the order |
|
V4 Tax 2 Data |
The tax data is the system by which Actinic calculates the final tax 2 for the order |
|
Original V4 Tax 2 Data |
The tax data is the system by which Actinic calculated the original tax 2 for the order |
|
Tax 1 Exempt |
1 -
buyer is exempt from tax 1 |
|
Tax 2 Exempt |
1 -
buyer is exempt from tax 2 |
|
Tax 1 Exemption Data |
Information provided when buyers exempt themselves |
|
Tax 2 Exemption Data |
Information provided when buyers exempt themselves |
|
Total Items Ordered |
Total number of lines ordered |
|
Number of Items Shipped |
Number of Items Shipped |
|
Number of Items Cancelled |
Number of Items Cancelled |
|
Number of Items Back-Ordered |
Number of Items Back-Ordered |
|
Handling Total Cost |
The total cost of the final handling charge |
|
Handling Tax Cost 1 |
The cost of tax 1 for the final handling charge |
|
Handling Tax Cost 2 |
The cost of tax 2 for the final handling charge |
|
Buyer ID |
The buyer ID (-1 if a retail order). Refers to buyers.csv. |
|
Customer ID |
The customer ID (-1 if a retail order). Refers to buyers.csv. |
|
Handling Tax Treatment |
The tax treatment on the handling charge |
|
Handling Tax 1 Rate |
The rate of tax 1 on the handling charge as a percentage |
|
Shipping Tax 1 Rate |
The rate of tax 1 on the shipping charge as a percentage |
|
Handling Tax 2 Rate |
The rate of tax 2 on the handling charge as a percentage |
|
Shipping Tax 2 Rate |
The rate of tax 2 on the shipping charge as a percentage |
|
Handling Tax 1 Code |
An Actinic reference code for the tax 1 applied to handling |
|
Shipping Tax 1 Code |
An Actinic reference code for the tax 1 applied to shipping |
|
Handling Tax 2 Code |
An Actinic reference code for the tax 2 applied to handling |
|
Shipping Tax 2 Code |
An Actinic reference code for the tax 2 applied to shipping |
|
Tax 1 Name |
The name of Tax 1 |
|
Tax 2 Name |
The name of Tax 2 |
|
Preauthorized Report Number |
The id of the preauthorized credit card that this order was shown on - if appropriate. |
|
Tax 1 ID |
A unique ID applied to the tax by Actinic |
|
Tax 2 ID |
A unique ID applied to the tax by Actinic |
|
WorldShip Export Date |
The date and time the order details were last transferred to UPS WorldShip |
|
Offline Order |
This will be set to '1' if the order is an offline order entered straight into the application. |
|
Coupon Code |
The coupon code that was entered by the customer online. |
|
ECI |
'Electronic Commerce Indicator'. This is set to '1' if the order was taken over the internet. |
|
Order Color |
A reference for the colour of the order. |
|
Journal |
Any text entered into the 'Journal' tab of the order. |
|
Terms and Conditions Accepted |
Set to '1' if the customer has accepted the terms and conditions of the order. |
|
Field Heading |
Explanation (where required) |
|
Order Sequence Number |
Unique number allocated sequentially to each order in turn. Referred to in orders.csv. |
|
Order Detail ID |
Unique number allocated sequentially to each line in the order in turn |
|
Status |
Status of record |
|
Product Reference |
Product Reference number of the product |
|
Product Description |
Short Description of the product - if it is a component then this will be the component name rather than then name of the associated product. |
|
Detailed Description |
The Report Description. |
|
Quantity Ordered |
Quantity of this line that has been ordered |
|
Quantity Shipped |
Quantity of this line that has been shipped |
|
Quantity Cancelled |
Quantity of this line that has been cancelled |
|
Quantity Back Ordered |
Quantity of this line that has been back ordered |
|
Price |
Price per unit of this line |
|
Tax 1 |
Amount of tax 1 calculated on the entire line |
|
Tax 2 |
Amount of tax 2 calculated on the entire line |
|
Tax Treatment |
Code for how the order line was treated tax-wise |
|
Total Cost |
Total cost of the order lines before tax and shipping |
|
Date Input |
Answer to question asked in Date field YYYY/mm/dd |
|
Information Input |
Answer to question asked in Other Info field |
|
Opaque Shipping Data |
Normally the weight of the product |
|
Original Unit Price |
Unit price of each line originally |
|
Original Tax 1 |
Amount of tax 1 calculated on the entire line originally |
|
Original Tax 2 |
Amount of tax 2 calculated on the entire line originally |
|
Original Total Cost |
Original total cost of the entire line |
|
Discount |
The discount total for this line |
|
Discount Rate |
The discount percentage for this line |
|
Original Discount |
The original discount total for this line. Default = 0 |
|
Original Discount Rate |
The original discount percentage for this line. Default = 0 |
|
Cancel Message |
The supplier's cancellation message for an order item or the supplier's adjustment message for an adjustment item |
|
V4 Tax 1 Data |
The tax data is the system by which Actinic calculates the tax 1 rate for the order line |
|
V4 Tax 2 Data |
The tax data is the system by which Actinic calculates the tax 2 rate for the order line |
|
Original V4 Tax 1 Data |
The tax data is the system by which Actinic calculated the tax 1 rate for the order line online |
|
Original V4 Tax 2 Data |
The tax data is the system by which Actinic calculated the tax 2 rate for the order line online |
|
Component Flag |
Set to 1 if this is a component |
|
Component Parent ID |
The ID of the parent product (if this is a component - if it is a main product this will show '-1') |
|
Tax 1 Rate |
The rate of Tax 1 charged on the line as a percentage |
|
Tax 2 Rate |
The rate of Tax 2 charged on the line as a percentage |
|
Tax 1 Code |
The Actinic reference for the tax 1 charged on the order line |
|
Tax 2 Code |
The Actinic reference for the tax 2 charged on the order line |
|
No Orderline For Main Product |
Set to '1' of the order line is a main product - but the main product line was not shown online |
|
Components Have Separate Order Lines |
Set to '1' of the order line is a component - and online the customer saw the component as a separate order line |
|
Line Type |
'0' for main product, '1' for component |
|
Offline Order Line |
This is set to '1' if the order is an offline order. |
|
Coupon Code |
Any coupon code supplied with the order online. |
|
Field Heading |
Explanation (where required) |
|
Order Sequence Number |
Unique number allocated sequentially to each order in turn. This is a key field referred to by some of the other tables |
|
Contact ID |
Unique number allocated sequentially to each contact in turn. Refers to orders.csv. |
|
Name |
Information supplied in the Name field (in any) |
|
Salutation |
Information supplied in the Salutation field (in any) |
|
Title |
Information supplied in the Title field (in any) |
|
Company |
Information supplied in the Company field (in any) |
|
Address Line 1 |
Information supplied in the Address Line 1 field (in any) |
|
Address Line 2 |
Information supplied in the Address Line 2 field (in any) |
|
Address Line 3 |
Information supplied in the Address Line 3 field (in any) |
|
Address Line 4 |
Information supplied in the Address Line 4 field (in any) |
|
Address Country |
Information supplied in the Address Country field (in any) |
|
Postal Code |
Information supplied in the Postal Code field (in any) |
|
Phone Number |
Information supplied in the Phone Number field (in any) |
|
FAX Number |
Information supplied in the FAX Number field (in any) |
|
Email Address |
Information supplied in the Email Address field (in any) |
|
Web Site |
Information supplied in the Web Site field (in any) |
|
User Defined |
Information supplied in the User Defined field (in any) |
|
Customer External Reference Business/Designer only |
The 'External Reference' field for a customer account. |
|
Keep Contact Private |
If customers indicate they do want you to share their information with third parties, this will be set to '1'. Otherwise '0' |
|
Field Heading |
Explanation (where required) |
|
Order Sequence Number |
Unique number referring to the order (from orders.csv) |
|
Time Created |
Date and time the record was created in format YYYY/MM/DD hh:mm. |
|
Payment Status |
0 - Payment Service Provider order pending payment |
|
Entry Type |
Whether the record was automatically (i.e. Web site) or manually (i.e. Actinic order processing) created |
|
Operation Mode |
|
|
Amount |
The amount involved |
|
Currency |
The currency code for the payment |
|
Comment |
Information entered in the comment field |
|
Payment Type |
0 - credit card
debit |
|
Time Actioned |
Date and time the record was actioned in format YYYY/MM/DD hh:mm |
|
CC Auth Code |
Credit card authorization code |
|
OCC Provider Ref |
PSP transaction reference number |
|
Customer Ref |
Code from the PSP that refers to the customer |
|
OCC Provider Response |
Used for a variety of reasons, depending on which PSP you choose |