ShoppingCartDonation

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
TransactionXml	ntext
AcknowledgementXml	ntext
Amount	decimal(30, 6)
AllowsMatchingGifts	bit		Default = 0
ECardsXml	ntext	yes
EReceiptPdfForCreditCard	bit		Default = 0
EReceiptPdfForDirectDebit	bit		Default = 0
MarkReceiptedForCreditCard	bit		Default = 0
MarkReceiptedForDirectDebit	bit		Default = 0
CartSendDonationAcknowledgementAlways	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ShoppingCartID	int		ShoppingCart.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_ShoppingCartDonation	ID	yes	yes