Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPAYMENT


                             ARPAYMENT FILE

                               AR Payment

The AR Payment file will contain the detail payment records entered for a
given batch. There are several online and batch programs to input payment
records. A payment record identifies an amount in original and company base
currency, to be used to apply to invoices and debit memos. All payment type
records will be contained in this file including Non-AR type payments.

REFERENCED BY

AR132     AR191     AR220     AR222     AR223     AR228
AR229     AR230     AR233     AR235     AR256     AR286
AR287     AR36.1    AR36.2    AR80.1    AR80.2    BR152
AR10.1    AR251     AR252     AR253     AR255     AR282
AR294     AR301     AR53.1    AR90.1    AR232     AR258
AR194     AR250     AR505     AR17.1    AR27.1    AR271
AR275     AC551     AR219     AR50.1    BR10.1    BR11.1
BR120     BR121     BR122     BR123     BR15.1    BR151
BR155     BR156     BR16.1    BR16.2    BR210     BR211
BR215     BR220     BR251     BR252     BR253     BR420
BR450     BR51.1    BR51.2    BR52.1    BR52.2    BR521
BR53.1    BR55.2    BR91.1    BRIP.1    BRPI.1    IC02.1
IC531     PBIP.1    PR197     TX140     TX40.1    WH110
WH120     WH130     WH132     WH190     WH20.1    WH20.2
WH20.7    WH21.2    WH224     WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    WH33.5    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830
WO30.1

UPDATED BY

AR115     AR124     AR129     AR13.1    AR13.2    AR130
AR131     AR135     AR137     AR150     AR180     AR190
AR198     AR20.1    AR21.1    AR21.2    AR21.3    AR21.4
AR21.5    AR21.6    AR24.1    AR28.1    AR29.1    AR29.2
AR30.1    AR30.2    AR30.3    AR30.4    AR30.8    AR30.9
AR31.5    AR31.6    AR35.1    AR35.2    AR37.1    AR37.2
AR37.3    AR37.4    AR37.5    AR37.6    AR37.7    AR42.1
AR42.2    AR42.6    AR42.7    AR43.1    AR44.3    AR48.3
AR502     AR503     AR504     AR560     AR570     AR575
AR580     AR82.1    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

APM-COMPANY            Numeric 4                                 AR115   AR21.1
Element: Company       Company number.                           AR21.2  AR21.3
                                                                 AR21.4  AR28.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   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

APM-BATCH-NBR          Numeric 6                                 AR115   AR21.1
Element: Batch Number  This identifies the batch to which the    AR21.2  AR21.3
                       entered payments belong.                  AR21.4  AR28.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   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

APM-PAYMENT-SEQ        Numeric 6                                 AR115   AR21.1
Record Sequence                                                  AR21.2  AR21.3
Number                                                           AR21.4  AR28.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   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

APM-STATUS             Numeric 1                                 AR115   AR124
Element: Status        This status indicates where the payment   AR129   AR13.1
                       is in the processing flow. Valid values   AR13.2  AR130
                       are:                                      AR131   AR135
                                                                 AR180   AR198
                       0 = Unreleased                            AR20.1  AR21.1
                       1 = Release, Unassigned                   AR21.2  AR21.3
                       2 = Open Payment                          AR24.1  AR28.1
                       7 = Applied                               AR29.1  AR29.2
                       8 = Closed                                AR30.1  AR30.2
                       9 = Historical                            AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 ...

APM-CUSTOMER           Alpha 9  (Right Justified)                AR115   AR13.1
Element: Customer      The customer that submitted the payment   AR13.2  AR21.1
                       for application.                          AR21.2  AR21.4
                                                                 AR28.1  AR29.1
                                                                 AR30.1  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

APM-BANK-ENTITY        Alpha 15                                  AR21.1  AR28.1
Element: Bank          Represents a bank institution location.   AR570   AR575

APM-BANK-ACCT-NBR      Alpha 17                                  AR21.1  AR28.1
Element: Bank Account NThe bank-assigned account number          AR570   AR575
                       identification to be used for the cash
                       code.

APM-GL-DATE            Numeric 8  (yyyymmdd)                     AR115   AR20.1
Element: Posting Date  This is the date used for posting to      AR21.1  AR21.2
                       general ledger. It will also be used in   AR21.3  AR21.4
                       determining the "as of" aging of          AR29.1  AR29.2
                       applications.                             AR30.1  AR30.2
                                                                 AR30.4  AR37.3
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.1  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

APM-TRANS-TYPE         Alpha 1                                   AR115   AR21.1
Element: Transaction TyThis field indicates the payment type     AR21.2  AR21.3
                       of the transaction. Valid values are:     AR21.4  AR29.1
                                                                 AR29.2  AR30.1
                       N = Non-AR payment                        AR30.2  AR30.4
                       P = Customer payment                      AR42.1  AR42.2
                       B = BOE Payment                           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

APM-TRANS-NBR          Alpha 10  (Right Justified)               AR115   AR21.1
Element: Transaction NuThis is the payment number for the        AR21.2  AR21.3
                       transaction. This can be a check number,  AR21.4  AR29.1
                       wire transfer number, etc. that           AR29.2  AR30.1
                       identifies the transaction.               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

APM-TRAN-AMT           Signed 15.2                               AR115   AR124
Element: Transaction AmBase transaction amount. Transaction      AR20.1  AR21.1
                       amount of the payment record in the       AR21.2  AR21.3
                       company base currency.                    AR21.4  AR21.6
                                                                 AR24.1  AR28.1
                                                                 AR29.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR35.1
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR90.1  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

APM-APPLD-AMT          Signed 15.2                               AR129   AR130
Element: Applied AmountThe amount of the payment that has been   AR131   AR135
                       applied.                                  AR180   AR29.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR44.3  AR48.3
                                                                 AR503   AR504
                                                                 DT150   DT92.1

APM-APPLIED-SEQ        Numeric 5                                 AR129   AR130
Element: Application SeThe total number of applications that     AR131   AR135
                       have been created with this payment.      AR180   AR29.1
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.2
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 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

APM-REMIT-SEQ          Numeric 5                                 AR21.2  AR21.4
Element: Remittance SeqTotal number of remittance records that   AR21.5  AR21.6
                       have been created from the lock box       AR29.1  AR570
                       interface program for this payment.       AR575   AR580

APM-DIST-SEQ           Numeric 4                                 AR190   AR21.3
Distribution           Total number of offset distributions on   AR29.1  AR29.2
Sequence               type "N" payment (Non-AR cash payment).

APM-PROCESS-LEVEL      Alpha 5                                   AR115   AR21.1
Element: Process Level This is the process level for the         AR21.2  AR21.3
                       payment.                                  AR21.4  AR29.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR35.1  AR37.3
                                                                 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

APM-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR29.1  AR29.2
Element: Cancel Date   This is the date the payment was          AR82.1
                       identified as being canceled. The
                       payment is no longer available for
                       application. If the transferred customer
                       field is blank, the cancellation was a
                       Return-to-maker (RTM) payment. If the
                       transferred customer has a value, the
                       cancellation was a transfer to another
                       customer.

APM-TRNS-CUST          Alpha 9                                   AR29.1  AR29.2
Element: Transferred PaThis field will be used to indicate
                       that a payment has been transferred to
                       another customer.

APM-CASH-CODE          Alpha 4                                   AR115   AR21.1
Element: Cash Code     Cash code containing currency indicator   AR21.2  AR21.3
                       and general ledger cash account. This     AR21.4  AR29.1
                       account will be debited with the total    AR29.2  AR30.1
                       amount of all payments in a batch.        AR30.2  AR30.4
                                                                 AR37.3  AR503
                                                                 AR570   AR575
                                                                 AR580

APM-AR-CODE            Alpha 4                                   AR115   AR21.1
Accounts               The received not applied code or          AR21.2  AR21.3
Receivable Code        prepayment code assigned to this          AR21.4  AR21.6
                       payment. This account is credited when    AR29.1  AR29.2
                       payments are entered, and debited when    AR30.1  AR30.2
                       payments are applied.                     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

APM-ORIG-CURRENCY      Alpha 5                                   AR115   AR124
Element: Transaction CuTransaction currency. Currency code of    AR20.1  AR21.1
                       the transaction amount of the payment.    AR21.2  AR21.3
                                                                 AR21.4  AR24.1
                                                                 AR29.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR37.3
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR503
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 CB06.1  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

APM-ORIG-RATE          Signed 12.6                               AR115   AR124
Element: Exchange Rate Exchange rate. This is the rate used to   AR20.1  AR21.1
                       convert a transaction amount from a       AR21.2  AR21.3
                       non-base currency to the company base     AR21.4  AR24.1
                       currency. The rate is maintained in the   AR29.1  AR29.2
                       currency relation file.                   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
                                                                 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

APM-ORIG-AMT           Signed 15.2                               AR115   AR20.1
Element: Transaction AmThis is the amount of the payment in      AR21.1  AR21.2
                       transaction currency.                     AR21.3  AR21.4
                                                                 AR21.6  AR29.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR37.3  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   AR560
                                                                 AR570   AR575
                                                                 AR580   AR90.1
                                                                 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

APM-BASE-DETAIL        Signed 15.2                               AR20.1  AR21.3
Element: Base Detail   This field will be updated with the       AR29.1  AR29.2
                       converted base amount for all             AR570   AR575
                       distributions for any Non-AR payments.    AR580
                       The system will match this amount
                       against the converted total amount of
                       the payment. If differences occur due to
                       rounding during currency conversion, the
                       system will automatically adjust the
                       amount of the last distribution to make
                       the total base amount of the
                       distributions equal to the base
                       transactions.

APM-GROUP-RATE         Signed 12.6                               AR115   AR21.1
Element: Group ExchangeThe rate used to convert a transaction    AR21.2  AR21.4
                       amount from a currency that differs from  AR29.1  AR29.2
                       the base currency to the group 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   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

APM-GROUP-MUDV         Alpha 1                                   AR115   AR21.1
Group                  Group Currency Multiplier or Divider.     AR21.2  AR21.4
Multiply/Divide        Mathematical technique used in            AR29.1  AR29.2
                       conjunction with the currency rate to     AR30.1  AR30.2
                       convert the company base currency amount  AR30.4  AR42.1
                       to the group currency amount.             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

APM-LAST-STA-DATE      Numeric 8  (yyyymmdd)                     AR150   AR503
Element: Last StatementDate of the last statement on which
                       this payment appeared.

APM-ORIG-APP-AMT       Signed 15.2                               AR129   AR130
Element: Payment AmountAmount applied against the payment in     AR131   AR135
                       the payment's transaction currency.       AR180   AR29.1
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.6
                                                                 AR35.1  AR37.3
                                                                 AR44.3  AR48.3
                                                                 AR503   AR504
                                                                 DT150   DT92.1

APM-AR-REFERENCE       Alpha 22  (Lower Case)                    AR115   AR21.2
Element: Ar Reference                                            AR21.6  AR29.1
                                                                 AR29.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR503   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

APM-REF-TYPE           Alpha 1                                   AR21.2  AR21.6
Element: Reference TypeThis field is used along with the         AR29.1  AR29.2
                       Reference field. It indicates the
                       specific type of transaction of the
                       reference field. Valid values are:

                       I = Invoice
                       O = Order
                       D = Debit Memo
                       B = Billing Invoice
                       C = Credit Memo
                       N = Non-Lawson
                       M = Mixed

APM-ORIG-ND            Numeric 1                                 AR115   AR21.1
Element: Number of DeciCurrency decimal indicator.               AR21.2  AR21.3
                                                                 AR21.4  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
                                                                 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

APM-PAYMENT-OPEN       Derived
Element: Payment Open  This field is used as a compute field
                       to calculate open amount. No data is
                       stored in this field. Please refer to
                       the Universe documentation for more
                       information on compute fields.

APM-TYPE-DSP           Derived
Element: Type Display  This field is used as a string field,
                       combining transaction type and
                       transaction number fields for record
                       access. No data is stored in this field.
                       Please refer to the Universe
                       documentation for more information on
                       string fields.

APM-PREPAY-FLAG        Numeric 1                                 AR115   AR21.2
Element: Prepay Flag   Indicates if payment is a prepayment.     AR21.6  AR29.1
                       Valid values are:                         AR29.2

                       0 = Not a Prepay
                       1 = Prepayment

