UFN_REVENUESPLITGIFTAID_GETGLDISTRIBUTION

            CREATE function dbo.UFN_REVENUESPLITGIFTAID_GETGLDISTRIBUTION(@REVENUESPLITGIFTAIDID uniqueidentifier) 
            returns @GIFTAIDGLDISTRIBUTION 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,
                TRANSACTIONCURRENCYID uniqueidentifier,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )

            as 
            begin    
                insert into @GIFTAIDGLDISTRIBUTION 
                    (ID, GLPAYMENTMETHODREVENUETYPEMAPPINGID, TRANSACTIONTYPECODE, DEBITCREDIT, ACCOUNT, PROJECT, AMOUNT, REFERENCE,
                     ORGANIZATIONAMOUNT, BASECURRENCYID, TRANSACTIONAMOUNT, TRANSACTIONCURRENCYID, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID)
                    select 
                        GIFTAIDGLDISTRIBUTION.ID, 
                        GIFTAIDGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONTYPECODE,
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT,
                        GIFTAIDGLDISTRIBUTION.ACCOUNT, 
                        GIFTAIDGLDISTRIBUTION.PROJECT, 
                        GIFTAIDGLDISTRIBUTION.AMOUNT, 
                        GIFTAIDGLDISTRIBUTION.REFERENCE,
                        GIFTAIDGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        GIFTAIDGLDISTRIBUTION.BASECURRENCYID,
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        GIFTAIDGLDISTRIBUTION.BASEEXCHANGERATEID,
                        GIFTAIDGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                    from 
                        dbo.GIFTAIDGLDISTRIBUTION 
                    where 
                        GIFTAIDGLDISTRIBUTION.REVENUESPLITGIFTAIDID = @REVENUESPLITGIFTAIDID
                        and GIFTAIDGLDISTRIBUTION.OUTDATED = 0;
                return
            end