Journal Fields

Field Name Description
Account Paid On Pledge This shows the amount paid on a single pledge.
Amount Received On Recurring Gift Schedule This shows the amount that has been received on a recurring gift schedule.
Approach This shows how a transaction came into your organization.
Approach Description This shows the description associated with the approach for the transactions in the report.
Arrears Amount This shows the amount past due on an individual pledge.
Arrears Plus Current Payment This shows the amount that is past due on an individual pledge plus the next payment that is due.
Arrears Plus Current Payment Date This shows the date of the next payment due for each pledge in your query.
Balance This shows the difference between the Pledged amount and the amount paid with the original pledge.
Calendar Item Attendee Count This shows the number of accounts that were invited to the calendar item in the report.
Calendar Item Attendees This shows the people who have attended or are planning on attending any of the calendar events on the account.
Calendar Item Attendees' Address Lines 1 This shows the first line of the address block listed on the persona page.
Calendar Item Attendees' Address Lines 2 This shows the second line of the address block listed on the persona page.
Calendar Item Attendees' Address Lines 3 This shows the third line of the address block listed on the persona page.
Calendar Item Attendees' Address Lines 4 This shows the fourth line of the address block listed on the persona page.
Calendar Item Attendees' Addresses This shows the addresses of all the people attending the calendar item.
Calendar Item Attendees' Cities This shows the names of the cities from which the calendar item attendees come.
Calendar Item Attendees' Emails This shows the email addresses of the calendar item attendees.
Calendar Item Attendees' Fax Numbers This shows the calendar item attendees' fax number(s).
Calendar Item Attendees' Long Salutations This shows the long and formal names of the calendar item attendees. Use the long salutation field to input information that would be used to formally address your accounts. For example, John Doe, might be addressed "Mr. John Doe" in the long salutation field or "Mr. Doe."
Calendar Item Attendees' Phones This shows the phone number of the calendar item attendees.
Calendar Item Attendees' Postal Codes This shows the postal code field information for all attendees on a calendar item.
Calendar Item Attendees' States This shows all the states from which that calendar item attendees come.
Calendar Item Priority This shows the priority that was assigned to the calendar item displayed in the report.
Calendar Item Status This shows the current status of the calendar item. Such as on schedule, rescheduled, or postponed.
Campaign This shows the campaign that was selected on the transaction displayed in the report.
Campaign Description This shows the description associated with the campaign that was selected for the transaction displayed in the report.
Contact Method This shows the way in which you contact your accounts. You can track these contacts on the account’s journal page.
Contact Subject This shows the topic of discussion or purpose of the contact when communication is made with an account.
Created By This shows which user made the account. This option is available in the report writer.
Creation Date This shows the date the account was created. This option is available in the report writer.
Creation Time This shows the time the account was created. This option is available in the report writer.
Credit Account This shows the amount of money that will be applied to the credit account. This is usually the negative of the received amount.
Credit Amount This shows the general ledger account that is being credited in the fund.
Date This shows the date of the credit or debit made to the account.
Debit Account This shows thegeneral ledger account that is being debited in the fund.
Debit Amount This shows the amount of money that will be applied to the debit account. This is usually the received amount.
End Date This shows the date that the calendar event is scheduled to end.
End Time This shows the time that the calendar event is scheduled to end.
Entry Type This shows the type of journal entry of the entries displayed in the report.
Failure Code This shows the failure code of processed transactions that have failed in your report.
Failure Message This shows the failure message associated with processed transactions that have failed in your report.
Final? This shows whether a transaction has been marked final or not.
First Installment Date This shows the date that the first installment of payments is due.
Frequency This shows how often a pledge payment is expected from a constituent.
Fund This shows where the money you have collected will be deposited. Tracking this information when you receive a new gift enables you to run reports on the fund and how successful it has been to date. Many times different funds will be used for each General Ledger account.
Fund Description This shows the description of the fund associated with the fund selected in transactions displayed in your report.
Fundraiser This shows the fundraiser value selected on transaction or participation journal entries.
Fundraiser Donation Message This shows the information stored in the fundraiser donation message on transaction journal entries; that field contains the message that the donor can type in when donating through the fundraiser
Fundraiser Total Pledged This shows the total amount of sponsorship donations that the participant or team has received in the form of Pledges. This is for participation journal entries.
Fundraiser Total Raised This shows the total amount of sponsorship donations that the participant or team has received in the form of Pledges, Gifts, or Recurring Gifts. This is for participation journal entries.
Fundraiser Total Received This shows the total amount of sponsorship donations that the participant or team has received in the form of gifts, pledge payments, or recurring gifts. This is for participation journal entries.
Generated Receipt Date Issued