APM-CREDIT-APPLD       Signed 15.2                               AR115   AR130
Credit Application     When a payment is applied  to a credit    AR180   AR30.1
Amount                 memo the amount of application will be    AR30.2  AR30.4
                       stored here.                              AR30.8  AR35.1
                                                                 AR504

APM-ORIG-CR-APPLD      Signed 15.2                               AR115   AR130
Credit Trans           When a payment is applied to a credit     AR180   AR30.1
Applied Amount         memo the amount of application in the     AR30.2  AR30.4
                       currency of the transaction will be       AR30.8  AR35.1
                       stored  here.                             AR504

APM-ADJ-AMT            Signed 15.2                               AR129   AR130
Element: Adjust Amount Payment adjustment amount in company      AR131   AR135
                       base currency.                            AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR48.3
                                                                 AR504

APM-ORIG-ADJ-AMT       Signed 15.2                               AR129   AR130
Transaction Adjust     The amount of the payment adjustment in   AR131   AR135
Amount                 transaction currency.                     AR180   AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.2  AR48.3
                                                                 AR504

APM-CURR-MUDV          Alpha 1                                   AR115   AR21.1
Currency               Currency Multiplier or Divider. This is   AR21.2  AR21.3
Multiply/Divide        used along with the currency rate to      AR21.4  AR30.1
                       compute the company base transaction      AR30.2  AR30.4
                       amount. Valid values are:                 AR503   AR570
                                                                 AR575   AR580
                       M = Multiply
                       D = Divide

APM-HIST-PER           Numeric 2                                 AR180   AR198
Element: Current Period                                          AR29.2

APM-SELECT-SEQ         Numeric 6                                 AR115   AR30.1
Element: Select Seq                                              AR30.2  AR30.4
                                                                 AR30.9

APM-LAST-FC-DATE       Numeric 8  (yyyymmdd)                     AR137   AR29.1
Element: Date

                         ARPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APMSET1   COMPANY       This path is used for record             AR115   AR124
          BATCH-NBR     uniqueness.                              AR129   AR130
          PAYMENT-SEQ                                            AR131   AR132
                                                                 AR135   AR137
                                                                 AR150   AR180
                                                                 AR190   AR191
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR21.4  AR21.5
                                                                 AR21.6  AR220
                                                                 AR222   AR223
                                                                 AR228   AR229
                                                                 AR230   AR233
                                                                 AR235   AR24.1
                                                                 AR256   AR286
                                                                 ...

APMSET10  COMPANY       This path is used to select records in   AR10.1  AR229
          CUSTOMER      customer number order.                   AR251   AR252
          TRANS-TYPE    KeyChange                                AR253   AR255
          TRANS-NBR                                              AR28.7  AR282
          BATCH-NBR                                              AR286   AR287
                                                                 AR29.2  AR294
                                                                 AR30.3  AR301
                                                                 AR53.1  AR90.1
                                                                 DT520

APMSET11  COMPANY       This index was created as a solution to  AR300
          PAYMENT-SEQ   the Find Next/Prev Flag error. It is
          BATCH-NBR     only used where a modify must be done
                        within a 850-FIND-NLT or 850-FIND-BEGRNG
                        loop.

APMSET2   COMPANY       This path is used to select records in   AR115   AR124
          BATCH-NBR     batch number order.                      AR13.1  AR13.2
          TRANS-TYPE    KeyChange                                AR130   AR132
          TRANS-NBR                                              AR191   AR20.1
          CUSTOMER                                               AR21.1  AR21.2
                                                                 AR21.3  AR21.4
                                                                 AR229   AR232
                                                                 AR233   AR24.1
                                                                 AR28.1  AR282
                                                                 AR29.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR300   AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR37.1  AR37.2
                                                                 ...

APMSET3   COMPANY       This path is used to access unassigned   AR13.1  AR13.2
          BANK-ENTITY   payment records by MICR number.          AR258   AR28.1
          BANK-ACCT-NBR KeyChange, Subset
          BATCH-NBR     Where  TRANS-TYPE = "P"
          PAYMENT-SEQ   And   (CUSTOMER   = Spaces
                        Or     CUSTOMER   = "000000000" )

APMSET4   COMPANY       This path is used to access open         AR258   AR28.2
          CASH-CODE     customer payments by cash code.
          GL-DATE       Subset
          BATCH-NBR     Where TRANS-TYPE = "P"
          PAYMENT-SEQ   And   STATUS     = 2

