Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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     AC750     AP195     AP197     AP213     AP220
AP240     AP260     AP282     AP284     AP57.2    AR48.3
EE230     MAED.1    POIJ.1    PR277     AP00.5    AP145
AP146     AP230     AP245     AP250     AP270     AP10.1
AP92.2    API3.1    API4.1    EE30.1    AP156     AP265
AP255     AP90.5

UPDATED BY

AP101     AP102     AP115     AP141     AP150     AP151
AP155     AP160     AP161     AP170     AP180     AP181
AP190     AP191     AP193     AP198     AP28.1    AP28.2
AP30.1    AP30.3    AP30.4    AP300     AP32.1    AP32.2
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     MA310
MA65.1    AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APP-COMPANY          Numeric 4                                   AP180   AP181
Company              The company number associated with the      AP190   AP260
                     invoice payment. Must be a valid record     AP28.1  AP28.2
                     in the Accounts Payable Company file.       AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-VENDOR           Alpha 9  (Right Justified)                  AP115   AP180
Vendor               The vendor number associated with the       AP181   AP190
                     invoice payment. Must be a valid record     AP260   AP28.1
                     in the Vendor file.                         AP28.2  AP30.3
                                                                 AP32.1  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-INVOICE          Alpha 22                                    AP115   AP180
Invoice Number       The invoice number. Must be a valid         AP181   AP190
                     record in the Accounts Payable Invoice      AP260   AP28.1
                     file.                                       AP28.2  AP30.3
                                                                 AP32.1  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-SUFFIX           Numeric 3                                   AP170   AP180
Invoice Suffix       The invoice suffix number. Represents       AP181   AP190
                     the occurrence value of the invoice for     AP193   AP260
                     recurring invoices, employee advances,      AP28.1  AP28.2
                     and prepayment credit memos.                AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520

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

APP-SEQ-NBR          Numeric 4                                   AP170   AP180
Sequence Number      An automatically assigned sequence          AP181   AP190
                     number.                                     AP28.1  AP28.2
                                                                 AP30.3  AP32.1
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-VOID-SEQ         Numeric 4                                   AP180   AP181
Void Sequence        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
Void 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
Invoice Currency     The currency of the invoice. Must be a      AP190   AP28.1
                     valid record in the Currency Code file.     AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

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

APP-REMIT-TO-CODE    Alpha 4                                     AP115   AP180
Remit To Location    The remit-to location associated with       AP181   AP190
Code                 the invoice payment. Must be a valid        AP28.1  AP28.2
                     record in the Vendor Location file.         AP30.1  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 CB06.2

APP-PAY-COMPANY      Numeric 4                                   AP151   AP180
Pay Company          The company associated with the pay         AP181   AP190
                     vendor. Must be a valid record in the       AP28.1  AP28.2
                     Accounts Payable Company file.              AP30.3  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  API1.1
                                                                 API2.1  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-CASH-CODE        Alpha 4                                     AP115   AP150
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.         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

APP-DUE-DATE         Numeric 8  (yyyymmdd)                       AP170   AP180
Due Date             The invoice due date. AP150 and AP151       AP181   AP190
                     use this date to determine whether to       AP193   AP28.1
                     schedule the invoice payment and whether    AP28.2  AP30.3
                     to take a discount, if applicable.          AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-ENCLOSURE        Alpha 1                                     AP180   AP181
Enclosure            Indicates whether the invoice payment       AP190   AP28.1
                     requires an enclosure. Valid values are:    AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                     N = No.                                     AP520   API1.1
                     Y = Yes.                                    API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-HOLD-FLAG        Alpha 1                                     AP141   AP150
On Hold Flag         Indicates whether the invoice payment       AP170   AP180
                     is on hold. If this field is Yes, AP150     AP181   AP190
                     or AP151 will not select the invoice        AP193   AP28.1
                     payment. Valid values are:                  AP28.2  AP30.3
                                                                 AP30.4  AP32.1
                     Y = Yes. Invoice payment is on hold.        AP35.1  AP36.1
                     Blank = Invoice payment is not on hold.     AP40.1  AP45.1
                                                                 AP520   AP55.2
                                                                 AP56.2  API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA65.1

