Summary Data Flow
Below is a table that lists the programs from the provided documents (AR745P.ocl36.txt, AR745P.rpgle.txt, AR745.ocl36.txt, AR745.rpg36.txt, and AR745A.ocl36.txt) as rows and the tables (files) used as columns. At each intersection, a brief description indicates how the program modifies or creates/writes to the table. If a program does not interact with a specific table, the cell is marked with "-". The tables include all explicitly mentioned files and implied files (e.g., ARDETL in AR745A via queries).
| Program | ARCONT | ARCUST | GSCONT | AR745PD | ARDETL | AR745S | AREFTD | LIST | LIST1 | LIST2 | LIST3 | ?9?ARINVCR | QPQUPRFIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GSGENIEC | - | - | - | - | - | - | - | - | - | - | - | - | - |
| AR745P.ocl36.txt | Reads for validation | Reads for validation | - | - | - | - | - | - | - | - | - | - | - |
| AR745P.rpgle.txt | Chains to validate company number | Chains to validate customer and EFT flag | Chains to retrieve default company number | Reads/writes for user input and error display | - | - | - | - | - | - | - | - | - |
| #GSORT | - | - | - | - | Reads for sorting | Creates and writes sorted records | - | - | - | - | - | - | - |
| AR745.ocl36.txt | Reads for company data | Reads for customer data | - | - | Reads as input for sorting | Creates and reads as sorted input | Creates (batch mode) and reads | Writes report headers | - | - | - | - | - |
| AR745.rpg36.txt | Chains for company data and G/L codes | Chains for customer data and EFT validation | - | - | Reads sorted data (via AR745S) |
Reads as primary input | Writes EFT transaction data | Writes minimal headers | Writes detailed report headers/lines | Writes summary report | Writes detailed report | - | - |
| AR745A.ocl36.txt | - | - | - | - | Implied read via queries for credit invoices | - | - | - | - | - | - | Reads condition for credit invoices | Writes credit invoice report |
Notes on Table Interactions¶
- GSGENIEC: No explicit file interactions; likely updates system control areas (not listed as tables).
- AR745P.ocl36.txt: Reads
ARCONTandARCUSTfor validation during job setup. - AR745P.rpgle.txt: Interacts with
AR745PD(workstation display) for input/output, chains toARCONT,ARCUST, andGSCONTfor validation and default values. - #GSORT: Reads
ARDETL, creates and writes toAR745Swith sorted records. - AR745.ocl36.txt: Manages file creation (
AREFTDin batch mode), readsARDETL,AR745S,ARCUST,ARCONT, and writes toLISTfor report headers. - AR745.rpg36.txt: Reads
AR745S(sortedARDETL), chains toARCUSTandARCONT, writes toLIST,LIST1,LIST2,LIST3for reports, andAREFTDfor EFT data. - AR745A.ocl36.txt: Reads
?9?ARINVCRfor credit invoice condition, writes toQPQUPRFILfor report output, and implies access toARDETLvia queries.
Table Definitions¶
- ARCONT: Accounts receivable control file (company data, G/L codes).
- ARCUST: Customer master file (customer details, EFT flag).
- GSCONT: Control file for default company number.
- AR745PD: Workstation display file for user interaction.
- ARDETL: Accounts receivable detail file (invoices).
- AR745S: Sorted work file for EFT report data.
- AREFTD: EFT output file (bank upload) and temporary batch files.
- LIST, LIST1, LIST2, LIST3: Printer output files for reports.
- ?9?ARINVCR: Data area for credit invoice condition.
- QPQUPRFIL: Printer file for credit invoice report.
If you need further clarification, additional details on specific interactions, or inclusion of other implied files, let me know!