USP_DATALIST_REVENUEGLREVERSAL

A datalist of revenue GL reversal distribution.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUEGLREVERSAL (@ID uniqueidentifier)
                as 
                    set nocount on;
                    select 
                        REVENUEID,
                        MAP.DESCRIPTION,
                        GLREVERSAL.DEBITACCOUNT,        
                        GLREVERSAL.CREDITACCOUNT,
                        GLREVERSAL.PROJECT,
                        GLREVERSAL.AMOUNT,
                        GLREVERSAL.REFERENCE
                    from dbo.GLREVERSAL
                    inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on GLREVERSAL.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    where REVENUEID = @ID and POSTSTATUSCODE = 1;