USP_REVENUETRANSACTION_MARKASRERECEIPT

Executes the "Revenue Transaction: Re-receipt" record operation.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_REVENUETRANSACTION_MARKASRERECEIPT
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as

                        set nocount on;

            /* CMC
                        update dbo.FINANCIALTRANSACTION
                        set 
                            FINANCIALTRANSACTION.CHANGEDBYID = @CHANGEAGENTID, 
                            FINANCIALTRANSACTION.DATECHANGED = getdate()
                        where ID = @ID

            update dbo.REVENUE_EXT
                        set 
                            REVENUE_EXT.NEEDSRERECEIPT = 1
                        where ID = @ID
            */
            update dbo.REVENUE
                        set 
                            REVENUE.NEEDSRERECEIPT = 1,
              REVENUE.CHANGEDBYID = @CHANGEAGENTID, 
                            REVENUE.DATECHANGED = getdate()
                        where ID = @ID

                        return 0;