Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPAYMENT


                             APPAYMENT FILE

                            Invoice Payment

The Invoice Payment file contains invoice payment records. Each invoice in
the Accounts Payable Invoice file has one or more corresponding invoice
payment records in this file. A split invoice (partially paid invoice) has at
least two invoice payment records.

AP150 (Cash Requirements) and AP151 (Bill of Exchange Generation) access this
file to select invoices for payment.

REFERENCED BY

AM19.1    AM19.2    AM19.4    AP131     AP136     AP178
AP195     AP197     AP198     AP213     AP220     AP240
AP282     AP284     AP57.2    AR48.3    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    EE230     MA168
MA180     MA279     MA530     MA531     MA63.1    MA67.2
MA67.3    MA80.1    MAED.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    PR277
UK277     RQ10.1    RQ10.2    WH20.2    WH20.7    AP00.5
AP145     AP146     AP230     AP245     AP250     AP270
AC160     AM115     AM117     AM15.1    AM15.2    AM15.3
AM15.4    AM20.1    AM20.3    AM21.1    AM21.3    AM500
AM51.1    AM551     AM97.1    AP03.3    AP10.1    AP110
AP210     AP510     AP90.1    AP90.5    AP91.1    AP92.2
API3.1    API4.1    MX123     MX500     PD235     PO10.1
PO120     PO220     PO223     PO233     PO253     PO254
PO278     PO54.1    PO54.2    PO54.3    PO54.4    PR05.1
PR05.3    PR226     PR247     PR26.1    PR47.1    PR514
UK47.1    EE30.1    AP156     AP265     CB186     CB187
CB286     AP255     CB170

UPDATED BY

AP101     AP102     AP115     AP125     AP126     AP141
AP150     AP151     AP155     AP160     AP161     AP170
AP180     AP181     AP190     AP191     AP193     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.6    AP20.7
AP20.8    AP21.1    AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP28.1    AP28.2    AP30.1    AP30.3    AP30.4
AP300     AP32.1    AP35.1    AP36.1    AP40.1    AP45.1
AP520     AP55.1    AP55.2    AP56.1    AP56.2    API1.1
API2.1    CB06.2    CB191     EE135     EE35.1    EE35.2
EE520     ET542     ET545     MA310     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA60.2    MA60.4    MA61.1    MA65.1    MA66.2
MA66.3    MA68.2    MA68.4    MA70.1    MA75.1    MAI1.1
AP305

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APP-COMPANY            Numeric 4                                 AP180   AP181
Element: Company       The company number associated with the    AP190   AP20.1
                       invoice payment. Must be a valid record   AP20.2  AP20.3
                       in the Accounts Payable Company file.     AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP32.1  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-VENDOR             Alpha 9  (Right Justified)                AP115   AP180
Element: Vendor        The vendor number associated with the     AP181   AP190
                       invoice payment. Must be a valid record   AP20.1  AP20.2
                       in the Vendor file.                       AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice       The invoice number. Must be a valid       AP181   AP190
                       record in the Accounts Payable Invoice    AP20.1  AP20.2
                       file.                                     AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-SUFFIX             Numeric 3                                 AP170   AP180
Element: Suffix        The invoice suffix number. Represents     AP181   AP190
                       the occurrence value of the invoice for   AP193   AP20.8
                       recurring invoices, employee advances,    AP25.1  AP25.2
                       and prepayment credit memos.              AP28.1  AP28.2
                                                                 AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API2.1
                                                                 MA70.1  MA75.1

APP-CANCEL-SEQ         Numeric 4                                 AP180   AP181
Element: Seq Nbr       The sequence number assigned upon the     AP190   AP28.1
                       cancellation of a distributed invoice.    AP28.2  AP30.4
                       The first sequence assigned is 9999.      AP32.1  AP45.1

APP-SEQ-NBR            Numeric 4                                 AP170   AP180
Element: Seq Nbr       An automatically assigned sequence        AP181   AP190
                       number.                                   AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-VOID-SEQ           Numeric 4                                 AP180   AP181
Element: Seq Nbr       The void sequence for the invoice         AP190   AP28.1
                       payment. Used by the system to keep       AP28.2  AP32.1
                       payment records unique each time a        AP45.1
                       payment is voided and the invoice is
                       reinstated for payment.

