Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARAPPLIED


                             ARAPPLIED FILE

                             AR Application

The AR Application file contains cash application records which serve as
linking or audit records for each application made. Applications originate
from one of four sources. The four sources are; applications made with
payments, applications made with credit memos, "adjustments" (partial or full
write-offs and full chargebacks), or applications that have transferred
liability from an open item to a bill of exchange.

REFERENCED BY

AR150     AR161     AR191     AR194     AR196     AR230
AR232     AR235     AR250     AR251     AR252     AR253
AR255     AR256     AR274     AR275     AR286     AR287
AR36.1    AR36.2    AR53.1    AR80.2    AR80.1    AR82.1
DT170     DT180     DT181     GL235     AR29.1    AR29.2
AR223     DT155     AR199     AR233     AR50.1

UPDATED BY

AR115     AR124     AR129     AR130     AR131     AR132
AR135     AR137     AR180     AR190     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR30.1    AR30.2    AR30.3
AR30.4    AR30.8    AR300     AR31.5    AR31.6    AR35.1
AR35.2    AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR48.3    AR502     AR504     AR560
AR570     AR575     AR580     AR700     CB06.2    CB191
DT150     DT45.1    DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARA-COMPANY            Numeric 4                                 AR129   AR130
Element: Company       The company number represents an          AR131   AR135
                       established company and is entered on     AR180   AR30.1
                       all function codes.                       AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-TRANS-TYPE         Alpha 1                                   AR129   AR130
Element: Transaction TyThe type of transaction referenced by     AR131   AR135
                       this application. Valid values are:       AR180   AR30.1
                                                                 AR30.2  AR30.3
                       C = Credit memo                           AR30.4  AR30.8
                       D = Debit memo                            AR31.5  AR31.6
                       I = Invoice                               AR35.1  AR35.2
                       P = Payment                               AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-INVOICE            Alpha 22                                  AR129   AR130
Element: Invoice NumberUsed to identify the invoice.             AR131   AR135
                                                                 AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-PAYMENT-SEQ        Numeric 6                                 AR129   AR130
Element: Payment Sequence                                        AR131   AR135
                                                                 AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-BATCH-NBR          Numeric 6                                 AR129   AR130
Element: Batch Number  This identifies the batch the entered     AR131   AR135
                       invoices, debit memos, credit memos, or   AR180   AR30.1
                       payments are a part of.                   AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR504
                                                                 AR560   DT150
                                                                 DT45.1

ARA-APP-SEQ            Numeric 5                                 AR129   AR130
Element: Application SeThe number of applications made to a      AR131   AR135
                       specific transaction.                     AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-STATUS             Numeric 1                                 AR115   AR124
Element: Status        Represents the processing position        AR129   AR130
                       within the posting cycle. For example,    AR131   AR132
                       if the application was made during the    AR135   AR180
                       entry and application of cash in AR30     AR190   AR20.1
                       (Cash Entry and Application), the status  AR21.1  AR21.2
                       will be 0. When that batch of cash is     AR21.3  AR24.1
                       released, the status will be changed      AR30.1  AR30.2
                       depending on the following set of rules:  AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                       If an application is made by other than   AR31.6  AR35.2
                       the entry and apply method, or when the   AR42.1  AR42.2
                       cash batch is released, the status will   AR42.6  AR42.7
                       be set to 2 if the debit company          AR43.1  AR44.3
                       requires an audit of applications (Yes    AR48.3  AR502
                       selected in the Review Applications       AR504   AR560
                       field in AR01.2). The status will be set  AR570   AR575
                       to a 4 if the debit company does not      AR580   CB191
                       require an audit of applications (No      DT150   DT45.1
                       selected in the Review Applications       DT92.1
                       field in AR01.2). Valid values are:

                       0 = Unreleased
                       2 = Requires audit listing
                       4 = Available for posting
                       5 = Posted

ARA-APPLD-AMT          Signed 15.2                               AR129   AR130
Element: Applied AmountThe amount applied to the transaction     AR131   AR135
                       by this payment or credit memo.           AR180   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-ADJ-AMT            Signed 15.2                               AR129   AR130
