6. REPORTS › 6.8 MICF Inquiries › 6.8.24 Generate CSV file from Financial Recap

6.8.24 Generate CSV file from Financial Recap

This Inquiry enables you to generate a Comma Separated Value
(CSV) file extracted from the Accounting Financial Recap
file.  The ACTRCP inquiry also creates a Data Transfer
Profile that provides descriptive information about the CSV
file metrics.  Data Transfer Profiles are used by the iCan
Provider Suite when processing CSV files.

INTENDED USE:

Generated CSV file that will allow the iCan chargeback
solution to utilize data from CA MICS Accounting and
Chargeback.

DATA SOURCE (file/timespan):

     ACTRCP - Financial Recap file at the MONTHS/TABLES time
              span.

DATA ELEMENTS USED:

     COSTCTRn  - User-Defined Cost Center Codes
     RCPCHG    - Amount Billed
     ACTINVTS  - Invoice Timestamp
     ACTMONTH  - Accounting Month
     ACTYEAR   - Accounting Year
     DATASRC   - Data Source (Component or File ID)
     INVCCAT   - Invoice Category
     INVCAT    - Invoice Category (Description)
     MONTH     - Month of Year
     RCPCLVL   - Cost Center Level
     RCPCPC    - Billable Computation Code
     COMPCODE  - Billable Computation code(Description)
     RCPILVL   - Invoice Level
     RCPQNT    - Number of Billable Items
     RCPRAT    - Billing Rate
     RCPSTAT   - Billing Status
     RCPSTYPE  - Record Sub-type
     RCPTYPE   - Record Type
     SYSID     - System Identifier
     YEAR      - Year of Century


HOW TO PRODUCE THE REPORT:

  o Enter the CA MICS Workstation Facility (MWF).

  o Choose option 2, CA MICS Information Center Facility
    (MICF).

  o Choose option 2, Database Inquiries.

  o Select ACTRCP, whose Catalog Group is FINANCE.

  o Complete the Execution-Time Parameters panel illustrated
    below. (If you are not familiar with MICF, see the
    CA MICS MICF Reference Guide.)

+---------------------------------------------------------------------------------+
|                                                                                 |
| -------------------------  Execution-Time Parameters  ------------------------- |
| Command ===>                                                  Scroll ===> PAGE  |
|                                                                                 |
| Executing CA MICS Inquiry:  ACTRCP - Generate CSV file from Financial Recap     |
|                                                                                 |
| ------------------------------------------------------------------------------  |
|   Enter range of CA MICS online file cycles or enter ARCHIVE for archive files. |
| 01                                    - _____________________________________   |
|                                                                                 |
+---------------------------------------------------------------------------------+