ZenotiHelp

Invoice Donations Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Tracks donation amounts collected through invoices, including payment center, donor, donation type, and payment mode details.

Columns

Column Name Data Type Nullable Description
factinvoicedonationswid BIGINT IDENTITY NOT NULL Surrogate key for the invoice donations fact record
FactDonationID NUMERIC(19,0) NULL Business/natural key for the donation record
PaymentCenterwid BIGINT NULL Foreign key to the center where payment was collected
Userwid BIGINT NULL Foreign key to the donor/guest user dimension
InvoiceId VARCHAR(36) NULL Unique identifier (GUID) of the invoice
InvoiceItemId VARCHAR(36) NULL Unique identifier (GUID) of the invoice item
TransactionId VARCHAR(36) NULL Unique identifier (GUID) for the payment transaction
Donationwid BIGINT NULL Foreign key to the donation dimension
DonationAmount DECIMAL(19,4) NULL Monetary amount of the donation
void BOOLEAN NULL Indicates whether the record has been voided
PaymentModeNumber VARCHAR(200) NULL Payment mode reference number or descriptor
orgpaymentoptionwid BIGINT NULL Foreign key to the organization payment option dimension
PaymentDate TIMESTAMP NULL Date and time of the payment
invoiceNo VARCHAR(160) NULL Human-readable invoice number

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factinvoicedonationswid

Foreign Keys

Column References
PaymentCenterwid Bi_DimCenter.centerwid
Userwid Bi_DimUser.userwid
Donationwid Bi_DimDonations.donationwid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.