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.