File Matching › Listing Transactions not on the Master File › Demonstration

Demonstration

Objective

This report lists transactions not on the master file. Multiple transactions are matched against a single-entry master file.

Procedure

• MB=KEEP retains a master file in the input buffer.
• A SELECT BUFFER statement selects transactions that cannot be matched with the master file.

  Note: Type 7 logic (IF M-ACCOUNT GE T-ACCOUNT DROP) can be used instead of the SELECT BUFFER statement.

The contents of the input buffer for the run (K denotes master records kept in the input buffer):

Complete Code

 col. 2
 ▼
 IN  80 MK=M-ACCOUNT MB=KEEP
 REC M-ACCOUNT     1    5           'ACCOUNT'

 IN 80 MK=T-ACCOUNT
 REC T-ACCOUNT     1     5          'ACCOUNT'
 REC T-TRANS-IND   6     1          'DEPOSIT/' 'WITHDRAWAL'
 REC T-TRANS-AMT   7    11  2 DP=2  'AMOUNT OF' 'TRANSACTION'
 REC T-DATE       18     6  2       'DATE'
 REC T-BRANCH     24     2          'BRANCH'
 REC T-NAME       26    20          'NAME'
 SEL BUFFER WHEN T-ACCOUNT GT M-ACCOUNT $Transactions without masters
 80OUT D
 80SORT T-BRANCH - T-DATE D T-ACCOUNT
 803 LISTING OF TRANSACTIONS WITHOUT MASTERS
 8051*010 T-BRANCH                HR
 8051*020 T-ACCOUNT               HR
 8051*030 T-NAME                  HR
 8051*050 T-TRANS-AMT             HR
 8051*060 T-TRANS-IND             HR
 8051*070 T-DATE  FD              HR

Result

REPORT NO. 80  LISTING OF TRANSACTIONS WITHOUT MASTERS    mm/dd/yy PAGE     1
                                                                         AMOUNT OF             DEPOSIT/
           BRANCH         ACCOUNT                 NAME                  TRANSACTION           WITHDRAWAL           DATE

             32            15060          SHARON ARMSTRONG                 100,990.11             D              mm/dd/yy
             32            15060          SHARON ARMSTRONG                     990.11             W              mm/dd/yy
             32            15060          SHARON ARMSTRONG                  10,099.01             D              mm/dd/yy


             40            31113          MARY CATREY                           36.00             W              mm/dd/yy
             40            31113          MARY CATREY                           36.00             D              mm/dd/yy


             45            36682          JEAN WREN                          4,000.78             W              mm/dd/yy

Note: The report would show actual dates in the format shown.