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

AC550     AP131     AP195     AP197     AP213     AP220
AP240     AP260     AP282     AP284     AP57.2    AR48.3
EE230     IC28.1    MA180     MA530     MA531     MA66.2
MA66.3    MA67.1    MA67.2    MA80.1    MAED.1    PO100
PO101     PO122     PO131     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.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
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    POII.1    POIJ.1    PR277     UK277
RQ10.1    RQ10.2    RQ10.3    RQIE.1    WH20.2    WH20.7
AP00.5    AP145     AP146     AP230     AP245     AP250
AP270     AM115     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP10.1    AP92.2    API3.1    API4.1
IC840     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    PR514     UK47.1    EE30.1    AP156     AP265
AP255     AP90.5

UPDATED BY

AP101     AP102     AP115     AP125     AP126     AP141
AP150     AP151     AP155     AP160     AP161     AP170
AP180     AP181     AP190     AP191     AP193     AP198
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP20.8    AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP28.1    AP28.2    AP30.1    AP30.3    AP30.4
AP300     AP31.3    AP32.1    AP32.2    AP35.1    AP36.1
AP40.1    AP43.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     MA310     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.4    MA43.5    MA43.7    MA43.8    MA60.2    MA60.4
MA61.1    MA65.1    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  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.2
                                                                 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
                                                                 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.2  MA43.2

APP-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice NumberThe 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
                                                                 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.2  MA43.2

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

APP-CANCEL-SEQ         Numeric 4                                 AP180   AP181
Element: Sequence NumbeThe 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: Sequence NumbeAn automatically assigned sequence        AP181   AP190
                       number.                                   AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 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.2  MA43.2

APP-VOID-SEQ           Numeric 4                                 AP180   AP181
Element: Sequence NumbeThe 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
To Company Base        The currency of the invoice. Must be a    AP190   AP20.1
Currency               valid record in the Currency Code file.   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  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
                                                                 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.2
                                                                 MA43.2

APP-REMIT-TO-CODE      Alpha 4                                   AP115   AP125
Purchase From          The remit-to location associated with     AP126   AP180
Location Code          the invoice payment. Must be a valid      AP181   AP190
                       record in the Vendor Location file.       AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.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.2  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
                                                                 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.2
                                                                 MA43.2

APP-CASH-CODE          Alpha 4                                   AP115   AP150
Accounts Receivable    The cash code assigned to the invoice.    AP151   AP160
Code                   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
                                                                 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.2  MA43.2

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

APP-HOLD-FLAG          Alpha 1                                   AP125   AP126
Element: On 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
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP30.4  AP31.3
                                                                 AP32.1  AP35.1
                                                                 AP36.1  AP40.1
                                                                 AP43.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.5  MA43.7
                                                                 MA43.8  MA60.2
                                                                 MA60.4  MA61.1
                                                                 MA65.1  MA70.1
                                                                 MA75.1  MAI1.1

APP-VEN-CLASS          Alpha 3                                   AP115   AP180
Element: Vendor 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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA43.2

APP-VEN-PRIORITY       Numeric 2                                 AP115   AP180
Element: Vendor PrioritThe 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
                       00                                        AP20.5  AP20.6
                       99                                        AP20.7  AP20.8
                                                                 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.2  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  AP23.1
                       the Process Group file.                   AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA43.2

APP-BASE-PMT-AMT       Signed 15.2                               AP125   AP126
Base Payment Amount    The amount of the invoice payment in      AP170   AP180
(at entry)             the company base currency. This amount    AP181   AP190
                       is calculated using the currency          AP193   AP20.1
                       exchange rate in effect when the invoice  AP20.2  AP20.3
                       payment was created.                      AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.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.5  MA43.7
                                                                 MA43.8  MA60.2
                                                                 MA60.4  MA61.1
                                                                 MA65.1  MAI1.1

APP-BASE-ACT-AMT       Signed 15.2                               AP125   AP126
Base Payment Amount    The amount of the invoice payment in      AP170   AP180
(revalued)             the company base currency. For non-base   AP181   AP190
                       currency invoices, this amount may be     AP191   AP193
                       updated when currency revaluation takes   AP20.1  AP20.2
                       place to account for exchange rate        AP20.3  AP20.4
                       fluctuations.                             AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.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.5  MA43.7
                                                                 MA43.8  MA60.2
                                                                 MA60.4  MA61.1
                                                                 MA65.1  MAI1.1

