REVENUESPLITGIFTAIDREFUND

Stores Gift Aid refund information for each revenue split.

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

Fields

Field	Change	Field Type	Null	Notes	Description
ORIGINALTAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when ORIGINALTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALBASETAXCLAIMAMOUNT + ORIGINALTRANSITIONALTAXCLAIMAMOUNT else ORIGINALBASETAXCLAIMAMOUNT end	Expression changed from case when ORIGINALTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALBASETAXCLAIMAMOUNT + ORIGINALTRANSITIONALTAXCLAIMAMOUNT else ORIGINALBASETAXCLAIMAMOUNT end to case when ORIGINALTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALBASETAXCLAIMAMOUNT + ORIGINALTRANSITIONALTAXCLAIMAMOUNT else ORIGINALBASETAXCLAIMAMOUNT end
ORIGINALTRANSACTIONTAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT + ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT end	Expression changed from case when ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT + ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT end to case when ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT + ORIGINALTRANSACTIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALTRANSACTIONBASETAXCLAIMAMOUNT end
ORIGINALORGANIZATIONTAXCLAIMAMOUNT	Changed	money (Computed)	yes	case when ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT + ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT end	Expression changed from case when ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT + ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT end to case when ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT + ORIGINALORGANIZATIONTRANSITIONALTAXCLAIMAMOUNT else ORIGINALORGANIZATIONBASETAXCLAIMAMOUNT end