USP_PAYMENT_ADDORIGINALAMOUNT

Maps the payment original amount when the payment is created.
Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_PAYMENT_ADDORIGINALAMOUNT(
                @REVENUEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )as
                set nocount on

                --If there is no revenueid then exit

                if (@REVENUEID is null)
                    return 0;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate()


                if exists(select top 1 [ID] from dbo.[REVENUE] where [ID] = @REVENUEID and [TRANSACTIONTYPECODE] = 0) and
                    not exists(select top 1 [ID] from dbo.[PAYMENTORIGINALAMOUNT] where ID = @REVENUEID) 
                begin

                    insert into dbo.[PAYMENTORIGINALAMOUNT](
                        [ID],
                        [ORIGINALAMOUNT],
                        [TRANSACTIONAMOUNT],
                        [ORGANIZATIONAMOUNT],
                        [BASECURRENCYID],
                        [TRANSACTIONCURRENCYID],
                        [BASEEXCHANGERATEID],
                        [ORGANIZATIONEXCHANGERATEID],
                        [ADDEDBYID],
                        [CHANGEDBYID], 
                        [DATEADDED], 
                        [DATECHANGED]
                    )
                    select
                        ID,
                        AMOUNT,
                        TRANSACTIONAMOUNT,
                        ORGANIZATIONAMOUNT,
                        BASECURRENCYID,
                        TRANSACTIONCURRENCYID,
                        BASEEXCHANGERATEID,
                        ORGANIZATIONEXCHANGERATEID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE
                    from
                        dbo.REVENUE
                    where
                        ID = @REVENUEID;

                end
                else
                    return 0;