USP_DATALIST_PROPERTYDETAILGLDISTRIBUTION

A datalist of sold property GL 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_PROPERTYDETAILGLDISTRIBUTION (@ID uniqueidentifier)
                as 
                    select 
                        PROPERTYDETAILGLDISTRIBUTION.PROPERTYDETAILID as ID,
                        PROPERTYDETAILGLDISTRIBUTION.ID as PROPERTYDETAILGLDISTRIBUTIONID,
                        MAP.DESCRIPTION,
                        PROPERTYDETAILGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        PROPERTYDETAILGLDISTRIBUTION.ACCOUNT,
                        PROPERTYDETAILGLDISTRIBUTION.PROJECT,
                        PROPERTYDETAILGLDISTRIBUTION.AMOUNT,
                        PROPERTYDETAILGLDISTRIBUTION.REFERENCE,
                        PROPERTYDETAILGLDISTRIBUTION.TRANSACTIONAMOUNT as [TRANSACTIONAMOUNT],
                        PROPERTYDETAILGLDISTRIBUTION.AMOUNT as [BASEAMOUNT],
                        PROPERTYDETAILGLDISTRIBUTION.ORGANIZATIONAMOUNT as [ORGANIZATIONAMOUNT],
                        PROPERTYDETAILGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        PROPERTYDETAILGLDISTRIBUTION.BASECURRENCYID,
                        dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() ORGANIZATIONCURRENCYID
                    from dbo.PROPERTYDETAILGLDISTRIBUTION
                        inner join  dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on PROPERTYDETAILGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                        inner join dbo.REVENUEPAYMENTMETHOD on PROPERTYDETAILGLDISTRIBUTION.PROPERTYDETAILID = REVENUEPAYMENTMETHOD.ID
                    where 
                        REVENUEPAYMENTMETHOD.REVENUEID = @ID
                        and PROPERTYDETAILGLDISTRIBUTION.OUTDATED = 0
                    order by 
                        MAP.DESCRIPTION,PROPERTYDETAILGLDISTRIBUTION.TRANSACTIONTYPE desc;