Skip to Content
0
Former Member
Feb 11, 2011 at 07:39 AM

Clarification for (dbo.SBO_SP_TransactionNotification)

41 Views

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.