APP-VOID-DATE          Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Date          The date assigned to a voided payment     AP190   AP28.1
                       associated with the invoice payment       AP28.2  AP45.1
                       record.

APP-INV-CURRENCY       Alpha 5                                   AP180   AP181
Element: To Base Curr  The currency of the invoice. Must be a    AP190   AP20.1
                       valid record in the Currency Code file.   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-PAY-VENDOR         Alpha 9  (Right Justified)                AP115   AP180
Element: Pay Vendor    The pay vendor associated with the        AP181   AP190
                       invoice payment. Represents the vendor    AP20.1  AP20.2
                       that will receive payment for the         AP20.3  AP20.4
                       invoice. Must be a valid record in the    AP20.5  AP20.6
                       Vendor file.                              AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 AP56.2  API1.1
                                                                 API2.1  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-REMIT-TO-CODE      Alpha 4                                   AP115   AP180
Element: Remit To Code The remit-to location associated with     AP181   AP190
                       the invoice payment. Must be a valid      AP20.1  AP20.2
                       record in the Vendor Location file.       AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APP-PAY-COMPANY        Numeric 4                                 AP151   AP180
Element: Pay Company   The company associated with the pay       AP181   AP190
                       vendor. Must be a valid record in the     AP20.1  AP20.2
                       Accounts Payable Company file.            AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  API1.1
                                                                 API2.1  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-CASH-CODE          Alpha 4                                   AP115   AP150
Element: Cash Code     The cash code assigned to the invoice.    AP151   AP160
                       Represents the bank account the invoice   AP161   AP180
                       payment is to be paid from. Must be a     AP181   AP190
                       valid record in the Cash Code file.       AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 AP56.1  AP56.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-DUE-DATE           Numeric 8  (yyyymmdd)                     AP170   AP180
Element: Due Date      The invoice due date. AP150 and AP151     AP181   AP190
                       use this date to determine whether to     AP193   AP20.1
                       schedule the invoice payment and whether  AP20.2  AP20.3
                       to take a discount, if applicable.        AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APP-ENCLOSURE          Alpha 1                                   AP180   AP181
Element: All Flag      Indicates whether the invoice payment     AP190   AP20.1
                       requires an enclosure. Valid values are:  AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       N = No.                                   AP20.6  AP20.7
                       Y = Yes.                                  AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-HOLD-FLAG          Alpha 1                                   AP125   AP126
Element: Hold Flag     Indicates whether the invoice payment     AP141   AP150
                       is on hold. If this field is Yes, AP150   AP170   AP180
                       or AP151 will not select the invoice      AP181   AP190
                       payment. Valid values are:                AP193   AP20.1
                                                                 AP20.2  AP20.3
                       Y = Yes. Invoice payment is on hold.      AP20.4  AP20.5
                       Blank = Invoice payment is not on hold.   AP20.6  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP30.4
                                                                 AP32.1  AP35.1
                                                                 AP36.1  AP40.1
                                                                 AP45.1  AP520
                                                                 AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 ET542   ET545
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA60.2  MA60.4
                                                                 MA61.1  MA65.1
                                                                 MA68.2  MA68.4
                                                                 MA70.1  MA75.1
                                                                 ...

APP-VEN-CLASS          Alpha 3                                   AP115   AP180
Element: Ven Class     The vendor class associated with the      AP181   AP190
                       invoice payment. Must be a valid record   AP20.1  AP20.2
                       in the Vendor Class file.                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-VEN-PRIORITY       Numeric 2                                 AP115   AP180
Element: Ven Priority  The payment priority defined for the      AP181   AP190
                       vendor. Valid values are 1 (highest       AP20.1  AP20.2
                       priority) through 99 (lowest priority).   AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                       00                                        AP20.7  AP20.8
                       99                                        AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-PROC-GRP           Alpha 4  (Lower Case)                     AP102   AP115
Element: Process Group The process group assigned to the         AP180   AP181
                       payment. A process group is an            AP190   AP20.1
                       identifier used for separating vendors    AP20.2  AP20.3
                       into different groups to enable           AP20.4  AP20.5
                       concurrent processing within the cash     AP20.6  AP20.7
                       payment cycle. Must be a valid record in  AP20.8  AP21.1
                       the Process Group file.                   AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-BASE-PMT-AMT       Signed 18.2                               AP170   AP180
