�STORE/RESTORE-HP/3000.MPEXL  
� �8�����B5152AA  C602403/16/010000�8�?fS���U� g�|/�NSFFORMJ        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS���U� i����	�NSFFORMM        QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS���U� �������NSFFORMT        QCPUB           AICS            MGR             AICS            MGR     AICS    `������?fS���U� Q����O�NSFFORMW        QCPUB           AICS            MGR             AICS            MGR     AICS    `P�����?fS���U� `�u��`DEFNSF          QCPUB           AICS            MGR             AICS            MGR     AICS    `�����?fS���U� Q�n�"`DEFKSACH        QCPUB           AICS            MGR             AICS            MGR     AICS    `0����8�(���H00000000000000000                            000000STORE  nsffo@,defn@,defk@;*v
�����������������pfS���U� g�|/� ����DISC                             1NSFFORMJ        QCPUB           AICS                            MGR     AICS    �fS5��~��5��~��5�ǀR<5�ǀR<--P�
  5�ǀR<AICS            !JOB NSFFORMJ,MGR.CU1,DATA;HIPRI                                                !COMMENT                                                                        !COMMENT  ***************************                                           !COMMENT  *** CREATE NSF NOTICES  ***                                           !COMMENT  ***************************                                           !COMMENT                                                                        !CG QCPUB                                                                       !FILE QCMACROF=NSFFORMM.QCPUB.CU1                                               !RUN QCX.QCPROGS.AICS                                                           !CG DATA                                                                        !COMMENT                                                                        !COMMENT ***************************                                            !COMMENT ***  RENAME FILES USED  ***                                            !COMMENT ***************************                                            !COMMENT                                                                        !CONTINUE                                                                       !PURGE ONSFTAG                                                                  !RENAME NSFTAG,ONSFTAG                                                          !COMMENT                                                                        !COMMENT **********************************                                     !COMMENT ***  E-MAIL: PROCESS COMPLETE  ***                                     !COMMENT **********************************                                     !ECHO SYS>CCARDS                                                                !ECHO ACCT>>CCARDS                                                              !ECHO ISDP>>CCARDS                                                              !ECHO ' '>>CCARDS                                                               !ECHO >>CCARDS                                                                  !ECHO NSF NOTICES PRINTED>>CCARDS                                               !ECHO >>CCARDS                                                                  !ECHO >>CCARDS                                                                  !ECHO >>CCARDS                                                                  !ECHO JOB NUMBER !HPJOBNUM STARTED AT !HPINTROTIME>>CCARDS                      !ECHO !HPJOBNAME FINISHED AT !HPTIMEF ON !HPDATEF.>>CCARDS                      !ECHO >>CCARDS                                                                  !ECHO NOTICES MAY BE SEALED AND MAILED NOW.>>CCARDS                             !ECHO *>>CCARDS                                                                 !RUN PSENDMAI.PGMS.SPECTRUM;LIB=P;MAXDATA=31232;NOCB;STDIN=CCARDS               !COMMENT                                                                        !TELLOP  ********************************************                           !TELLOP  ***  NSFFORMJ - OVERDRAFT & NSF NOTICES  ***                           !TELLOP  ***          HAVE FINISHED ON CU1        ***                           !TELLOP  ********************************************                           !COMMENT                                                                        !SET STDLIST=DELETE                                                             !EOJ                                                                            p��������VfS���U� i���	�	�� ����DISC                             1NSFFORMM        QCPUB           AICS                            MGR     AICS    �fS5��С�5��С�5���]5���]	��
	�����  5���]AICS            	�QCMACRO   NSFFORMM                                                                                                                                                                                                                                                 10  >**************************************                                                                                                                                                                                                                    20  >***  NSF NOTICES FOR ACH & DRAFTS  ***                                                                                                                                                                                                                    30  >**************************************                                                                                                                                                                                                                    40  >                                                                                                                                                                                                                                                          50  /LOAD NSFFORMW                                                                                                                                                                                                                                             60  !!A:D                                                                                                                                                                                                                                                      70  /PRINTDB D NSFFEES                                                                                                                                                                                                                                         80  !!E                                                                                                                                                                                                                                                        90  /PRINT E S FORMC                                                                                                                                                                                                                                       V��������r`fS���U� ����pp� ����DISC                             1NSFFORMT        QCPUB           AICS                            MGR     AICS    �fS5�łP5�łP5�Ň�H5�Ň�H��������P�!  5�Ň�HAICS            ����                 QueryCalc Reports for Credit Unions                                               written by:  Mizzou Credit Union                                                     last update:  09/14/01                                                                                                                                                 NSF NOTICES                                                   ---------------------------------------------                                                                                                                                                                                      This file contains important information on the following topics:               **********************************************************************          Report highlights                                                               Files included                                                                  Databases accessed                                                              Download instructions                                                           Restoring files to the HP3000                                                   Customizing the report for the credit union                                     Verifying databases are defined                                                 Updating the database dictionary                                                Troubleshooting common problems                                                 Limited warranty on reports                                                                                                                                                                                                                     Report highlights                                                               **********************************************************************          This report gathers information about items which are listed in an              NSF tagfile.  This information is formatted and printed out as                  notices to members.                                                                                                                                             The NSF tagfile is created from the PPOSTDFT program (ftn 31).  If              the Paid NSF module is enabled, the item status will be reported as             either PAID or RETURNed.  If ACH items are included, the company name           will be displayed.  The report assumes a single tagfile is used each            day for all runs of the program.                                                                                                                                A job has been created that can be streamed when the notices should             be printed.  This allows the notices to be printed automatically,               without input or interference from an operator.                                                                                                                                                                                                                                                                                 Files included                                                                  **********************************************************************                                                                                           1)  NSFFormW  - QueryCalc worksheet                                             2)  NSFFormM  - QueryCalc macro                                                 3)  NSFFormJ  - job which runs the macro                                        4)  DefNSF    - pseudodatabase definition file                                  5)  DefKSACH  - pseudodatabase definition file                                  6)  Readme   - this text file of instructions                                                                                                                                                                                                  Databases accessed                                                              **********************************************************************          This report uses data from the following databases:                                                                                                                     ACH            [SPECTRUM IMAGE DATABASE]                                        HISTRY         [SPECTRUM IMAGE DATABASE]                                        MEMBRS         [SPECTRUM IMAGE DATABASE]                                        MEMBRS         [SPECTRUM IMAGE DATABASE]                                        KACHBASE       [PSEUDODATABASE CREATED BY MIZZOU CREDIT UNION]                  QCNSFBASE      [PSEUDODATABASE CREATED BY MIZZOU CREDIT UNION]                  NSFFEES-PRDB   [KSAM DATABASE CREATED BY QUERYCALC]                                                                                                                                                                                     Download instructions                                                           **********************************************************************          Although downloading reports from the web site is quite simple, you             may wish to print these instructions before proceeding.  The procedure          outlined below requires the use of: (i) a relatively recent version of          the Reflection terminal emulator and (ii) either Netscape Navigator             3.0 (or greater) or Microsoft Internet Explorer 3.0 (or greater),               running on any version of Windows (3.x, 95, or NT). If you're missing           any of these pieces, the downloading procedure unfortunately will not           work.                                                                                                                                                                Step 1.                                                                         -------                                                                         Click on the desired download link. Store the self-extracting                   file anywhere you wish on your PC. Its residency on your PC                     will only be temporary. At the conclusion of the downloading                    process, after the files have been successfully transferred to                  your HP3000, this file will be deleted.                                                                                                                         Step 2.                                                                         -------                                                                         Once the file has been downloaded, double click on the newly                    downloaded file. When you press the UnZip button, the file will                 unzip itself and automatically build an AICS directory (folder)                 on the C: drive, with a subdirectory (subfolder) labeled                        Reports.                                                                                                                                                        Step 3.                                                                         -------                                                                         You will now find files in the Reports subdirectory.  The files                 include a Readme.txt file, the report and any attendant macros,                 jobs and ancillary files (see above).  These files are stored                   in Reflection's WRQ protocol (LABEL mode) and must be                           transferred back onto your HP3000 in that format. The particular                version of Reflection that was used to originally upload these                  files was 5.21. It would probably be best to use a reasonably                   similar version.                                                                                                                                                Step 4.                                                                         -------                                                                         Using Reflection, restore the files to your HP3000 using the                    procedure outlined below.                                                                                                                                       Step 5.                                                                         -------                                                                         Once the transfer is complete, follow the instructions below to                 setup the report for your credit union.                                                                                                                         Step 6.                                                                         -------                                                                         Once you are satisfied that the report is working, you may                      delete the self-extracting download file as well as the Reports                 subdirectory and its files from your PC's file directory.                                                                                                       Step 8.                                                                         -------                                                                         Congratulations on a successful download. We sincerely hope you                 will find your new QueryCalc report useful!                                                                                                                                                                                                Restoring files to the HP3000                                                   **********************************************************************           1)  Using Reflection, sign onto your HP3000 to the group and account                the files are to be stored to.  You may use any group or account                you choose.  However, the assumption is that files will be                      restored as follows:                                                                                                                                                      DATA.CU1 . . . . . . TEMPLATES                                                 QCPUB.CU1 . . . . . . JOBS                                                                . . . . . . MACROS                                                              . . . . . . WORKSHEETS                                                          . . . . . . ASCII READ FILES                                                    . . . . . . ASCII OUTPUT FILES                                                                                                               NOTES:                                                                          ------                                                                          a)  If this group does not exist, your system administrator can                     create it.  This is a handy way of keeping your QueryCalc                       reports separate from the other files on your system.  The                      capabilities that should be assigned are BA, IA and PH.                         The security should be set to Read/Any, Write/AC, Append/AC,                    Lock/AC, Execute/Any.                                                                                                                                       b)  After due consideration, MCU has adopted the following                          conventions.                                                                                                                                                    1)  We created new groups on the CU1 account for our                                QueryCalc reports.  QCPUB is one such group.  In this                           way, groups are used in the same manner that a                                  subdirectory on a PC is used - to help organize the                             files.  Further, the only thing that is stored in the                           group are QueryCalc reports and their related files.                                                                                                        2)  We have adopted a naming convention in which the last                           letter of the name indicates the type of file (e.g.                             W = Worksheet, M = Macro, J = Job).  The only exception                         to this was that we continued using Summit's convention                         of naming templates with a leading "T".                                                                                                             2)  Using Reflection, transfer the files, using LABEL mode transfer.                                                                                            3)  Once the transfer is complete, you may delete the files and                     directories from your PC hard drive.                                                                                                                                                                                                       Customizing the report for the credit union                                     **********************************************************************          The following steps should be taken to insure the report runs on your           system.                                                                                                                                                          1)  Modify the job (NSFFORMJ).  These steps can be ignored if the                   files were restored to QCPUB.CU1.                                                                                                                               a)  Speak to the DP supervisor.  They may need to do this for                       you.  You will require access to an MPE ":" prompt, access                      to the group.account where the files were stored and access                     to an editor such as QUAD.                                                                                                                                  b)  Change line 7 to logon to the group and account where the                       files were restored.                                                                                                                                        c)  Change the macro line to read the macro from the group and                      account where the files were restored.                                                                                                                      d)  Change line 23 - 25 to logon to valid email addresses, or,                      remove lines 20 - 38.                                                                                                                                       e)  Add any password formatting your system may require.                                                                                                    2)  Modify the WORKSHEET (NSFFORMW).                                                                                                                                a)  Load the worksheet.  In QueryCalc, type                                                /LOAD NSFFORMW                                                                                                                                       b)  Change the credit union name.                                                       /S&R "MIZZOU CREDIT UNION" "MY CREDIT UNION NAME" ALL                                                                                                   c)  Change the printer to the name of your postscript printer                              /PRINTER MYPRINTER                                                                                                                                   d)  Page A:                                                                                                                                                        1)  AD44:  Change the NSF Fee amount to your institution's                          fee.                                                                                                                                                        2)  AD30:  Change the contact name to the appropriate person.                                                                                                   3)  AD31:  Change the contact phone to the appropriate number.                                                                                               e)  Page B:  Change the address to your institution's return                                 mail address.                                                                                                                                      f)  Page C:  This is the NSF form.                                                                                                                                 1)  CD23:  Change the logo to your insititution's logo, or                          delete the logo.                                                                                                                                            2)  CB47:  Change the logo to your insititution's logo, or                          delete the logo.                                                                                                                                         g)  Page D:  This page creates the KSAM database (nsffees-prdb)                              that is used to generate the notices.                                                                                                              h)  Page E:  This is the actual notices.                                                                                                                           1)  EA24:  Change the message to whatever you want printed                          on your forms.  In the example provided, it is the web                          address for the institution.                                                                                                                             i)  Save the worksheet.                                                                    /SAVE NSFFORMW                                                                                                                                                                                                                                                                                                                                                                                  Verifying the databases are defined                                             **********************************************************************          Unless you have used the database(s) above in other reports, it would           be prudent to verify they have been defined in your QueryCalc                   dictionary.  The process only takes a few minutes and could save you            some trouble-shooting later.  You can verify the databases are                  defined by attempting to open each of them from within QueryCalc.                                                                                                1)  Get into QueryCalc.  From a MPE prompt, type:                                             RUN QCX.QCPROGS.AICS                                                                                                                              2)  Once a blank worksheet has been loaded, type:                                             @OPENDB databasename/password.                                                                                                                        NOTE:  Most SPECTRUM image databases use "LOOKUP" as the                               password, while HP, QueryCalc and CFO module databases                          use "READER" as the password.  Pseudodatabases can use                          any password assigned by the creator.  Try "LOOKUP" and                         "READER" if you receive a password error.                                                                                                            3)  If the database exists, it will be opened.  If it does not exist,               you will receive the following error message, in which case you                 will need to add the database to your QueryCalc dictionary.                                                                                                     The database DATABASENAME isn't registered in QueryCalc's                       dictionary.                                                                                                                                                                                                                                Updating the database dictionary                                                **********************************************************************          If a needed database does not exist, you will need to add it to the             QueryCalc database dictionary.  The procedure varies only slightly,             depending on the type of database to be added.                                                                                                                                                                                                  Adding an IMAGE database                                                        ------------------------                                                        Most SPECTRUM databases and CFO module databases are IMAGE databases.                                                                                            1)  From a MPE prompt, type:  RUN ADDIMAGE.AICS.QCPROGS;PARM=1234               2)  Type:  A   (to add)                                                         3)  Enter the fully qualified database name.  (e.g. MEMBRS.DATA.CU1)            4)  Enter the password.  (e.g. LOOKUP)                                          5)  Type:  E   (to exit)                                                        6)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                                                                                                 Adding a copy of an IMAGE database                                              ----------------------------------                                              You may want to run reports against a copy of a database.  The most             common example is a copy of the MEMBRS database, created at month-end           after dividends are posted.  This database is typically stored on               REPORT.CU1.                                                                                                                                                      1)  From a MPE prompt, type:  RUN ADDIMAGE.AICS.QCPROGS;PARM=1234               2)  Type:  A   (to add)                                                         3)  Enter the fully qualified database name. (e.g. MEMBRS.REPORT.CU1)           4)  Enter the password.  (e.g. LOOKUP)                                          5)  Enter the database synonym (1-16 chars):  (e.g. REPORT)                     6)  Type:  E   (to exit)                                                        7)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                                                                                                 Adding a QueryCalc KSAM database                                                --------------------------------                                                A database denoted above with [KSAM database created by QueryCalc] was          created and opened by QueryCalc.  These databases are created by                simply calculating a report and printing the results of a detail list           report or a storelist into a database via the /PRINTDB command.  You            do not need to do anything, since the macro which automatically                 calculates this report will build the database(s) for you.  For more            information on these databases, see QUERYCALC, ADDITIONAL DOCUMENTS.                                                                                                                                                                            Adding a pseudodatabase                                                         -----------------------                                                         A database denoted above as [Pseudodatabase . . .] allows you to                "read" a file on the HP3000 as if it were a database.  Many times,              this is simply a flat, ASCII file.  Two files are required in order             to define a pseudodatabase of this type.  The first, is the file to             be read.  The second, is a schema file that "maps" the file for the             dictionary.  For example, it might indicate that the first 20                   characters are for the name, the second 20 for the address, etc.  If            a pseudodatabase is required for this report, both of the required              files have been included in the files downloaded.                                                                                                               The process for adding the database to your dictionary is, once again,          straightforward and simple.                                                                                                                                      1)  From a MPE prompt, type:  RUN ADDKSAM.AICS.QCPROGS;PARM=1234                2)  Type:  A   (to add)                                                         3)  Database schema file:  (e.g. DEFTSTDB.QCPUB.CU1)                            4)  Enter the password.  (e.g. LOOKUP)                                          5)  Type:  E   (to exit)                                                        6)  Verify the database has been added to your dictionary by                        following the steps above.                                                                                                                                 For additional information on creating and using pseudodatabases, see           QUERYCALC, ADDITIONAL DOCUMENTS.                                                                                                                                                                                                                Troubleshooting Common Problems                                                 **********************************************************************          Q: "When I try to modify the macro, I receive an error message stating              that the macro does not exist."                                             ----------------------------------------------------------------------          A:  You must be signed on to the group and account where the macro was              stored.  Some logon scripts sign you on to specific groups and                  accounts.  If this is not the same group and account where the                  macro was stored, you won't be able to modify it.  You will need                to sign off and then sign back on to the correct group and account                                                                                              Be careful qualifying the macro and then modifying it.  For                     example, you could be logged on to DATA.CU1 and type                              /PROG MYMACRO.QCPUB.CU1                                                                                                                                       The macro would be displayed.  You could make changes to it.                    However, the macro would be r`�fS���U� ����p������saved back to the group and account                 where you are signed on, not the original group and account.  In                the above example, the changed macro would be saved to DATA.CU1.                                                                                                                                                                            Q: "I receive an error message stating that a dataset does not exist                in a database.  However, I am sure the dataset does exist in this               database."                                                                  ----------------------------------------------------------------------          A:  First, verify the database exists in your database dictionary.                  You can do this quickly by closing the database and then                        re-opening it.  If you receive an error telling you that the                    database isn't registered in QueryCalc's dictionary, follow the                 steps listed above to add this database to your dictionary.                                                                                                     If the database is in your dictionary, it may be that the                       database has been modified since the dictionary was last updated.               This typically occurs when a SPECTRUM release is loaded to your                 system. In this case, delete the database from your dictionary                  and then add it back in, following the steps listed above.                                                                                                                                                                                  Q: "I have transferred all of the files to the HP3000.  However, when               I look in the QueryCalc catalog, the report does not show up."              ----------------------------------------------------------------------          A:  Relax.  The file is on your HP3000.  It will not show in the                    QueryCalc catalog until you retrieve and save the file.  To                     retrieve the file, type                                                                /LOAD filename                                                                                                                                           To save the file, type                                                                 /SAVE                                                                                                                                                    Now use the /CAT command and your report will be listed.                                                                                                                                                                                        For macros, type                                                                       /PROG filename                                                                                                                                           To save the file, type                                                                 K filename                                                                                                                                               Now use the /CAT command and your macro will be listed.                                                                                                                                                                                                                                                                     Limited Warranty on Reports                                                     **********************************************************************          *  The reports are distributed "AS IS".  No warranties are made or                 provided by any parties.                                                                                                                                     *  The reports are copyrighted.  Sale or redistribution of the                     reports is strictly prohibited.                                                                                                                              *  The download and/or use of these reports indicates acceptance of                the terms set forth.                                                                                                                                         ���������RfS���U� Q���O�O�� ����DISC                             1NSFFORMW        QCPUB           AICS                            MGR     AICS    �fS5�ó�i5�ó�i5�ù'p5�ù'pO�P(('O���RR5�ù'pAICS            O�O�- V2.00 5 168  200109132001091315:13 9T � %MIZZOU CREDIT UNION �d38 T � %Create NSF Notices �d>��$ � %"As Of: "+DAT$6(SYSDATE) �
