Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              AROIHDR FILE

                         AR Transaction Header

AR Transaction Header

REFERENCED BY

AC115     AR01.1    AR100     AR105     AR110     AR124
AR131     AR132     AR135     AR136     AR140     AR141
AR150     AR155     AR161     AR180     AR194     AR196
AR20.1    AR21.1    AR21.2    AR21.3    AR21.4    AR21.5
AR230     AR232     AR233     AR235     AR24.1    AR25.1
AR250     AR251     AR252     AR253     AR255     AR256
AR258     AR274     AR275     AR282     AR286     AR287
AR294     AR35.1    AR35.2    AR36.1    AR36.2    AR46.1
AR50.1    AR504     AR505     AR506     AR507     AR53.1
AR570     AR575     AR58.1    AR580     AR700     AR73.1
AR74.1    AR80.1    AR80.2    AR90.1    AR980     BL120
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    BL940     CB06.2
CB191     DT170     GL235     OE114     OE129     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE830     OE950     AR72.1    AR199     AR242
AR10.1    AR17.1    AR227     AR234     AR271

UPDATED BY

AR115     AR130     AR137     AR145     AR190     AR191
AR29.3    AR30.1    AR30.2    AR30.4    AR30.8    AR300
AR31.5    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    AR45.1    AR502     AR560     AR82.1
AR953     AR954     AR976     DT150     DT180     DT181
DT40.1    DT45.1    DT520     DT92.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARH-COMPANY          Numeric 4                                   AR115   AR130
Company              Company number.                             AR137   AR190
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-TRANS-TYPE       Alpha 1                                     AR115   AR130
Transaction Type     Indicates the type of transaction.          AR137   AR190
                     Valid values are:                           AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                     C = Credit Memo                             AR31.5  AR42.2
                     D = Debit Memo                              AR42.7  AR44.3
                     I = Invoice                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-TRANS-NBR        Alpha 10  (Right Justified)                 AR115   AR130
Transaction Number   The transaction number. This is either      AR137   AR190
                     the invoice, credit memo or debit memo      AR30.1  AR30.2
                     number, depending on the type of            AR30.4  AR30.8
                     transaction.                                AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-STATUS           Numeric 1                                   AR115   AR130
Transaction Status   This field contains the status of the       AR137   AR190
                     transaction. Valid values are               AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                     0 = Unreleased                              AR31.5  AR42.1
                     1 = Released                                AR42.2  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-CUSTOMER         Alpha 9  (Right Justified)                  AR115   AR130
Customer             Customer number.                            AR137   AR190
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-BATCH-NBR        Numeric 6                                   AR115   AR130
Batch Number         This identifies the batch the entered       AR137   AR190
                     invoices and debit memos are part of.       AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-PROCESS-LEVEL    Alpha 5                                     AR115   AR130
Process Level        This field contains the process level,      AR137   AR190
                     which is the reporting hierarchy below      AR30.1  AR30.2
                     company.                                    AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-TRANS-DATE       Numeric 8  (yyyymmdd)                       AR115   AR130
Transaction Date     This field contains the date of the         AR137   AR190
                     transaction.                                AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-GL-DATE          Numeric 8  (yyyymmdd)                       AR115   AR130
General Ledger Date  This field contains the general ledger      AR137   AR190
                     posting date.                               AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-ORIG-CURRENCY    Alpha 5                                     AR115   AR130
Transaction Currency The transaction currency code.              AR137   AR190
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-ORIG-ND          Numeric 1                                   AR115   AR130
Number of Decimals   Currency decimal indicator.                 AR137   AR190
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-ORIG-AMT         Signed 15.2                                 AR115   AR130
Transaction Amount   The amount of the transaction in            AR137   AR190
                     transaction currency.                       AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-TRAN-AMT         Signed 15.2                                 AR115   AR130
Base Amount          The total amount of the transaction in      AR137   AR190
                     the company base currency.                  AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-CUST-PO-NBR      Alpha 20                                    AR115   AR130
Customer PO Number   The customer purchase order number          AR190   AR30.1
                     assigned to the invoice.                    AR30.2  AR30.4
                                                                 AR30.8  AR42.2
                                                                 AR42.6  AR502
                                                                 AR560   AR953
                                                                 AR954   AR976

ARH-XREF-COMPANY     Numeric 4                                   AR42.2  AR42.6
Cross Reference      The company associated with the cross       AR502   AR560
Company              referenced transaction.                     AR954   AR976

