Paul POULAIN wrote:
Could someone from katipo explain what is the meaning of the various=20 columns in aqorders table that are related to an amount.
I'm not katipo, but here's my impression.
I see : * listprice (the price entered when placing the order ?)
The full catalgue price of the item (not including discounts)
* totalamount (seems always empty)
I'd expect this to be unitprice*number ordered after discounts and surcharges.
* freight (empty or=3D0 for me ? Maybe should be attached to the aqbasket= table if it's freight fees, as they should be counted only once) * unitprice (the price really paid ?) * rrp (?)
Recommended retail price (not trade price).
* ecost (?) * gst (?)
General sales tax (our local equivalent, VAT, is not paid on books in the UK - don't know about TVA). -- MJ Ray (slef), K. Lynn, England, email see http://mjr.towers.org.uk/ http://www.ttllp.co.uk/koha/