Billing Dataset Refinements for Billing Dashboard

The following tables were refined as a part of billing dataset refinements for billing dashboard:

• Fact Table for Adjustments (C1_​ADJ_​DTLS_​INTG) - It is a Fact table used for adjustments, which stores the details of all adjustments, including Contract ID, Adjustment Type, Adjustment Status, Cancellation Reason and measures such as Base Amount, Exempt Amount, and Adjustment Amount.

• Dimension Table for Account (C1_​DIM_​ACCT_​INTG) - It is a Dimension table used for account, which stores all the business-related attributes, such as, Division, Bill Cycle, Collection Class, Usage Type, and Customer Class Details for all the accounts in the system.

• Bill Fact Table for Generic Dataset Extract (C1_​BILL_​FACT_​INTG) - It is a Fact table used for Bill, which stores bill related details like Bill ID, Invoice Account, Bill Cycle and measures like New Charges, Corrections, Current Bill Balance, and Payments received against the Bill for all the invoices in the system.

• Table for Bill and Autopay Details (C1_​BILL_​APAY_​DTLS_​INTG) - This table stores the autopay related details, such as, Autopay ID, Autopay Source Code, External Account, Autopay Type, and Routing Details.

• Integrated dataset for Bill Segments (C1_​BSEG_​DTLS_​INTG) - It is a Fact table for bill segments, which stores details of all the bill segments, such as, Corresponding Bill ID, Calculation Lines, Cancellation Reason, and Exception Messages.

• Integrated dataset for FT & GL (C1_​FT_​GL_​DTLS_​INTG) - It is a Fact table for financial transactions, which stores the entire details of all the FT Types (Bill Segments, Payments and Adjustments) and measures like Current Amount, Total Amount along with their corresponding Bill ID and GL related attributes.