USP_RECEIVABLECREDIT_DELETE

Executes the "Delete credit" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy


                    CREATE procedure dbo.USP_RECEIVABLECREDIT_DELETE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin
                        set nocount on;

                        -- create financial transaction xml

                        declare @TRANSACTIONSXML xml;
                        set @TRANSACTIONSXML = (select @ID as ID for xml raw('ITEM'),type,elements,root('TRANSACTIONS'),BINARY BASE64);

                        -- delete financial transaction

                        exec USP_FINANCIALTRANSACTION_DELETEMULTIPLE @TRANSACTIONSXML, @CHANGEAGENTID                    

                        return 0;

                    end