Base Payment Amount    The amount of the invoice payment in      AP181   AP190
(at entry)             the company base currency. This amount    AP193   AP20.1
                       is calculated using the currency          AP20.2  AP20.3
                       exchange rate in effect when the invoice  AP20.4  AP20.5
                       payment was created.                      AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA60.2  MA60.4
                                                                 MA61.1  MA65.1
                                                                 MA68.2  MA68.4
                                                                 MAI1.1

APP-BASE-ACT-AMT       Signed 18.2                               AP170   AP180
Base Payment Amount    The amount of the invoice payment in      AP181   AP190
(revalued)             the company base currency. For non-base   AP191   AP193
                       currency invoices, this amount may be     AP20.1  AP20.2
                       updated when currency revaluation takes   AP20.3  AP20.4
                       place to account for exchange rate        AP20.5  AP20.6
                       fluctuations.                             AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP30.4  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA43.6
                                                                 MA60.2  MA60.4
                                                                 MA61.1  MA65.1
                                                                 MA68.2  MA68.4
                                                                 MAI1.1

APP-BASE-ND            Numeric 1                                 AP180   AP181
Element: Base Nd       The number of decimal places defined      AP190   AP20.1
                       for the company base currency.            AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-TRAN-PMT-AMT       Signed 18.2                               AP180   AP181
Element: Intl Amt      The amount of the invoice payment in      AP190   AP20.1
                       the currency of the invoice.              AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP30.4
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 AP56.2  API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA43.6  MA60.2
                                                                 MA60.4  MA61.1
                                                                 MA65.1  MA68.2
                                                                 MA68.4  MAI1.1

APP-TRAN-ND            Numeric 1                                 AP180   AP181
Element: Acct Nd       The number of decimal places defined      AP190   AP20.1
                       for the invoice currency.                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-BANK-CHK-AMT       Signed 18.2                               AP150   AP170
Bank Account           The amount of the invoice payment in      AP180   AP181
Currency Amount        the currency of the bank account (cash    AP190   AP20.1
                       code).                                    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 CB06.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA70.1  MA75.1

APP-BANK-ND            Numeric 1                                 AP150   AP170
Bank Account           The number of decimal places defined      AP180   AP181
Currency Decimals      for the bank account currency.            AP190   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-BASE-DISC-AMT      Signed 18.2                               AP150   AP170
Element: Intl Amt      The amount of the available discount      AP180   AP181
                       for the invoice payment in the company    AP190   AP191
                       base currency.                            AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APP-TRAN-DISC-AMT      Signed 18.2                               AP150   AP170
Element: Intl Amt      The amount of the available discount      AP180   AP181
                       for the invoice payment in the currency   AP190   AP20.1
                       of the invoice.                           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APP-BASE-CHK-AMT       Signed 18.2                               AP150   AP170
Element: Intl Amt      The net payment amount for the invoice    AP180   AP181
                       in the company base currency.             AP190   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-TRAN-CHK-AMT       Signed 18.2                               AP150   AP170
Element: Intl Amt      The net payment amount for the invoice    AP180   AP181
                       in the currency of the invoice.           AP190   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-BASE-INC-WH        Signed 18.2                               AP150   AP170
Element: Intl Amt      The reportable income withholding         AP180   AP181
                       amount in the company base currency.      AP190   AP193
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1

APP-TRAN-INC-WH        Signed 18.2                               AP150   AP170
Element: Intl Amt      The reportable income withholding         AP180   AP181
                       amount in the currency of the invoice.    AP190   AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520

APP-TRAN-INC-AMT       Signed 18.2                               AP170   AP180
Element: Intl Amt      The portion of the invoice amount         AP181   AP190
                       classified as reportable income.          AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-GAINLOS-AMT        Signed 18.2                               AP170   AP180
Element: Gain or Loss AThe currency gain or loss amount. This    AP181   AP190
                       amount is calculated when the invoice is  AP193   AP28.1
                       revalued to account for currency          AP28.2  AP45.1
                       exchange rate fluctuations.               MA70.1  MA75.1

APP-UNRL-REV-DATE      Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Date          The date of the last currency             AP190   AP191
                       revaluation that resulted in the          AP28.1  AP28.2
                       creation of an unrealized gain or loss    AP30.3  AP45.1
                       transaction.

