USP_DATALIST_AUCTIONPURCHASEGLDISTRIBUTION

A datalist of auction purchase GL distributions.
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_AUCTIONPURCHASEGLDISTRIBUTION
                (
                    @ID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        AUCTIONPURCHASEGLDISTRIBUTION.ID as ID,
                        MAP.DESCRIPTION,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        AUCTIONPURCHASEGLDISTRIBUTION.ACCOUNT,
                        AUCTIONPURCHASEGLDISTRIBUTION.PROJECT,
                        AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT,
                        AUCTIONPURCHASEGLDISTRIBUTION.REFERENCE,
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONAMOUNT as [TRANSACTIONAMOUNT],
                        AUCTIONPURCHASEGLDISTRIBUTION.AMOUNT as [BASEAMOUNT],
                        AUCTIONPURCHASEGLDISTRIBUTION.ORGANIZATIONAMOUNT as [ORGANIZATIONAMOUNT],
                        AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        AUCTIONPURCHASEGLDISTRIBUTION.BASECURRENCYID,
                        dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() ORGANIZATIONCURRENCYID
                    from 
                        dbo.AUCTIONPURCHASEGLDISTRIBUTION
                        inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on AUCTIONPURCHASEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                        inner join dbo.GLTRANSACTION on AUCTIONPURCHASEGLDISTRIBUTION.GLTRANSACTIONID = GLTRANSACTION.ID
                    where 
                        AUCTIONPURCHASEGLDISTRIBUTION.REVENUEPURCHASEID = @ID
                        and AUCTIONPURCHASEGLDISTRIBUTION.OUTDATED = 0
                        and GLTRANSACTION.SYSTEMDISTRIBUTION = 0
                    order by 
                        MAP.DESCRIPTION,AUCTIONPURCHASEGLDISTRIBUTION.TRANSACTIONTYPE desc;