Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPYMNTHDR


                            ARPYMNTHDR FILE

                            AR Payment Batch

The AR Payment Batch file contains the batch header information for payments
entered into the system. Batch header records include balancing controls,
transaction dates, currency indicators and other information regarding all
payments in that batch.

REFERENCED BY

AR01.1    AR129     AR13.1    AR13.2    AR130     AR131
AR135     AR137     AR150     AR190     AR220     AR223
AR228     AR229     AR230     AR275     AR28.1    AR28.3
AR28.4    AR28.7    AR282     AR286     AR287     AR31.1
AR31.5    AR31.6    AR35.1    AR35.2    AR36.1    AR37.1
AR37.2    AR37.7    AR48.1    AR48.3    AR504     AR53.1
AR82.1    AR199     AR222

UPDATED BY

AR115     AR124     AR20.1    AR21.1    AR21.2    AR21.3
AR21.4    AR21.6    AR24.1    AR29.1    AR29.2    AR30.1
AR30.2    AR30.4    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR502     AR503     AR560     AR570
AR575     AR580     CB06.1    CB06.2    CB191     DT150
DT155     DT160     DT165     DT166     DT180     DT30.1
DT30.2    DT40.1    DT45.1    DT520     DT60.1    DT60.2
DT70.1    DT70.3    DT80.1    DT85.1    DT85.2    DT92.1
AR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APH-COMPANY            Numeric 4                                 AR115   AR20.1
Element: Company       Company number.                           AR24.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-BATCH-NBR          Numeric 6                                 AR115   AR20.1
Element: Batch Number  This is the identifying number of a       AR24.1  AR42.1
                       group of payments within a company.       AR42.2  AR42.6
                       There is an option to have this number    AR42.7  AR43.1
                       assigned automatically or manually        AR44.3  AR502
                       entered.                                  AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-PROCESS-LEVEL      Alpha 5                                   AR115   AR20.1
Element: Process Level This is the process level of the batch.   AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-STATUS             Numeric 1                                 AR115   AR124
Element: Status        This is the status of the batch of        AR20.1  AR21.1
                       payments. Valid values are:               AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                       0 = Open batch - unreleased               AR30.2  AR30.4
                       1 = Released batch                        AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-OPR-CODE           Alpha 10  (Lower Case)                    AR115   AR20.1
Element: Requester     This will contain the operator code of    AR42.1  AR42.2
                       the individual entering cash. This will   AR42.6  AR42.7
                       either be a valid operator code or the    AR43.1  AR44.3
                       individual's signon identification.       AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-DEPOSIT-DATE       Numeric 8  (yyyymmdd)                     AR115   AR20.1
Element: Deposit Date  Deposit date to be recognized for this    AR42.1  AR42.2
                       batch of payments.                        AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-GL-DATE            Numeric 8  (yyyymmdd)                     AR115   AR20.1
Element: Posting Date  General ledger transaction date for       AR286   AR287
                       posting the entire batch to General       AR42.1  AR42.2
                       Ledger.                                   AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-CASH-CODE          Alpha 4                                   AR115   AR20.1
Accounts Receivable    Cash code containing default general      AR503   AR570
Code                   ledger cash account.                      AR575   AR580
                                                                 CB06.2

APH-CURRENCY-CD        Alpha 5                                   AR115   AR20.1
Element: Currency Code Currency code tied to the cash code       AR42.1  AR42.2
                       entered for the batch.                    AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-ORIG-RATE          Signed 12.6                               AR115   AR20.1
Element: Exchange Rate The rate used to convert a transaction    AR42.1  AR42.2
                       amount from a non-base currency to the    AR42.6  AR42.7
                       company base currency.                    AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-CURR-MUDV          Alpha 1                                   AR115   AR20.1
Currency               Currency Multiplier or Divider.           AR42.1  AR42.2
Multiply/Divide        Mathematical technique used in            AR42.6  AR42.7
                       conjunction with the currency exchange    AR43.1  AR44.3
                       rate to convert the transaction currency  AR502   AR503
                       amount to the company base currency       AR560   AR570
                       amount. Valid values are:                 AR575   AR580
                                                                 CB06.2  DT150
                       D = Divide                                DT155   DT160
                       M = Multiply                              DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-GROUP-RATE         Signed 12.6                               AR115   AR20.1
Element: Group ExchangeThe rate used to convert a transaction    AR42.1  AR42.2
                       amount from a currency that differs from  AR42.6  AR42.7
                       the customer group currency to the        AR43.1  AR44.3
                       customer group currency.                  AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-GROUP-MUDV         Alpha 1                                   AR115   AR20.1