Element: Adjustment AmoThe total amount of adjustments made      AR131   AR135
                       with this application.                    AR180   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR44.3
                                                                 AR48.3  AR504
                                                                 DT45.1

ARA-ADJ-SEQ            Numeric 3                                 AR129   AR130
Element: Adjustment SeqThe last adjustment sequence number for   AR131   AR135
                       this application record.                  AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR44.3  AR48.3
                                                                 AR504   DT45.1

ARA-CR-COMPANY         Numeric 4                                 AR129   AR130
Payment Transaction    The company number associated with the    AR131   AR135
Company                applied payment or credit memo.           AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-CUSTOMER        Alpha 9  (Right Justified)                AR129   AR130
Payment Transaction    The customer number associated with the   AR131   AR135
Customer               applied payment or credit memo.           AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-BATCH           Numeric 6                                 AR129   AR130
Element: Cash Batch NumThe cash batch number associated with     AR131   AR135
                       the applied payment or credit memo.       AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR504
                                                                 AR560   DT150
                                                                 DT45.1

ARA-CR-PYMNT-SEQ       Numeric 6                                 AR129   AR130
Element: Payment SequenThe sequence number of the payment        AR131   AR135
                       within the cash batch. This field will    AR180   AR30.1
                       be 0 if the application was from a        AR30.2  AR30.3
                       credit memo or an adjustment.             AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR44.3
                                                                 AR48.3  AR504
                                                                 DT150   DT45.1

ARA-CR-TYPE            Alpha 1                                   AR129   AR130
Element: Payment Type  The transaction type of the payment.      AR131   AR135
                       Valid values are:                         AR180   AR30.1
                       B = Bill of Exchange                      AR30.2  AR30.3
                       C = Credit Memo                           AR30.4  AR30.8
                       D = Debit Memo                            AR31.5  AR31.6
                       P = Payment                               AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-NBR             Alpha 22                                  AR129   AR130
Payment Transaction    The transaction number of the applied     AR131   AR135
Number                 payment or credit memo.                   AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-SUFFIX          Numeric 3                                 AR180   AR42.1
Credit Memo Suffix     Suffix number needed for file             AR42.2  AR42.6
Number                 relationships.                            AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-CANCEL-SEQ      Numeric 4                                 AR180   DT45.1
Element: BOE Cancel SeqThe bill of exchange cancel sequence
                       number.

ARA-CR-APP-SEQ         Numeric 5                                 AR129   AR130
Application            Sequence number of the application made   AR131   AR135
Sequence Number        with this payment or credit memo.         AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-APP-AMT         Signed 15.2                               AR129   AR130
Payment Applied        The amount in payment in the currency     AR131   AR135
Amount                 of the payment or credit memo that was    AR180   AR20.1
                       applied against the transaction.          AR21.1  AR21.2
                                                                 AR21.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-CR-ORIG-AP-AMT     Signed 15.2                               AR129   AR130
Element: Adj Amt       The amount of the application in the      AR131   AR135
                       currency of the payment.                  AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR504   AR560
                                                                 AR700   DT150
                                                                 DT45.1

ARA-CR-ADJ-SEQ         Numeric 3                                 AR129   AR130
Credit Adjustment      The sequence number of the credit         AR131   AR135
Sequence               adjustment.                               AR180   AR30.3
                                                                 AR31.6  AR48.3
                                                                 AR504

ARA-CR-ADJ-AMT         Signed 15.2                               AR129   AR130
Credit Adjustment      The amount of the credit adjustment.      AR131   AR135
Amount                                                           AR180   AR30.3
                                                                 AR31.6  AR35.2
                                                                 AR48.3  AR504

ARA-DEPOSIT-DATE       Numeric 8  (yyyymmdd)                     AR129   AR130
Element: Deposit Date  The deposit date of the payment, or the   AR131   AR135
                       general ledger date of the credit memo.   AR180   AR30.1
                       This date is used in calculations such    AR30.2  AR30.3
                       as IPA, DBT, and so on.                   AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-OPR-CODE           Alpha 10  (Lower Case)                    AR129   AR130
