UFN_GIFTAID_CALCULATEINSTALLMENTSPLITTAXCLAIMAMOUNT
Calculate the estimated Gift Aid tax claim amount for a pledge or recurring gift installment.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @DESIGNATIONID | uniqueidentifier | IN | |
| @DATE | datetime | IN | |
| @SPLITAMOUNT | money | IN |
Definition
Copy
create function dbo.UFN_GIFTAID_CALCULATEINSTALLMENTSPLITTAXCLAIMAMOUNT(
@CONSTITUENTID uniqueidentifier,
@DESIGNATIONID uniqueidentifier,
@DATE datetime,
@SPLITAMOUNT money
)
returns money
with execute as caller
as begin
declare @TAXRATE numeric(30,6);
declare @TAXCLAIMAMOUNT money = 0;
set @TAXRATE = dbo.UFN_GETGIFTAIDBASETAXRATE(@DATE) + dbo.UFN_GETGIFTAIDTRANSITIONALTAXRATE(@DATE);
if not exists (select ID from dbo.GIFTAIDDISQUALIFIEDBYDESIGNATION where ID = @DESIGNATIONID)
and dbo.UFN_VALIDYESDECLARATION(@DATE, @CONSTITUENTID, @DESIGNATIONID, null, null) = 1
set @TAXCLAIMAMOUNT = @SPLITAMOUNT * (@TAXRATE/(100 - @TAXRATE));
return @TAXCLAIMAMOUNT;
end