Donations fact table
Bi_FactInvoiceDonations_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
FactDonationID | NUMERIC(19,0) | Unique identifier for the record. Primary key | Yes | ||
PaymentCenterid | VARCHAR(36) | Unique identifier for the center where payment is received | Bi_DimCenter centerid | ||
UserID | VARCHAR(36) | unique identifier for the guest who made the donation | Bi_DimUser userid | ||
InvoiceId | VARCHAR(36) | Unique identifier for the invoice generated. Unique within organization | |||
InvoiceItemId | VARCHAR(36) | unique identifier for individual line item within invoice | |||
TransactionId | VARCHAR(36) | A unique non-blank identifier for each transaction. For example, if an invoice is paid by using two swipes of a credit card, then two unique transaction IDs get associated with the invoice. There is an exception in case of group invoices. Even if they are paid through a single transaction, the 'transaction ID' is different against each of the group invoices. | |||
DonationId | VARCHAR(36) | Unique identifier for a donation type. Unique for a center | bi_dimdonations donationid | ||
DonationAmount | DECIMAL(19,4) | Amount donated | |||
void | BOOLEAN | indicates if the row is void or not. 1- void, 0- not void | |||
PaymentModeNumber | VARCHAR(200) | Indicates the payment mode used to make transaction | |||
PaymentTypeId | VARCHAR(36) | A unique identifier for Payment type option used for the payment(bi_dimorgpaymentoption). | Bi_DimOrgPaymentOption paymentoptiontype | ||
PaymentDate | TIMESTAMP | Date on which payment is made | |||
OrganizationId | varchar(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter Organizationid | ||
etlcreatedby | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlcreateddate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
podname | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||