UFN_REVENUESPLITGIFTAID_GETELIGIBLE
Returns the revenue split gift aid records that meet the criteria.
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ACTUALONLY | bit | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE
(
@ACTUALONLY bit
)
returns table
as
return
(
select
ID,
case dbo.UFN_GIFTAIDREVENUESPLIT_ISRECURRINGGIFTSPLIT(ID) when 0 then TAXCLAIMAMOUNT
else dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATENEXTCLAIMAMOUNT(ID) end as TAXCLAIMAMOUNT,
TAXCLAIMNUMBER,
BASETAXCLAIMAMOUNT,
TRANSITIONALTAXCLAIMAMOUNT,
INCLUDETRANSITIONALAMOUNTCODE,
REVENUESPLITGIFTAIDELIGIBILITY.DATETAXDECLARATIONCHANGED
from dbo.REVENUESPLITGIFTAID
outer apply dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMELIGIBILITYSTATUS_INLINE_2(ID) as REVENUESPLITGIFTAIDELIGIBILITY
where
(
@ACTUALONLY = 1 and
(RULES_STATUS & ATTRIBUTES_STATUS) = 1 and DECLINESGIFTAID = 0 and
REVENUESPLITGIFTAIDELIGIBILITY.ELIGIBILITY in (2,3,4)
)
or
(
@ACTUALONLY = 0 and
(RULES_STATUS & ATTRIBUTES_STATUS) = 1 and
REVENUESPLITGIFTAIDELIGIBILITY.ELIGIBILITY != 1
)
)