This shows the receipt date for a transaction on an eReceipt.

Generated Receipt Number This shows the generated receipt number for a transaction on an eReceipt.
Generated Receipt Status This shows the current status of the transaction's receipt on an eReceipt.
Generated Voided Receipt Number This shows the most recently voided receipt number for a transaction on an eReceipt.
Gift Aid Amount For UK users, this shows the amount of gift aid associated with a transaction.
Gift Aid Applied? For UK users, this shows whether or not a transaction has had gift aid applied to it.
Gift Aid Claimed Date For UK users, this shows the date that was entered as the Claim Date when a transaction had gift aid applied to it.
Gift Aid Declaration Address For UK users, this shows the address associated with the gift aid declaration.
Gift Aid Declaration City For UK users, this shows the city associated with the gift aid declaration.
Gift Aid Declaration Confirmation Date For UK users, this shows the confirmation date on verbal declarations.
Gift Aid Declaration Country For UK users, this shows the country associated with the gift aid declaration.
Gift Aid Declaration End Date- For UK users, this shows the end date associated with the gift aid declaration.
Gift Aid Declaration Name For UK users, this shows the name associated with the gift aid declaration.
Gift Aid Declaration Note For UK users, this shows the note associated with the gift aid declaration.
Gift Aid Declaration Postal Code For UK users, this shows the postal code associated with the gift aid declaration.
Gift Aid Declaration Start Date For UK users, this shows the start date associated with the gift aid declaration.
Gift Aid Declaration State For UK users, this shows the state associated with the gift aid declaration.
Gift Aid Declaration Type For UK users, this shows whether the declaration is verbal or written associated with the gift aid declaration.
Gift Aid Ready? For UK users, this shows whether a transaction's Gift Aid Eligible box has been checked or not. If checked, the transaction will display "Yes" in this column.
Gift Aid Transitional Relief For UK users, this shows the amount of transitional relief applied to the transaction during the Gift Aid Mass Update process.
Gift Type This shows the gift type that was selected on a transaction.
Gift Type Information This shows the information that was recorded on all of the various fields listed in the Gift Type section of the transaction screen.
Gift Type Note This shows the contents of the Note field located in the Gift Type section of the transaction screen.
Gift Type Value This shows the amount associated with the Gift Type on a transaction.
Gifted This shows the money that has been received with no pledge.
GL Account When you select the Extended Line Items launch option, this shows the GL Account associated with transactions displayed in the report. Each transaction will have two GL accounts associated with it (through the Fund value assigned to the transaction), so the Extended Line Items option creates a separate record for the credit and debit account associated with the transaction.
GL Amount

