Order Report Fields: Order No, Order Date, Customer No, Order Status, Ship Date, Billing Status, Order Amount, Order Net, Bill Last Name, Bill First Name, Bill Phone, Bill Phone Ext, Bill Company Name, Bill Address, Bill Address 2, Bill City, Bill State, Bill Postal, Bill Country, Bill Type, Payment Method, Credit Card Type, Credit Card Number, Credit Card Expiration Date, PO Number, Placed By, Affiliate, Customer Comments, Company Comments, Order Type, IP Address, IP Country.
Order Details (Line Items): Order No, Item, SKU, Unit Price, Quantity, Extended Price, Status, Ship Date, Ship From, Ship Last Name, Ship First Name, Ship Phone, Ship Phone Ext, Ship Company Name, Ship Address, Ship Address 2, Ship City, Ship State, Ship Postal Code, Ship Country, Ship Type, Ship Method, Sales Tax Rate, Tracking Number, Gift Card, Gift Card Text, Gift Wrap.
Customers: Customer No, Last Name, First Name, Email, Address Label, Company Name, Address 1, Address 2, City, State, Postal Code, Country, Address Type, Phone Num, Phone Ext, Primary Ship, Primary Bill, Discount, Mailing List, Active, Cust Type, Password, Password Reminder, Custom Field 1, Custom Field 2, Custom Field 3, Custom Field 4, Custom Field 5, Custom Field 6, Affiliate, Comments.
