Skip to content

Summary Data Flow

Below is a table that lists the programs from the provided call stack (AR200.ocl36.txt, AR200P.ocl36.txt, AR200P.rpgle.txt, AR200.rpg36.txt, AR210.rpg36.txt, AR211.rpg36.txt, AR2011.ocl36.txt, AR2011.rpg36.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. Empty cells indicate the program does not interact with the table. The table is generated based on the file specifications and logic described in each program.

Program CRIEGG CRPSGG CRTRGG CRDIGG CRTGGG AR211S ARCUST ARDETL ARCONT ARHIST GLMAST TEMGEN ARDALY SA5FIND GSTABL SA5DSC REPORT REPORTP
AR200.ocl36.txt Reads transaction input Reads transaction input Creates sorted transaction file Creates GL distribution file Creates GL journal entries Creates sorted GL entries Reads customer data Reads control data Routes transaction register Routes paperless transaction register
AR200P.ocl36.txt Checks existence Checks existence Reads control data
AR200P.rpgle.txt Checks existence Checks existence Reads control data
AR200.rpg36.txt Reads transactions Writes GL distribution entries Updates balances, payment dates Updates invoice amounts, payments Reads control data, updates journal numbers Writes audit trail Writes transaction register Writes paperless transaction register
AR210.rpg36.txt Reads distribution entries Writes GL journal entries Reads control data (GL accounts)
AR211.rpg36.txt Reads GL journal entries Reads sorted GL entries Reads control data (GL accounts) Reads account descriptions Writes GL postings Writes daily AR summaries Writes sales/cash journals Writes paperless sales/cash journals
AR2011.ocl36.txt Reads transactions Reads customer data Reads control data Reads invoice line items Reads product/discount codes Reads for discount processing
AR2011.rpg36.txt Reads transactions Reads customer data Reads invoice line items Reads product/discount codes Writes product-level discount details

Notes

  • Programs: Listed in the order provided: AR200.ocl36.txt, AR200P.ocl36.txt, AR200P.rpgle.txt, AR200.rpg36.txt, AR210.rpg36.txt, AR211.rpg36.txt, AR2011.ocl36.txt, AR2011.rpg36.txt.
  • Tables: Include all files referenced across the programs: CRIEGG, CRPSGG, CRTRGG (?9?CRTRGG), CRDIGG (?9?CRDIGG), CRTGGG (?9?CRTGGG), AR211S (?9?AR211S), ARCUST (?9?ARCUST), ARDETL (?9?ARDETL), ARCONT (?9?ARCONT), ARHIST (?9?ARHIST), GLMAST (?9?GLMAST), TEMGEN (?9?TEMGEN), ARDALY (?9?ARDALY), SA5FIND (?9?SA5FIND), GSTABL (?9?GSTABL), SA5DSC (?9?SA5DSC), REPORT, REPORTP.
  • Interactions:
  • Read: File is used as input without modification (e.g., ARCONT for control data).
  • Update: File is modified in place (e.g., ARDETL invoice amounts, ARCUST balances).
  • Write: File is created or appended with new records (e.g., SA5DSC discount details).
  • Create: File is generated by the program (e.g., CRTRGG by AR200.ocl36.txt).
  • Route: Reports are sent to output queues (e.g., ARPOST, TESTOUTQ).
  • Assumptions: AR200P.ocl36.txt and AR200P.rpgle.txt do not modify files directly but facilitate initialization. AR211 does not update ARCONT (per 8/06/14 change). File labels use ?9? prefix (e.g., GG for Atrium).
---
title: Cash Receipts Programs
---
graph TD
    AR300P["`AR300P ARMENU12 <br> **Soft Deletes records in ARDETL**`"]
    AR745["AR745P Automated <br>EFT file creation<br><br>ARR17"] 
    AR135["AR135P Manual EFT <br> Create or update<br><br>ARMENU 7"]
    AR136["AR136P EFT Post Report <br> Reads EMMDDYY<br><br>ARMENU 8"] 
    AR137["AR137P Send EFT Notice to Customers <br>ARMENU 11<br><br>"]
    AR156["AR156 Create PNC Upload File <br>ARMENU 9"]
    AR157["AR157 Create Cash Receipts from EFT <br>*copies non-deleted*<br><br>ARMENU 10<br>"]
    AR050IDV[AR050 ARMENU1 <br>OPTION = INDVIDUAL <br>]
    AR050PAY[AR050 ARMENU1 <br>OPTION = PAY STATMENT<br>]    
    AR200[AR200 Cash Receipts Posting ARMENU2 <br>*Updates ARDETL invoice due amounts and payments*]

    ARDETL[(ARDETL)]
    EMMDDYY[(EMMDDYY)]
    CRIEGG[(CRIEGG)]
    AREFTD[(AREFTD)]
    AREFTS[(AREFTS)]

    ARCUST[(ARCUST)]
    TEMGEN[(TEMGEN)]
    ARHIST[(ARHIST)]
    SA5DSC[(SA5DSC)]
R1[/"EFT Post Report"\]

AR300P
ARDETL-->AR745
ARDETL-->AR135
AR745-->EMMDDYY
AR135-->EMMDDYY
EMMDDYY-->AR136
EMMDDYY-->AR137
AR137--->AREFTD
AR137--->AREFTS
EMMDDYY-->AR156
AR156-->AREFTD
AR156-->AREFTS

AR157-.->AR050IDV
AR050IDV-->CRIEGG
AR050PAY-->CRPSGG
CRIEGG-->AR200
CRPSGG-->AR200

EMMDDYY-->AR157-.->CRIEGG

AR200-->ARHIST
AR200-->TEMGEN
AR200-->ARCUST
AR200-->SA5DSC
AR200-->ARDALY
AR136-->R1
ARDALY[(ARDALY <br>**Obsolete**<br>)]