|
|
|
DATA SOURCE (file):
ACTLGR - Ledger File at DAYS timespan
DATA ELEMENTS USED:
COSTCTRn - User-Defined Cost Center Codes
INVCCAT - Invoice Category
LGRCPC - Ledger Computation Code
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 ACTLD1, 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 ===> CSR | | | | Executing CA MICS Inquiry: ACTLD1 - Daily Revenue Ranking | | | | ------------------------------------------------------------------------------ | | Enter the Data Base ID. (1 character) for the Data Base to be processed. | | _____________________________________ - _____________________________________ | | | | Enter the range of MICS File Cycles (e.g., 01 - 04) to be processed. | | 01 - _____________________________________ | | | | Specify the Cost Centers to be reported or blank to report all. | | _____________________________________ - _____________________________________ | | | | Specify the invoice categories to be reported or blank to report all. | | _____________________________________ - _____________________________________ | | | | Specify the computation codes to be reported or blank to report all. | | _____________________________________ - _____________________________________ | | | | | +----------------------------------------------------------------------------------+
Daily Revenue Ranking - Top 10 Charges CA FOR: December 7, YYYY INQUIRY: ACTLD1 RUN DATE: 08DECYY Amount Comp. No. Billing Inv. Cost Billed Code Items Rate Hour Cat. Center
$18,023.00 0097 3605 $5.0000 1 1200 UNK $16,769.00 0097 3354 $5.0000 15 1200 STO $13,312.00 0097 2662 $5.0000 16 1200 STO $12,360.00 0097 2472 $5.0000 15 1200 UNK $11,711.00 0097 2342 $5.0000 16 1200 UNK $9,453.00 0023 3151 $3.0000 9 1100 EJM $9,004.00 0097 1801 $5.0000 5 1200 IIS $8,896.00 0097 1779 $5.0000 16 1200 STO $8,412.00 0252 1402 $6.0000 15 1100 MFB $7,871.00 0097 1574 $5.0000 0 1200 IIS
Daily Revenue Ranking - Top 5 Charges by Invoice Category CA FOR: December 7, YYYY INQUIRY: ACTLD1 RUN DATE: 08DECYY ---------------------------------------------- Invoice Category=CENTRAL PROCESSOR(S) -----------------------------------------------
Amount Comp. No. Billing Cost Billed Code Items Rate Hour Center
$9,453.00 0023 3151 $3.0000 9 EJM $8,412.00 0252 1402 $6.0000 15 MFB $7,360.00 0023 2453 $3.0000 16 UNK $6,954.00 0023 2318 $3.0000 15 UNK $6,402.00 0252 1067 $6.0000 15 MFB
---------------------------------------------------- Invoice Category=CHANNELS -----------------------------------------------------
Amount Comp. No. Billing Cost Billed Code Items Rate Hour Center
$18,023.00 0097 3605 $5.0000 1 UNK $16,769.00 0097 3354 $5.0000 15 STO $13,312.00 0097 2662 $5.0000 16 STO $12,360.00 0097 2472 $5.0000 15 UNK $11,711.00 0097 2342 $5.0000 16 UNK
Daily Revenue Ranking - Top 5 Charges by Cost Center CA FOR: December 7, YYYY INQUIRY: ACTLD1 RUN DATE: 08DECYY
--------------------------------------------------------- Cost Center=ALF ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$1,236.00 0252 206 $6.0000 15 1100 $455.00 0097 91 $5.0000 14 1200 $450.00 0252 75 $6.0000 13 1100 $396.00 0252 66 $6.0000 18 1100 $342.00 0252 57 $6.0000 15 1100
--------------------------------------------------------- Cost Center=CPT ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$726.00 0252 121 $6.0000 19 1100 $164.00 0097 33 $5.0000 19 1200 $78.00 0252 13 $6.0000 18 1100 $32.00 0023 11 $3.0000 19 1100 $30.00 0252 5 $6.0000 23 1100
--------------------------------------------------------- Cost Center=CTO ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$4,830.00 0252 805 $6.0000 15 1100 $1,026.00 0097 205 $5.0000 15 1200 $504.00 0252 84 $6.0000 14 1100 $204.00 0097 41 $5.0000 14 1200 $157.00 0023 52 $3.0000 15 1100
--------------------------------------------------------- Cost Center=CTS ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$36.00 0252 6 $6.0000 17 1100 $24.00 0252 4 $6.0000 20 1100 $24.00 0252 4 $6.0000 7 1100 $18.00 0252 3 $6.0000 1 1100 $18.00 0097 4 $5.0000 20 1200
Daily Revenue Ranking - Top 5 Charges by Cost Center CA FOR: December 7, 2005 INQUIRY: ACTLD1 RUN DATE: 08DEC05
--------------------------------------------------------- Cost Center=EJM ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$9,453.00 0023 3151 $3.0000 9 1100 $1,254.00 0252 209 $6.0000 12 1100 $852.00 0252 142 $6.0000 10 1100 $714.00 0252 119 $6.0000 12 1100 $458.00 0097 92 $5.0000 10 1200
--------------------------------------------------------- Cost Center=FIN ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$55.00 0097 11 $5.0000 2 1200 $7.00 0023 2 $3.0000 2 1100 $6.00 0252 1 $6.0000 2 1100 $6.00 0252 1 $6.0000 2 1100 $6.00 0252 1 $6.0000 2 1100
--------------------------------------------------------- Cost Center=GIS ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$18.00 0252 3 $6.0000 23 1100 $18.00 0252 3 $6.0000 23 1100 $18.00 0252 3 $6.0000 23 1100 $2.00 0097 0 $5.0000 23 1200 $1.00 0097 0 $5.0000 23 1200
--------------------------------------------------------- Cost Center=IIS ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$9,004.00 0097 1801 $5.0000 5 1200 $7,871.00 0097 1574 $5.0000 0 1200 $6,614.00 0097 1323 $5.0000 7 1200 $3,072.00 0097 614 $5.0000 4 1200 $3,032.00 0097 606 $5.0000 7 1200
Daily Revenue Ranking - Top 5 Charges by Cost Center CA FOR: December 7, YYYY INQUIRY: ACTLD1 RUN DATE: 08DECYY
--------------------------------------------------------- Cost Center=MFB ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$8,412.00 0252 1402 $6.0000 15 1100 $6,402.00 0252 1067 $6.0000 15 1100 $2,298.00 0252 383 $6.0000 13 1100 $1,822.00 0097 364 $5.0000 0 1200 $1,500.00 0252 250 $6.0000 11 1100
--------------------------------------------------------- Cost Center=OSY ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$6,383.00 0097 1277 $5.0000 23 1200 $5,641.00 0097 1128 $5.0000 17 1200 $5,615.00 0097 1123 $5.0000 18 1200 $2,031.00 0097 406 $5.0000 23 1200 $947.00 0097 189 $5.0000 17 1200
--------------------------------------------------------- Cost Center=SPT ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$1,196.00 0097 239 $5.0000 20 1200 $992.00 0097 198 $5.0000 13 1200 $930.00 0252 155 $6.0000 9 1100 $715.00 0097 143 $5.0000 9 1200 $714.00 0252 119 $6.0000 1 1100
--------------------------------------------------------- Cost Center=STO ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$16,769.00 0097 3354 $5.0000 15 1200 $13,312.00 0097 2662 $5.0000 16 1200 $8,896.00 0097 1779 $5.0000 16 1200 $4,854.00 0097 971 $5.0000 11 1200 $2,820.00 0252 470 $6.0000 21 1100
Daily Revenue Ranking - Top 5 Charges by Cost Center CA FOR: December 7, YYYY INQUIRY: ACTLD1 RUN DATE: 08DECYY
--------------------------------------------------------- Cost Center=TST ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$72.00 0252 12 $6.0000 16 1100 $54.00 0252 9 $6.0000 15 1100 $54.00 0252 9 $6.0000 17 1100 $48.00 0252 8 $6.0000 8 1100 $45.00 0097 9 $5.0000 14 1200
--------------------------------------------------------- Cost Center=UNC ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$4,668.00 0023 1556 $3.0000 3 1100 $3,672.00 0097 734 $5.0000 1 1200 $3,299.00 0023 1099 $3.0000 9 1100 $2,377.00 0097 475 $5.0000 5 1200 $2,324.00 0097 465 $5.0000 4 1200
--------------------------------------------------------- Cost Center=UNK ----------------------------------------------------------
Amount Comp. No. Billing Inv. Billed Code Items Rate Hour Cat.
$18,023.00 0097 3605 $5.0000 1 1200 $12,360.00 0097 2472 $5.0000 15 1200 $11,711.00 0097 2342 $5.0000 16 1200 $7,360.00 0023 2453 $3.0000 16 1100 $6,954.00 0023 2318 $3.0000 15 1100
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |