UFN_REVENUE_GETGIFTINKINDPAYMENTMETHODDETAILGLDISTRIBUTION

            create function dbo.UFN_REVENUE_GETGIFTINKINDPAYMENTMETHODDETAILGLDISTRIBUTION(@GIFTINKINDPAYMENTMETHODDETAILID uniqueidentifier) 
            returns @GIFTINKINDPAYMENTMETHODDETAILGLDISTRIBUTION 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(255) not null,
                GIFTINKINDSALEID uniqueidentifier not null,
                ORGANIZATIONAMOUNT money not null,
                BASECURRENCYID uniqueidentifier,
                TRANSACTIONAMOUNT money not null,
                TRANSACTIONCURRENCYID uniqueidentifier,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            as 
            begin
                insert into @GIFTINKINDPAYMENTMETHODDETAILGLDISTRIBUTION 
                    (ID, GLPAYMENTMETHODREVENUETYPEMAPPINGID, TRANSACTIONTYPECODE, DEBITCREDIT, ACCOUNT, PROJECT, AMOUNT, REFERENCE, GIFTINKINDSALEID, ORGANIZATIONAMOUNT, BASECURRENCYID, TRANSACTIONAMOUNT, TRANSACTIONCURRENCYID, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID)
                    select 
                        GIFTINKINDSALEGLDISTRIBUTION.ID, 
                        GIFTINKINDSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONTYPECODE, 
                        GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT, 
                        GIFTINKINDSALEGLDISTRIBUTION.ACCOUNT, 
                        GIFTINKINDSALEGLDISTRIBUTION.PROJECT, 
                        GIFTINKINDSALEGLDISTRIBUTION.AMOUNT, 
                        GIFTINKINDSALEGLDISTRIBUTION.REFERENCE,
                        GIFTINKINDSALEGLDISTRIBUTION.GIFTINKINDSALEID,
                        GIFTINKINDSALEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        GIFTINKINDSALEGLDISTRIBUTION.BASECURRENCYID,
                        GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        GIFTINKINDSALEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        GIFTINKINDSALEGLDISTRIBUTION.BASEEXCHANGERATEID,
                        GIFTINKINDSALEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                    from 
                        dbo.GIFTINKINDSALEGLDISTRIBUTION
                    inner join
                        dbo.GIFTINKINDSALE on GIFTINKINDSALEGLDISTRIBUTION.GIFTINKINDSALEID = GIFTINKINDSALE.ID
                    where 
                        GIFTINKINDSALE.GIFTINKINDPAYMENTMETHODDETAILID = @GIFTINKINDPAYMENTMETHODDETAILID
                        and GIFTINKINDSALEGLDISTRIBUTION.OUTDATED = 0;
                return
            end