Dear Experts,
I have the below query from dbo.SBO_SP_TransactionNotification developed by my vendor. My Questions are:
1) What is the working of variable @list_of_cols_val_tab_del?
2) What is the working of variable @list_of_key_cols_tab_del?
3)Where is object_type=140 is defined as object types saved in table OPDF (Payment Draft) is either 24 and 46 as they are for ORCT(Incoming Payments) and OVPM(Outgoing Payments)?
IF @transaction_type ='A' AND @object_type = '140'
BEGIN
IF EXISTS (SELECT T0.[DocNum] FROM OPDF T0 WHERE T0.[DocType] ='c' AND T0.[Usersign]='21' AND T0.[PayNoDoc] ='Y' AND T0.DocEntry = @list_of_cols_val_tab_del)
BEGIN
SELECT @Error = 1, @error_message = 'Abacus - You cannot receive Payment On Account'
END
END
Please Elaborate and explain as I have couple of assignments in the dbo.SBO_SP_TransactionNotification.