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.