APP-BASE-ND            Numeric 1                                 AP180   AP181
Account Currency       The number of decimal places defined      AP190   AP20.1
Code                   for the company base currency.            AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  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.2
                                                                 MA43.2

APP-TRAN-PMT-AMT       Signed 15.2                               AP125   AP126
Element: Adj Amt       The amount of the invoice payment in      AP180   AP181
                       the currency of the invoice.              AP190   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.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.5
                                                                 MA43.7  MA43.8
                                                                 MA60.2  MA60.4
                                                                 MA61.1  MA65.1
                                                                 MAI1.1

APP-TRAN-ND            Numeric 1                                 AP180   AP181
Account Currency       The number of decimal places defined      AP190   AP20.1
Code                   for the invoice currency.                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  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.2
                                                                 MA43.2

APP-BANK-CHK-AMT       Signed 15.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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 MA41.2  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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  MA41.2
                                                                 MA43.2

APP-BASE-DISC-AMT      Signed 15.2                               AP125   AP126
Element: Actual Disc   The amount of the available discount      AP150   AP170
                       for the invoice payment in the company    AP180   AP181
                       base currency.                            AP190   AP191
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP32.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APP-TRAN-DISC-AMT      Signed 15.2                               AP125   AP126
Element: Actual Disc   The amount of the available discount      AP150   AP180
                       for the invoice payment in the currency   AP181   AP190
                       of the invoice.                           AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP32.2  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.2  API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APP-BASE-CHK-AMT       Signed 15.2                               AP150   AP170
Element: Adj 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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-TRAN-CHK-AMT       Signed 15.2                               AP150   AP170
Element: Adj 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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-BASE-INC-WH        Signed 15.2                               AP150   AP170
Element: Exchange Rate 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 15.2                               AP150   AP170
Element: Actual Cost   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 15.2                               AP170   AP180
Element: Adj 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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA43.2

APP-GAINLOS-AMT        Signed 15.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 12.6                               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
                                                                 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.2  MA43.2

APP-DSC-ACCT-UNIT      Alpha 15                                  AP170   AP180
Element: Accounting UniThe 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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA43.2

APP-DSC-SUB-ACCT       Numeric 4                                 AP170   AP180
Element: Subaccount    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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA43.2

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

APP-DISC-DATE          Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          The date through which the available      AP150   AP170
                       discount amount of the invoice can be     AP180   AP181
                       taken.                                    AP190   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 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  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.2
                                                                 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  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.2
                                                                 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  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.2
                                                                 MA43.2

APP-REC-STATUS         Numeric 1                                 AP125   AP126
Element: Record 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.8  AP25.1
                       4 = Paid with a Manual Payment            AP25.2  AP26.1
                       5 = Paid with a Bill of Exchange Payment  AP27.1  AP28.1
                       7 = Unreleased Manual Payment             AP28.2  AP30.3
                       8 = Canceled (bill of exchange)           AP35.1  AP45.1
                       9 = Historical                            AP520   AP55.1
                                                                 AP55.2  AP56.1
                       Note: All void status invoice payment     AP56.2  API1.1
                       records should have a historical status.  API2.1  CB06.2
                                                                 CB191   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.7
                                                                 MA61.1  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  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.2
                                                                 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  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.2  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
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA43.2  MA70.1
                                                                 MA75.1

APP-INCOME-CODE        Alpha 4                                   AP180   AP181
Accounts Receivable    The income code assigned to the invoice   AP190   AP20.1
Code                   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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  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.                                   AP23.1  AP28.1
                       Y = Yes.                                  AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 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.                                  AP23.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP35.1  AP40.1
                                                                 AP43.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 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
                                                                 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.2  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  AP23.1
                       Y = Yes.                                  AP28.1  AP28.2
                       N = No.                                   AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  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   AP193
                       user-defined character expression that    AP20.1  AP20.2
                       can be used to select invoices for        AP20.3  AP20.4
                       payment.                                  AP20.5  AP20.7
                                                                 AP20.8  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  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
                                                                 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.2  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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA43.2

APP-INC-ACCR-CODE      Alpha 10                                  AP180   AP181
Income Withholding     The withholding code assigned to the      AP190   AP20.1
Code                   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  AP23.1
                       file.                                     AP28.1  AP28.2
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA43.2

APP-RECON-STMT-NBR     Numeric 12                                AP180   AP181
Reconciliation         The bank-assigned reconciliation          AP190   AP28.1
Statement              statement number. Used only for cash      AP28.2  AP45.1
                       codes that require reconciliation         CB06.2
                       statements.

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

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

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

APP-BASE-NET-PMT       Derived
Base Invoice Amount    The net invoice amount paid in the
Paid                   company base currency.

APP-TRAN-NET-PMT       Derived
Element: Invoice AmountThe 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

                         APPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APPSET1   COMPANY       This index is used to access payment     AC550   AP115
          VENDOR        records for a specific invoice.          AP125   AP126
          INVOICE                                                AP131   AP141
          SUFFIX                                                 AP150   AP151
          CANCEL-SEQ                                             AP170   AP180
          SEQ-NBR                                                AP181   AP190
          VOID-SEQ                                               AP191   AP193
                                                                 AP195   AP197
                                                                 AP198   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP213
                                                                 AP220   AP23.1
                                                                 AP240   AP25.1
                                                                 ...

APPSET10  REC-STATUS    This index is used to access payment     AP00.5  AP101
          COMPANY       records by a specific status.            AP145   AP146
          PROC-LEVEL    KeyChange                                AP230   AP245
          VENDOR                                                 AP250   AP270
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          PAY-GROUP

APPSET12  PAY-GROUP     This index is used for inquiring on      AP55.2  AP56.2
          VENDOR        status 1 and 2 payment records by pay
          INVOICE       group and vendor.
          SUFFIX        KeyChange, Subset
          CANCEL-SEQ    Where (REC-STATUS = 1 )
          SEQ-NBR       Or    (REC-STATUS = 2 )
          VOID-SEQ
          COMPANY

APPSET2   PAY-GROUP     This index is used to access payment     AM115   AM15.1
          REC-STATUS    records for a specific invoice by        AM15.2  AM15.3
          VENDOR        payment status.                          AM15.4  AM20.1
          INVOICE       KeyChange                                AM20.3  AM21.1
          SUFFIX                                                 AM21.3  AM500
          CANCEL-SEQ                                             AM51.1  AM551
          SEQ-NBR                                                AM97.1  AP10.1
          VOID-SEQ                                               AP102   AP141
          COMPANY                                                AP40.1  AP92.2
                                                                 API3.1  API4.1
                                                                 IC840   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

APPSET3   PAY-GROUP     This index is used to access open        AP150   AP151
          REC-STATUS    payment records for cash requirements.   AP170
          PAY-IMM-FLAG  The index is also used by AP170 (Payment
          PROC-GRP      Closing) to aid in concurrent
          VENDOR        processing.
          INVOICE       KeyChange
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

APPSET4   COMPANY       This index is used to access open        AP191   AP30.3
          VENDOR        payment records for a specific vendor    AP35.1  EE30.1
          INVOICE       and/or invoice.
          SUFFIX        KeyChange, Subset
          CANCEL-SEQ    Where REC-STATUS = 1
          SEQ-NBR       Or    REC-STATUS = 2
          VOID-SEQ

APPSET6   PAY-GROUP     This index is used to link the payment   AP125   AP126
          BANK-INST-CODErecord with associated check records.    AP151   AP155
          TRANS-IDENT   The index accesses check records         AP156   AP160
          VENDOR        associated with a specific transaction   AP161   AP180
          INVOICE       ID by pay group and payment code.        AP181   AP190
          SUFFIX        KeyChange, Subset                        AP25.1  AP25.2
          CANCEL-SEQ    Where TRANS-IDENT != Zeroes              AP26.1  AP265
          SEQ-NBR                                                AP27.1  AP28.1
          VOID-SEQ                                               AP28.2  AP32.1
          COMPANY                                                AP55.1  AP55.2
                                                                 AP56.1  AP56.2
                                                                 API1.1  CB06.2
                                                                 CB191   MA41.7
                                                                 MA61.1  MAI1.1

APPSET8   PAY-GROUP     This index is used by AP255 (Bank        AP255   AP90.5
          CASH-CODE     Account Payment History) to access
          TRANS-NBR     payment records by pay group, cash code,
          BANK-INST-CODEand the payment number.
          COMPANY       KeyChange
          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-PAY-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

Cbstmtdtl      CBSTMTDTL    Required

                            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

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