APP-ACT-CNV-RATE       Signed 14.7                               AP170   AP180
Currency Exchange      The currency exchange rate used to        AP181   AP190
Rate                   convert the invoice payment amount to     AP191   AP193
                       the company base currency. This field     AP20.1  AP20.2
                       may be updated when the invoice is        AP20.3  AP20.4
                       revalued.                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-DSC-ACCT-UNIT      Alpha 15                                  AP170   AP180
Element: Acct Unit     The accounting unit used for posting      AP181   AP190
                       the discount amount to the general        AP193   AP20.1
                       ledger. Must be a valid accounting unit   AP20.2  AP20.3
                       in the Lawson General Ledger system.      AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-DSC-ACCOUNT        Numeric 6                                 AP170   AP180
Element: Account       The account number used for posting the   AP181   AP190
                       discount amount to the general ledger.    AP193   AP20.1
                       Must be a valid account in the Lawson     AP20.2  AP20.3
                       General Ledger system.                    AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-DSC-SUB-ACCT       Numeric 4                                 AP170   AP180
Element: Sub Acct      The subaccount number used for posting    AP181   AP190
                       the discount amount to the general        AP193   AP20.1
                       ledger. Must be a valid subaccount in     AP20.2  AP20.3
                       the Lawson General Ledger system.         AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-DISCOUNT-RT        Percent 5.3  (Percent)                    AP180   AP181
Element: Discount Rt   The rate used to calculate the discount   AP190   AP20.1
                       amount of the invoice payment.            AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APP-DISC-DATE          Numeric 8  (yyyymmdd)                     AP150   AP170
Element: Date          The date through which the available      AP180   AP181
                       discount amount of the invoice can be     AP190   AP193
                       taken.                                    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APP-TRANS-IDENT        Numeric 10                                AP150   AP151
Element: Transaction IDA sequencing number created by AP150      AP170   AP180
                       (Cash Requirements) or AP151 (Bill of     AP181   AP190
                       Exchange Generation) to sequence          AP193   AP20.1
                       payments. Used to link the Invoice        AP20.2  AP20.3
                       Payment record with the associated        AP20.4  AP20.5
                       Accounts Payable Cash Payment record.     AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-ACCR-CODE          Alpha 4                                   AP180   AP181
Element: Invoice AccruaThe invoice accrual code assigned to      AP190   AP20.1
                       the invoice. Used to default a general    AP20.2  AP20.3
                       ledger accrual account to the invoice.    AP20.4  AP20.5
                       Must be a valid record in the Invoice     AP20.6  AP20.7
                       Accrual Code file.                        AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-PROC-LEVEL         Alpha 5                                   AP180   AP181
Element: Process Level The process level associated with the     AP190   AP20.1
                       invoice. Must be a valid record in the    AP20.2  AP20.3
                       Accounts Payable Process Level file.      AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-REC-STATUS         Numeric 1                                 AP125   AP126
Element: Rec Status    The record status. Valid values are:      AP150   AP151
                                                                 AP155   AP160
                       0 = Unreleased                            AP161   AP170
                       1 = Released                              AP180   AP181
                       2 = Selected for Payment                  AP190   AP193
                       3 = Paid with a System Cash Payment       AP20.1  AP20.2
                       4 = Paid with a Manual Payment            AP20.3  AP20.4
                       5 = Paid with a Bill of Exchange Payment  AP20.5  AP20.7
                       7 = Unreleased Manual Payment             AP20.8  AP21.1
                       8 = Canceled (bill of exchange)           AP23.1  AP25.1
                       9 = Historical                            AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                       Note: All void status invoice payment     AP28.2  AP30.3
                       records should have a historical status.  AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  API1.1
                                                                 API2.1  CB06.2
                                                                 CB191   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA61.1
                                                                 MA66.3  MA70.1
                                                                 MA75.1  MAI1.1

APP-TRANS-NBR          Alpha 10  (Right Justified)               AP151   AP155
Element: Payment NumberThe system or manual payment number       AP160   AP161
                       used to pay the invoice payment.          AP170   AP180
                                                                 AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-CHK-SUFFIX         Numeric 3                                 AP180   AP181
Payment Suffix         The system or manual payment suffix       AP190   AP20.8
Number                 number used to pay the invoice payment.   AP28.1  AP28.2
                                                                 AP45.1  AP56.1
                                                                 AP56.2  MA70.1
                                                                 MA75.1

