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 main 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     AR232
AR235     AR239     AR250     AR251     AR252     AR253
AR255     AR256     AR257     AR265     AR274     AR275
AR286     AR287     AR296     AR36.1    AR36.2    AR53.1
AR800     AR82.1    DT170     DT180     DT181     GL235
AR29.1    AR29.2    AR50.1    AR223     AR230     DT155
AR199     AR233     AR237

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.8    AR300
AR32.1    AR33.1    AR33.3    AR33.5    AR33.6    AR34.1
AR35.1    AR35.2    AR37.1    AR37.2    AR37.3    AR37.4
AR37.5    AR37.6    AR37.7    AR38.1    AR38.2    AR38.3
AR39.1    AR39.2    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR48.3    AR502     AR504     AR560
AR570     AR575     AR580     AR80.1    AR80.2    ARLL.1
CB06.2    CB191     DT150     DT45.1    DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARA-COMPANY            Numeric 4                                 AR129   AR130
Element: Company       The number representing an AR company.    AR131   AR135
                                                                 AR180   AR30.1
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 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.8  AR32.1
                       C = Credit memo                           AR33.1  AR33.3
                       D = Debit memo                            AR33.5  AR33.6
                       I = Invoice                               AR34.1  AR35.1
                       P = Payment                               AR35.2  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-INVOICE            Alpha 22                                  AR129   AR130
Element: Invoice       Used to identify the invoice.             AR131   AR135
                                                                 AR180   AR30.1
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-PAYMENT-SEQ        Numeric 6                                 AR129   AR130
Element: Payment SequenA unique number assigned to each          AR131   AR135
                       transaction to be interfaced into the     AR180   AR30.1
                       Lawson system.                            AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

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

ARA-APP-SEQ            Numeric 7                                 AR129   AR130
Element: Application SeThe number of applications made to a      AR131   AR135
                       specific transaction.                     AR180   AR30.1
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR38.1
                                                                 AR38.2  AR38.3
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8
                       depending on the following set of rules:  AR32.1  AR33.1
                                                                 AR33.3  AR33.5
                       If an application is made by other than   AR33.6  AR34.1
                       the entry and apply method, or when the   AR35.2  AR38.1
                       cash batch is released, the status will   AR38.2  AR38.3
                       be set to 2 if the debit company          AR39.1  AR39.2
                       requires an audit of applications (Yes    AR42.1  AR42.2
                       selected in the Review Applications       AR42.6  AR42.7
                       field in AR01.2). The status will be set  AR43.1  AR44.3
                       to a 4 if the debit company does not      AR48.3  AR502
                       require an audit of applications (No      AR504   AR560
                       selected in the Review Applications       AR570   AR575
                       field in AR01.2). Valid values are:       AR580   AR80.1
                                                                 AR80.2  ARLL.1
                       0 = Unreleased                            CB191   DT150
                       2 = Requires audit listing                DT45.1  DT92.1
                       4 = Available for posting
                       5 = Posted

ARA-APPLD-AMT          Signed 18.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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-ADJ-AMT            Signed 18.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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR44.3
                                                                 AR48.3  AR504
                                                                 AR80.1  AR80.2
                                                                 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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR38.1
                                                                 AR38.2  AR38.3
                                                                 AR39.1  AR39.2
                                                                 AR44.3  AR48.3
                                                                 AR504   AR80.1
                                                                 AR80.2  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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                       credit memo or an adjustment.             AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                       C = Credit Memo                           AR33.1  AR33.3
                       D = Debit Memo                            AR33.5  AR33.6
                       P = Payment                               AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

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

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

ARA-CR-APP-AMT         Signed 18.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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 DT150   DT45.1
                                                                 DT92.1

ARA-CR-ORIG-AP-AMT     Signed 18.2                               AR129   AR130
Element: Intl Amt      The amount of the application in the      AR131   AR135
                       currency of the payment.                  AR180   AR30.1
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.1
                                                                 AR33.1  AR33.6
                                                                 AR39.1  AR39.2
                                                                 AR48.3  AR504
                                                                 AR80.1  AR80.2

