UFN_REVENUE_GETPROPERTYDETAILGLDISTRIBUTION

            CREATE function dbo.UFN_REVENUE_GETPROPERTYDETAILGLDISTRIBUTION(@PROPERTYDETAILID uniqueidentifier) 
            returns @PROPERTYDETAILGLDISTRIBUTION 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,
                ORGANIZATIONAMOUNT money not null,
                BASECURRENCYID uniqueidentifier not null,
                TRANSACTIONAMOUNT money not null,
                TRANSACTIONCURRENCYID uniqueidentifier null,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )

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

                return
            end