Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
AR223     DT155     AR199     AR233     AR50.1    AR232

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
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
Transaction Type     The 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
Invoice Number       Used 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
Payment Sequence     Payment Sequence. This is the generated     AR131   AR135
                     sequence number to separate individual      AR180   AR30.1
                     invoice payment requirements.               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
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
                                                                 DT150   DT45.1

ARA-APP-SEQ          Numeric 5                                   AR129   AR130
Application Sequence The 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
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
Applied Amount       The 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
Adjustment Amount    The 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
Adjustment Sequence  The 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  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
                                                                 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
                                                                 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
Cash Batch Number    The 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
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR504   DT150
                                                                 DT45.1

ARA-CR-PYMNT-SEQ     Numeric 6                                   AR129   AR130
Payment Sequence     The 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
                                                                 AR44.3  AR48.3
                                                                 AR504   DT150
                                                                 DT45.1

ARA-CR-TYPE          Alpha 1                                     AR129   AR130
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                                 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
                                                                 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
BOE Cancel Sequence  The 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
                                                                 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
Cr Orig Ap 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
                                                                 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
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
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
General Ledger Date  The 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
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
Application Source   Indicates 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
Application Result   Indicates 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
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
Prepayment Flag      Indicates 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
Delete Fl            C = Credit Memo Deleted
                     D = Debit Memo Deleted
                     I = Invoice Deleted
                     P = Payment Deleted

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

ARA-AR-DUE-DATE      Derived
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   AR235
          APP-SEQ                                                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  AR42.6
                                                                 ...

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  AR570
                                                                 ...

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               AR223   AR230
          CR-PYMNT-SEQ                                           AR235   AR250
          CR-BATCH                                               AR251   AR252
          CR-SUFFIX                                              AR253   AR255
          CR-CANCEL-SEQ                                          AR256   AR275
          CR-APP-SEQ                                             AR30.1  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
                                                                 ...

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              AR232   AR300
          GL-DATE       applications by general ledger date for
          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