APP-BANK-INST-CODE     Alpha 3                                   AP115   AP150
Element: Payment Code  The payment code assigned to the          AP160   AP161
                       invoice payment. Represents a type of     AP180   AP181
                       cash or bill of exchange payment used to  AP190   AP20.1
                       pay the invoice payment. Must be a valid  AP20.2  AP20.3
                       cash payment or bill of exchange payment  AP20.4  AP20.5
                       transaction code record in the Bank       AP20.6  AP20.7
                       Transaction Code file.                    AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-CHECK-DATE         Numeric 8  (yyyymmdd)                     AP155   AP160
Element: Payment Date  The date assigned to the system or        AP161   AP170
                       manual payment associated with the        AP180   AP181
                       invoice payment record.                   AP190   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA279   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA70.1  MA75.1

APP-INCOME-CODE        Alpha 4                                   AP180   AP181
Element: Income Code   The income code assigned to the invoice   AP190   AP20.1
                       payment record. Used to track vendor      AP20.2  AP20.3
                       reportable income. Must be a valid        AP20.4  AP20.5
                       record in the Income Code file.           AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-SEP-CHK-FLAG       Alpha 1                                   AP170   AP180
Element: Separate PaymeIndicates whether the payment should be   AP181   AP190
                       made on a separate payment form from      AP20.1  AP20.2
                       other payments to the same vendor. Valid  AP20.3  AP20.4
                       values are:                               AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                       N = No.                                   AP21.1  AP23.1
                       Y = Yes.                                  AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-PAY-IMM-FLAG       Alpha 1                                   AP170   AP180
Element: Pay ImmediatelIndicates whether the invoice is to be    AP181   AP190
                       paid immediately regardless of the        AP20.1  AP20.2
                       invoice due date. Valid values are:       AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                       N = No.                                   AP20.7  AP20.8
                       Y = Yes.                                  AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP40.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-DISC-LOST-FLG      Alpha 1                                   AP150   AP170
Element: Discount Lost Indicates whether the available           AP180   AP181
                       discount for the invoice payment was      AP190   AP193
                       lost. Valid values are:                   AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                       N = No.                                   AP20.5  AP20.6
                       Y = Yes.                                  AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-ANTICIPATION       Alpha 1                                   AP180   AP181
Anticipation           Indicates whether anticipation criteria   AP190   AP20.1
Discount               should be used to calculate the discount  AP20.2  AP20.3
                       amount for the invoice payment. Valid     AP20.4  AP20.5
                       values are:                               AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                       Y = Yes.                                  AP23.1  AP28.1
                       N = No.                                   AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-INVOICE-GROUP      Alpha 4                                   AP115   AP170
Element: Invoice Group The invoice group assigned to the         AP180   AP181
                       invoice payment. An invoice group is a    AP190   AP20.1
                       user-defined character expression that    AP20.2  AP20.3
                       can be used to select invoices for        AP20.4  AP20.5
                       payment.                                  AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-VENDOR-GROUP       Alpha 4                                   AP180   AP181
Element: Vendor Group  The vendor group associated with the      AP190   AP20.1
                       invoice payment. Must be a valid record   AP20.2  AP20.3
                       in the Vendor Group file.                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-PAY-GROUP          Alpha 4                                   AP101   AP180
Element: Pay Group     The pay group associated with the         AP181   AP190
                       invoice payment. A pay group is used for  AP20.1  AP20.2
                       processing accounts payable payments.     AP20.3  AP20.4
                       Must be a valid record in the Pay Group   AP20.5  AP20.6
                       file.                                     AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 AP56.2  API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APP-DISCOUNT-CODE      Alpha 10                                  AP180   AP181
Element: Discount Code The discount code assigned to the         AP190   AP20.1
                       invoice payment. Used to default a        AP20.2  AP20.3
                       general ledger discount account to the    AP20.4  AP20.5
                       invoice. Must be a valid record in the    AP20.6  AP20.7
                       Discount Code file.                       AP20.8  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-INC-ACCR-CODE      Alpha 10                                  AP180   AP181
Element: Inc Accr Code The withholding code assigned to the      AP190   AP20.1
                       invoice payment. Used to default a        AP20.2  AP20.3
                       general ledger withholding accrual        AP20.4  AP20.5
                       account to the invoice. Must be a valid   AP20.6  AP20.7
                       record in the Income Withholding Code     AP20.8  AP21.1
                       file.                                     AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