ARH-XREF-CUSTOMER    Alpha 9  (Right Justified)                  AR42.2  AR42.6
Cross Reference      The customer associated with the cross      AR560   AR954
Customer             referenced transaction.                     AR976

ARH-XREF-TYPE        Alpha 1                                     AR115   AR130
Cross Reference Type The type of cross reference. Used to        AR190   AR30.1
                     identify the reference number being         AR30.2  AR30.4
                     cross referenced in this transaction.       AR30.8  AR31.5
                     Valid values are:                           AR42.2  AR42.6
                                                                 AR502   AR560
                     I = Invoice                                 AR82.1  AR953
                     D = Debit Memo                              AR954   AR976
                     C = Credit Memo                             DT92.1

ARH-XREF-NBR         Alpha 10                                    AR115   AR130
Cross Reference      The cross reference number entered when     AR190   AR30.1
Number               the transaction was created.                AR30.2  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR42.2  AR42.6
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-XREF-SEQ         Numeric 3                                   AR190   AR42.2
Cross Reference      The cross reference transaction             AR42.6  AR502
Sequence             sequence number.                            AR560   AR953
                                                                 AR954   AR976

ARH-XREF-DUE-DATE    Numeric 8  (yyyymmdd)                       AR42.2  AR42.6
Cross Reference Due  The due date of the cross referenced        AR954   AR976
Date                 transaction.

ARH-AUTO-APP-FL      Alpha 1                                     AR42.2  AR42.6
Automatic            Indicates if the transaction is             AR502   AR560
Application Flag     eligible for automatic cash application.    AR954   AR976


ARH-DESC             Alpha 30  (Lower Case)                      AR115   AR130
Description          The description of invoice or debit         AR137   AR190
                     memo.                                       AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-TRANS-USER1      Alpha 10                                    AR190   AR42.2
Transaction User 1   A user-defined field that is built with     AR42.6  AR502
                     an access path in the invoice/debit memo    AR560   AR953
                     transaction file.                           AR954   AR976

ARH-TRANS-USER2      Alpha 15                                    AR190   AR42.2
Transaction User 2   A user-defined field.                       AR42.6  AR502
                                                                 AR560   AR953
                                                                 AR954   AR976

ARH-TRANS-USER3      Numeric 8  (yyyymmdd)                       AR190   AR42.2
Transaction User 3   A user-defined field.                       AR42.6  AR502
                                                                 AR560   AR953
                                                                 AR954   AR976

ARH-TRANS-USER4      Numeric 9                                   AR190   AR42.2
Transaction User 4   A user-defined field.                       AR42.6  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976

ARH-TRANS-USER5      Signed 13.2                                 AR190   AR42.2
Transaction User 5   A user-defined field.                       AR42.6  AR502
                                                                 AR560   AR953
                                                                 AR954   AR976

ARH-AR-CODE          Alpha 4                                     AR115   AR130
Accounts Receivable  The accounts receivable code that           AR137   AR190
Code                 identifies the accounts receivable          AR30.1  AR30.2
                     general ledger account to be credited       AR30.4  AR30.8
                     during cash application.                    AR31.5  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-SALESMAN         Numeric 4                                   AR115   AR130
Sales Rep            The sales representative. Defaults from     AR137   AR190
                     AR Company Customer file.                   AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976

ARH-ORIG-RATE        Signed 12.6                                 AR115   AR130
Exchange Rate        The currency exchange rate used to          AR137   AR190
                     convert a non-base currency transaction     AR30.1  AR30.2
                     amount to the company base currency.        AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-CURR-MUDV        Alpha 1                                     AR115   AR130
Currency             The currency multiply/divide indicator.     AR137   AR190
Multiply/Divide      Indicates whether the currency exchange     AR30.1  AR30.2
                     rate is to be multiplied or divided by      AR30.4  AR30.8
                     the original, transaction amount to         AR31.5  AR42.2
                     calculate the base currency amount.         AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-GROUP-RATE       Signed 12.6                                 AR115   AR130
Group Rate           The group currency exchange rate. Used      AR137   AR190
                     to convert a non-base currency              AR30.1  AR30.2
                     transaction amount to the group             AR30.4  AR30.8
                     currency.                                   AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-GROUP-MUDV       Alpha 1                                     AR115   AR130
Group                The group currency multiply/divide          AR137   AR190
Multiply/Divide      indicator.                                  AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  AR953
                                                                 AR954   AR976
                                                                 DT92.1

