Recurring payment amount log fact table
This table is used to log and report on recurring payments made by users/members, including detailed breakdowns of payment amounts, discounts, taxes, and time periods
Bi_FactRecurringPaymentAmountLog_s3
Field | Field Type |
|---|---|
FactRecurringPaymentAmountLogId | DECIMAL(190) |
UsermembershipId | VARCHAR(36) |
RecurringPaymentPk | DECIMAL(190) |
CenterID | VARCHAR(36) |
StartDate | TIMESTAMP |
EndDate | TIMESTAMP |
PaymentAmount | FLOAT |
PaymentDiscount | FLOAT |
PaymentTax | FLOAT |
AnnualPaymentAmount | FLOAT |
AnnualPaymentDiscount | FLOAT |
AnnualPaymentTax | FLOAT |
groupid | DECIMAL(190) |
etlCreatedDate | TIMESTAMP |
etlCreatedBy | DECIMAL(190) |
EtlLastUpdatedOn | TIMESTAMP |
void | INT |
podname | VARCHAR(100) |
organizationid | VARCHAR(36) |