APP-RECON-STMT-NBR     Numeric 12                                AP180   AP181
Element: Recon Stmt NbrThe bank-assigned reconciliation          AP190   AP28.1
                       statement number. Used only for cash      AP28.2  AP45.1
                       codes that require reconciliation         CB06.2
                       statements.


APP-MATCH-DISC-TAK     Alpha 1                                   AP180   AP181
Element: Match DiscountIndicates if a discount was taken         AP190   AP28.1
                       during the invoice matching process.      AP28.2  AP45.1
                       " "                                       AP520   MA61.1
                       Y = Yes                                   MA66.2  MA70.1
                                                                 MA75.1  MAI1.1

APP-OPEN-BASE-PMT      Derived
Element: Open Base Pmt The amount of the invoice remaining to
                       be paid in the company base currency.

APP-OPEN-TRAN-PMT      Derived
Element: Open Tran Pmt The amount of the invoice remaining to
                       be paid in the currency of the invoice.

APP-BASE-NET-PMT       Derived
Element: Base Net Pmt  The net invoice amount paid in the
                       company base currency.

APP-TRAN-NET-PMT       Derived
Element: Tran Net Pmt  The net invoice amount paid in the
                       currency of the invoice.

APP-PMT-STATUS         Derived
Element: Payment StatusDisplays the payment status when Drill
                       Around(TM) is used. Valid values are:

                       OPEN = The payment record has an open
                       status.

                       PAID = The payment record has a paid
                       status.

APP-BANK-STATUS        Derived
Element: Bank Status   The reconciliation status of the
                       payment record associated with the
                       invoice payment.

APP-NO-REINSTATE       Derived
Payment Not            If the invoice payment was paid and the
Reinstated             payment was voided, this field indicates
                       if the split invoice has not been
                       reinstated by AP190 (Invoice
                       Reinstatement).

APP-PAID-DOC-DATE      Derived
Payment Document       If the invoice payment was paid with a
Date                   cash payment, this field contains the
                       date assigned to the cash payment. If
                       the invoice payment was paid with a bill
                       of exchange payment, this field contains
                       the date the bill of exchange was
                       cashed.

APP-DRAFT-ACCRUED      Derived
Bill of Exchange       If the invoice payment was paid with a
Accrued                bill of exchange, this field indicates
                       whether the bill of exchange has been
                       accrued in the general ledger.

APP-AP-INV-DATE        Derived
Element: Ap Inv Date

APP-AP-PO-NBR          Derived
Element: Ap Po Nbr

APP-AP-INV-TYPE        Derived
Element: Ap Inv Type

APP-AP-BASE-INV        Derived
Element: Ap Base Inv

APP-AP-FORMAT-NBR      Derived
Element: Ap Format Nbr

APP-STATEMENT          Alpha 22                                  API1.1
Element: Invoice       Used to identify the invoice.

                         APPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APPSET1   COMPANY                                                AM19.1  AM19.2
          VENDOR                                                 AM19.4  AP115
          INVOICE                                                AP125   AP126
          SUFFIX                                                 AP131   AP136
          CANCEL-SEQ                                             AP141   AP150
          SEQ-NBR                                                AP151   AP170
          VOID-SEQ                                               AP178   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP197
                                                                 AP198   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP21.1
                                                                 ...

APPSET10  REC-STATUS    KeyChange                                AP00.5  AP101
          COMPANY                                                AP145   AP146
          PROC-LEVEL                                             AP230   AP245
          VENDOR                                                 AP250   AP270
          INVOICE                                                MA168
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          PAY-GROUP

APPSET12  PAY-GROUP     KeyChange, Subset                        AP55.2  AP56.2
          VENDOR        Where (REC-STATUS = 1 )
          INVOICE       Or    (REC-STATUS = 2 )
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

APPSET2   PAY-GROUP     KeyChange                                AC160   AM115
          REC-STATUS                                             AM117   AM15.1
          VENDOR                                                 AM15.2  AM15.3
          INVOICE                                                AM15.4  AM19.1
          SUFFIX                                                 AM19.2  AM20.1
          CANCEL-SEQ                                             AM20.3  AM21.1
          SEQ-NBR                                                AM21.3  AM500
          VOID-SEQ                                               AM51.1  AM551
          COMPANY                                                AM97.1  AP03.3
                                                                 AP10.1  AP102
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP141
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

