7. FILES › 7.11 Multi-Site Financial Recap File (ACT_RC)

7.11 Multi-Site Financial Recap File (ACT_RC)

The Multi-Site Financial Recap File (ACT_RC) quantifies the
total amount of debits, credits, discounts, and budgets in
dollars and cents for all central and remote site cost center
combinations used in multi-site accounting.  Quantities are
carried for debits and credits, and rates are carried for
debits.


USAGE CONSIDERATIONS

Note the following special considerations or techniques
related to using the Multi-Site Financial Recap File
(ACT_RC):

1.  The type of data contained in each observation (debit,
    credit, discount, surcharge, budgets or zero-balance
    adjustment) is indicated by the RCPTYPE and RCPSTYPE
    variables as shown in the table below.  The RCPCHG
    variable always contains the amount of the item in
    dollars and cents.  The value of RCPCHG may be either
    positive or negative.

      Data Type    RCPTYPE    RCPSTYPE    Data Detail
      ---------    -------    --------    -----------
      Charges        10          D        Debit
      Charges        10          C        External Entry
      Charges        10          L        Ledger

      Credits        20        blank      n/a

      Discounts      30        DFPC       Fixed Percent
      Discounts      30        DLSA       Lump Sum Amount
      Discounts      30        DVOL       Volume

      Surcharges     40        blank      n/a

      Budgets        50          C        Cost Center
      Budgets        50          I        Invoice Category
      Budgets        50          M        Computation Code

      Zero Balance
      Adjustments    60        blank      n/a

2.  The INVCCAT variable contains the invoice category in
    those observations in which it is meaningful,
    specifically:  charges, invoice category discounts,
    invoice category surcharges, computation code or invoice
    category budgets, computation code or invoice category
    zero-balance adjustments.  INVCCAT also contains the
    credit category in credit observations (RCPTYPE = 20).
    It is blank in all other observations.

3.  The RCPCPC variable contains the value of computation
    code for those observations in which it is meaningful,
    specifically:  charges, computation code budgets, and
    computation code zero-balance adjustments.  It is blank
    in all other observations.

4.  The RCPQNT variable specifies the quantity of the item
    billed for charges, the number of credits issued
    (SCTCOUNT) for credits, and the net charge for invoice
    category discounts, fixed percentage cost center
    discounts, surcharges, and zero-balance adjustments.  It
    carries a missing value in all other cases.

5.  The RCPRAT variable contains the billing rate for
    charges and the discount percentage (divided by 100, that
    is, decimal format) for invoice category discounts, fixed
    percentage cost center discounts, surcharges, and zero-
    balance adjustments.  It carries a missing value in all
    other cases.

6.  The RCPSTAT variable carries the billing status of the
    item (BILL or NOBILL) as derived from the Cost Center
    Attributes File.  A default of BILL is used if a value is
    not present in the product's file.

7.  The value of RCPCHG may be either positive or negative
    for charges or zero-balance adjustments.  It is always
    negative for credits or discounts.