Element: Operator Code The operator code used to create the      AR131   AR135
                       application. If the operator is required  AR180   AR30.1
                       at the company level, must be a valid     AR30.2  AR30.3
                       operator code defined in AR15.6           AR30.4  AR30.8
                       (Operator). If the operator is not        AR31.5  AR31.6
                       required, this is the operator's system   AR35.2  AR42.1
                       logon ID.                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1

ARA-GL-DATE            Numeric 8  (yyyymmdd)                     AR129   AR130
Element: General LedgerThe general ledger posting date of the    AR131   AR135
                       application. Either the general ledger    AR180   AR30.1
                       date of the applied payment or credit     AR30.2  AR30.3
                       memo or the system date of the            AR30.4  AR30.8
                       application defaults depending on the     AR31.5  AR31.6
                       options defined for the company. For      AR35.1  AR35.2
                       partial and full write-offs, the          AR42.1  AR42.2
                       application general ledger date defined   AR42.6  AR42.7
                       by the operator will be used. All         AR43.1  AR44.3
                       application general ledger dates are      AR48.3  AR502
                       maintainable by the operator.             AR504   AR560
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-AR-CODE            Alpha 4                                   AR129   AR130
Accounts Receivable    The accounts receivable code used to      AR131   AR135
Code                   identify the general ledger account that  AR180   AR30.1
                       is to be credited. This is normally the   AR30.2  AR30.3
                       accounts receivable code assigned to the  AR30.4  AR30.8
                       invoice or debit memo being paid.         AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-OFFSET-CODE        Alpha 4                                   AR129   AR130
Element: Offset Code   The accounts receivable code that         AR131   AR135
                       identifies the offset general ledger      AR180   AR30.1
                       account that is debited when application  AR30.2  AR30.3
                       occurs. For payment applications, this    AR30.4  AR30.8
                       is the RNA code or Prepay code. For       AR31.6  AR42.1
                       credit applications, this is the AR code  AR42.2  AR42.6
                       assigned to the credit memo.              AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                       If grouping by a bill of exchange, this   AR502   AR504
                       is the AR code assigned to the bill of    AR560   DT150
                       exchange process level.                   DT45.1  DT92.1

ARA-APP-SOURCE         Alpha 1                                   AR129   AR130
Element: Application SoIndicates how the application was made.   AR131   AR135
                       Valid values are:                         AR180   AR30.1
                                                                 AR30.2  AR30.3
                       A = Automatic cash application            AR30.4  AR30.8
                       C = Converted application record          AR31.5  AR31.6
                       M = Manual cash application               AR35.2  AR42.1
                       R = Payment reversal application          AR42.2  AR42.6
                       X = Automatic memo application            AR42.7  AR43.1
                       B = Bill of Exchange                      AR44.3  AR48.3
                       E = Electronic Funds Transfer             AR502   AR504
                       W = Automatic Write Off                   AR560   DT150
                       T = Transfer to AP                        DT45.1  DT92.1

ARA-RESULT-FL          Alpha 1                                   AR129   AR130
Element: Application ReIndicates the result of the application   AR131   AR135
                       as it relates to the invoice or debit     AR137   AR180
                       memo. It tracks fully applied status and  AR190   AR30.1
                       timeliness of the application. Valid      AR30.2  AR30.3
                       values are:                               AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                       C = Credit application                    AR35.2  AR42.1
                       D = Partially applied (late)              AR42.2  AR42.6
                       F = Fully applied (on time)               AR42.7  AR43.1
                       L = Fully applied (late)                  AR44.3  AR48.3
                       P = Partially applied (on time)           AR502   AR504
                       W = Finance charge assessed               AR560   DT150
                       B = Bill of Exchange                      DT45.1  DT92.1
                       X = Partially applied (late) with
                       charges assessed
                       Y = Fully applied (late) with charges
                       assessed