APPSET3   PAY-GROUP     KeyChange                                AP150   AP151
          REC-STATUS                                             AP170
          PAY-IMM-FLAG
          PROC-GRP
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

APPSET4   COMPANY       KeyChange, Subset                        AP191   AP30.3
          VENDOR        Where REC-STATUS = 1                     AP35.1  EE30.1
          INVOICE       Or    REC-STATUS = 2
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ

APPSET6   PAY-GROUP     KeyChange, Subset                        AP125   AP126
          BANK-INST-CODEWhere TRANS-IDENT != Zeroes              AP151   AP155
          TRANS-IDENT                                            AP156   AP160
          VENDOR                                                 AP161   AP180
          INVOICE                                                AP181   AP190
          SUFFIX                                                 AP25.1  AP25.2
          CANCEL-SEQ                                             AP26.1  AP265
          SEQ-NBR                                                AP27.1  AP28.1
          VOID-SEQ                                               AP28.2  AP32.1
          COMPANY                                                AP55.1  AP55.2
                                                                 AP56.1  AP56.2
                                                                 CB06.2  CB186
                                                                 CB187   CB191
                                                                 CB286   MA61.1
                                                                 MAI1.1

APPSET8   PAY-GROUP     KeyChange                                AP255   AP90.5
          CASH-CODE                                              CB170
          TRANS-NBR
          BANK-INST-CODE
          COMPANY
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ

                         APPAYMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APP-COMPANY           -> CPY-COMPANY

Apdrafts       APDRAFTS     Not Required

                            APP-BANK-INST-CODE    -> APT-BANK-INST-CODE
                            APP-TRANS-IDENT       -> APT-TRANS-IDENT

Apinvoice      APINVOICE    Required

                            APP-COMPANY           -> API-COMPANY
                            APP-VENDOR            -> API-VENDOR
                            APP-INVOICE           -> API-INVOICE
                            APP-SUFFIX            -> API-SUFFIX
                            APP-CANCEL-SEQ        -> API-CANCEL-SEQ

Appayvendor    APVENMAST    Required

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            APP-PAY-VENDOR        -> VEN-VENDOR

Approclev      APPROCLEV    Required

                            APP-COMPANY           -> APR-COMPANY
                            APP-PROC-LEVEL        -> APR-PROC-LEVEL

Apvenclass     APVENCLASS   Required

                            CPY-VENDOR-GROUP      -> VCL-VENDOR-GROUP
                            APP-VEN-CLASS         -> VCL-VEN-CLASS

Apvencurrbal   APVENBAL     Not Required

                            CPY-VENDOR-GROUP      -> VBA-VENDOR-GROUP
                            APP-COMPANY           -> VBA-COMPANY
                            APP-VENDOR            -> VBA-VENDOR
                            APP-REMIT-TO-CODE     -> VBA-LOCATION-CODE

Apvengroup     APVENGROUP   Required

                            CPY-VENDOR-GROUP      -> VGP-VENDOR-GROUP

Apvenloc       APVENLOC     Not Required

                            CPY-VENDOR-GROUP      -> VLO-VENDOR-GROUP
                            APP-PAY-VENDOR        -> VLO-VENDOR
                            APP-REMIT-TO-CODE     -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            APP-VENDOR            -> VEN-VENDOR

Cbbankinst     CBBANKINST   Required

                            APP-BANK-INST-CODE    -> CBI-BANK-INST-CODE

Cbcashcode     CBCASHCODE   Required

                            APP-CASH-CODE         -> CBC-CASH-CODE

Cbcashform     CBCASHFORM   Not Required

                            APP-CASH-CODE         -> CCF-CASH-CODE
                            APP-BANK-INST-CODE    -> CCF-BANK-INST-CODE
                            APP-PROC-GRP          -> CCF-PROC-GRP

Cbcheck        CBCHECK      Required

                            APP-CASH-CODE         -> CHK-CASH-CODE
                            APP-BANK-INST-CODE    -> CHK-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CHK-TRANS-IDENT

Cbcpycach      CBCPYCASH    Required

                            APP-PAY-COMPANY       -> CBY-COMPANY
                            APP-CASH-CODE         -> CBY-CASH-CODE

Cbstatement    CBSTATEMNT   Not Required

                            APP-CASH-CODE         -> CSM-CASH-CODE
                            APP-RECON-STMT-NBR    -> CSM-RECON-STMT-NBR

