Below is a table that lists the programs in the EFT cash receipts batch file creation suite as rows and the tables/files used as columns. At each intersection, a brief description indicates how the program interacts with the table (e.g., reading, modifying, creating, or writing). The programs and files are derived from the provided documents: AR157P.ocl36, AR157P.rpgle, AR157.ocl36, AR157A.ocl36, and AR157A.rpg36. Programs that do not explicitly use tables (GSGENIEC, GSY2K) are included for completeness but show no interactions.
Program and Table Interaction Matrix¶
| Program | ARCONT | GSCONT | AR157PFM | CRTRAN (?9?E?L'110,6'?) | ?9?CRIEGG |
|---|---|---|---|---|---|
| GSGENIEC | - | - | - | - | - |
| GSY2K | - | - | - | - | - |
| AR157P.ocl36 | Reads to validate company number (?9?ARCONT). |
- | - | - | Checks existence and deletes if KYDELT = 'Y' (DATAF1). |
| AR157P.rpgle | Reads to validate KYCO. |
Reads to retrieve default company number (GXCONO). |
Reads user inputs (KYCO, KYUPDT); writes error messages. |
- | - |
| AR135TC | - | - | - | Checks existence of file ('GE' + KYUPDT). |
- |
| AR157.ocl36 | - | - | - | Reads non-deleted records; deletes file after copy. | Creates or replaces with non-deleted records from CRTRAN. |
| AR157A.ocl36 | - | - | - | Opens for shared access to allow updates. | - |
| AR157A.rpg36 | - | - | - | Reads and updates fields (e.g., KYUPDT at position 37). |
- |
Notes¶
- File Naming:
?9?is a placeholder for the company code (e.g.,CO123).?L'110,6'?represents the bank upload date (KYUPDT, e.g.,202311).- Example:
CRTRANresolves toQS36F/CO123E202311,?9?CRIEGGtoQS36F/CO123CRIEGG. - Interactions:
- Reads: Accessing file data for validation or retrieval.
- Writes: Updating file content or displaying data (e.g., error messages on
AR157PFM). - Creates/Replaces: Generating or overwriting a file (e.g.,
?9?CRIEGG). - Deletes: Removing a file (e.g.,
CRTRANor?9?CRIEGG). - Missing Logic:
AR157A.rpg36lacks calculation specs, so updates are inferred (e.g.,KYUPDT). - No Interaction: Programs
GSGENIECandGSY2Khave no explicit file interactions in the provided code.