ZenotiHelp

Recurring Payment Amount Log Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Logs recurring payment amounts, discounts, and taxes for user memberships over time, including both regular and annual payment components.

Columns

Column Name Data Type Nullable Description
FactRecurringPaymentAmountLogWID BIGINT IDENTITY NOT NULL Surrogate warehouse key for the recurring payment amount log record.
FactRecurringPaymentAmountLogId BIGINT NULL Source system identifier for the recurring payment amount log.
UsermembershipWId BIGINT NULL Warehouse key referencing the user membership dimension.
RecurringPaymentPk BIGINT NULL Primary key of the recurring payment in the source system.
StartDate TIMESTAMP NULL Start date/time of the payment period.
EndDate TIMESTAMP NULL End date/time of the payment period.
PaymentAmount FLOAT NULL Recurring payment amount for the period.
PaymentDiscount FLOAT NULL Discount applied to the recurring payment.
PaymentTax FLOAT NULL Tax amount applied to the recurring payment.
AnnualPaymentAmount FLOAT NULL Annual recurring payment amount.
AnnualPaymentDiscount FLOAT NULL Discount applied to the annual recurring payment.
AnnualPaymentTax FLOAT NULL Tax amount applied to the annual recurring payment.
CenterWID BIGINT NULL Warehouse key referencing the center dimension.
etlCreatedBy BIGINT NULL Identifier of the ETL process or user that created this record.
void INT NULL Flag indicating whether the record is voided (soft delete).

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

Primary Key

FactRecurringPaymentAmountLogWID

Foreign Keys

Column References
CenterWID Bi_DimCenter.centerwid

Enumerator Values

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