Cbtrans        CBTRANS      Not Required
                            Valid When CHK-SERIAL-NUM = Zeroes

                            APP-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CBT-TRANS-IDENT

Cbtrans Tape   CBTRANS      Not Required
                            Valid When CHK-           =  APP-
                                  And  CHK-REC-STATUS =  2
                                  And  CHK-SERIAL-NUM != Zeroes

                            CHK-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            CHK-SERIAL-NUM        -> CBT-SERIAL-NUM
                            CHK-TRANS-IDENT       -> CBT-TRANS-IDENT

Invcurrency    CUCODES      Required

                            APP-INV-CURRENCY      -> CUC-CURRENCY-CODE

                         APPAYMENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apdiscacc      APDISCACC

                            APP-COMPANY           -> DSK-COMPANY
                            APP-VENDOR            -> DSK-VENDOR
                            APP-INVOICE           -> DSK-INVOICE
                            APP-SUFFIX            -> DSK-SUFFIX
                            APP-CANCEL-SEQ        -> DSK-CANCEL-SEQ
                            APP-SEQ-NBR           -> DSK-SEQ-NBR
                                                     DSK-VOID-SEQ
                                                     DSK-DISC-TYPE

Aphldinv       APHLDINV     Delete Cascades
                            Valid When (APP-HOLD-FLAG = "Y" )

                            "P"                   -> HLI-REC-TYPE
                            APP-VENDOR-GROUP      -> HLI-VENDOR-GROUP
                            APP-COMPANY           -> HLI-COMPANY
                            APP-VENDOR            -> HLI-VENDOR
                            APP-INVOICE           -> HLI-INVOICE
                            APP-SUFFIX            -> HLI-SUFFIX
                            APP-CANCEL-SEQ        -> HLI-CANCEL-SEQ
                            APP-SEQ-NBR           -> HLI-SEQ-NBR
                            APP-VOID-SEQ          -> HLI-VOID-SEQ
                                                     HLI-HLD-CODE

Appset6        APPAYMENT

                            APP-PAY-GROUP         -> APP-PAY-GROUP
                            APP-BANK-INST-CODE    -> APP-BANK-INST-CODE
                            APP-TRANS-IDENT       -> APP-TRANS-IDENT
                                                     APP-VENDOR
                                                     APP-INVOICE
                                                     APP-SUFFIX
                                                     APP-CANCEL-SEQ
                                                     APP-SEQ-NBR
                                                     APP-VOID-SEQ
                                                     APP-COMPANY

Appset8        APPAYMENT

                            APP-PAY-GROUP         -> APP-PAY-GROUP
                            APP-CASH-CODE         -> APP-CASH-CODE
                            APP-TRANS-NBR         -> APP-TRANS-NBR
                            APP-BANK-INST-CODE    -> APP-BANK-INST-CODE
                                                     APP-COMPANY
                                                     APP-VENDOR
                                                     APP-INVOICE
                                                     APP-SUFFIX
                                                     APP-CANCEL-SEQ
                                                     APP-SEQ-NBR
                                                     APP-VOID-SEQ

Apvencomments  APCOMMENTS

                            "V"                   -> APC-REC-TYPE
                            CPY-VENDOR-GROUP      -> APC-VENDOR-GROUP
                            APP-VENDOR            -> APC-VENDOR
                            Spaces                -> APC-LOCATION-CODE
                            APP-COMPANY           -> APC-COMPANY
                                                     APC-SEQ-NBR

Apvendiv       APVENDIV

                            APP-VENDOR-GROUP      -> VDC-VENDOR-GROUP
                            APP-VENDOR            -> VDC-VENDOR
                            API-LOCATION          -> VDC-LOCATION-CODE
                                                     VDC-DIVERSE-CODE
                                                     VDC-DCERT-DATE

Cbstmtdtl      CBSTMTDTL

                            APP-BANK-INST-CODE    -> CSD-BANK-INST-CODE
                            APP-RECON-STMT-NBR    -> CSD-RECON-STMT-NBR
                            APP-TRANS-NBR         -> CSD-PAYMENT-NBR
                            "V"                   -> CSD-TRANS-TYPE
                            APP-CASH-CODE         -> CSD-CASH-CODE
                                                     CSD-LINE-NBR