| Credit note ID | id_order_slip (NUMBER) | * select = 'os.`id_order_slip`'; |
| Order ID | id_order (NUMBER) | * select = 'os.`id_order`'; |
| Customer ID | id_customer (NUMBER) | * select = 'os.`id_customer`'; |
| Customer name | customer (TEXT) | * select = 'CONCAT(
IFNULL(`customer`.firstname, ''), ' ', IFNULL(`customer`.lastname, '') ) as `customer`'; * join = 'LEFT JOIN `ps_customer` `customer` ON (`customer`.id_customer = os.id_customer)'; |
| Total products TTC | total_products_tax_incl (NUMBER) | * select = 'os.`total_products_tax_incl`'; |
| Total products HT | total_products_tax_excl (NUMBER) | * select = 'os.`total_products_tax_excl`'; |
| Total shipping TTC | total_shipping_tax_incl (NUMBER) | * select = 'os.`total_shipping_tax_incl`'; |
| Total shipping HT | total_shipping_tax_excl (NUMBER) | * select = 'os.`total_shipping_tax_excl`'; |
| Total TTC | total_tax_incl (NUMBER) | * select = '(os.total_products_tax_incl + os.total_shipping_tax_incl) as `total_tax_incl`';
|
| Total HT | total_tax_excl (NUMBER) | * select = '(os.total_products_tax_excl + os.total_shipping_tax_excl) as `total_tax_excl`';
|
| Credit note date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(os.date_add, '%Y%m%d%H') as date_add';
|
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = o.id_shop'; |