5.26. transactions.txt
Each individual customer order has an entry in this table. The line items are not entered here, but in the orderline table.
See the page query/check_orders.html for how it can be used. See etc/report for how to add to it.
code store_id order_number session username shipmode nitems subtotal shipping handling salestax total_cost fname lname Last Name company address1 address2 Address line 2 city state zip country phone_day Daytime Phone phone_night Home Phone fax email b_fname b_lname Billing Last Name b_company b_address1 b_address2 Billing Address Line 2 b_city b_state Billing State b_zip Billing Postcode b_country Billing Country b_phone order_date order_ymd order_wday payment_method po_number avs order_id update_date status affiliate campaign parent archived deleted complete comments