Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ARAPPLIED FILE

                             AR Application

AR Application

REFERENCED BY

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

UPDATED BY

AR115     AR124     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    AR502     AR504     AR560     AR570     AR575
AR580     AR700     AR972     AR980     CB06.2    CB191
DT150     DT40.1    DT45.1    DT520     DT92.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARA-COMPANY          Numeric 4                                   AR130   AR131
Company              The company number represents an            AR135   AR180
                     established company and is entered on       AR30.1  AR30.2
                     all function codes.                         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  AR502
                                                                 AR504   AR560
                                                                 AR972   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   DT92.1

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

ARA-TRANS-NBR        Alpha 10  (Right Justified)                 AR130   AR131
Transaction Number   The transaction number referenced by        AR135   AR180
                     this application.                           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  AR502
                                                                 AR504   AR560
                                                                 AR972   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   DT92.1

ARA-PAYMENT-SEQ      Numeric 6                                   AR130   AR131
Payment Sequence     Payment Sequence. This is the generated     AR135   AR180
                     sequence number to separate individual      AR30.1  AR30.2
                     invoice payment requirements.               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  AR502
                                                                 AR504   AR560
                                                                 AR972   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   DT92.1

ARA-BATCH-NBR        Numeric 6                                   AR130   AR131
Batch Number         This identifies the batch the entered       AR135   AR180
                     invoices, debit memos, credit memos, or     AR30.1  AR30.2
                     payments are a part of.                     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  AR504
                                                                 AR972   AR980
                                                                 DT150   DT40.1
                                                                 DT45.1  DT520

ARA-APP-SEQ          Numeric 5                                   AR130   AR131
Application Sequence The number of applications made to a        AR135   AR180
                     specific transaction.                       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  AR502
                                                                 AR504   AR560
                                                                 AR972   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   DT92.1

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

ARA-ADJ-AMT          Signed 15.2                                 AR130   AR131
Adjustment Amount    The total amount of adjustments made        AR135   AR180
                     with this application.                      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  AR504
                                                                 AR972   DT45.1

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

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

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

ARA-CR-BATCH         Numeric 6                                   AR130   AR131
Cash Batch Number    The cash batch number associated with       AR135   AR180
                     the applied payment or credit memo.         AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR504   AR972
                                                                 DT150   DT40.1
                                                                 DT45.1  DT520

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

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

ARA-CR-NBR           Alpha 10                                    AR130   AR131
Payment Transaction  The transaction number of the applied       AR135   AR180
Number               payment or credit memo.                     AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR504   AR560
                                                                 AR972   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   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   AR972
                                                                 DT150   DT40.1
                                                                 DT45.1  DT520
                                                                 DT92.1

ARA-CR-CANCEL-SEQ    Numeric 4                                   AR180   AR972
BOE Cancel Sequence  The bill of exchange cancel sequence        DT45.1
                     number.

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

ARA-CR-APP-AMT       Signed 15.2                                 AR130   AR131
Payment Applied      The amount in payment in the currency       AR135   AR180
Amount               of the payment or credit memo that was      AR20.1  AR21.1
                     applied against the transaction.            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
                                                                 AR502   AR504
                                                                 AR560   AR972
                                                                 DT150   DT40.1
                                                                 DT45.1  DT520
                                                                 DT92.1

ARA-CR-ORIG-AP-AMT   Signed 15.2                                 AR130   AR131
Credit Application   The amount of the application in the        AR135   AR180
Orig Amt             currency of the payment.                    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
                                                                 AR504   AR700
                                                                 AR980   DT150
                                                                 DT40.1  DT520

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

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

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

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

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

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

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

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

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

ARA-ORIG-APP-AMT     Signed 15.2                                 AR130   AR131
Transaction          The application amount in transaction       AR135   AR180
Application Amount   currency.                                   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
                                                                 AR502   AR504
                                                                 AR560   AR972
                                                                 DT150   DT40.1
                                                                 DT45.1  DT520
                                                                 DT92.1

ARA-APP-CURR-CD      Alpha 5                                     AR130   AR131
Application          The currency of the application.            AR135   AR180
Currency Code                                                    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
                                                                 AR502   AR504
                                                                 AR560   AR972
                                                                 AR980   DT150
                                                                 DT40.1  DT45.1
                                                                 DT520   DT92.1

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

ARA-REVERSE-FL       Alpha 1                                     AR180   AR42.1
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     AR972   DT45.1
                     (Payment Application Reversal Creation),    DT92.1
                     the system creates the appropriate
                     reversing journal entries. Valid values
                     are:

                     N = No reversal
                     Y = Reversal application record

ARA-PREPAY-FLAG      Numeric 1                                   AR130   AR131
Prepayment Flag      Indicates if payment is a prepayment.       AR135   AR180
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR972

ARA-AR-CUST-PO-NBR   Derived
Customer PO Number   Used by Lawson SEA programs.

ARA-AR-DUE-DATE      Derived
Due Date             Used by Lawson SEA programs.

                         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
          TRANS-NBR                                              AR190   AR191
          PAYMENT-SEQ                                            AR194   AR196
          BATCH-NBR                                              AR235   AR250
          APP-SEQ                                                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
                                                                 AR42.6  AR505
                                                                 ...

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

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

ARASET4   COMPANY       This path will be used to select         AR132   AR135
          TRANS-TYPE    applications that need audits (status 2) AR190   AR199
          TRANS-NBR     and those records that are not yet       AR233   AR50.1
          PAYMENT-SEQ   updated in the GL (status 2 & 4).  When
          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              AR232   AR300
          GL-DATE       applications by general ledger date for
          TRANS-TYPE    reporting purposes.
          TRANS-NBR
          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-TRANS-NBR       -> ARH-TRANS-NBR

Aroitems       AROITEMS     Required

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

Arpayment      ARPAYMENT    Required
                            When ARA-CR-TYPE = "P"

                            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-TRANS-NBR       -> RVD-TRANS-NBR
                            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-TRANS-NBR       -> ADJ-TRANS-NBR
                            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-DRAFT-NBR
                            ARA-CR-SUFFIX       -> ARD-SUFFIX
                            ARA-CR-CUSTOMER     -> ARD-CUSTOMER
                            Zeroes              -> ARD-CANCEL-SEQ
                                                   ARD-DRAFT-SOURCE

Cradjust       ARADJUST

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