dAs Of: 09/04/01`5�z$ � %E8+" - Page A" �dFNSFFORMW.QCACCT.CU1 - Page A-;�t$ � %"RUN TIME: "+HRS$(12) �d$�$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�RUN TIME: 4:24 PM-�T � %FILENAME: �7�T � %NSFFORMW.QCACCT.CU1 �0�T � %CREATED BY: �0�T � %Kevin Spene �0�T � %MACRO NAME: �7�T � %NSFFORMM.QCACCT.CU1 �;1�T � %MODIFIED BY: �d$�$�$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�;�T � %Rob Perkins (9/13/00) � .�T � %JOB NAME: �5�T � %TNOTICE1.DATA.CU1 � ;<T � %Recovery Instructions: �TVT � '1. From an mpe prompt: copy onsftag,nsftag �7pT � '2. /LOAD NSFFORMW �IED BY: �d$�$�$R6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�5�T � '3. /REP b46>d46 �A�T � '4. @OPENDB QCNSFBASE/LOOKUP �k�T � '5. Change d46 from text label to equation (replace ' with @) {TZ�T � '6. Update account numbers to the ones you want �-�T � '7. /SAVE �IED BY: �d$�$�R6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�7T � '8. /EXEC NSFFORMM �5&T � '9. /REP b45>d46 �Ul@T � &10. Change d46 from text label to equation (replace ' with @) {.ZT � &11. /SAVE �.�T � %DATABASES: �*�T � %HISTRY �*�T � %MEMBRS �$�$�$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�'T � %ACH �N,+T � %KACHBASE �-ET � %QCNSFBASE �0_T � %NSFFEES-PRDB �#�  � �.1�T � %SCRATCH DATA �dT)�T � %VALUE �*/�T � %DESCRIPTION � � %MEMBRS �$�$�$�"6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�2��$FU� � %DAT$2(SYSDATE) �200109040IT � 'Report Date �)bN@� �B %15.00 �4cT � 'NSF Fee Amount �pzT � %using qcnsfbase.nsftype, store in !a account when account<>"";type=I2 uO��R@@ �B %using sets, define !c as 75,91;type=i1 ��$�$�$R"6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�@}T � '!C = Commands to include ���T � %using qcnsfbase.nsftype, store in !a account when account=" 40085"," 64793";type=I2 gp�jRA΀ �B %using qcnsfbase.nsftype, store in !a account when account<>"";type=I2 uH�T � '!A = Accounts with NSF Activity �75,91;type=i1 ��$�$�$R"6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�#�  �B �C.T � %PAGE DATA �d(LT � %PAGE �,MT � %CONTENTS �%�T � %A �+�T � 'Scratch �a%�T � %B �0�T � 'MCU Address �%�T � %C � �$�$�$�$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�6�T � 'Form: NSF Notice �%�T � %D �0�T � 'NSFFEES-PRDB �%�T � %E �D�T � 'Detail List: NSF Transactions �6T � %First & Broadway �#d3T � %P.O. Box 1795 �#d � %C � �$�$�$�$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�=5T � %Columbia, MO 65205-1795 �#dTZ8T � %THE FOLLOWING ACTIVITY OCCURRED ON YOUR ACCOUNT. �!dHRT � %PLEASE NOTE THE CURRENT BALANCE. �!d/�T � %Transaction �+�T � %Account �(�T � %Fees � � %C � �$�$�$Q$�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�+�T � %Current �6(�T � %Date �*�T � %Number �,�T � %Assessed �+�T � %Balance �/	T � %Transaction �/T � %NSF NOTICE �(
(
T � %Item � � %C � �$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�)T � %Draft �+T � %Company �*#T � %Amount �*'T � %Status �*+T � %Number �//T � %Description �/T � %NSF NOTICE �(
(
T � %Item � � %C � �$�$�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2����R@ * �A %using histry.sh-history, find when entry-date=[{AD43}] and account=!a and command=!c and description=@NSF FEE@ and description <> ATM@ 4C��RC�w * � %rereading, val of account �%+T � %ACCOUNT �B��RA� * � %rereading, val of suffix � � %C � �$�$�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�*6T � %SUFFIX �E��R� * �A %rereading, val of amount-sh �mG��Q * � %rereading, val of description �CNSF FEE FOR # 1492D�}RC� * � %rereading, val of sequence �,�T � %SEQUENCE �G�cQ * � %rereading, val of teller-intl �60K4$�$�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�G�IRB�@ * � %rereading, val of voucher-num � F�/RB�� * � %rereading, val of balance-sh ���Q � %using histry.sh-history, val of description when entry-date=[{AD43}] and account=[a2] and suffix=[a3] and sequence=[A6] and balance-sh>[a9] and voucher-num=[a8] SHARE DRAFT # 1492of teller-intl �60K4$�"�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�E��R�]� * �A %rereading, val of amount-sh ����R�]� �A %using histry.sh-history, val of amount-sh when entry-date=[{AD43}] and account=[A2] and suffix=[A3] and sequence=[A6] and trace-num<>"" and voucher-num=[A8] u��RB�� �A %using membrs.share-file, val of balance when account=[a2] and suffix=[a3] q60K4$�"�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2����Q � %using ach.posting-file, val of batch-id when account=[a2] and suffix=[a3] and posting-date=[AD43] and description=[$A10] BG��R * � %rereading, val of return-date �-F�yR * � %rereading, val of record-key �membrs.share-file, val of balance when account=[a2] and suffix=[a3] q60K4$�"�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�h�_Q � %using kachbase.ksachba, val of company-id when batch-id=[$A14] |d�EQ � %using ach.company-id, val of comp-name when comp-id=[$A17] �f�+Q � %using ach.record-file, val of record when \record-key\=[A16] ~*�N�� �A %A4/100 �'�T � %FEE �60K4$�$�R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�0��$ � %SUB$(A5,1,4) �NSF a0��$ � %SUB$(A7,3,3) �K�($T � %INTL �P��$ � %IF$($A22=$"B",IF$(A15=0,"PAID","RETURN"),"") �E��$ � %IF$($A21=$"PAID","PAID","RETURN") �RETURN:��$ � %IF$($A22=$"B",A23,A24) �RETURN � %FEE �60K4$�$�$R"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�*rT � %STATUS �+�uNAN������ �A %A13/100 �$+�T � %BALANCE �A�[N�� �A %(A12+IF($A22=$"K",0,A11))/100 �,*�T � %AMOUNT �?�A$ � %IF$($A22=$"B",NAM$(A18),"") ��+�T � %COMPANY �)RETURN � %FEE �60K4$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�3�'$ � %SUB$(A19,40,46) �9�
$B�@ � %IF$($A22=$"B",A29,A8) �1492)�T � %DRAFT �p��RA΀ * �A %using membrs.member-file, find when account=!a and zip<>100,1000000 wC��RD� * � %rereading, val of account �+T � %ACCOUNT �60K4$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�&T � %2A �@��Q * � %rereading, val of name �PEAKE/DEBRA LI��Q * � %rereading, val of address-lines � 511 STALCUP DR@��Q * � %rereading, val of city �COLUMBIA(jT � %CITY �A�}Q * � %rereading, val of state �MO60K4$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�)�T � %STATE �@?�cRC�Y� * � %rereading, val of zip �E'�T � %ZIP � &�T � %1A �o�I$GM�`` � %IF$(A7<10000,RJS$("00000"+A7+"0000",9),IF$(A7<100000,RJS$(A7+"0000",9),A7)) o	652030000IJ�/$GM�`` � %IF$(A8<100000000,RJS$("0000"+A8,9),A8) �	65203000060K4$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�b�R�x �A %using nsffees-prdb.nsffees, sum of fee when account=[a2] �(�T � %FEES �C��R�I\(� * �A %rereading, val of balance �+T � %BALANCE �0/��$ � %DAT$6(AD43) �	09/04/01, T � %TRAN DT �JS$("0000"+A8,9),A8) �	65203000060K4$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�]��R@� * �A %using nsffees-prdb.nsffees, find when account=[a2] �B��R�b\(�� * �A %rereading, val of amount �*TT � %AMOUNT �B��Q * � %rereading, val of status �RETURN*nT � %STATUS �A�yQB�P * � %rereading, val of draft �	104500060K4$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�)�T � %DRAFT �fC�_Q * � %rereading, val of company �+�T � %COMPANY �/�EN@� �A %POS(A3,"/") �BK�+$ � %SUB$(A3,A18+1,30)+" "+SUB$(A3,1,A18-1) �TDEBRA L PEAKE-�$ � %NAM$(A19) �Debra L Peake (�T � %NAME �$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�,��$ � %NAM$(A4) �511 Stalcup Dr(
T � %ADDR �X��$ � %NAM$(A5)+", "+A6+" "+SUB$(A9,1,5)+"-"+SUB$(A9,6,9) �Columbia, MO 65203-0000'$T � %CSZ � &��$GM�`` � %A8 �5d	652030000*>T � %POSTAL �&?T � %1A �NAME �$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�[W$ � %"You may review your account at www.mizzoucu.com" �#d%5You may review your account at www.mizzoucu.com (XT � %MSG1 �#d&ZNAd � %50 �,O 
 ,BXSA2K?2dd �;O 
 ,XC D2KT%

�� �-O 
 ,BX C%
H/Pd �1A �NAME �$�$�$Q"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�;O 
 ,XC B/2
D2:]dd� �t-5O 
 ,BX C%
H'Pd �w;7O 
 ,GB D/K[MH<d< �-OO 
 ,BX C'
H)Pd �0;QO 
 ,LN DF2d �O-iO 
 ,LN D6H62d �;kO 
 ,LN L2N<d �NAME �$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�-�O 
 ,BX C2
H=Pd �;�O 
 ,LN H
J
dd �w-�O 
 ,BX C4
H6Pd �;�O 
 ,LN O
2R
dd �0;�O 
 ,LN D'ZD/Zd �O;�O 
 ,LN OdRdd �;�O 
 ,LN D6ZD=Zd �$�$�$�"�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�;�O 
 ,LN L
2N
<d �;�O 
 ,BX C2
H4Pd �;�O 
 ,LN HJdd �;O 
 ,LN D
F
2d �d$$$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�$�$�$�$�$�$�$�$�$�6�6�6�6�6�6�6�6�6�2�	
	6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6R6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6R6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6R	^EOUDQFS^�@
<<��6�6�4�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6R<HISTRY.DATA.CU1              IM)+*%.(�HISTRY            <MEMBRS.DATA.CU1              IM)+*%.(�MEMBRS            <ACH.DATA.CU1                 IM)+*%.(�ACH               <KSACHBA.DATA.CU1             KSS0		,KACHBASE          <NSFFEES.QCACCT.CU1           KS.7*EMLNSFFEES-PRDB      <SDRETAD2.DATA.CU1            MP:)&����QCNSFBASE         QCREPRTD    10  GROUP 1	    20  H$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6R�    30  H,"ACCOUNT",-8;"SUFFIX",-18;"SEQUENCE",-28;"DRAFT",-38;"FEE",-48;"INTL",51;"STATUS",59;"BALANCE",-74;"AMOUNT",-89;"COMPANY",95	    40  H r    50  D,ACCOUNT,-8;SUFFIX,-18;SEQUENCE,-28;DRAFT,-38;FEE,-48;INTL,51;STATUS,59;BALANCE,-74;AMOUNT,-89;COMPANY,95    90  ENDGROUPQCREPRTE    10  GROUP 1     20  D,SKIPTO 86    30  D,TRAN DT,-21;ACCOUNT,-36;FEES,-53;BALANCE,-68    40  D,SKIPTO 13	    20  H$�$�$�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6R    50  GROUP 2U3    60  D,AMOUNT,-21;STATUS,33;DRAFT,-52;COMPANY,59-    70  F,SKIPTO 38;MSG1,22A    80  F,SKIPTO 55;    90  F,NAME,400   100  F,ADDR,40O   110  F,CSZ,40   120  F,POSTAL,408   130  ENDGROUP   140  ENDGROUP
^EODLTMPS^^EOQ$^#vsdw8H{#8YFZ^
Fv
2
_dT,-36;FEES,-53;BALANCE,-68    40  D,SKIPTO 13	    20  H$�$�$�4�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6R�sd 3017 is br01                                                                                                                                                                                                  3017                                        Q$^#vsdw8H{#8YFZ^
Fv
2
_dT,-36;FEES,-53;BALANCE,-68    40  D,SKIPTO 13	    20  H"$�$�4�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6�6[6�6�6�6�6�6RR���������fS���U� `�u�``� ����DISC                             1DEFNSF          QCPUB           AICS                            MGR     AICS    �fS5��e"�5��e"�5��f>�5��f>�``P�  5��f>�AICS            ``MPE-DATABASE QCNSFBASE                                                                                                                                          PASSWORDS:                                                                        LOOKUP 0                                                                                                                                                      FILE NSFTAG.DATA.CU1                                                            DATASET NSFTYPE                                                                 ITEMS:                                                                            STATUS                X7                                                        ACCOUNT               X6                                                        SUFFIX                X2                                                      END                                                                                                                                                             END                                                                             ���������$�fS���U� Q�n"`"`� ����DISC                             1DEFKSACH        QCPUB           AICS                            MGR     AICS    �fS5��G��5��G��5��I��5��I��"`0nn$"`P�
  5��I��AICS            "`"`KSAM-DATABASE KACHBASE                                                                                                                                          PASSWORDS:                                                                        LOOKUP 0                                                                                                                                                      FILE KSACHBA.DATA.CU1                                                           DATASET KSACHBA                                                                 ITEMS:                                                                            BATCH-ID           U6    KEY                                                    ORIGIN             U2                                                           ACH-STATUS         I1                                                           COMPANY-ID         U10   KEY                                                    ENTRY-DESC         U10                                                          ENTRY-CLASS        U3                                                           DFI-IDENT          U9                                                           ACH-IDENT          U9                                                           SERVICE-CLASS      U3                                                           COMPANY-NAME       U16                                                          DISC-DATA          U20                                                          DATE-OPTION        U2                                                           SUB-CODE-POS       I1                                                           SUB-CODE-LEN       I1                                                           DETAIL-ID          U6                                                           ACCT-XREF          U8                                                           GROUP              I1                                                           POST-REST-FLAG     U1                                                           BALANCE-LIM        U1                                                           POST-GL            I2                                                           EXC-GL             I2                                                           HOLD-DESC          U40                                                          HOLD-CMND          U4                                                           TAG-FILE           U8                                                           PYRL-MERGE         U1                                                           PYRL-RPT           U1                                                           USE-ACCT-BRANCH    U1                                                           TRAN-LOCATION      I1                                                           FEE-GL             I2                                                           FEE-EXC-GL         I2                                                           DENIAL-CODE        U2                                                           FILLER             U46                                                        END                                                                                                                                                                                                                                             FILE KSACHCH.DATA.CU1                                                           DATASET KSACHCH                                                                 ITEMS:                                                                            DETAIL-ID          U6    KEY                                                    FIELD-POS          I1                                                           FIELD-LEN          I1                                                           OLD-VALUE          U20                                                          NEW-VALUE          U20                                                        END                                                                                                                                                                                                                                             FILE KSACHDE.DATA.CU1                                                           DATASET KSACHDE                                                                 ITEMS:                                                                            DETAIL-ID          U6    KEY                                                    ACH-TRAN-CODE      U2                                                           SUB-TRAN-CODE      U2                                                           SURNAME-OPT        I1                                                           ACCT-OPTION        U8                                                           ACCOUNT-POS        I1                                                           ACCOUNT-LEN        I1                                                           SUFFIX-POS         I1                                                           SUFFIX-LEN         I1                                                           CHECK-POS          I1                                                           CHECK-LEN          I1                                                           ATM-SFX-FLD        I1                                                           ATM-CARD-NUM       U2                                                           ATM-CARD-POS       I1                                                           ATM-CARD-LEN       I1                                                           DRAFT-ACCT-POS     I1                                                           DRAFT-ACCT-LEN     I1                                                           ACCT-MULT          I1                                                           ACCT-ADJ           I2                                                           ACCT-BASE          I1                                                           SUFFIX-MULT        I1                                                           SUFFIX-ADJ         I1                                                           POST-CODE          U2                                                           SIGN               U4                                                           COMMAND-CODE       U4                                                           TYPE-CODE          U2                                                           TRAN-DESC          U56                                                          DESC-POS           I1                                                           DESC-LEN           I1                                                           DESC-KEY-POS       I1                                                           DESC-KEY-LEN       I1                                                           PRINT-OPTION       U2                                                           TRACE-POS          I1                                                           TRACE-LEN          I1                                                           SPEC1-POS          I1                                                           SPEC1-LEN          I1                                                           SPEC2-POS          I1                                                           SPEC2-LEN          I1                                                           SPEC3-POS          I1                                                           SPEC3-LEN          I1                                                           SUB-CODE-POS       I1                                                           SUB-CODE-LEN       I1                                                           NET-POS            I1                                                           NET-LEN            I1                                                           DENIAL-POS         I1                                                           DENIAL-LEN         I1                                                           FEE-CODE           U2                                                           DESC-KEY-FLAG      U2                                                           FILLER             17I1                                                       END                                                                                                                                                                                                                                             END                                                                             $������������������������STORE/RESTORE-HP/3000.MPEXL  
� �8�����B5152AA  C602403/16/010000�������������������������