USP_MISCELLANEOUS_ADDPAYMENT

Adds a miscellaneous payment.
Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@AMOUNT	money	IN
@CREATIONDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_MISCELLANEOUS_ADDPAYMENT
            (
                @REVENUEID uniqueidentifier,
                @AMOUNT money,
                @CREATIONDATE datetime = null,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on;

                declare @ID uniqueidentifier;
                set @ID = newid();

                declare @BASEAMOUNT money;
                declare @ORGANIZATIONAMOUNT money;
                declare @TRANSACTIONCURRENCYID uniqueidentifier;
                declare @BASECURRENCYID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;
                declare @ORGANIZATIONEXCHANGERATEID uniqueidentifier;

                select @BASEAMOUNT = AMOUNT
                    ,@ORGANIZATIONAMOUNT = ORGANIZATIONAMOUNT
                    ,@TRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID
                    ,@BASECURRENCYID = BASECURRENCYID
                    ,@BASEEXCHANGERATEID = BASEEXCHANGERATEID
                    ,@ORGANIZATIONEXCHANGERATEID = ORGANIZATIONEXCHANGERATEID
                from dbo.REVENUE
                where ID = @REVENUEID;

                insert into dbo.REVENUESPLIT(ID, REVENUEID, AMOUNT, TRANSACTIONAMOUNT, ORGANIZATIONAMOUNT,  APPLICATIONCODE, TYPECODE, DESIGNATIONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, TRANSACTIONCURRENCYID, BASECURRENCYID, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID)
          values(@ID, @REVENUEID, @BASEAMOUNT, @AMOUNT, @ORGANIZATIONAMOUNT, 11, 8, null, @CHANGEAGENTID, @CHANGEAGENTID, @CREATIONDATE, @CREATIONDATE, @TRANSACTIONCURRENCYID, @BASECURRENCYID, @BASEEXCHANGERATEID, @ORGANIZATIONEXCHANGERATEID)