A product which have following prices in catalog has been sold with qty 1:-
Price - 65.00 [INR] [Inc. Tax Rs 8.23] Rate - 51.61 [INR] [Inc. Tax Rs 6.54] SpecialPrice - 61.75 [INR] [Inc. Tax Rs 7.82] Cost - 59.09
when I go to table "sales_flat_order_item" and find this item, there following prices are being shown-
base_cost - 59.09 price - 53.93 base_price - 53.93 original_price - 61.75 base_original_price - 61.75 tax_percent - 14.5 tax_amount - 7.82
Now in this table which column represent Rate, Special Price and Price of product? So I can know what was the selling price of this product.