When you select the Extended Line Items launch option, two report records are generated for each transaction, one representing the credit account and one the debit account associated with the transaction. This shows the credit amount on the credit account record, and the debit amount on the debit account record. The difference between the credit amount and the debit amount is simply the sign - one of these values is negative, and the other is positive. When any other launch option is selected, the GL Amount is populated with the absolute value of the donation amount.
Installment Amount This shows the amount of money paid on a regular basis to satisfy the pledge.
Invitation Status This shows whether the invitation for a calendar event is pending, confirmed, declined, etc.
Last Modified By This shows the person who last modified the account and made changes.
Last Modified Date This shows the date the data was last modified.
Last Modified Time This shows the time the modifications were made.
Letter This shows the letter type selected (if any) on transactions displayed in your report.
Letter Description This shows the description associated with the letter selected on transactions displayed in your report.
Linked Hard Credit Account Name This shows the soft credit, the linked person who is responsible for the actual donation and the payment of money. See Soft Credit for more information.
Linked Hard Credit Address This shows the address of the hard credited account that is linked to the soft credited account.
Linked Hard Credit Amount This shows the amount of money that the person donated that is linked with the soft credit on another account.
Linked Hard Credit City This shows the city of the hard credited account that is linked to the soft credited account.
Linked Hard Credit Phone Number This shows the phone number of the hard credited account that is linked to the soft credited account.
Linked Hard Credit Pledged Amount This shows the amount of money pledged by the account that caused another account to receive soft credit for the transaction.
Linked Hard Credit Postal Code This shows the postal code of the hard credited account that is linked to the soft credited account.
Linked Hard Credit Sort Name This shows the person who holds the account that receives hard credit for the transaction.
Linked Hard Credit State This shows thestate of the hard credited account that is linked to the soft credited account.
Linked Soft Credit Account Name This shows the name of the account the linked person holds. When looking at hard credit, the linked person is responsible for inspiring the contribution.
Linked Soft Credit Address This shows the address of the soft credited account that is linked to the hard credited account.
Linked Soft Credit Amount This shows the amount of money soft credited to the account.
Linked Soft Credit City This shows the city of the soft credited account that is linked to the hard credited account.
Linked Soft Credit Phone Number This shows the phone number of the soft credited account that is linked to the hard credited account.
Linked Soft Credit Postal Code This shows the postal code of the soft credited account that is linked to the hard credited account.
Linked Soft Credit State This shows the state of the soft credited account that is linked to the hard credited account.
Most Recent Payment Amount This shows the amount of the payment that was most recently made on the pledge.
Most Recent Payment Date This shows the date of the payment that was most recently made on the pledge.
Next Payment Amount This shows the amount of money due upon the date of the next payment.
Next Payment Date This shows the date that the next payment is due.
Next Recurring Gift Amount This shows the amount for the next recurring gift for the recurring gift schedule.
Next Recurring Gift Date This shows the date for the next recurring gift for the recurring gift schedule.
Nondeductible Amount This shows the amount of money that is not tax deductible.
Note This shows the note associated with the journal entry that is being pulled in the report.
Order Item Price This shows the unit price for the Item associated with an Order Item transaction or split. The Order Item Price is recorded at the time the purchase is made, and may differ from the Unit Price currently on the Item in the eTapestry Cart. This value is zero for journal entry types other than Order Item.
Order Shipping Amount This shows the portion of a Cart Order transaction that is associated with the Shipping fee. This value is zero for journal entries that are not of types Order Item, Order Shipping and Order Tax.
Order Tax Amount This shows the portion of a Cart Order transaction that is associated with the Sales Tax collected. This value is zero for journal entries that are not of types Order Item, Order Shipping and Order Tax.
Ordered This shows the amount of money associated with an Order Item transaction or split. This value is zero for journal entries types other than Order Item.
Original Pledge Amount Paid on Pledge This shows the total amount paid so far on the pledge. This is for reporting or creating documents using payment transactions.
Original Pledge Approach This shows the approach associated with the original pledge. This is for pledge payment records.
Original Pledge Approach Description This shows the description of the approach associated with the original pledge. This is for pledge payment records.
Original Pledge Campaign This shows the campaign associated with the original pledge. This is for pledge payment records.
Original Pledge Campaign Description This shows the description of the campaign associated with the original pledge. This is for pledge payment records.
Original Pledge Date This shows the journal entry date from the associated pledge. This is for pledge payments.
Original Pledge Fund This shows the fund associated with the original pledge. This is for pledge payment records.
Original Pledge Fund Description This shows the description of the fund associated with the original pledge. This is for pledge payment records.
Original Pledge Non-Deductible Amount This shows the non-deductible amount from the pledge. This is for payment transactions.
Original Pledge Outstanding Balance This shows the amount of money that still needs to be paid on the original pledge. This is for pledge payment records.
Original Pledged Amount This shows the amount of money that was originally pledged. This is for pledge payment records.
Outstanding Balance This shows the amount of money left to be paid on a pledge.
Overpaid This shows the amount that was overpaid on a pledge.
Paid This shows the amount paid by the constituent that was received.
Participant Display Name This shows the data in the Display Name field located on Participation journal entries on constituent accounts.
Payment Schedule This shows the payment scheduled associated with a pledge.
Pledge Final Scheduled Payment Amount This shows the amount of the final payment listed on the schedule.
Pledge Final Scheduled Payment Date This shows the date of the final payment listed on the schedule.
Pledge Payments Made This shows the total number of payments that have been made.
Pledge Payoff Date This shows the date of the last payment that was made on a pledge that is now paid off.
Pledge Schedule Note This shows the note associated with the schedule of pledge payments.
Pledge Scheduled Payments Fulfilled This shows the total number of scheduled payments that have been fulfilled.
Pledge Scheduled Payments Remaining This shows the total number of scheduled payments that have not yet been fulfilled.
Pledge Scheduled Payments Total This shows the total number of payments scheduled.
Pledge Write Off Amount When is pledge is written off, this shows the amount by which it was not fulfilled
Pledge Write Off Date This shows when a pledge was written off.
Pledge Written Off? This shows whether a pledge was written off.
Pledged This shows the amount that constituents promised to pay.
Process Type This shows how a transaction was processed.
Purchased This shows the received amount from any purchase transactions processed through the Cart.
Raised This shows the total of the constituent's pledges and gifts. It does not include pledge payments.
Raised & Soft Credit

