7. FILES › 7.14 Multi-Site Year-to-Date Financial Recap File (ACT_YT)

7.14 Multi-Site Year-to-Date Financial Recap File (ACT_YT)

The Multi-Site Year-to-Date Financial Recap File (ACT_YT)
quantifies the year-to-date amount of debits, credits,
discounts, surcharges, and budgets in monetary units for all
central and remote site cost center combinations used in
multi-site accounting.  Quantities and rates, as summarized
from the original data source, are carried for debits and
credits.


USAGE CONSIDERATIONS

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

1.  The Multi-Site Year-to-Date Financial Recap File contains
    all debits, credits, discounts, zero-balance adjustments,
    surcharges, and budgets applied to all central and remote
    cost centers for one year.  It is created when the
    ACTMGTAB job is run.

2.  Cycle 00 contains information for the current year to
    date, and higher cycles contain information for previous
    years.  The Multi-Site Year-to-Date Financial Recap File
    is not aged.  It is recreated every time the ACTMGTAB job
    is run.

3.  The type of data contained in each observation (debit,
    credit, discount, surcharge, budget 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

4.  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, and 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.

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

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

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

8.  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.

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