USP_DATALIST_REVENUE_RECEIPT

Returns a list of receipts for a revenue transaction record.
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_REVENUE_RECEIPT
                (
                    @ID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        RR.RECEIPTNUMBER,
                        RR.RECEIPTPROCESSDATE,
                        RR.RECEIPTDATE,
                        PREVIOUS.RECEIPTNUMBER as PREVIOUSRECEIPTNUMBER,
                        RP.ID as RECEIPTINGPROCESSID,
                        RR.UNIQUERECEIPTNUMBER,
                        PREVIOUS.UNIQUERECEIPTNUMBER as PREVIOUSUNIQUERECEIPTNUMBER,
                        RD.DATEADDED as RERECEIPTDATE,
                        CASE RD.NEWNUMBERONRERECEIPT WHEN 0 THEN 'Use same number' WHEN 1 THEN  'Generate new number' ELSE '' END  as RERECEIPTSTATUS,
                        RE.CODE as RERECEIPTREASONCODE,
                        RD.DETAILS as RERECEIPTDETAILS
                    from
                        dbo.REVENUERECEIPT RR
                    left join
                        dbo.REVENUERECEIPT PREVIOUS on RR.PREVIOUSREVENUERECEIPTID = PREVIOUS.ID
                    left join
                        dbo.RECEIPTINGPROCESSSTATUS RPS on RR.RECEIPTINGPROCESSSTATUSID = RPS.ID
                    left join
                        dbo.RECEIPTINGPROCESS RP on RPS.PARAMETERSETID =  RP.ID
                    left join dbo.REVENUERECEIPTRERECEIPTDETAIL RD on RD.REVENUERECEIPTID = RR.ID
                    left join dbo.RERECEIPTREASONCODE RE on RD.RERECEIPTREASONCODEID = RE.ID
                    where
                        RR.REVENUEID = @ID
                    order by
                        RR.RECEIPTPROCESSDATE desc, RR.RECEIPTNUMBER desc;