ARA-ORIG-APP-AMT       Signed 15.2                               AR129   AR130
Transaction            The application amount in transaction     AR131   AR135
Application Amount     currency.                                 AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-APP-CURR-CD        Alpha 5                                   AR129   AR130
Application            The currency of the application.          AR131   AR135
Currency Code                                                    AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR700
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-APP-CURR           Alpha 1                                   AR129   AR130
Application            This field indicates what type of         AR131   AR135
Currency Type          application occurred in terms of          AR180   AR30.1
                       currency. Valid values are:               AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                       B = Base                                  AR31.5  AR31.6
                       N = Non-base                              AR35.2  AR42.1
                       M = Mixed                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   DT150
                                                                 DT45.1  DT92.1

ARA-REVERSE-FL         Alpha 1                                   AR180   AR42.1
Element: Reversal      Indicates whether an application was      AR42.2  AR42.6
                       reversed after posting to the general     AR42.7  AR43.1
                       ledger. If a reversal is created in AR80  AR502   AR560
                       (Payment Application Reversal) or AR180   DT45.1  DT92.1
                       (Payment Application Reversal Creation),
                       the system creates the appropriate
                       reversing journal entries. Valid values
                       are:

                       N = No reversal
                       Y = Reversal application record

ARA-PREPAY-FLAG        Numeric 1                                 AR129   AR130
Element: Prepayment FlaIndicates if payment is a prepayment.     AR131   AR135
                                                                 AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR48.3

ARA-DELETE-FL          Alpha 1                                   AR300
Element: Delete Fl     C = Credit Memo Deleted
                       D = Debit Memo Deleted
                       I = Invoice Deleted
                       P = Payment Deleted

ARA-AR-CUST-PO-NBR     Derived
Element: Ar Cust Po Nbr

ARA-AR-DUE-DATE        Derived
Element: Ar Due Date

                         ARAPPLIED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARASET1   COMPANY       This is the primary path used to access  AR137   AR150
          TRANS-TYPE    applied records by transaction number.   AR161   AR180
          INVOICE                                                AR190   AR191
          PAYMENT-SEQ                                            AR194   AR196
          BATCH-NBR                                              AR230   AR232
          APP-SEQ                                                AR235   AR250
                                                                 AR251   AR252
                                                                 AR253   AR255
                                                                 AR256   AR274
                                                                 AR275   AR286
                                                                 AR287   AR300
                                                                 AR35.1  AR35.2
                                                                 AR36.1  AR36.2
                                                                 AR37.6  AR37.7
                                                                 AR37.8  AR37.9
                                                                 ...

ARASET2   CR-COMPANY    This path is used to access              AR115   AR124
          CR-BATCH      applications made by payments.           AR137   AR150
          CR-PYMNT-SEQ  Subset                                   AR180   AR191
          COMPANY       Where CR-TYPE = "P"                      AR194   AR20.1
          TRANS-TYPE                                             AR21.1  AR21.2
          INVOICE                                                AR21.3  AR24.1
          PAYMENT-SEQ                                            AR250   AR251
          BATCH-NBR                                              AR252   AR253
          APP-SEQ                                                AR255   AR256
                                                                 AR275   AR286
                                                                 AR287   AR29.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR300   AR37.1
                                                                 AR37.2  AR48.1
                                                                 ...

ARASET3   CR-COMPANY    This path is used to select non          AR137   AR150
          CR-CUSTOMER   write-off applications.                  AR161   AR180
          CR-TYPE       Subset                                   AR190   AR194
          CR-NBR        Where CR-COMPANY != Zeroes               AR196   AR223
          CR-PYMNT-SEQ                                           AR230   AR232
          CR-BATCH                                               AR235   AR250
          CR-SUFFIX                                              AR251   AR252
          CR-CANCEL-SEQ                                          AR253   AR255
          CR-APP-SEQ                                             AR256   AR275
                                                                 AR286   AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 ...

ARASET4   COMPANY       This path will be used to select         AR132   AR135
          TRANS-TYPE    applications that need audits (status 2) AR190   AR199
          INVOICE       and those records that are not yet       AR233   AR48.1
          PAYMENT-SEQ   updated in the GL (status 2 & 4).  When  AR50.1
          BATCH-NBR     the selections are made for audits, the
          APP-SEQ       selection of status 2 only will need to
                        be handled programatically.
                        Subset
                        Where STATUS = Zeroes
                        Or    STATUS = 2
                        Or    STATUS = 4

