SP Transaction Notification for Special Prices
I need to monitor changes on the additions and updates for the business partners special prices. I have a challenge while implementing the
@num_of_cols_in_key because I understand a special price object number 7 has two keys i.e CardCode and ItemCode both from OSPP table.
I have tested with this sql code:
IF ((@object_type = 7) AND (@transaction_type = 'U'))
IF EXISTS (SELECT T0.ItemCode, T0.CardCode, T0.Price, T0.Currency, T0.Discount, T0.ListNum FROM OSPP T0 WHERE
T0.ItemCode = @list_of_key_cols_tab_del)
What am I doing wrong?