Receipts

Grain: RECEIPTS — one row per receipt issued to a contact. RECEIPTED_GIFTS — one row per gift included in a receipt.

A RECEIPT is the acknowledgment document issued to a donor. It can cover one or more gifts (RECEIPTED_GIFTS). Receipts are generated through two mechanisms: a RECEIPTING_GROUP_RUN (a batch run across many donors) or a RECEIPTING_STATEMENT_RUN (a year-end statement for an individual contact). Both can deliver via email, tracked in SENT_EMAILS.

Solid lines — required join (FK always populated). Dotted lines — optional join (FK is nullable; always use LEFT JOIN).

Table columns

Tables on this page: RECEIPTS · RECEIPTED_GIFTS · GIFTS (boundary) · RECEIPTING_GROUP_RUNS · RECEIPTING_GROUP_RUN_GIFTS · RECEIPTING_STATEMENT_RUNS · SENT_EMAILS

One row per receipt issued to a contact. RECEIPT_TYPE and RECEIPT_MEDIUM are numeric codes. Individual gifts covered by this receipt are in RECEIPTED_GIFTS.

Column	Type	Notes
`RECEIPT_KEY`	TEXT	Primary key
`CONTACT_KEY`	TEXT	FK → CONTACTS
`RECEIPTING_STATEMENT_RUN_KEY`	TEXT	FK → RECEIPTING_STATEMENT_RUNS (optional) — the statement batch that generated this receipt
`RECEIPT_TYPE`	NUMBER	Type of receipt — decode with TYPE_REFERENCES (Entity: `Receipt`, Property: `ReceiptType`)
`RECEIPT_MEDIUM`	NUMBER	Delivery medium (email, mail, etc.) — decode with TYPE_REFERENCES (Entity: `Receipt`, Property: `ReceiptMedium`)
`YEAR`	NUMBER	Tax year for this receipt
`EMAIL_ADDRESS`	TEXT	Email address the receipt was sent to
`RECEIPT_IS_AVAILABLE_TO_DONOR`	BOOLEAN	Receipt is visible in the donor portal
`RECEIPT_IS_DELETED`	BOOLEAN	Soft delete flag

RECEIPTED_GIFTS

One row per gift included in a receipt. A single receipt can cover multiple gifts; this is the junction table between RECEIPTS and GIFTS.

Column	Type	Notes
`RECEIPTED_GIFT_KEY`	TEXT	Primary key
`RECEIPT_KEY`	TEXT	FK → RECEIPTS
`GIFT_KEY`	TEXT	FK → GIFTS
`RECEIPTED_GIFT_IS_DELETED`	BOOLEAN	Soft delete flag

GIFTS

GIFTS appears in this diagram as the endpoint for both RECEIPTED_GIFTS and RECEIPTING_GROUP_RUN_GIFTS. The full gift structure is documented in Gifts — extended reference.

Column	Type	Notes
`GIFT_KEY`	TEXT	Primary key
`CONTACT_KEY`	TEXT	FK → CONTACTS
`GIFT_DATE_UTC`	TIMESTAMP	Date the gift was made
`AMOUNT`	NUMBER	Total gift amount
`GIFT_IS_DELETED`	BOOLEAN	Soft delete flag

RECEIPTING_GROUP_RUNS

One row per receipting batch run — a bulk operation that generates receipts for a group of donors at once. Summary totals show how many receipts were produced and by which channel.

Column	Type	Notes
`RECEIPTING_GROUP_RUN_KEY`	TEXT	Primary key
`RECEIPTING_GROUP_NAME`	TEXT	Name of the receipting group
`QUERY_NAME`	TEXT	Name of the query used to select donors
`TEMPLATE_NAME`	TEXT	Receipt template used
`RECEIPT_MEDIUM`	NUMBER	Delivery medium — decode with TYPE_REFERENCES (Entity: `Receipt`, Property: `ReceiptMedium`)
`RECEIPT_CODE`	TEXT	Receipt code identifier
`TOTAL_GIFTS_RECEIPTED`	NUMBER	Total gifts included in this run
`TOTAL_EMAIL_RECEIPTS`	NUMBER	Number of receipts delivered by email
`TOTAL_MAIL_RECEIPTS`	NUMBER	Number of receipts delivered by mail
`TOTAL_LETTER_ON_DEMAND_RECEIPTS`	NUMBER	Number of letter-on-demand receipts
`RECEIPTING_GROUP_RUN_IS_DELETED`	BOOLEAN	Soft delete flag

