USP_DATALIST_REVENUEGLDISTRIBUTION

A datalist of revenue GL distribution (projected or user-defined)
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@SYSTEMDISTRIBUTION	bit	IN	System distributions
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_REVENUEGLDISTRIBUTION 
                (
                    @ID uniqueidentifier,
                    @SYSTEMDISTRIBUTION bit = 0
                )
                as 
                    set nocount on;
                    select 
                        REVENUEGLDISTRIBUTION.REVENUEID as ID,
                        REVENUEGLDISTRIBUTION.ID as REVENUEGLDISTRIBUTIONID,
                        MAP.DESCRIPTION,
                        REVENUEGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        REVENUEGLDISTRIBUTION.ACCOUNT,
                        REVENUEGLDISTRIBUTION.PROJECT,
                        case when REVENUEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(REVENUEGLDISTRIBUTION.AMOUNT, 0) else REVENUEGLDISTRIBUTION.AMOUNT end [AMOUNT],
                        REVENUEGLDISTRIBUTION.REFERENCE,
                        case when REVENUEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(REVENUEGLDISTRIBUTION.TRANSACTIONAMOUNT, 0) else REVENUEGLDISTRIBUTION.TRANSACTIONAMOUNT end [TRANSACTIONAMOUNT],
                        case when REVENUEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(REVENUEGLDISTRIBUTION.AMOUNT, 0) else REVENUEGLDISTRIBUTION.AMOUNT end [BASEAMOUNT],
                        case when REVENUEGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(REVENUEGLDISTRIBUTION.ORGANIZATIONAMOUNT, 0) else REVENUEGLDISTRIBUTION.ORGANIZATIONAMOUNT end [ORGANIZATIONAMOUNT],
                        REVENUEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        REVENUEGLDISTRIBUTION.BASECURRENCYID
                    from 
                        dbo.REVENUEGLDISTRIBUTION
                    inner join 
                        dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on REVENUEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    inner join 
                        dbo.GLTRANSACTION on GLTRANSACTION.ID = REVENUEGLDISTRIBUTION.GLTRANSACTIONID
                    where 
                        REVENUEGLDISTRIBUTION.REVENUEID = @ID
                        and REVENUEGLDISTRIBUTION.OUTDATED = 0
                        and GLTRANSACTION.SYSTEMDISTRIBUTION = @SYSTEMDISTRIBUTION
                    order by
                        MAP.DESCRIPTION, REVENUEGLDISTRIBUTION.TRANSACTIONTYPE desc;