[cflsystems]

It is not only the order items table, discounts/surcharges are also registered in the order surcharges table.
I'd suggest you follow the XC way of working with discounts/surcharges instead of direct changes to number sin database as this may just not always work properly