ARASET5   COMPANY       This path is used to access              AR180   AR232
          GL-DATE       applications by general ledger date for  AR300
          TRANS-TYPE    reporting purposes.
          INVOICE
          PAYMENT-SEQ
          BATCH-NBR
          APP-SEQ
          CR-COMPANY
          CR-BATCH
          CR-PYMNT-SEQ

ARASET6   CR-COMPANY    This path is used to access the credit   AR230
          GL-DATE       side of applications by general ledger
          CR-CUSTOMER   date.
          CR-TYPE       Subset
          CR-NBR        Where CR-COMPANY != Zeroes
          CR-PYMNT-SEQ
          CR-SUFFIX
          CR-CANCEL-SEQ
          CR-BATCH
          CR-APP-SEQ

                         ARAPPLIED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ARA-COMPANY        -> ACO-COMPANY

Arcrcomp       ARCOMP       Required
                            When ARA-CR-COMPANY != Zeroes

                            ARA-CR-COMPANY     -> ACO-COMPANY

Arcrcustomer   ARCUSTOMER   Required
                            When ARA-CR-CUSTOMER != Spaces
                            And  ARA-CR-CUSTOMER != "000000000"

                            ARA-CR-COMPANY     -> ACM-COMPANY
                            ARA-CR-CUSTOMER    -> ACM-CUSTOMER

Aroihdr        AROIHDR      Required

                            ARA-COMPANY        -> ARH-COMPANY
                            ARA-TRANS-TYPE     -> ARH-TRANS-TYPE
                            ARA-INVOICE        -> ARH-INVOICE

Aroitems       AROITEMS     Required

                            ARA-COMPANY        -> ARO-COMPANY
                            ARA-TRANS-TYPE     -> ARO-TRANS-TYPE
                            ARA-INVOICE        -> ARO-INVOICE
                            ARA-PAYMENT-SEQ    -> ARO-PAYMENT-SEQ

Arpayment      ARPAYMENT    Required

                            ARA-CR-COMPANY     -> APM-COMPANY
                            ARA-CR-BATCH       -> APM-BATCH-NBR
                            ARA-CR-TYPE        -> APM-TRANS-TYPE
                            ARA-CR-NBR         -> APM-TRANS-NBR
                            ARA-CR-CUSTOMER    -> APM-CUSTOMER

Custdescpay    CUSTDESC     Required
                            When ARA-CR-CUSTOMER != Spaces
                            And  ARA-CR-CUSTOMER != "000000000"

                            ACO-CUST-GROUP     -> CUD-CUST-GROUP
                            ARA-CR-CUSTOMER    -> CUD-CUSTOMER

Reversedtl     REVERSEDTL   Not Required

                            ARA-COMPANY        -> RVD-COMPANY
                            ARA-TRANS-TYPE     -> RVD-TRANS-TYPE
                            ARA-INVOICE        -> RVD-INVOICE
                            ARA-PAYMENT-SEQ    -> RVD-PAYMENT-SEQ
                            ARA-BATCH-NBR      -> RVD-BATCH-NBR
                            ARA-APP-SEQ        -> RVD-APP-SEQ

                         ARAPPLIED FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aradjust       ARADJUST     Delete Cascades

                            ARA-COMPANY        -> ADJ-COMPANY
                            ARA-TRANS-TYPE     -> ADJ-TRANS-TYPE
                            ARA-INVOICE        -> ADJ-INVOICE
                            ARA-PAYMENT-SEQ    -> ADJ-PAYMENT-SEQ
                            ARA-BATCH-NBR      -> ADJ-BATCH-NBR
                            ARA-APP-SEQ        -> ADJ-APP-SEQ
                                                  ADJ-ADJ-SEQ

Ardrafts       ARDRAFTS     Required

                            ARA-CR-COMPANY     -> ARD-COMPANY
                            ARA-CR-NBR         -> ARD-AR-DRAFT-NBR
                            ARA-CR-SUFFIX      -> ARD-SUFFIX
                            ARA-CR-CUSTOMER    -> ARD-CUSTOMER
                            Zeroes             -> ARD-CANCEL-SEQ
                                                  ARD-DRAFT-SOURCE