APMSET5   COMPANY       This path is used to access non-AR       AR28.5  AR28.6
          CASH-CODE     payments by cash code.
          GL-DATE       Subset
          BATCH-NBR     Where TRANS-TYPE = "N"
          PAYMENT-SEQ

APMSET6   COMPANY       This path is used to access open         AR129   AR130
          CUSTOMER      customer payments by customer number     AR135   AR137
          GL-DATE       order.                                   AR150   AR194
          BATCH-NBR     KeyChange, Subset                        AR223   AR250
          PAYMENT-SEQ   Where TRANS-TYPE != "N"                  AR251   AR252
                        And   STATUS     =  2                    AR253   AR255
                                                                 AR30.3  AR48.1
                                                                 AR505

APMSET7   TRANS-NBR     This path is used to access payment      AR17.1  AR230
          CUSTOMER      records by payment number order.         AR27.1  AR28.3
          COMPANY       KeyChange                                AR28.4  AR504
          TRANS-TYPE                                             AR90.1  CB191
          BATCH-NBR

APMSET8   COMPANY       This path will be used to select         AR137   AR150
          CUSTOMER      customer payment records that are open   AR194   AR198
          GL-DATE       or not historical.                       AR250   AR251
          TRANS-TYPE    KeyChange, Subset                        AR252   AR253
          TRANS-NBR     Where (STATUS     > 1                    AR255   AR271
          BATCH-NBR     And    STATUS     < 9 )                  AR275
                        And   (TRANS-TYPE = "P"
                        Or     TRANS-TYPE = "B" )

APMSET9   COMPANY       This path is used to select open         AC551   AR130
          CUSTOMER      customer payments or unreleased customer AR219   AR48.1
          GL-DATE       payments.                                AR48.3  AR50.1
          BATCH-NBR     KeyChange, Subset                        AR90.1  BR10.1
          PAYMENT-SEQ   Where (TRANS-TYPE = "P"                  BR11.1  BR120
                        Or     TRANS-TYPE = "B" )                BR121   BR122
                        And   (STATUS     = Zeroes               BR123   BR15.1
                        Or     STATUS     = 2 )                  BR151   BR152
                                                                 BR155   BR156
                                                                 BR16.1  BR16.2
                                                                 BR210   BR211
                                                                 BR215   BR220
                                                                 BR251   BR252
                                                                 BR253   BR420
                                                                 BR450   BR51.1
                                                                 ...

                         ARPAYMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Company     ARCOMP       Required

                            APM-COMPANY          -> ACO-COMPANY

Ar Pymnt Hdr   ARPYMNTHDR   Required

                            APM-COMPANY          -> APH-COMPANY
                            APM-BATCH-NBR        -> APH-BATCH-NBR

Arapmuf        ARAPMUF      Not Required, Delete Cascades

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

Arapselect     ARAPSELECT   Not Required

                            APM-COMPANY          -> AAI-COMPANY
                            APM-CUSTOMER         -> AAI-CUSTOMER
                            APM-BATCH-NBR        -> AAI-BATCH-NBR
                            APM-PAYMENT-SEQ      -> AAI-PAYMENT-SEQ

Arcode         ARCODE       Required

                            APM-COMPANY          -> RCD-COMPANY
                            APM-AR-CODE          -> RCD-AR-CODE

Armicrcust     ARMICRCUST   Required

                            APM-COMPANY          -> AMX-COMPANY
                            APM-BANK-ENTITY      -> AMX-BANK-ENTITY
                            APM-BANK-ACCT-NBR    -> AMX-BANK-ACCT-NBR

Arprepay       ARPREPAY     Not Required, Delete Cascades

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

Arproclevl     ARPROCLEVL   Required

                            APM-COMPANY          -> APV-COMPANY
                            APM-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

Arrtm1         ARRTM        Not Required, Delete Cascades

                            APM-COMPANY          -> RTM-COMPANY
                            APM-CUSTOMER         -> RTM-CUSTOMER
                            APM-TRANS-NBR        -> RTM-TRANS-NBR
                            APM-BATCH-NBR        -> RTM-BATCH-NBR

