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 | YES | ||
| 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 | ||
| 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 | ||
| salesforce_id | varchar | NO |