RECEIPTING_GROUP_RUN_GIFTS

One row per gift processed in a receipting group run. Junction table between RECEIPTING_GROUP_RUNS and GIFTS.

Column	Type	Notes
`RECEIPTING_GROUP_RUN_GIFT_KEY`	TEXT	Primary key
`RECEIPTING_GROUP_RUN_KEY`	TEXT	FK → RECEIPTING_GROUP_RUNS
`GIFT_KEY`	TEXT	FK → GIFTS
`RECEIPTING_GROUP_RUN_GIFT_IS_DELETED`	BOOLEAN	Soft delete flag

RECEIPTING_STATEMENT_RUNS

One row per year-end statement run. A statement run generates year-end tax summary receipts and can target a single contact or a query-based group.

Column	Type	Notes
`RECEIPTING_STATEMENT_RUN_KEY`	TEXT	Primary key
`CONTACT_KEY`	TEXT	FK → CONTACTS (optional) — populated for single-contact runs
`TITLE`	TEXT	Statement title
`STATEMENT_DATE`	TIMESTAMP	Date the statement covers
`RECEIPT_FORMAT`	NUMBER	Output format (PDF, email, etc.)
`RECEIPTING_STATEMENT_RUN_IS_AVAILABLE_TO_DONOR`	BOOLEAN	Statement is visible in the donor portal
`RECEIPTING_STATEMENT_RUN_IS_DELETED`	BOOLEAN	Soft delete flag

SENT_EMAILS

One row per email delivery record. In the receipts context, SENT_EMAILS tracks receipt and statement emails delivered to donors. Also linked to email marketing — see Campaigns — extended reference for the full email structure.

Column	Type	Notes
`SENT_EMAIL_KEY`	TEXT	Primary key
`CONTACT_INDIVIDUAL_KEY`	TEXT	FK → CONTACT_INDIVIDUALS — the recipient
`RECEIPT_KEY`	TEXT	FK → RECEIPTS (optional) — set when this is a receipt delivery
`RECEIPTING_GROUP_RUN_KEY`	TEXT	FK → RECEIPTING_GROUP_RUNS (optional) — set when sent as part of a group run
`RECEIPTING_STATEMENT_RUN_KEY`	TEXT	FK → RECEIPTING_STATEMENT_RUNS (optional) — set when sent as part of a statement run
`EMAIL_VERSION_KEY`	TEXT	FK → EMAIL_VERSIONS (optional) — set for marketing emails
`EMAIL_ADDRESS`	TEXT	Recipient email address
`DELIVERY_STATUS`	NUMBER	Delivery outcome — decode with TYPE_REFERENCES (Entity: `SentEmail`, Property: `DeliveryStatus`)
`OPENED`	BOOLEAN	Email was opened
`CLICKED`	BOOLEAN	Email was clicked
`UNSUBSCRIBE`	BOOLEAN	Recipient globally unsubscribed
`MARKED_AS_SPAM`	BOOLEAN	Recipient marked as spam
`SENT_EMAIL_IS_DELETED`	BOOLEAN	Soft delete flag

Data freshness: These tables sync continuously from Virtuous CRM. Typical lag is under 4 hours. To check when a record was last updated, inspect the SF__ROW_SYNCED_DATE_TIME_UTC column on any table.

Overview

Reference

Receipts

Table columns

RECEIPTS

RECEIPTED_GIFTS

GIFTS

RECEIPTING_GROUP_RUNS

RECEIPTING_GROUP_RUN_GIFTS

RECEIPTING_STATEMENT_RUNS

SENT_EMAILS

​Table columns

​RECEIPTS

​RECEIPTED_GIFTS

​GIFTS

​RECEIPTING_GROUP_RUNS

​RECEIPTING_GROUP_RUN_GIFTS

​RECEIPTING_STATEMENT_RUNS

​SENT_EMAILS

Table columns

RECEIPTS

RECEIPTED_GIFTS

GIFTS

RECEIPTING_GROUP_RUNS

RECEIPTING_GROUP_RUN_GIFTS

RECEIPTING_STATEMENT_RUNS

SENT_EMAILS