4 minutes ago, idnovate.com said:But this value is stored in fields total_discounts, total_discounts_tax_incl, total_discounts_tax_excl from table ps_orders.
yes, at the time of order creation, values are being calculated according to applied discount as per the ps_cart_rule table and stored in ps_orders to reduce the joins and recalculation everytime while fetching order details.
So if we want the original discount information from where it is calculated, that is in ps_cart_rule and calculated amount is in ps_orders.