REVENUESPLITGIFTAIDAMOUNTS

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
ELIGIBILITYCODE	tinyint		Default = 0
ELIGIBILITY	nvarchar(20) (Computed)	yes	CASE [ELIGIBILITYCODE] WHEN 0 THEN N'No valid declaration' WHEN 1 THEN N'Not eligible' WHEN 2 THEN N'Valid declaration' WHEN 3 THEN N'Covenant gift' WHEN 4 THEN N'Gift Aid sponsorship' END
DECLINESGIFTAID	bit		Default = 0
ISSPONSORSHIP	bit		Default = 0
TAXCLAIMNUMBER	nvarchar(10)		Default = ''
QUALIFICATIONSTATUS	nvarchar(50)		Default = ''
TAXCLAIMAMOUNT	money		Default = 0
TRANSACTIONTAXCLAIMAMOUNT	money		Default = 0
ORGANIZATIONTAXCLAIMAMOUNT	money		Default = 0
CLAIMABLEGIFTAIDAMOUNT	money		Default = 0
TRANSACTIONCLAIMABLEGIFTAIDAMOUNT	money		Default = 0
ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT	money		Default = 0
RECEIVEDGIFTAIDAMOUNT	money		Default = 0
TRANSACTIONRECEIVEDGIFTAIDAMOUNT	money		Default = 0
ORGANIZATIONRECEIVEDGIFTAIDAMOUNT	money		Default = 0
GROSSAMOUNT	money		Default = 0
TRANSACTIONGROSSAMOUNT	money		Default = 0
ORGANIZATIONGROSSAMOUNT	money		Default = 0
POTENTIALGROSSAMOUNT	money		Default = 0
TRANSACTIONPOTENTIALGROSSAMOUNT	money		Default = 0
ORGANIZATIONPOTENTIALGROSSAMOUNT	money		Default = 0
REVENUESPLITGIFTAIDDATEADDED	datetime	yes
REVENUESPLITGIFTAIDDATECHANGED	datetime	yes
REVENUESPLITGIFTAIDADDEDBYUSERNAME	nvarchar(128)		Default = ''
REVENUESPLITGIFTAIDCHANGEDBYUSERNAME	nvarchar(128)		Default = ''
REVENUESPLITGIFTAIDTS	varbinary	yes
REVENUESPLITGIFTAIDTSLONG	bigint (Computed)	yes	(CONVERT([bigint],[REVENUESPLITGIFTAIDTS],0))
REVENUEDATEADDED	datetime	yes
REVENUEDATECHANGED	datetime	yes
REVENUEADDEDBYUSERNAME	nvarchar(128)		Default = ''
REVENUECHANGEDBYUSERNAME	nvarchar(128)		Default = ''
REVENUETS	varbinary	yes
REVENUETSLONG	bigint (Computed)	yes	(CONVERT([bigint],[REVENUETS],0))
REFRESHDATE	datetime	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		FINANCIALTRANSACTIONLINEITEM.ID
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID
BASEEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID
TRANSACTIONCURRENCYID	uniqueidentifier	yes	CURRENCY.ID
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID
FINANCIALTRANSACTIONID	uniqueidentifier	yes	FINANCIALTRANSACTION.ID
REVENUEORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID
REVENUEBASEEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID
REVENUETRANSACTIONCURRENCYID	uniqueidentifier	yes	CURRENCY.ID
REVENUEBASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REVENUESPLITGIFTAIDAMOUNTS_FINANCIALTRANSACTIONID	FINANCIALTRANSACTIONID
PK_REVENUESPLITGIFTAIDAMOUNTS	ID	yes	yes	yes