Group                  Group Currency Multiplier or Divider.     AR42.1  AR42.2
Multiply/Divide        Mathematical technique used in            AR42.6  AR42.7
                       conjunction with the group currency       AR43.1  AR44.3
                       exchange rate to convert the company      AR502   AR503
                       base currency amount to the group         AR560   AR570
                       currency amount. Valid values are:        AR575   AR580
                                                                 CB06.2  DT150
                       D = Divide                                DT155   DT160
                       M = Multiply                              DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-BASE-CASH          Signed 15.2                               AR115   AR20.1
Element: Base Cash AmouTotal amount of cash in the company       AR21.1  AR21.2
                       base currency for a particular batch.     AR21.3  AR21.4
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-BASE-RNA           Signed 15.2                               AR115   AR20.1
Element: Base RNA AmounTotal amount going to the Received Not    AR21.1  AR21.2
                       Applied account valued in the company     AR21.3  AR21.4
                       base currency.                            AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-RNA-TOTAL          Signed 15.2                               AR115   AR20.1
Element: RNA Total     This will contain the transaction         AR21.1  AR21.2
                       currency value of the RNA amount for      AR21.3  AR21.4
                       type "P" payments.                        AR30.1  AR30.2
                                                                 AR30.4  AR503
                                                                 AR570   AR575
                                                                 AR580   CB06.2

APH-LOCK-BOX           Alpha 2                                   AR115   AR20.1
Element: Lock Box      Lock box code identifier for this         AR570   AR575
                       batch.                                    AR580

APH-LOC-BOX-BATCH      Numeric 3                                 AR570
Element: Lock Box BatchThis will be the batch number from the
                       lock box interface batch header record.
                       It will be for reference purposes only.

APH-BATCH-TOTAL        Signed 15.2                               AR115   AR20.1
Element: Detail Total  Control total representing total amount   AR24.1  AR42.1
                       of payment records in transaction         AR42.2  AR42.6
                       currency for this batch.                  AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-BATCH-COUNT        Signed 5.0                                AR115   AR20.1
Element: Batch Count   Control total representing total number   AR24.1  AR42.1
                       of payment records within this batch.     AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-ADDTNL-AMT         Signed 15.2                               AR115   AR20.1
Element: Additional AmoThis will hold any additional charges     AR570   AR580
                       that may have been incurred from the
                       bank. This has no affect on the total
                       amount of cash in the batch.
                       Example: A charge for currency exchange
                       transactions may be entered on the batch
                       header screen. The offset general ledger
                       account entered will be debited, and the
                       general ledger cash account will be
                       credited.

APH-ACCT-UNIT          Alpha 15                                  AR115   AR20.1
Element: Accounting UniThis will be the accounting unit that     AR580
                       the additional charges will be posted
                       to. The offset will be the cash account
                       of that batch.

APH-ACCOUNT            Numeric 6                                 AR115   AR20.1
Element: Account       This will be the account that the         AR580
                       additional charges will be posted to.
                       The offset will be the cash account of
                       that batch.

APH-SUB-ACCT           Numeric 4                                 AR115   AR20.1
Element: Subaccount    This will be the sub-account the          AR580
                       additional charges will be posted to.
                       The offset will be the cash account of
                       that batch.

APH-DETAIL-TOTAL       Signed 15.2                               AR115   AR20.1
Element: Detail Total  Detail total representing actual total    AR21.1  AR21.2
                       of payment records in transaction         AR21.3  AR21.4
                       currency entered for this batch.          AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-DETAIL-COUNT       Signed 5.0                                AR115   AR20.1
Element: Detail Count  Detail count representing actual number   AR21.1  AR21.2
                       of payment records entered in this        AR21.3  AR21.4
                       batch.                                    AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-LAST-LOG-SEQ       Numeric 6                                 AR115   AR21.1
Record Sequence        Sequence counter representing order of    AR21.2  AR21.3
Number                 record input within a batch. This field   AR21.4  AR29.1
                       is used for sequential batch reviews and  AR29.2  AR30.1
                       record uniqueness.                        AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-ORIG-ND            Numeric 1                                 AR115   AR20.1
Element: Number of DeciCurrency decimal indicator.               AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-REFERENCE          Alpha 10  (Lower Case)                    AR115   AR20.1
Element: Requester     The batch header reference.               AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR575   AR580
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-NOT-APPLD-CD       Alpha 4                                   AR115   AR20.1
Element: RNA Code      The default received not applied GL       AR42.1  AR42.2
                       code. The general ledger account          AR42.6  AR42.7
                       represented by this code will be debited  AR43.1  AR44.3
                       for each payment applied, if a            AR502   AR503
                       prepayment GL code is not present for     AR560   AR570
                       that payment.                             AR575   AR580
                                                                 CB06.2  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-PRE-PAY-CODE       Alpha 4                                   AR115   AR20.1
