Every line item that is actually ordered is detailed in this table. The order as a whole is one record in the transactions 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 sku quantity price subtotal shipping taxable mv_mi mv_si size color options order_date update_date status pending = Pending shipped = Shipped backorder = Back ordered credit = Waiting for credit check canceled = Cancelled parent affiliate campaign description mv_mp