USP_DATALIST_REVENUESYSTEMGLDISTRIBUTION

                CREATE procedure dbo.USP_DATALIST_REVENUESYSTEMGLDISTRIBUTION
                (
                    @ID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @DISTRIBUTION table
                    (
                        ID uniqueidentifier,
                        GLDISTRIBUTIONID uniqueidentifier,
                        DESCRIPTION nvarchar(255),
                        TRANSACTIONTYPE nvarchar(20),                        
                        ACCOUNT nvarchar(100),
                        PROJECT nvarchar(100),
                        AMOUNT money,
                        REFERENCE nvarchar(255),
                        TRANSACTIONAMOUNT money,
                        BASEAMOUNT money,
                        ORGANIZATIONAMOUNT money,
                        TRANSACTIONCURRENCYID uniqueidentifier,
                        BASECURRENCYID uniqueidentifier
                    )

                    insert into @DISTRIBUTION
                    exec dbo.USP_DATALIST_REVENUEGLDISTRIBUTION @ID, 1

                    insert into @DISTRIBUTION
                    select 
                        AUCTIONPURCHASEGLDISTRIBUTION.REVENUEID,
                        AUCTIONPURCHASEGLDISTRIBUTION.ID,
                        MAP.DESCRIPTION,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        AUCTIONPURCHASEGLDISTRIBUTION.ACCOUNT,
                        AUCTIONPURCHASEGLDISTRIBUTION.PROJECT,
                        case when AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT, 0) else AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT end [AMOUNT],
                        AUCTIONPURCHASEGLDISTRIBUTION.REFERENCE,
                        case when AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONAMOUNT, 0) else AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONAMOUNT end [TRANSACTIONAMOUNT],
                        case when AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT, 0) else AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT end [BASEAMOUNT],
                        case when AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(AUCTIONPURCHASEGLDISTRIBUTION.ORGANIZATIONAMOUNT, 0) else AUCTIONPURCHASEGLDISTRIBUTION.ORGANIZATIONAMOUNT end [ORGANIZATIONAMOUNT],
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        AUCTIONPURCHASEGLDISTRIBUTION.BASECURRENCYID
                    from 
                        dbo.AUCTIONPURCHASEGLDISTRIBUTION
                    inner join 
                        dbo.GLTRANSACTION on GLTRANSACTION.ID = AUCTIONPURCHASEGLDISTRIBUTION.GLTRANSACTIONID
                    left join 
                        dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on AUCTIONPURCHASEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    where 
                        AUCTIONPURCHASEGLDISTRIBUTION.REVENUEPURCHASEID = @ID
                        and AUCTIONPURCHASEGLDISTRIBUTION.OUTDATED = 0
                        and GLTRANSACTION.SYSTEMDISTRIBUTION = 1

                    select
                        ID,
                        GLDISTRIBUTIONID,
                        DESCRIPTION,
                        TRANSACTIONTYPE,                        
                        ACCOUNT,
                        PROJECT,
                        AMOUNT,
                        REFERENCE,
                        TRANSACTIONAMOUNT,
                        BASEAMOUNT,
                        ORGANIZATIONAMOUNT,
                        TRANSACTIONCURRENCYID,
                        BASECURRENCYID
                    from @DISTRIBUTION