UFN_PLANNEDGIFTPAYOUT_GETGLDISTRIBUTION

Gets a table of Planned Gift Payout GL distributions.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_PLANNEDGIFTPAYOUT_GETGLDISTRIBUTION(@REVENUEID uniqueidentifier) 
            returns @PAYOUTGLDISTRIBUTION table
            (
                ID uniqueidentifier null,
                GLPAYMENTMETHODREVENUETYPEMAPPINGID uniqueidentifier not null,
                TRANSACTIONTYPECODE tinyint not null,
                DEBITCREDIT nvarchar(50) not null,
                ACCOUNT nvarchar(100) not null,
                PROJECT nvarchar(100) null,
                AMOUNT money not null,
                REFERENCE nvarchar(100) not null,
                ORGANIZATIONAMOUNT money not null,
                BASECURRENCYID uniqueidentifier,
                TRANSACTIONAMOUNT money not null,
                TRANSACTIONCURRENCYID uniqueidentifier,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            as 
            begin    
                insert into @PAYOUTGLDISTRIBUTION 
                (
                    ID, 
                    GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                    TRANSACTIONTYPECODE, 
                    DEBITCREDIT, 
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT, 
                    REFERENCE,
                    ORGANIZATIONAMOUNT, 
                    BASECURRENCYID, 
                    TRANSACTIONAMOUNT, 
                    TRANSACTIONCURRENCYID, 
                    BASEEXCHANGERATEID, 
                    ORGANIZATIONEXCHANGERATEID
                    )

                    select 
                        ID, 
                        GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        TRANSACTIONTYPECODE,
                        TRANSACTIONTYPE as DEBITCREDIT,
                        ACCOUNT, 
                        PROJECT, 
                        AMOUNT, 
                        REFERENCE,
                        ORGANIZATIONAMOUNT, 
                        BASECURRENCYID, 
                        TRANSACTIONAMOUNT, 
                        TRANSACTIONCURRENCYID, 
                        BASEEXCHANGERATEID, 
                        ORGANIZATIONEXCHANGERATEID
                    from 
                        dbo.PLANNEDGIFTPAYOUTGLDISTRIBUTION  
                    where 
                        REVENUEID = @REVENUEID
                        and OUTDATED = 0;
                    return
            end