UFN_REVENUE_GETAUCTIONPURCHASEGLDISTRIBUTION

            CREATE function dbo.UFN_REVENUE_GETAUCTIONPURCHASEGLDISTRIBUTION
            (
                @REVENUEID uniqueidentifier
            )
            returns @GLDISTRIBUTION 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 not null,
                TRANSACTIONAMOUNT money not null,
                TRANSACTIONCURRENCYID uniqueidentifier not null,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            with execute as caller
            as begin
                insert into @GLDISTRIBUTION 
                    (ID, GLPAYMENTMETHODREVENUETYPEMAPPINGID, TRANSACTIONTYPECODE, DEBITCREDIT, ACCOUNT, PROJECT, AMOUNT, REFERENCE, ORGANIZATIONAMOUNT, BASECURRENCYID, TRANSACTIONAMOUNT, TRANSACTIONCURRENCYID, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID)
                    select 
                        AUCTIONPURCHASEGLDISTRIBUTION.ID, 
                        AUCTIONPURCHASEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONTYPECODE,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT,
                        AUCTIONPURCHASEGLDISTRIBUTION.ACCOUNT, 
                        AUCTIONPURCHASEGLDISTRIBUTION.PROJECT, 
                        AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT, 
                        AUCTIONPURCHASEGLDISTRIBUTION.REFERENCE,
                        AUCTIONPURCHASEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        AUCTIONPURCHASEGLDISTRIBUTION.BASECURRENCYID,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        AUCTIONPURCHASEGLDISTRIBUTION.BASEEXCHANGERATEID,
                        AUCTIONPURCHASEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                    from 
                        dbo.AUCTIONPURCHASEGLDISTRIBUTION
                        inner join dbo.GLTRANSACTION on AUCTIONPURCHASEGLDISTRIBUTION.GLTRANSACTIONID = GLTRANSACTION.ID
                    where
                        AUCTIONPURCHASEGLDISTRIBUTION.REVENUEPURCHASEID = @REVENUEID
                        and AUCTIONPURCHASEGLDISTRIBUTION.OUTDATED = 0
                        and GLTRANSACTION.SYSTEMDISTRIBUTION = 0;
                return
            end