ARA-CR-ADJ-AMT         Signed 18.2                               AR129   AR130
Credit Adjustment      The amount of the credit adjustment.      AR131   AR135
Amount                                                           AR180   AR30.1
                                                                 AR33.1  AR33.6
                                                                 AR35.2  AR38.1
                                                                 AR38.2  AR38.3
                                                                 AR39.1  AR39.2
                                                                 AR48.3  AR504
                                                                 AR80.1  AR80.2

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.8  AR32.1
                       as IPA, DBT, and so on.                   AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR35.2  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 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.8  AR32.1
                       operator code defined in AR15.6           AR33.1  AR33.3
                       (Operator). If the operator is not        AR33.5  AR33.6
                       required, this is the operator's system   AR34.1  AR35.2
                       logon ID.                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 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.8  AR32.1
                       memo or the system date of the            AR33.1  AR33.3
                       application defaults depending on the     AR33.5  AR33.6
                       options defined for the company. For      AR34.1  AR35.1
                       partial and full write-offs, the          AR35.2  AR38.1
                       application general ledger date defined   AR38.2  AR38.3
                       by the operator will be used. All         AR39.1  AR39.2
                       application general ledger dates are      AR42.1  AR42.2
                       maintainable by the operator.             AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                       accounts receivable code assigned to the  AR33.1  AR33.3
                       invoice or debit memo being paid.         AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                       occurs. For payment applications, this    AR33.1  AR33.3
                       is the RNA code or Prepay code. For       AR33.6  AR34.1
                       credit applications, this is the AR code  AR39.1  AR39.2
                       assigned to the credit memo.              AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                       If grouping by a bill of exchange, this   AR43.1  AR44.3
                       is the AR code assigned to the bill of    AR48.3  AR502
                       exchange process level.                   AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  DT150
                                                                 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.8  AR32.1
                       A = Automatic cash application            AR33.1  AR33.3
                       C = Converted application record          AR33.5  AR33.6
                       M = Manual cash application               AR34.1  AR35.2
                       R = Payment reversal application          AR39.1  AR39.2
                       X = Automatic memo application            AR42.1  AR42.2
                       B = Bill of Exchange                      AR42.6  AR42.7
                       E = Electronic Funds Transfer             AR43.1  AR44.3
                       W = Automatic Write Off                   AR48.3  AR502
                       T = Transfer to AP                        AR504   AR560
                       S = Mixed Signed Application              AR80.1  AR80.2
                       G = Grouped Memo                          ARLL.1  DT150
                       J = Adjustment Maintenance                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.8  AR32.1
                       values are:                               AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                       C = Credit application                    AR34.1  AR35.2
                       D = Partially applied (late)              AR39.1  AR39.2
                       F = Fully applied (on time)               AR42.1  AR42.2
                       L = Fully applied (late)                  AR42.6  AR42.7
                       P = Partially applied (on time)           AR43.1  AR44.3
                       W = Finance charge assessed               AR48.3  AR502
                       B = Bill of Exchange                      AR504   AR560
                       X = Partially applied (late) with         AR80.1  AR80.2
                       charges assessed                          ARLL.1  DT150
                       Y = Fully applied (late) with charges     DT45.1  DT92.1
                       assessed

ARA-ORIG-APP-AMT       Signed 18.2                               AR129   AR130
Transaction            The application amount in transaction     AR131   AR135
Application Amount     currency.                                 AR180   AR30.1
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR504
                                                                 AR560   AR80.1
                                                                 AR80.2  ARLL.1
                                                                 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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR35.2
                                                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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.8  AR32.1
                                                                 AR33.1  AR33.3
                       B = Base                                  AR33.5  AR33.6
                       N = Non-base                              AR34.1  AR35.2
                       M = Mixed                                 AR39.1  AR39.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR80.1  AR80.2
                                                                 ARLL.1  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   AR80.1  AR80.2
                       (Payment Application Reversal Creation),  ARLL.1  DT45.1
                       the system creates the appropriate        DT92.1
                       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.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR33.5  AR33.6
                                                                 AR34.1  AR39.1
                                                                 AR39.2  AR48.3
                                                                 AR80.1  AR80.2

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       KeyChange                                AR130   AR135
          TRANS-TYPE                                             AR137   AR150
          INVOICE                                                AR161   AR180
          PAYMENT-SEQ                                            AR190   AR191
          BATCH-NBR                                              AR194   AR196
          APP-SEQ                                                AR232   AR235
                                                                 AR239   AR250
                                                                 AR251   AR252
                                                                 AR253   AR255
                                                                 AR256   AR257
                                                                 AR265   AR274
                                                                 AR275   AR286
                                                                 AR287   AR296
                                                                 AR30.1  AR30.6
                                                                 AR30.8  AR300
                                                                 ...

ARASET2   CR-COMPANY    KeyChange, Subset                        AR115   AR124
          CR-BATCH      Where CR-TYPE = "P"                      AR137   AR150
          CR-PYMNT-SEQ                                           AR191   AR194
          COMPANY                                                AR20.1  AR21.1
          TRANS-TYPE                                             AR21.2  AR21.3
          INVOICE                                                AR24.1  AR250
          PAYMENT-SEQ                                            AR251   AR252
          BATCH-NBR                                              AR253   AR255
          APP-SEQ                                                AR256   AR257
                                                                 AR275   AR286
                                                                 AR287   AR29.1
                                                                 AR29.2  AR30.1
                                                                 AR300   AR32.1
                                                                 AR34.1  AR37.1
                                                                 AR37.2  AR50.1
                                                                 ...

ARASET3   CR-COMPANY    KeyChange, Subset                        AR130   AR135
          CR-CUSTOMER   Where CR-COMPANY != Zeroes               AR137   AR150
          CR-TYPE                                                AR161   AR190
          CR-NBR                                                 AR194   AR196
          CR-PYMNT-SEQ                                           AR223   AR230
          CR-BATCH                                               AR232   AR235
          CR-SUFFIX                                              AR239   AR250
          CR-CANCEL-SEQ                                          AR251   AR252
          CR-APP-SEQ                                             AR253   AR255
                                                                 AR256   AR257
                                                                 AR275   AR286
                                                                 AR30.1  AR30.6
                                                                 AR30.8  AR32.1
                                                                 AR33.1  AR33.3
                                                                 AR34.1  AR35.2
                                                                 ...

ARASET4   COMPANY       KeyChange, Subset                        AR132   AR135
          TRANS-TYPE    Where STATUS = Zeroes                    AR190   AR199
          INVOICE       Or    STATUS = 2                         AR233   AR48.1
          PAYMENT-SEQ   Or    STATUS = 4
          BATCH-NBR
          APP-SEQ

ARASET5   COMPANY       KeyChange                                AR180   AR232
          GL-DATE                                                AR237
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          BATCH-NBR
          APP-SEQ
          CR-COMPANY
          CR-BATCH
          CR-PYMNT-SEQ

ARASET6   CR-COMPANY    KeyChange, Subset                        AR230
          GL-DATE       Where CR-COMPANY != Zeroes
          CR-CUSTOMER
          CR-TYPE
          CR-NBR
          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
                            ARO-ALT-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

                         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