Get your free trail of Salsa

Object: donation

Name Type Null Default
donation_KEY int YES
supporter_KEY int NO
event_KEY int NO
donate_page_KEY int NO
recurring_donation_KEY int NO
membership_invoice_KEY int NO
Last_Modified timestamp YES CURRENT_TIMESTAMP
Transaction_Date timestamp YES Invalid Date
Date_Entered date NO
amount decimal NO
Currency_Code varchar NO
Transaction_Type enum NO
Form_Of_Payment enum NO
cc_type varchar NO
Credit_Card_Digits varchar NO
Credit_Card_Expiration varchar NO
PNREF varchar NO
RESULT int NO
RESPMSG varchar NO
AUTHCODE varchar NO
AVS varchar NO
Order_Info mediumtext NO
Status enum NO
Disbursement_Status enum NO Unknown
Responsible_Party varchar NO
Date_Fulfilled date NO
PRIVATE_Complete_Summary blob NO
First_Name varchar NO
Last_Name varchar NO
Email varchar NO
Tracking_Code varchar NO
Donation_Tracking_Code varchar NO
Tax_Status enum NO
Designation_Code varchar NO
PRIVATE_Donation_Source enum NO Other
Note mediumtext NO
Thank_You_Sent tinyint NO
Thank_Date date NO
referral_supporter_KEY int NO
merchant_account_KEY int NO
IP_Address varchar NO
In_Honor_Name varchar NO
In_Honor_Email varchar NO
In_Honor_Address mediumtext NO
uid varchar NO
Batch_Code varchar NO
VARCHAR0 varchar NO
VARCHAR1 varchar NO
VARCHAR2 varchar NO
In_Memory_Name varchar NO
event_fee_KEY int NO
Employer varchar NO
Occupation varchar NO
Employer_Street varchar NO
Employer_Street_2 varchar NO
Employer_City varchar NO
Employer_State varchar NO
Employer_Zip varchar NO