FundRaiserDonations

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Amount	money
IsOffline	bit		Default = 0
CurrencyType	int	yes
ThankedDate	datetime	yes
IsAthon	bit		Default = 0
InvoiceDate	datetime	yes
InvoicePaid	bit		Default = 0
GiftBackOfficeID	int	yes
IsChangeBucket	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SolicitorID	int		FundRaiserSolicitors.ID
DonationTransactionsID	int		DonationTransactions.DonationTransactionsID
PledgeID	int	yes	FundRaiserDonations.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FundraiserDonations_DonationTransactionsID_SolicitorID_IsAthon_PledgeID_Amount	DonationTransactionsID, SolicitorID, IsAthon, PledgeID, Amount
IX_FundraiserDonations_ID_DonationTransactionsID_GiftBackOfficeID	ID, DonationTransactionsID, GiftBackOfficeID
IX_FundraiserDonations_SolicitorID_DonationTransactionsID_Amount_IsAthon	SolicitorID, DonationTransactionsID, Amount, IsAthon
PK_FundRaiserDonations	ID	yes	yes	yes

Referenced by

Referenced by	Field
FundraiserSolicitorContactAction	FundRaiserDonationsID