APP-VEN-CLASS        Alpha 3                                     AP115   AP180
Vendor Class         The vendor class associated with the        AP181   AP190
                     invoice payment. Must be a valid record     AP28.1  AP28.2
                     in the Vendor Class file.                   AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-VEN-PRIORITY     Numeric 2                                   AP115   AP180
Vendor Priority      The payment priority defined for the        AP181   AP190
                     vendor. Valid values are 1 (highest         AP28.1  AP28.2
                     priority) through 99 (lowest priority).     AP30.3  AP35.1
                     00                                          AP45.1  AP520
                     99                                          API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

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

APP-BASE-PMT-AMT     Signed 15.2                                 AP170   AP180
Base Payment Amount  The amount of the invoice payment in        AP181   AP190
(at entry)           the company base currency. This amount      AP193   AP28.1
                     is calculated using the currency            AP28.2  AP30.1
                     exchange rate in effect when the invoice    AP30.3  AP35.1
                     payment was created.                        AP45.1  AP520
                                                                 AP55.2  AP56.1
                                                                 AP56.2  API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA65.1

APP-BASE-ACT-AMT     Signed 15.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       AP28.1  AP28.2
                     updated when currency revaluation takes     AP30.1  AP30.3
                     place to account for exchange rate          AP30.4  AP35.1
                     fluctuations.                               AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA65.1

APP-BASE-ND          Numeric 1                                   AP180   AP181
Base Number Of       The number of decimal places defined        AP190   AP28.1
Decimals             for the company base currency.              AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-TRAN-PMT-AMT     Signed 15.2                                 AP180   AP181
Payment Amount       The amount of the invoice payment in        AP190   AP28.1
                     the currency of the invoice.                AP28.2  AP30.1
                                                                 AP30.3  AP30.4
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 AP56.1  AP56.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA65.1

APP-TRAN-ND          Numeric 1                                   AP180   AP181
Transaction Number   The number of decimal places defined        AP190   AP28.1
of Decimals          for the invoice currency.                   AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

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   AP28.1
                     code).                                      AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2

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   AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2

APP-BASE-DISC-AMT    Signed 15.2                                 AP150   AP170
Base Discount Amount The amount of the available discount        AP180   AP181
                     for the invoice payment in the company      AP190   AP191
                     base currency.                              AP193   AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP32.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.2
                                                                 API1.1  API2.1

APP-TRAN-DISC-AMT    Signed 15.2                                 AP150   AP180
Discount Amount      The amount of the available discount        AP181   AP190
                     for the invoice payment in the currency     AP28.1  AP28.2
                     of the invoice.                             AP30.1  AP30.3
                                                                 AP32.2  AP35.1
                                                                 AP45.1  AP520
                                                                 AP55.2  API1.1
                                                                 API2.1

APP-BASE-CHK-AMT     Signed 15.2                                 AP150   AP170
Base Payment Amount  The net payment amount for the invoice      AP180   AP181
                     in the company base currency.               AP190   AP193
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-TRAN-CHK-AMT     Signed 15.2                                 AP150   AP170
Payment Amount       The net payment amount for the invoice      AP180   AP181
                     in the currency of the invoice.             AP190   AP193
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-BASE-INC-WH      Signed 15.2                                 AP150   AP170
Base Income Withheld 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
Income Withholding   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
Income Amount        The portion of the invoice amount           AP181   AP190
                     classified as reportable income.            AP193   AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1

APP-GAINLOS-AMT      Signed 15.2                                 AP170   AP180
Gain or Loss Amount  The 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.

APP-UNRL-REV-DATE    Numeric 8  (yyyymmdd)                       AP180   AP181
Last Revaluation     The date of the last currency               AP190   AP191
Date                 revaluation that resulted in the            AP28.1  AP28.2
                     creation of an unrealized gain or loss      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       AP28.1  AP28.2
                     may be updated when the invoice is          AP30.3  AP35.1
                     revalued.                                   AP45.1  AP520
                                                                 AP55.1  AP55.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-DSC-ACCT-UNIT    Alpha 15                                    AP170   AP180
Discount Accounting  The accounting unit used for posting        AP181   AP190
Unit                 the discount amount to the general          AP193   AP28.1
                     ledger. Must be a valid accounting unit     AP28.2  AP30.3
                     in the Lawson General Ledger system.        AP45.1  AP520
                                                                 API1.1  API2.1

APP-DSC-ACCOUNT      Numeric 6                                   AP170   AP180
Discount Account     The account number used for posting the     AP181   AP190
                     discount amount to the general ledger.      AP193   AP28.1
                     Must be a valid account in the Lawson       AP28.2  AP30.3
                     General Ledger system.                      AP45.1  AP520
                                                                 API1.1  API2.1

APP-DSC-SUB-ACCT     Numeric 4                                   AP170   AP180
Discount Subaccount  The subaccount number used for posting      AP181   AP190
Number               the discount amount to the general          AP193   AP28.1
                     ledger. Must be a valid subaccount in       AP28.2  AP30.3
                     the Lawson General Ledger system.           AP45.1  AP520
                                                                 API1.1  API2.1

APP-DISCOUNT-RT      Percent 5.3  (Percent)                      AP180   AP181
Discount Rate        The rate used to calculate the discount     AP190   AP28.1
                     amount of the invoice payment.              AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1

APP-DISC-DATE        Numeric 8  (yyyymmdd)                       AP150   AP170
Discount Date        The date through which the available        AP180   AP181
                     discount amount of the invoice can be       AP190   AP193
                     taken.                                      AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1

APP-TRANS-IDENT      Numeric 10                                  AP150   AP151
Transaction ID       A sequencing number created by AP150        AP170   AP180
                     (Cash Requirements) or AP151 (Bill of       AP181   AP190
                     Exchange Generation) to sequence            AP193   AP28.1
                     payments. Used to link the Invoice          AP28.2  AP45.1
                     Payment record with the associated          AP520   AP55.1
                     Accounts Payable Cash Payment record.       AP55.2  AP56.1
                                                                 AP56.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-ACCR-CODE        Alpha 4                                     AP180   AP181
Invoice Accrual Code The invoice accrual code assigned to        AP190   AP28.1
                     the invoice. Used to default a general      AP28.2  AP30.1
                     ledger accrual account to the invoice.      AP30.3  AP35.1
                     Must be a valid record in the Invoice       AP45.1  AP520
                     Accrual Code file.                          API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-PROC-LEVEL       Alpha 5                                     AP180   AP181
Process Level        The process level associated with the       AP190   AP28.1
                     invoice. Must be a valid record in the      AP28.2  AP30.1
                     Accounts Payable Process Level file.        AP30.3  AP35.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

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

APP-TRANS-NBR        Alpha 10  (Right Justified)                 AP151   AP155
Payment Number       The system or manual payment number         AP160   AP161
                     used to pay the invoice payment.            AP170   AP180
                                                                 AP181   AP190
                                                                 AP193   AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

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

APP-BANK-INST-CODE   Alpha 3                                     AP115   AP150
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   AP28.1
                     pay the invoice payment. Must be a valid    AP28.2  AP30.3
                     cash payment or bill of exchange payment    AP35.1  AP45.1
                     transaction code record in the Bank         AP520   AP55.1
                     Transaction Code file.                      AP55.2  AP56.2
                                                                 API1.1  API2.1
                                                                 CB06.2  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

APP-CHECK-DATE       Numeric 8  (yyyymmdd)                       AP155   AP160
Payment Date         The date assigned to the system or          AP161   AP170
                     manual payment associated with the          AP180   AP181
                     invoice payment record.                     AP190   AP193
                                                                 AP28.1  AP28.2
                                                                 AP35.1  AP45.1
                                                                 AP520   AP55.1
                                                                 AP55.2  CB06.2
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

APP-INCOME-CODE      Alpha 4                                     AP180   AP181
Income Code          The income code assigned to the invoice     AP190   AP28.1
                     payment record. Used to track vendor        AP28.2  AP30.3
                     reportable income. Must be a valid          AP35.1  AP45.1
                     record in the Income Code file.             AP520   API1.1
                                                                 API2.1

APP-SEP-CHK-FLAG     Alpha 1                                     AP170   AP180
Separate Payment     Indicates whether the payment should be     AP181   AP190
                     made on a separate payment form from        AP28.1  AP28.2
                     other payments to the same vendor. Valid    AP30.3  AP35.1
                     values are:                                 AP45.1  AP520
                                                                 API1.1  API2.1
                     N = No.                                     EE135   EE35.1
                     Y = Yes.                                    EE35.2  EE520

APP-PAY-IMM-FLAG     Alpha 1                                     AP170   AP180
Pay Immediately      Indicates whether the invoice is to be      AP181   AP190
                     paid immediately regardless of the          AP28.1  AP28.2
                     invoice due date. Valid values are:         AP30.3  AP35.1
                                                                 AP40.1  AP45.1
                     N = No.                                     AP520   API1.1
                     Y = Yes.                                    API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

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

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

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

APP-VENDOR-GROUP     Alpha 4                                     AP180   AP181
Vendor Group         The vendor group associated with the        AP190   AP28.1
                     invoice payment. Must be a valid record     AP28.2  AP30.3
                     in the Vendor Group file.                   AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

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

APP-DISCOUNT-CODE    Alpha 10                                    AP180   AP181
Discount Code        The discount code assigned to the           AP190   AP28.1
                     invoice payment. Used to default a          AP28.2  AP30.3
                     general ledger discount account to the      AP45.1  AP520
                     invoice. Must be a valid record in the      API1.1  API2.1
                     Discount Code file.

APP-INC-ACCR-CODE    Alpha 10                                    AP180   AP181
Income Withholding   The withholding code assigned to the        AP190   AP28.1
Code                 invoice payment. Used to default a          AP28.2  AP45.1
                     general ledger withholding accrual          AP520   API1.1
                     account to the invoice. Must be a valid     API2.1
                     record in the Income Withholding Code
                     file.

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                                     AP180   AP181
Match Discount Taken Indicates if a discount was taken           AP190   AP28.1
                     during the invoice matching process.        AP28.2  AP45.1
                     " "                                         AP520
                     Y = Yes

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
Open Invoice Amount  The 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
Invoice Amount Paid  The net invoice amount paid in the
                     currency of the invoice.

APP-PMT-STATUS       Derived
Payment Status       Displays 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
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
Ap Inv Date

APP-AP-PO-NBR        Derived
Ap Po Nbr

APP-AP-INV-TYPE      Derived
Ap Inv Type

APP-AP-BASE-INV      Derived
Ap Base Inv

APP-AP-FORMAT-NBR    Derived
Ap Format Nbr

                         APPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APPSET1   COMPANY       This index is used to access payment     AC550   AC750
          VENDOR        records for a specific invoice.          AP115   AP141
          INVOICE                                                AP150   AP151
          SUFFIX                                                 AP170   AP180
          CANCEL-SEQ                                             AP181   AP190
          SEQ-NBR                                                AP191   AP193
          VOID-SEQ                                               AP195   AP197
                                                                 AP198   AP213
                                                                 AP220   AP240
                                                                 AP260   AP28.1
                                                                 AP28.2  AP282
                                                                 AP284   AP30.1
                                                                 AP30.3  AP30.4
                                                                 AP300   AP305
                                                                 AP32.1  AP32.2
                                                                 ...

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     AP10.1  AP102
          REC-STATUS    records for a specific invoice by        AP141   AP270
          VENDOR        payment status.                          AP40.1  AP92.2
          INVOICE       KeyChange                                API3.1  API4.1
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

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   AP151   AP155
          BANK-INST-CODErecord with associated check records.    AP156   AP160
          TRANS-IDENT   The index accesses check records         AP161   AP180
          VENDOR        associated with a specific transaction   AP181   AP190
          INVOICE       ID by pay group and payment code.        AP265   AP28.1
          SUFFIX        KeyChange, Subset                        AP28.2  AP32.1
          CANCEL-SEQ    Where TRANS-IDENT != Zeroes              AP55.1  AP55.2
          SEQ-NBR                                                AP56.1  AP56.2
          VOID-SEQ                                               CB06.2  CB191
          COMPANY

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

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

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

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

Cbtrans Tape   CBTRANS      Not Required
                            Valid When APP-           =  APP-
                                  And  APP-REC-STATUS =  2
                                  And  APP-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