Previous Topic: 7.1 Accounting Journal Files (ACTJxx)Next Topic: 7.1.2 Usage Considerations


7.1.1 File Organization


 
 DETAIL.ACTJxx contains a record for each WORKUNIT (job,
 session, and so on) that was processed.  Each record contains
 all of the billing information for the WORKUNIT:
 
 o   AJFIVC (Invoice Category)
 o   AJFQNT (Quantity)
 o   AJFRAT (Rate)
 o   AJFCPC (Computation Code)
 o   AJFCHG (Amount Charged)
 
 This is accomplished by constructing five arrays (the AJFCPC,
 AJFQNT, AJFRAT, AJFIVC, and AJFCHG) containing these
 values.  The values have the same relative position in each
 array (for example, AJFQNT01 is billed at AJFRAT01 and
 referenced by AJFIVC01 and AJFCPC01).  The ACTJxx files are
 not supported in the WEEKS, MONTHS, or YEARS timespans.
 
 Figure 7-2 shows the layout of the journal files.

 +---------------------------------------+  |    |   | COSTCTR1 |                   |  | R  |   | COSTCTR2 |       COST        |  | E  |   | COSTCTR3 |      CENTER       |  | C  | S |    |     |    DEFINITION     |  | O  | O | COSTCTRn |                   |  | R  | R |----------+-------------------+  | D  | T | SYSID    | SYSTEM IDENTIFIER |  |    |   |----------+-------------------+  | H  |   | YEAR     |      COMMON       |  | E  | K | MONTH    |     DATE-TIME     |  | A  | E | DAY      |     ELEMENTS      |  | D  | Y +----------+-------------------+  | E  |   | BILLTS   | BILLING TIME STAMP|  | R  |   | ACTYEAR  | ACCOUNTING YEAR   |  |    |   | ACTMONTH | ACCOUNTING MONTH  |  |    |___| ACTDAY   | ACCOUNTING DAY    |  |    |   | WORKUNIT | TRANSACTION       |  |    |   | ENDTS    | END TIME STAMP    |  |    |   | WORKAREA | SUBSYSID & SUBTYPE|  |    |   | ZONE     | COMMON ELEMENT    |  |----|---+-----------+------------------+-------------------+  | D  | AJFIVC01 | AJFQNT01 | AJFRAT01 | AJFCPC01 | AJFCHG01 |  | A  | AJFIVC02 | AJFQNT02 | AJFRAT02 | AJFCPC02 | AJFCHG02 |  | T  | AJFIVC03 | AJFQNT03 | AJFRAT03 | AJFCPC03 | AJFCHG03 |  | A  |     |    |    |     |     |    |    |     |    |     |  |    |     |    |    |     |     |    |    |     |    |     |  | A  |     |    |    |     |     |    |    |     |    |     |  | R  |     |    |    |     |     |    |    |     |    |     |  | E  |     |    |    |     |     |    |    |     |    |     |  | A  | AJFIVCnn | AJFQNTnn | AJFRATnn | AJFCPCnn | AJFCHGnn |  +-----------------------------------------------------------+

 Figure 7-2.  Layout of Journal Files
 
 
 The following chart shows, by accounting journal file
 identifier, the default content of the WORKUNIT, WORKAREA,
 and BILLTS variables.  The values of the WORKUNIT and
 WORKAREA variables depend on the data source used for each.
 You can change these values at your site with the Journal
 File Eligibility option of the Special Requirements Menu.
 Refer to Appendix B, the Data Dictionary, for information on
 the values listed in the chart.

  +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | Accounting Journal|    WORKUNIT     |    WORKAREA     |    WORKAREA     |    WORKAREA     |     BILLTS         |   | File Name/Name of |     Value       |    Variable 1   |    Variable 1   |    Variable 2   |     Value          |   |    Source File    |                 |  Position n-n   |  Position n-n   |  Position n-n   |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJBJ / BATJOB   | JOB or          | Job Group       | JOBGRPRC (5-7)  | SUBSYSID (9-12) | RDRTS              |   |                   | TSO user ID     | Requested (1-3) |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJBP / BATPGM   | PROGRAM or      |                 |                 | SUBSYSID (9-12) | STARTTS            |   |                   | TSO User ID     |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJBS / BATSPL   | JOB             |                 |                 | SUBSYSID (9-12) | RDRTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJRN / BATREN   | JOB             |                 |                 | SUBSYSID (9-12) | RDRTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJBM / BATMUA   | PROGRAM         | MUVER (1-8)     |                 | MUPROD (9-16)   | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTP / BATATP   | ATPAPU          | ATPTYPE(1-8)    |                 | SUBSYSID (9-16) | RDRTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJCS / CICCSU   | CICSID          |                 |                 | CICSID (9-12)   | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJCA / CICCAC   | CICAPU          |                 |                 | CICSID (9-12)   | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJDS / DB2DSU   |                 |                 |                 | DB2ID (9-13)    | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJSU / IDMSUA   | IDMSID          |                 |                 | IDMSID (9-13)   | STARTTS            |   |                   |                 |                 |                 | IDMTYPE (14)    |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJSA / IDMSAC   | IDMAPU          |                 |                 | IDMSID (9-13)   | STARTTS            |   |                   |                 |                 |                 | IDMTYPE (14)    |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTU / TSOTSU   | USER            | USER (1-8)      |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTC / TSOTSC   | USER            | TSOAPU (1-16)   |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTI / TSOTSU   | USER            | TSOAPU (1-16)   |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+  

 Figure 7-3.  Contents of WORKUNIT, WORKAREA, and BILLTS Variables (Part 1 of 3)

  +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | Accounting Journal|    WORKUNIT     |    WORKAREA     |    WORKAREA     |    WORKAREA     |     BILLTS         |   | File Name /Name of|    Value        |    Variable 1   |    Variable 1   |    Variable 2   |     Value          |   | Source File       |                 |  Position n-n   |  Position n-n   |  Position n-n   |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJIS / IMSISU   | IMSID           |                 |                 | IMSID (9-12)    | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJIA / IMSIAC   | IMSAPU          |                 |                 | IMSID (9-12)    | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJIX / IMS_IS   | IMSID           |                 |                 | IMSID (9-12)    | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJCM / VMCCMU   | USER            | VMCACNT (1-8)   |                 | CMUXMODE (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJDC / VMCDAC   | USER            | VMCACNT (1-8)   |                 | DEVCLASS (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJNT / VMCNTU   | USER            | VMCACNT (1-8)   |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJVR / VMCVRA   | USER            | VMCACNT (1-8)   |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJLN / LNXLXP   | LNXLGID         |                 |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJDA / VCADAA   | SYSID           |                 |                 | DEVTYPE (9-16)  | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMS / VCADAA   | SYSID           | MGMTCLAS (1-8)  |                 | STORCLAS (9-16) | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJVS / VCA_VS   | SYSID           |                 |                 | DEVTYPE (9-16)  | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJHF / HFSDIR   | SYSID           |                 |                 | DEVTYPE (9-16)  | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMG / HSMMIG   | SYSID           | HSMLEVEL (1-8)  |                 | MGMTCLAS (9-16) | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJBC / HSBBAC   | SYSID           |                 |                 | MGMTCLAS (9-16) | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPC / DEAPRC   | DEXUSER         |                 |                 | PRCTYPE (9-16)  | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJIM / DEAIMG   | DEXUSER         |                 |                 | IMGTYPE (9-16)  | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPQ / DEAPRQ   | DEXUSER         |                 |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+  

 Figure 7-3.  Contents of WORKUNIT, WORKAREA, and BILLTS Variables  (Part 2 of 3)

  +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | Accounting Journal|    WORKUNIT     |    WORKAREA     |    WORKAREA     |    WORKAREA     |     BILLTS         |   | File Name /Name of|    Value        |    Variable 1   |    Variable 1   |    Variable 2   |     Value          |   | Source File       |                 |  Position n-n   |  Position n-n   |  Position n-n   |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJDK / DESDKU   | SYSID           |                 |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPJ / PWRPJB   | JOB             | JOBGROUP (1)    |                 |                 | RDRTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPP / PWRPPG   | PROGRAM         | PROGRAM  (1-8)  |                 | JOB (9-16)      | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPO / PWRPOA   | JOB             | FORMNUM  (1-8)  |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJPS / SNTPSU   | SLU             | PSULDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJNP / SNTNAC   | SLU             | NACLDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJNS / SNTNSS   | SLU             | NSSLDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJNA / NVSNSA   | SLU             | NSCLDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJNC / NVSNSC   | SLU             | NSCLDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJRT / NVSRTM   | SLU             | NSCLDEV (1-8)   |                 | PLU (9-16)      | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJXA / AUCAPL   | AUCAPU          | AUCOPSYS (1-8)  |                 | APPLNUMX (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJXP / AUCKPR   | AUCPROG         | AUCOPSYS (1-8)  |                 | APPLNUMX (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMA / AUMAPP   | AUMAPU          | AUMOPSYS (1-8)  |                 | MAPPNUMX (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMP / AUMKPS   | AUMPROG         | AUMOPSYS (1-8)  |                 | MAPPNUMX (9-16) | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMQ / MQAMMA   | Connection Name | MQMSSI   (1-8)  |                 | MQSATYP  (9-16) | STARTTS            |   |                   | or CICS tranid  |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJQA / MQAQAA   | Base Queue Name | MQMSSI   (1-8)  |                 | MQSATYP  (9-16) | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTA / MQATAA   | Connection Name | MQMSSI   (1-8)  |                 | MQSATYP  (9-16) | ENDTS              |   |                   | or CICS tranid  |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJMF / MQBMFA   | MQBBKID         |                 |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJWB / WLGSAL   | WEBIP           |                 |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJSF / WASSAF   | WEBIP           |                 |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJLX            | COMMAND         |                 |                 |                 | ULXBTIME           |   | (EXT JOURNAL)     |                 |                 |                 |                 | (STARTTS)          |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTD            | SYSID           |                 |                 |                 | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJTV            | SYSID           | TAPELIB  (1-8)  |                 | STORMGTC (9-16) | ENDTS              |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJWA / WEBWAA   | WEBSRVNM        |                 |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+   | ACTJWR / WEBWRA   | WEBSRVNM        |                 |                 |                 | STARTTS            |   |                   |                 |                 |                 |                 |                    |   +-------------------+-----------------+-----------------+-----------------+-----------------+--------------------+  

 Figure 7-3.  Contents of WORKUNIT, WORKAREA, and BILLTS Variables  (Part 3 of 3)