When you do not collapse groups, this shows the received amount on the gift transactions, the pledged amount on pledge transactions, or the soft credit amount if the transaction is a soft credit.

When you select to group a report by account or household, and then collapse the groups, this shows the total of the received amount on all gift transactions, the pledged amount on all pledge transactions, and the soft credited amounts from all soft credits for each particular account or household, based on the transactions included in the query.

This does not include the linked soft credit amount if a gift or pledge transaction has linked soft credit.

Receipt ID This text field enables you to assigned any receipt number for a gift.
Receipt Number This shows the receipt number assigned to the transaction.
Receivable This shows the pledge amount.
Received This shows the amount that has been received from a constituent. It includes pledge payments and gifts.
Received & Soft Credit

When you do not collapse groups, this shows the received amount on the transaction, or the soft credit amount if the transaction is a soft credit.

When you select to group a report by account or household, and then collapse the groups, this shows the total of the received amount on all transactions plus the soft credited amounts from all soft credits for each particular account or household, based on the transactions included in the query.

This does not include the linked soft credit amount if a gift, pledge, or payment transaction has linked soft credit.

Received + Linked Soft Credit This shows the amount received plus the amount of the linked soft credit for a transaction.
Received Minus Non Deductible This analyzes transactions within your query and subtracts the total received amount from the total non deductible amount.
Recognition This shows whether the constituent wants the gift to be anonymous, do not recognize, or known by a specific name.
Recognition Name This shows the specific name by which the constituent wants the gift to be recognized, if the name is different from the account or default name.
Recurring Gift Schedule Note This shows the entered on the recurring gift schedule in your report.
Recurring Gift Schedule Status This shows the status of the recurring gift.
Scheduled Gift Type This shows the Gift Type that was scheduled for recurring gifts in the report.
Scheduled Gift Type Information This shows the information that was recorded on all of the various fields listed in the Gift Type section of the transaction screen for recurring gifts.
Scheduled Gift Type Value This shows the amount associated with the Gift Type on the scheduled recurring gifts.
Soft Credit Amount This shows the amount soft credited to a specific person.
Soft Credit Approach This shows the approach used to obtain the soft credit.
Soft Credit Approach Description This shows the description of the approach associated with the soft credit.
Soft Credit Campaign - This shows the specific campaign at the time that soft credit was issued.
Soft Credit Campaign Description This shows the description of the campaign associated with the soft credit.
Soft Credit Fund This shows the specific fund that the soft credit went towards.
Soft Credit Fund Description This shows the description of the fund associated with the soft credit.
Soft Credit Letter This shows the user defined field value that marks a soft credit with a specific way to track it in case an organization wants to send a specific letter for the soft credit.
Soft Credit Letter Description This shows the description of the letter associated with the soft credit.
Soft Credit Note This shows the note that applies to the soft credit.
Start Time This shows the time entered for the start of a calendar item.
Title This shows the title of calendar items and invites.
Transaction Date This shows the journal entry date from a transaction
Transaction Number This shows the unique identifier for a transaction inside eTapestry.
Transaction Type This shows the type of transactions that occur within an account such as calendar item, gift, note, soft credit, recurring gift schedule, invitation, recurring gift, payment, disbursement, contact, split gift, pledge, or soft credit without a hard credit link.
Tribute This shows the account set up as an honorarium. For example, someone who passed away. This is a special account in database separate from regular constituents.
Upgraded/Split Transaction - Consolidated Payment Schedule This shows the split pledge schedules as a consolidated payment schedule.
Upgraded/Split Transaction - Next Payment Amount This shows the next payment amount on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Next Payment Date This shows the next payment date on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Non-Deductible Total This shows the total non-deductible amount of an upgraded pledge or split transaction.
Upgraded/Split Transaction - Number of Splits This shows the number of splits include in an upgraded pledge or split transaction.
Upgraded/Split Transaction - Revised Total Pledged This shows the total amount that is expected to be paid on an upgraded pledge that has one or more splits written off.
Upgraded/Split Transaction - Revised Total Raised This shows the total amount that is expected to be paid on an upgraded pledge that has one or more splits written off.
Upgraded/Split Transaction - Total Amount Paid on Pledge This shows the total amount that has been paid on an upgraded pledge or split pledge.
Upgraded/Split Transaction - Total Arrears This shows the total arrears amount on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Arrears Plus Current Payment This shows the total amount in arrears plus the current payment due on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Arrears Plus Current Payment Date This shows the current payment date on an upgraded pledge or split transaction. If the last scheduled payment for this pledge is in the past, the field will show the last scheduled payment date.
Upgraded/Split Transaction - Total Item Price This shows the total amount of money associated with all Order Item splits associated with a Cart order transaction. This value is zero except when reporting on a split Order transaction.
Upgraded/Split Transaction - Total Number of Payments This shows the total number of payments associated with an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Ordered This shows the total amount of money associated with all splits associated with a Cart order transaction. This value is zero except when reporting on a split Order transaction.
Upgraded/Split Transaction - Total Outstanding Balance This shows the total outstanding balance on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Overpaid This shows the amount overpaid on an upgraded pledge or split transaction.
This shows the Upgraded/Split Transaction - Total Paid This shows the total amount paid on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Pledged This shows the total amount pledged on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Raised This shows the total amount raised on an upgraded pledge or split transaction.
Upgraded/Split Transaction - Total Received This shows the total amount of an upgraded pledge or split gift. All of the parts of the transaction added together.
Upgraded/Split Transaction - Total Shipping This shows the total amount of money associated with shipping fees for a Cart order transaction. This value is zero except when reporting on a split Order transaction.
Upgraded/Split Transaction - Total Tax This shows the total amount of money associated with Sales Tax for a Cart order transaction. This value is zero except when reporting on a split Order transaction.
Upgraded/Split Transaction - Total Variance This shows the total difference between the original pledged amount and the amount expected to be received on an upgraded pledge with one or more written-off splits.
Variance This shows the difference between the original pledged amount and the amount expected to be received on a written-off pledge.