Custdesc       CUSTDESC     Required
                            When APM-CUSTOMER != Spaces
                            And  APM-CUSTOMER != "000000000"

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            APM-CUSTOMER         -> CUD-CUSTOMER

Customer       ARCUSTOMER   Required
                            When APM-CUSTOMER != Spaces
                            And  APM-CUSTOMER != "000000000"

                            APM-COMPANY          -> ACM-COMPANY
                            APM-CUSTOMER         -> ACM-CUSTOMER

Reverse        REVERSE      Not Required, Delete Restricted

                            APM-COMPANY          -> RVH-COMPANY
                            APM-CUSTOMER         -> RVH-CUSTOMER
                            APM-TRANS-TYPE       -> RVH-TRANS-TYPE
                            APM-TRANS-NBR        -> RVH-INVOICE
                            APM-BATCH-NBR        -> RVH-BATCH-NBR
                            APM-PAYMENT-SEQ      -> RVH-PAYMENT-SEQ

                         ARPAYMENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aradjust       ARADJUST

                            APM-COMPANY          -> ADJ-COMPANY
                            APM-TRANS-TYPE       -> ADJ-TRANS-TYPE
                            APM-TRANS-NBR        -> ADJ-INVOICE
                            APM-PAYMENT-SEQ      -> ADJ-PAYMENT-SEQ
                            APM-BATCH-NBR        -> ADJ-BATCH-NBR
                                                    ADJ-APP-SEQ
                                                    ADJ-ADJ-SEQ

Arapplied      ARAPPLIED    Delete Restricted

                            APM-COMPANY          -> ARA-CR-COMPANY
                            APM-BATCH-NBR        -> ARA-CR-BATCH
                            APM-PAYMENT-SEQ      -> ARA-CR-PYMNT-SEQ
                                                    ARA-COMPANY
                                                    ARA-TRANS-TYPE
                                                    ARA-INVOICE
                                                    ARA-PAYMENT-SEQ
                                                    ARA-BATCH-NBR
                                                    ARA-APP-SEQ

Arcomment      ARCOMMENT

                            APM-COMPANY          -> CMT-COMPANY
                            APM-CUSTOMER         -> CMT-CUSTOMER
                            "T"                  -> CMT-CMMT-TYPE
                            APM-TRANS-TYPE       -> CMT-TRANS-TYPE
                            APM-TRANS-NBR        -> CMT-INVOICE
                                                    CMT-BEG-DATE
                                                    CMT-SEQ-NUMBER

Armemodist     ARDISTRIB    Delete Cascades
                            Valid When APM-TRANS-TYPE = "P"

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

Arremit        ARREMIT      Delete Cascades

                            APM-COMPANY          -> RMI-COMPANY
                            APM-BATCH-NBR        -> RMI-BATCH-NBR
                            APM-PAYMENT-SEQ      -> RMI-PAYMENT-SEQ
                                                    RMI-REMIT-SEQ

Arsadjust      ARSADJUST

                            APM-COMPANY          -> ASJ-COMPANY
                            APM-TRANS-TYPE       -> ASJ-TRANS-TYPE
                            APM-TRANS-NBR        -> ASJ-INVOICE
                            APM-PAYMENT-SEQ      -> ASJ-PAYMENT-SEQ
                                                    ASJ-ADJ-SEQ

Arsapplied     ARSAPPLIED   Delete Cascades

                            APM-COMPANY          -> ASG-CR-COMPANY
                            APM-BATCH-NBR        -> ASG-CR-BATCH
                            APM-PAYMENT-SEQ      -> ASG-CR-PYMNT-SEQ
                                                    ASG-SELECT-SEQ

Non Ar Distrib ARDISTRIB    Delete Cascades
                            Valid When APM-TRANS-TYPE = "N"

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

Reversedtl     REVERSEDTL   Delete Cascades

                            APM-COMPANY          -> RVD-CR-COMPANY
                            APM-BATCH-NBR        -> RVD-CR-BATCH
                            APM-PAYMENT-SEQ      -> RVD-CR-PYMNT-SEQ
                                                    RVD-COMPANY
                                                    RVD-TRANS-TYPE
                                                    RVD-INVOICE
                                                    RVD-PAYMENT-SEQ
                                                    RVD-BATCH-NBR
                                                    RVD-APP-SEQ