USP_DATALIST_SPONSORSHIPGIFTPAYMENT
Retrieve the revenue id of the recurring gift and associated payments.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SPONSORSHIPGIFTPAYMENT(@CONTEXTID uniqueidentifier)
as
set nocount on;
select REVENUE.ID as GIFTREVENUEID, RECURRINGGIFTINSTALLMENTPAYMENT.PAYMENTID from SPONSORSHIP
inner join SALESORDERITEMSPONSORSHIP on SPONSORSHIP.ID = SALESORDERITEMSPONSORSHIP.SPONSORSHIPID
inner join REVENUESPLIT on SPONSORSHIP.REVENUESPLITID = REVENUESPLIT.ID
inner join REVENUE on REVENUESPLIT.REVENUEID = REVENUE.id
left join RECURRINGGIFTINSTALLMENT on REVENUE.ID = RECURRINGGIFTINSTALLMENT.REVENUEID
left join RECURRINGGIFTINSTALLMENTPAYMENT on RECURRINGGIFTINSTALLMENT.ID = RECURRINGGIFTINSTALLMENTPAYMENT.RECURRINGGIFTINSTALLMENTID
where SALESORDERITEMSPONSORSHIP.ID = @CONTEXTID