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
Field | Field Type | Primary Key |
|---|---|---|
FactRecurringPaymentAmountLogWID | BIGINT IDENTITY NOT NULL | Yes |
FactRecurringPaymentAmountLogId | BIGINT | |
UsermembershipWId | BIGINT | |
RecurringPaymentPk | BIGINT | |
StartDate | TIMESTAMP | |
EndDate | TIMESTAMP | |
PaymentAmount | FLOAT | |
PaymentDiscount | FLOAT | |
PaymentTax | FLOAT | |
AnnualPaymentAmount | FLOAT | |
AnnualPaymentDiscount | FLOAT | |
AnnualPaymentTax | FLOAT | |
CenterWID | BIGINT | |
etlCreatedBy | BIGINT | |
etlCreatedDate | TIMESTAMP | |
podname | VARCHAR(100) | |
void | INT | |
groupid | BIGINT | |
organizationid | VARCHAR(36) | |
EtlLastUpdatedOn | TIMESTAMP DEFAULT convert_timezone('UTC'sysdate) | |
EtlLastUpdatedBy | VARCHAR(50) DEFAULT current_user |