Element: Prepayment CodThe default prepayment GL code. The       AR42.1  AR42.2
                       general ledger account represented by     AR42.6  AR42.7
                       this code will be debited for each        AR43.1  AR44.3
                       payment applied, if a received not        AR502   AR560
                       applied GL code is not present for that   AR570   AR575
                       payment.                                  AR580   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-DEP-INST-CODE      Alpha 3                                   AR115   AR124
Deposit Bank           The deposit bank transaction code of      AR20.1  AR21.1
Transaction Code       the payment header. It must exist in the  AR21.2  AR21.3
                       Lawson Cash Ledger system.                AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-TRANS-IDENT        Numeric 10                                AR115   AR124
Element: Transaction IDA unique system-generated                 AR20.1  AR21.1
                       identification value assigned to the      AR21.2  AR21.3
                       transaction to make this record unique.   AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

APH-ADJ-INST-CODE      Alpha 3                                   AR115   AR124
Adjustment Bank        The adjustment bank transaction code of   AR20.1  AR21.1
Trans Code             the payment header. It must be set up in  AR21.2  AR21.3
                       the Lawson Cash Ledger system.            AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   CB191

APH-ADJ-TRANS-IDNT     Numeric 10                                AR115   AR124
Adjustment Trans ID    A unique system-generated                 AR20.1  AR21.1
Code                   identification value assigned to the      AR21.2  AR21.3
                       transaction to make this record unique.   AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   CB191

APH-JRNL-BOOK-NBR      Alpha 12                                  AR115   AR20.1
Element: Journal Book NThis field contains the journal book      AR42.1  AR42.2
                       number for the payment batch header.      AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR570   AR575
                                                                 AR580   CB06.2
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

APH-RECON-STMT-NBR     Numeric 12                                AR20.1  CB06.2
Bank Statement         The bank-assigned reconciliation
Number                 statement number. Used only for cash
                       codes that require reconciliation
                       statements.

APH-JBK-SEQ-NBR        Numeric 10                                AR20.1  CB06.2
Journal Book           The journal book sequence number
Sequence Number        assigned to a journal book transaction
                       when it is added or interfaced to the
                       Lawson system. Used only when  Auto
                       Journal Book Seq Nbr is set to Yes in
                       GL10.1 (Company).

                         ARPYMNTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APHSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR115
          BATCH-NBR     and selection.                           AR124   AR129
                                                                 AR13.1  AR13.2
                                                                 AR130   AR131
                                                                 AR135   AR137
                                                                 AR150   AR190
                                                                 AR20.1  AR20.2
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR21.4
                                                                 AR21.5  AR21.6
                                                                 AR21.7  AR220
                                                                 AR223   AR228
                                                                 AR229   AR230
                                                                 AR24.1  AR275
                                                                 AR28.1  AR28.3
                                                                 ...

APHSET2   COMPANY       This path is used to select unreleased   AR124   AR199
          BATCH-NBR     records.                                 AR24.1
                        Subset
                        Where STATUS = Zeroes

APHSET3   COMPANY       This path is used to select records in   AR124   AR220
          GL-DATE       general ledger date order.               AR222   AR228
          BATCH-NBR     KeyChange                                AR300

APHSET4   DEP-INST-CODE This path is used to allow drill down
          TRANS-IDENT   from cash ledger screens back into the
                        payment header file.
                        KeyChange, Subset
                        Where DEP-INST-CODE != Spaces

APHSET5   ADJ-INST-CODE This path is used to allow drill down
          ADJ-TRANS-IDNTfrom cash ledger screens back into the
                        payment header file for any bank
                        charges entered.
                        KeyChange, Subset
                        Where ADJ-INST-CODE != Spaces

                         ARPYMNTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Company     ARCOMP       Required

                            APH-COMPANY          -> ACO-COMPANY  (ACOSET1)

Ar Lock Box    ARLOCKBOX    Required
                            When APH-LOCK-BOX != Spaces

                            APH-LOCK-BOX         -> ARL-LOCK-BOX

Ar Process Lvl ARPROCLEVL   Required

                            APH-COMPANY          -> APV-COMPANY
                            APH-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

Aroptr         AROPTR       Required
                            When APH-OPR-CODE != Spaces

                            APH-COMPANY          -> AOP-COMPANY
                            APH-OPR-CODE         -> AOP-OPR-CODE

Arupmnthdr     ARUPMNTHDR   Not Required

                            APH-COMPANY          -> UPH-COMPANY
                            APH-BATCH-NBR        -> UPH-BATCH-NBR

                         ARPYMNTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Pymnt Detls ARPAYMENT    Delete Cascades

                            APH-COMPANY          -> APM-COMPANY
                            APH-BATCH-NBR        -> APM-BATCH-NBR
                                                    APM-PAYMENT-SEQ