UFN_REVENUESPLIT_GETCOMMITMENTID
Returns a the Revenue commitment id for a payment.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUESPLITID | uniqueidentifier | IN | |
| @APPLICATIONTYPECODE | tinyint | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUESPLIT_GETCOMMITMENTID(
@REVENUESPLITID uniqueidentifier,
@APPLICATIONTYPECODE tinyint
)
returns uniqueidentifier
as
begin
if @APPLICATIONTYPECODE in (
0, --Donation
1, --Event registration
4, --Other
5, --Membership
9, --Admission
11, --Miscellaneous
12, --Auction purchase
15, --Event sponsorship
16 --Merchandise
)
return null;
if @APPLICATIONTYPECODE in (
2, --Pledge
6, --Planned gift
7, --Matching gift
8, --Grant award
13, --Donor challenge
19 --Membership installment plan
)
return(select top 1 PLEDGEID from INSTALLMENTSPLITPAYMENT where PAYMENTID = @REVENUESPLITID);
if @APPLICATIONTYPECODE in (
3 --Recurring gift
)
return(select top 1 SOURCEREVENUEID from RECURRINGGIFTACTIVITY where PAYMENTREVENUEID = @REVENUESPLITID);
if @APPLICATIONTYPECODE in (
10 --Order
)
return(select top 1 SALESORDER.REVENUEID
from dbo.FINANCIALTRANSACTIONLINEITEM
inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
inner join dbo.SALESORDERPAYMENT
on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = SALESORDERPAYMENT.PAYMENTID
inner join SALESORDER
on SALESORDER.ID = SALESORDERPAYMENT.SALESORDERID
where FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID);
return null;
end