Donor ID |
Donor, Recurring Gift, Transaction |
10011 |
A unique ID you use for identifying the donor. |
If there is preceding zeros, put quote identifier and treat them as text. |
Birth Date |
Donor |
1970-11-14 |
The date of birth of the donor. |
The preferred format is YYYY-MM-DD |
Gender |
Donor |
Male |
The gender of the donor. |
|
Suburb |
Donor |
Denman Prospect |
The suburb the donor resides in. |
|
State |
Donor |
ACT |
The state the donor resides in. |
|
Postcode |
Donor |
2603 |
The postcode the donor resides in. |
Preferred as text format with quotes as text identifier to prevent missing preceding zeros for ACT suburbs. |
Country |
Donor |
Australia |
The country of the donor. |
|
Signup Date |
Recurring Gift |
2018-09-15 |
The date the donor signs up for this recurring gift. |
The preferred format is YYYY-MM-DD |
Gift ID |
Recurring Gift, Transaction |
12276 |
A unique ID you use for identifying the recurring gift. |
If there is preceding zeros, put quote identifier and treat them as text. |
Gift Start Date |
Recurring Gift |
2018-10-01 |
The date that recurring gift started for this recurring gift. |
The preferred format is YYYY-MM-DD |
First Payment Date |
Recurring Gift |
2018-11-01 |
The first payment for this recurring gift (successful or unsuccessful). |
The preferred format is YYYY-MM-DD |
Last Payment Date |
Recurring Gift |
2019-10-01 |
The last payment for this recurring gift (successful or unsuccessful). |
The preferred format is YYYY-MM-DD |
Gift End Date |
Recurring Gift |
2020-01-21 |
The date this recurring gift has ended. |
The preferred format is YYYY-MM-DD |
Next Payment Date |
Recurring Gift |
2020-01-21 |
The date the next payment is expected from this recurring gift. |
The preferred format is YYYY-MM-DD |
Frequency |
Recurring Gift |
Monthly |
The frequency the donor donates under this recurring gift. |
|
Gift Status |
Recurring Gift |
Active |
The status of this recurring gift. |
|
Gift Status Active |
Recurring Gift |
TRUE |
If the status of this recurring gift represents it still being active. True means the gift is active. |
|
Donor Freebie Status |
Recurring Gift |
Credited |
The reason for free acquisition if this donor was a free donor. |
|
CPA Start Date |
Recurring Gift |
2018-01-01 |
The effective start date for the CPA profile relevant to this donor. |
The preferred format is YYYY-MM-DD |
CPA End Date |
Recurring Gift |
2018-12-31 |
The effective end date for the CPA profile relevant to this donor. |
The preferred format is YYYY-MM-DD |
CPA |
Recurring Gift |
250.00 |
The cost per acquisition (CPA) of acquiring this donor. |
Number format without dollar sign. |
Cancel Reason Code |
Recurring Gift |
FR |
The reason code for the donor cancelling this recurring gift. |
|
Cancel Reason |
Recurring Gift |
Financial Reasons |
The reason description for the donor cancelling this recurring gift. |
|
Cancel Reason Comment |
Recurring Gift |
Health problems, in hospital |
A comment as to why the donor cancelled this recurring gift. |
|
Transaction ID |
Transaction |
140929 |
A unique ID you use for identifying the transaction. |
If there is preceding zeros, put quote identifier and treat them as text. |
Split Gift ID |
Transaction |
152999 |
A unique ID you use for identifying gift splits under the same transaction. |
If the split gift ID is not available but you are using split gift, please provide the instructions how to create a unique identifier for each split gift e.g. using transaction ID and appeal to identify split gift records. |
Transaction Date |
Transaction |
2019-10-01 |
The date the transaction occurred. |
The preferred format is YYYY-MM-DD |
Gift Amount |
Transaction |
32 |
The amount you received from the transaction |
Number format without dollar sign. If it’s a refund transaction, negative amount is preferred. |
Appeal |
Transaction |
REACTIVATION19 |
The appeal that sourced this transaction. |
|
Campaign |
Transaction |
Recurring Giving 2017/18 |
The campaign that sourced this transaction |
|
Fund |
Transaction |
Raffles 1057 |
The fund that this transaction was acquired through. |
|
Payment Method |
Transaction |
Credit Card |
The payment method of this transaction. |
|
Supplier |
Transaction |
Cosmic Connections |
The supplier that this transaction was acquired through. |
|
Fundraiser |
Transaction |
Joe Bloggs |
The individual fundraiser who acquired the donor. |
|
Transaction Status |
Transaction |
Accepted |
The status of this transaction. |
If there is no field that determine the transaction result status, please give us the criteria to determine whether the transaction processing is successful e.g. reject transactions will have 0 gift amount, etc. |
Transaction Status Accepted |
Transaction |
TRUE |
If the status of this transaction represents an accepted transaction. |
|
Decline Reason Code |
Transaction |
DR-0001 |
The reason code for why this transaction was declined. |
|
Decline Reason |
Transaction |
Invalid Expiry Date |
The reason description for why this transaction was declined. |
|
Decline Reason Comment |
Transaction |
Card was not a valid card. |
A comment as to why this transaction was declined. |
|
Channel |
Transaction |
F2F |
The channel that this transaction was acquired through. |
|