Hi,
Very straightforward requirement here for just one SQL trigger.
If the ERP is EAV based, then I tend towards just using a CASE statement. But for some 3TB sized databases that pivot around some key 3-4 tables, I much prefer separate statements to prevent any chance of parameter sniffing and bottlenecks.
Regards,
Richard