REVENUESPLITGIFTAID

Stores gift aid information for each revenue split.

For the full definition of the REVENUESPLITGIFTAID table, see REVENUESPLITGIFTAID.

Fields

Field	Change	Field Type	Null	Notes	Description
TAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when TRANSITIONALTAXCLAIMAMOUNT = 0 then BASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then BASETAXCLAIMAMOUNT + TRANSITIONALTAXCLAIMAMOUNT else BASETAXCLAIMAMOUNT end	Expression changed from case when TRANSITIONALTAXCLAIMAMOUNT = 0 then BASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then BASETAXCLAIMAMOUNT + TRANSITIONALTAXCLAIMAMOUNT else BASETAXCLAIMAMOUNT end to case when TRANSITIONALTAXCLAIMAMOUNT = 0 then BASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then BASETAXCLAIMAMOUNT + TRANSITIONALTAXCLAIMAMOUNT else BASETAXCLAIMAMOUNT end
TRANSACTIONTAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then TRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then TRANSACTIONBASETAXCLAIMAMOUNT + TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else TRANSACTIONBASETAXCLAIMAMOUNT end	Expression changed from case when TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then TRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then TRANSACTIONBASETAXCLAIMAMOUNT + TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else TRANSACTIONBASETAXCLAIMAMOUNT end to case when TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then TRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then TRANSACTIONBASETAXCLAIMAMOUNT + TRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else TRANSACTIONBASETAXCLAIMAMOUNT end
ORGANIZATIONTAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT + ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORGANIZATIONBASETAXCLAIMAMOUNT end	Expression changed from case when ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT + ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORGANIZATIONBASETAXCLAIMAMOUNT end to case when ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORGANIZATIONBASETAXCLAIMAMOUNT + ORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORGANIZATIONBASETAXCLAIMAMOUNT end