USP_DATALIST_REFUNDGLDISTRIBUTION

A datalist of the refund 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_REFUNDGLDISTRIBUTION(@ID uniqueidentifier)
            as
                set nocount on;

                select 
                    CREDITGLDISTRIBUTION.CREDITPAYMENTID,
                    CREDITGLDISTRIBUTION.ID as CREDITGLDISTRIBUTION,
                    CREDITGLDISTRIBUTION.TRANSACTIONTYPE,                        
                    CREDITGLDISTRIBUTION.ACCOUNT,
                    CREDITGLDISTRIBUTION.AMOUNT,
                    CREDITGLDISTRIBUTION.REFERENCE,
                    CREDITPAYMENT.PAYMENTMETHOD,
                    case [CREDITPAYMENT].[PAYMENTMETHODCODE]
                        when 0 then ''
                        when 2 then 
                            (
                                select dbo.UFN_CREDITTYPECODE_GETDESCRIPTION([CREDITCARDPAYMENTMETHODDETAIL].[CREDITTYPECODEID])  + ' #' + [CREDITCARDPAYMENTMETHODDETAIL].[CREDITCARDPARTIALNUMBER]
                                from dbo.[CREDITCARDPAYMENTMETHODDETAIL] 
                                inner join dbo.[REVENUEPAYMENTMETHOD]
                                    on [CREDITCARDPAYMENTMETHODDETAIL].[ID] = [REVENUEPAYMENTMETHOD].[ID]
                                where [REVENUEPAYMENTMETHOD].[REVENUEID] = [CREDITPAYMENT].[REVENUEID]
                            )
                        when 10 then dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION([CREDITPAYMENT].[OTHERPAYMENTMETHODCODEID])
                    end as [PAYMENTTYPE]
                from 
                    dbo.CREDITGLDISTRIBUTION
                inner join dbo.CREDITPAYMENT on CREDITGLDISTRIBUTION.CREDITPAYMENTID = CREDITPAYMENT.ID
                where 
                    CREDITPAYMENT.CREDITID = @ID
                    and CREDITGLDISTRIBUTION.OUTDATED = 0
                order by
                    CREDITGLDISTRIBUTION.TRANSACTIONTYPE, CREDITGLDISTRIBUTION.ACCOUNT desc;