CA PMA Chargeback Tables › CCCTAB (Consolidated Calculated Charges Table)

CCCTAB (Consolidated Calculated Charges Table)

This table contains the information used by all CA PMA Chargeback functions. It is created and maintained by the Detail (batch) functions and is a summary table of the output records' processed data. Each item kept in the CCCTAB table is a line item on an invoice. The table is maintained with a unique key comprised of the Accounting Structure, Period, Charge Element, and Qualifier. Information includes:

• Number of units
• Rate
• Charge
• Number of ORD records that constitute each CCCTAB record

The CCCTAB table is the principal CA PMA Chargeback information database.

           Key  Field-Name          Type      Length

            *   VERSION             CHAR         8
            *   ORDID               CHAR         3
            *   PERIOD              INT          4
            *   PERIODB             INT          4
            *   ELEMENT             CHAR        16
            *   QUAL                CHAR        16
            *   MODIFIER            CHAR        16
                CNT                 INT          4
                UNITS               DEC         15 (scale 0)
            *   RATE                DEC         15 (scale 0)
                CHARGE              DEC         15 (scale 0)
              + FLAGS               CHAR         2
            *   STRUCT1             CHAR        16
            *   STRUCT2             CHAR        16
            *   STRUCT3             CHAR        16
            *   STRUCT4             CHAR        16
            *   STRUCT5             CHAR        16

           + Split or Mod