ARH-BASE-DETAIL      Signed 15.2                                 AR137   AR190
Base Detail          This is a working field used to insure      AR31.5  AR42.2
                     balancing non-base distributions in a       AR42.7  AR44.3
                     rounding situation.                         AR507   AR953
                                                                 AR954   AR976

ARH-BANK-INST-CODE   Alpha 3                                     AR115   AR130
Payment Code         The cash (check) payment or bill of         AR137   AR190
                     exchange payment transaction code.          AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-BANK-INST-TYPE   Alpha 1                                     AR115   AR130
Transaction Code     This categorizes the type of bank           AR137   AR190
Type                 instrument.                                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976

ARH-TERMS-CD         Alpha 5                                     AR115   AR130
Terms Code           The terms code used in the generation       AR137   AR190
                     of invoice obligations. Used to             AR30.1  AR30.2
                     calculate prepayment discount dates and     AR30.4  AR30.8
                     net due dates.                              AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-PAYMENT-SEQ      Numeric 6                                   AR115   AR130
Payment Sequence     The last sequence number used in            AR137   AR190
                     generating invoice obligations. An          AR30.1  AR30.2
                     invoice may have multiple records with      AR30.4  AR30.8
                     the same transaction number; each will      AR31.5  AR42.1
                     have its own due date, but will be tied     AR42.2  AR42.6
                     to the primary transaction number.          AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT92.1

ARH-DIST-SEQ         Numeric 4                                   AR190   AR31.5
Distribution         The last distribution sequence number       AR42.1  AR42.2
Sequence Number      assigned to the transaction.                AR42.7  AR43.1
                                                                 AR44.3  AR507
                                                                 AR560   AR82.1
                                                                 AR953   AR954
                                                                 AR976   DT150
                                                                 DT180   DT181
                                                                 DT40.1  DT520
                                                                 DT92.1

ARH-ORIG-CODE        Alpha 1                                     AR115   AR130
Origin Code          A system-generated code that identifies     AR137   AR190
                     where the record originated. Valid          AR30.1  AR30.2
                     values are:                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                     B = AR invoice (AR42)                       AR42.7  AR44.3
                     C = Chargeback                              AR502   AR560
                     F = Finance and/or Late Payment Charges     AR82.1  AR953
                     L = Converted data (Lawson)                 AR954   AR976
                     M = Memo (AR42)
                     O = External Order Processing system
                     R = Returned Payment
                     G = Grouped Debit Memo
                     E = Closing created chargeback
                     P = Payment created credit memo

ARH-BILL-TO          Numeric 4                                   AR42.2  AR42.6
Bill To              The bill to location for the open item.     AR502   AR560
                                                                 AR976

ARH-REVALUE-FL       Alpha 1                                     AR115   AR130
Revaluation          This field indicates if a currency          AR137   AR190
                     revaluation is needed for this non-base     AR30.1  AR30.2
                     invoice or debit memo. Valid values are:    AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                     N = No; no revaluation needed               AR44.3  AR502
                     Y = Yes; revaluation needed                 AR560   AR82.1
                                                                 AR953   AR976

ARH-TAX-EXEMPT-CD    Alpha 1                                     AR115   AR130
Tax Exempt Code      This is the customer tax exempt             AR30.1  AR30.2
                     indicator.  Used by the Lawson Order        AR30.4  AR30.8
                     Entry system and AR invoice entry. Valid    AR42.2  AR502
                     values are:                                 AR560   AR953
                                                                 AR976
                     T = Taxable
                     E = Exempt

ARH-NOTICE-FL        Alpha 1                                     AR191   AR953
Notice Flag          Identifies whether to print notices.        AR976

ARH-CB-REASON        Alpha 4                                     AR130   AR190
Chargeback Reason    The chargeback reason code.                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR953   AR976

ARH-CB-ORIG-COMP     Numeric 4                                   AR130   AR190
Chargeback Company   The chargeback company.                     AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR953   AR976

ARH-CB-SEQ-NBR       Numeric 4                                   AR130   AR190
Chargeback Sequence  The sequence number of the chargeback.      AR30.1  AR30.2
Number                                                           AR30.4  AR30.8
                                                                 AR953   AR976

ARH-CANCEL-FLAG      Alpha 1                                     AR29.3  AR976
Cancellation Flag    Indicates if the open item has been has
                     been transferred to another customer.
                     Valid values are:

                     Y = Open item has been transferred
                     Blank = Open item has not been
                     transferred

ARH-REASON-CODE      Alpha 4                                     AR42.2  AR42.6
Reason Code          Indicates the reason for memos.             AR42.7  AR976

ARH-JRNL-BOOK-NBR    Alpha 12                                    AR190   AR42.2
Journal Book Number  This field contains the journal book        AR42.7  AR44.3
                     number for this transaction header          AR502   AR560
                     record.                                     AR82.1  AR953
                                                                 AR976

ARH-TAX-FL           Alpha 1                                     AR42.1  AR42.2
Tax Point            Indicates tax point origin, used for        AR42.7  AR43.1
                     tax calculation. Valid values are:          AR560

                     N = No tax calculation
                     Y = Payment origin

ARH-LATE-CH-FL       Alpha 1                                     AR42.2  AR42.6
Late Charge Flag     Late Charge Flag.  Indicates if late        AR560
                     charge is to be applied to the invoice.
                     Y = Yes
                     N = No

ARH-LATE-CH-TR-NBR   Alpha 10  (Right Justified)                 AR137
Late Charge          The transaction number of the late
Transaction Number   payment charge invoice.

ARH-LATE-CH-OR-AMT   Signed 15.2                                 AR137
Late Charge Amnt -   The late payment charge amount in
Trans Curr           transaction currency.

ARH-LATE-CH-TR-AMT   Signed 15.2                                 AR137
Late Charge Amount   The late payment charge amount in
- Comp Curr          company base currency.

ARH-SUM-LINE         Alpha 1                                     AR115   AR130
Summarize Open Item  Determines whether line items are           AR137   AR30.1
Line Items           displayed in summary or detail.             AR30.2  AR30.4
                     N = No                                      AR30.8  AR42.1
                     Y = Yes                                     AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1

ARH-INTRASTAT-NBR    Numeric 10                                  AR42.2  AR560
Intrastat Number     The number assigned by the Intrastat
                     system to a transaction that involves
                     Intrastat reporting after it has been
                     added.

ARH-SHIP-TO-CTRY     Alpha 2                                     AR42.2  AR560
Ship To Country      The ship-to country code. Must be a
                     valid Intrastat country code, defined in

                     IN01.1 (Country Maintenance)

ARH-SHIP-FR-CTRY     Alpha 2                                     AR42.2  AR560
Ship From Country    The ship-from country code.  Must be a
                     valid Intrastat country code defined in
                     IN01.1  (Country Maintenance)

ARH-SHIP-TO-REGION   Alpha 2                                     AR42.2  AR560
Ship To Region       The ship-to region code.
                     Must be a valid region for the country,
                     defined in IN02.1 (Region
                     Maintenance).

ARH-SHIP-FR-REGION   Alpha 2                                     AR42.2  AR560
Ship From Region     The ship-from region code. Used for
                     Intrastat reporting only. Must be a
                     valid region for the country in IN02.1
                     (Region Maintenance).

ARH-DUN-LTR-IND      Alpha 1
Dunning Letter       Dunning Letters in use for customer. Yes
Indicator            or No.  Specified in AR10.1 (Customer).
                     Applies only to the advanced dunning
                     process.
                     Y = Yes
                     N = No

ARH-OVERIDE-DUNPRC   Alpha 1                                     AR42.6  AR45.1
Override Dunning     Override dunning process.
Process              " " = Normal processing
                     1 = Bypass dunning entirely
                     2 = Do not send for collection

ARH-DUN-PROCESS-CD   Alpha 6                                     AR145
Dunning Process Code Dunning letter process code for
                     thetransaction. A unique  code that
                     represents a combination of  Dunning
                     Letter options.

ARH-LST-DUNLTR-STM   Numeric 2                                   AR145
Last Dunning Letter  Level of the last dunning letter sent as
Level                if this transaction was dunned in
                     isolation.  I.E.  As if it were the only
                     overdue transaction on the letter.

ARH-LAST-LTR-DATE    Numeric 8  (yyyymmdd)                       AR145
Last Dunning Letter  Date last dunning letter was issued for
Date                 this invoice.

ARH-LST-LTRTEXT-CD   Alpha 6                                     AR145
Last Dunning Letter  Text code for last dunning letter sent
Text Code            on this invoice.

ARH-SENT-FOR-COLL    Alpha 1                                     AR145
Sent For Collection  Sent for collection.  This indicates
                     whether the invoice has been sent for
                     collection (Yes or No).
                     Y = Yes
                     N = No

ARH-ASSESS-DUN-FEE   Alpha 1                                     AR145
Assess Dunning Fee?  Specifies whether to assess a dunning
                     letter fee.
                     Y = Yes
                     N = No

                         AROIHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARHSET1   COMPANY       This path is used for record             AC115   AR01.1
          TRANS-TYPE    uniqueness.                              AR100   AR105
          TRANS-NBR                                              AR110   AR115
                                                                 AR124   AR130
                                                                 AR131   AR132
                                                                 AR135   AR136
                                                                 AR137   AR140
                                                                 AR141   AR145
                                                                 AR150   AR155
                                                                 AR161   AR180
                                                                 AR190   AR191
                                                                 AR194   AR196
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR21.4  AR230
                                                                 ...

ARHSET2   CUST-PO-NBR   This path is used to select records by   AR30.1  AR30.2
          COMPANY       purchase order number.                   AR30.3  AR58.1
          CUSTOMER      KeyChange                                AR72.1  AR73.1
          TRANS-TYPE                                             AR90.1
          TRANS-NBR

ARHSET3   COMPANY       This path is used to select records by   AR199   AR242
          BATCH-NBR     batch number.                            AR300   AR42.1
          CUSTOMER                                               AR42.2  AR42.7
          TRANS-TYPE                                             AR43.1
          TRANS-NBR

ARHSET4   COMPANY       This path is used to select records by   AR10.1  AR131
          CUSTOMER      customer number.                         AR150   AR17.1
          TRANS-TYPE                                             AR191   AR227
          TRANS-NBR                                              AR230   AR232
                                                                 AR233   AR234
                                                                 AR271   AR300
                                                                 AR45.1  AR506
                                                                 AR58.1  AR72.1

ARHSET5   TRANS-TYPE    This index is used to access open item   AR130   AR21.4
          TRANS-NBR     records by transaction number            AR21.5  AR30.3
          COMPANY       independent of company.                  AR30.4  AR30.9
                                                                 AR44.3  AR575
                                                                 AR58.1

                         AROIHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcode         ARCODE       Required

                            ARH-COMPANY           -> RCD-COMPANY
                            ARH-AR-CODE           -> RCD-AR-CODE

Arcomp         ARCOMP       Required

                            ARH-COMPANY           -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            ARH-COMPANY           -> ACM-COMPANY
                            ARH-CUSTOMER          -> ACM-CUSTOMER

Arproclevl     ARPROCLEVL   Required

                            ARH-COMPANY           -> APV-COMPANY
                            ARH-PROCESS-LEVEL     -> APV-PROCESS-LEVEL

Aruoihdr       ARUOIHDR     Not Required

                            ARH-COMPANY           -> UIH-COMPANY
                            ARH-TRANS-TYPE        -> UIH-TRANS-TYPE
                            ARH-TRANS-NBR         -> UIH-TRANS-NBR

Blinvhdr       BLINVHDR     Required

                            ARH-COMPANY           -> BLH-COMPANY
                            ARH-BATCH-NBR         -> BLH-BATCH-NBR

Cbbankinst     CBBANKINST   Required

                            ARH-BANK-INST-CODE    -> CBI-BANK-INST-CODE

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP        -> CUD-CUST-GROUP
                            ARH-CUSTOMER          -> CUD-CUSTOMER

Salesrep       SALESREP     Required

                            ARH-COMPANY           -> SAW-COMPANY
                            ARH-SALESMAN          -> SAW-SALESMAN

Terms          TERMS        Required

                            ARH-TERMS-CD          -> TMS-TERMS-CD

                         AROIHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomment      ARCOMMENT    Delete Cascades

                            ARH-COMPANY           -> CMT-COMPANY
                            ARH-CUSTOMER          -> CMT-CUSTOMER
                            "T"                   -> CMT-CMMT-TYPE
                            ARH-TRANS-TYPE        -> CMT-TRANS-TYPE
                            ARH-TRANS-NBR         -> CMT-TRANS-NBR
                                                     CMT-BEG-DATE
                                                     CMT-SEQ-NBR

Ardistrib      ARDISTRIB    Delete Cascades

                            ARH-COMPANY           -> AMD-COMPANY
                            ARH-BATCH-NBR         -> AMD-BATCH-NBR
                            ARH-TRANS-TYPE        -> AMD-TRANS-TYPE
                            ARH-TRANS-NBR         -> AMD-TRANS-NBR
                            ARH-CUSTOMER          -> AMD-CUSTOMER
                                                     AMD-DIST-SEQ

Aroitems       AROITEMS     Delete Cascades

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