Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              AROIHDR FILE

                         AR Transaction Header

The AR Transaction Header is the header record for all transactions in the AR
system. There will be subordinate records to this file that will carry the
individual due dates and amounts for each of the scheduled "due dates" for a
specific transaction.

REFERENCED BY

AR01.1    AR100     AR105     AR110     AR12.1    AR124
AR129     AR131     AR132     AR135     AR136     AR140
AR141     AR150     AR155     AR161     AR180     AR194
AR196     AR20.1    AR21.1    AR21.2    AR21.3    AR21.4
AR21.6    AR21.5    AR230     AR232     AR233     AR235
AR24.1    AR245     AR25.1    AR250     AR251     AR252
AR253     AR255     AR256     AR258     AR274     AR275
AR282     AR286     AR287     AR293     AR294     AR35.1
AR35.2    AR36.1    AR36.2    AR46.1    AR48.1    AR48.3
AR50.1    AR504     AR505     AR506     AR507     AR53.1
AR570     AR575     AR58.1    AR580     AR700     AR72.1
AR74.1    AR80.1    AR80.2    AR90.1    DA90.1    DA91.1
BR11.1    CB06.2    CB191     DT170     DT520     GL235
PHI3.1    WH20.7    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
DT150     DT180     DT181     DT45.1    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  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
                                                                 AR72.1  AR82.1
                     M = Mixed                                   DT92.1

ARH-INVOICE          Alpha 22                                    AR115   AR130
Invoice Number       Used to identify the invoice.               AR137   AR190
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR72.1  AR82.1
                                                                 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  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
                                                                 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  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
                                                                 AR72.1  AR82.1
                                                                 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  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  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
                                                                 AR72.1  AR82.1
                                                                 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
                                                                 AR72.1  AR82.1
                                                                 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  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
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1  DT92.1

ARH-CUST-PO-NBR      Alpha 22                                    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   AR72.1

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

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

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                                 AR72.1  AR82.1
                     D = Debit Memo                              DT92.1
                     C = Credit Memo

ARH-XREF-NBR         Alpha 22                                    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
                                                                 AR72.1  AR82.1
                                                                 DT92.1

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

ARH-XREF-DUE-DATE    Numeric 8  (yyyymmdd)                       AR42.2  AR42.6
Cross Reference Due  The due date of the cross referenced
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.


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  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   AR72.1
                     transaction file.


ARH-TRANS-USER2      Alpha 15                                    AR190   AR42.2
Transaction User 2   A user-defined field.                       AR42.6  AR502
                                                                 AR560   AR72.1

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

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

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

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
                                                                 DT92.1

ARH-SALESMAN         Numeric 4                                   AR115   AR130
SalesRep             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

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

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
                                                                 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
                     C = Cash Payment                            AR30.4  AR30.8
                     D = Bill of Exchange                        AR31.5  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR44.3  AR502
                                                                 AR560   AR82.1

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
                                                                 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
                                                                 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   DT150
                                                                 DT180   DT181
                                                                 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
                     L = Converted data (Lawson)
                     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

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


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

                     T = Taxable
                     E = Exempt

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

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

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

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

ARH-CANCEL-FLAG      Alpha 1                                     AR29.3
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                                     AR31.5  AR42.2
Reason Code          Indicates the reason for memos.             AR42.6  AR42.7

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

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                                     AR137   AR42.2
Late Ch Fl           Late Charge Flag.  Indicate if late         AR42.6  AR560
                     charge is to be applied to the invoice.


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

ARH-LATE-CH-OR-AMT   Signed 15.2                                 AR137
Late Ch Or Amt       The late payment charge amount in
                     transction currrency.

ARH-LATE-CH-TR-AMT   Signed 15.2                                 AR137
Late Ch Tr Amt       The late payment charge amount in
                     company base currency.

ARH-ALT-TYPE         Alpha 1                                     AR115   AR130
Alt Type             C = Credit Memo                             AR137   AR190
                     D = Debit Memo                              AR30.1  AR30.2
                     I = Invoice                                 AR30.4  AR30.8
                                                                 AR31.5  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR82.1

ARH-SUM-LINE         Alpha 1                                     AR130   AR137
Sum Line             N = No                                      AR190   AR30.1
                     Y = Yes                                     AR30.2  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR72.1  AR82.1

ARH-SYSTEM           Alpha 2                                     AR42.2  AR42.7
System Code          A two-character code representing an        AR44.3  AR502
                     application used within the Lawson          AR560   AR82.1
                     system. (i.e.: GL = General Ledger, AP =
                     Accounts Payable, etc.)

ARH-DUN-LTR-IND      Alpha 1
Dun Ltr Ind          Dunning letters in use for customer. Yes
                     or No.  Specified in AR10.1 (customer).
                     Applies only to the advanced dunning
                     process.

ARH-OVERIDE-DUNPRC   Alpha 1                                     AR42.6  AR45.1
Overide Dunprc       Override Dunning Process.

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

ARH-LST-DUNLTR-STM   Numeric 2                                   AR145
Lst Dunltr Stm       Level of the last dunning letter sent
                     as 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 Ltr Date        Date last dunning letter was sent for
                     the invoice.


ARH-LST-LTRTEXT-CD   Alpha 6                                     AR145
Lst Ltrtext Cd       Text Code for last Dunning Letter sent
                     on this invoice.


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

ARH-ASSESS-DUN-FEE   Alpha 1                                     AR145
Assess Dun Fee       Specifies whether to assess a dunning
                     letter fee.


ARH-INV-OBJ-ID       Numeric 12
Inv Obj Id

ARH-AC-CUSTOMER-ID   Alpha 5
Ac Customer Id

                         AROIHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARHSET1   COMPANY       This path is used for record             AR01.1  AR100
          TRANS-TYPE    uniqueness.                              AR105   AR110
          INVOICE                                                AR115   AR12.1
                                                                 AR124   AR129
                                                                 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
                                                                 ...

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                                AR90.1  DA90.1
          TRANS-TYPE                                             DA91.1
          INVOICE

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

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

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

ARHSET6   COMPANY                                                AR131   AR30.1
          ALT-TYPE                                               AR30.2  AR31.5
          INVOICE                                                AR42.2  AR42.7
                                                                 AR560   BR11.1
                                                                 PHI3.1  WH20.7

                         AROIHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Not Required

                            ARH-TRANS-USER1       -> CNT-CONTRACT

Achisthdr      ACHISTHDR    Not Required

                            ARH-TRANS-USER1       -> HIH-CONTRACT
                            ARH-COMPANY           -> HIH-COMPANY
                            ARH-CUSTOMER          -> HIH-CUSTOMER
                            CNT-AC-CUSTOMER-ID    -> HIH-AC-CUSTOMER-ID
                            ARH-INVOICE           -> HIH-INVOICE

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-INVOICE           -> UIH-INVOICE

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-INVOICE           -> CMT-INVOICE
                                                     CMT-BEG-DATE
                                                     CMT-SEQ-NUMBER

Ardistrib      ARDISTRIB    Delete Cascades

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

Aroitems       AROITEMS     Delete Cascades

                            ARH-COMPANY           -> ARO-COMPANY
                            ARH-TRANS-TYPE        -> ARO-ALT-TYPE
                            ARH-INVOICE           -> ARO-INVOICE
                                                     ARO-PAYMENT-SEQ