Order
Order ID
Invoice No.:
Invoice Prefix
Store ID
Store
Store Url
Customer ID
Customer
Customer Group ID
First Name
Last Name
E-Mail
Telephone
Fax
Customer Field
Payment First Name
Payment Last Name
Payment Company
Payment Address 1
Payment Address 2
Payment Postcode
Payment City
Payment Zone ID
Payment Zone
Payment Zone Code
Payment Country ID
Payment Country
Payment ISO Code 2
Payment ISO Code 3
Payment Address Format
Payment Custom field
Payment Method:
Payment Code
shipping First Name
shipping Last Name
shipping Company
shipping Address 1
shipping Address 2
shipping Postcode
shipping City
shipping Zone ID
shipping Zone
shipping Zone Code
shipping Country ID
shipping Country
shipping ISO Code 2
shipping ISO Code 3
shipping Address Format
shipping Custom field
Shipping Method:
shipping Code
Comment:
Total:
Reward Points:
Order status ID
Affiliate ID
Affiliate Firstname
Affiliate Lastname
Commission:
Language ID
Language Code
Language Directory
Currency ID
Currency Code
Currency Value
IP Address:
Forwarded IP:
User Agent:
Accept Language:
Date Added:
Date Modified:

Order Product
--------------------------------------
Order product ID
Order ID
Product ID
Product
Model
Quantity
Price
Total
Tax
Reward

Order Product Option
-------------------------------------
Order Option ID
Order ID
Order Product ID
Product Option ID
Product Option Value ID
Option Name
Option Value
Option Type

Order Total
-------------------------------------
Order Total ID
Order ID
Code
Title
Value
Sort order

Order History
-------------------------------------
Order History ID
Order ID
Order Status ID
Order Status
Notify
Comment
Date Added

Order Voucher
-----------------------------------
Order Voucher ID
Order ID
Voucher ID
Description
Code
From Name
From Email
To Name
Voucher Theme ID
Message
Amount