USP_DATALIST_EVENTREGISTRANT_GETRECEIPTAMOUNT

Returns the receipt amount for the given registrant, without considering benefits.

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN	Registrant
@REVENUEDATE	datetime	IN	Date
@TRANSACTIONAMOUNT	money	IN	Amount
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate
@SPOTRATE	decimal(20, 8)	IN	Spot rate
@REGISTRATIONEXISTSINBATCH	bit	IN	Registration exist in batch
@EXISTINGREVENUEID	uniqueidentifier	IN	Existing revenue

Definition

Copy



CREATE procedure dbo.USP_DATALIST_EVENTREGISTRANT_GETRECEIPTAMOUNT
(
    @REGISTRANTID uniqueidentifier = null,
    @REVENUEDATE datetime = null,
    @TRANSACTIONAMOUNT money = 0,
    @TRANSACTIONCURRENCYID uniqueidentifier = null,
    @BASECURRENCYID uniqueidentifier = null,
    @BASEEXCHANGERATEID uniqueidentifier = null,
    @SPOTRATE decimal(20,8) = 0,
    @REGISTRATIONEXISTSINBATCH bit = 0,
    @EXISTINGREVENUEID uniqueidentifier = null
)
as
    set nocount on;

    if @BASECURRENCYID is null and @TRANSACTIONCURRENCYID is null
        select @BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(), @TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()

    declare @RECEIPTAMOUNT money =
        dbo.UFN_EVENTREGISTRANT_GETRECEIPTAMOUNT_NOBENEFITS(
            @REGISTRANTID,
            @REVENUEDATE,
            @TRANSACTIONAMOUNT,
            @TRANSACTIONCURRENCYID,
            @BASECURRENCYID,
            @BASEEXCHANGERATEID,
            @SPOTRATE,
            @REGISTRATIONEXISTSINBATCH,
            @EXISTINGREVENUEID
        )

    select @RECEIPTAMOUNT RECEIPTAMOUNT, @TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID;