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 AP195 AP197 AP213 AP225 AP226 AP240 AP260 AP282 AP284 AP285 AP57.2 EE230 PR277 AP00.7 AP145 AP146 AP230 AP245 AP250 AP270 AP10.1 AP92.2 EE30.1 AP156 AP265 AP255 AP90.5 UPDATED BY AP101 AP102 AP125 AP126 AP150 AP151 AP155 AP157 AP160 AP161 AP170 AP180 AP181 AP190 AP191 AP193 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP25.1 AP25.2 AP26.1 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 AP952 AP983 CB06.2 CB191 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO122 PO20.1 PO21.3 PO22.2 PO22.3 PO30.1 PO31.1 PO34.1 PO35.1 PO52.1 PO530 RQ10.1 RQ10.2 AP305 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY APP-COMPANY Numeric 4 AP20.1 AP20.2 Company The company number associated with the AP20.5 AP20.6 invoice payment. Must be a valid record AP20.7 AP20.8 in the Accounts Payable Company file. AP23.1 AP260 AP30.3 AP32.1 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-VENDOR Alpha 9 AP20.1 AP20.2 Vendor ID The vendor number associated with the AP20.5 AP20.6 invoice payment. Must be a valid record AP20.7 AP20.8 in the Vendor file. AP23.1 AP260 AP30.3 AP32.1 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-INVOICE Alpha 22 AP20.1 AP20.2 Invoice Number The invoice number. Must be a valid AP20.5 AP20.6 record in the Accounts Payable Invoice AP20.7 AP20.8 file. AP23.1 AP260 AP30.3 AP32.1 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-SUFFIX Numeric 3 AP125 AP126 Invoice Suffix The invoice suffix number. Represents AP170 AP180 the occurrence value of the invoice for AP181 AP193 recurring invoices, employee advances, AP20.8 AP25.1 and prepayment credit memos. AP25.2 AP26.1 AP260 AP28.1 AP28.2 AP30.3 AP32.1 AP35.1 AP520 AP952 APP-CANCEL-SEQ Numeric 4 AP260 AP30.4 Cancel Sequence The sequence number assigned upon the AP32.1 AP952 cancellation of a distributed invoice. The first sequence assigned is 9999. APP-SEQ-NBR Numeric 4 AP170 AP20.1 Sequence Number An automatically assigned sequence AP20.2 AP20.5 number. AP20.6 AP20.7 AP20.8 AP23.1 AP30.3 AP32.1 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 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 AP952 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 AP952 record. APP-INV-CURRENCY Alpha 5 AP20.1 AP20.2 Invoice Currency The currency of the invoice. Must be a AP20.5 AP20.6 valid record in the Currency Code file. AP20.7 AP20.8 AP23.1 AP30.3 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PAY-VENDOR Alpha 9 AP180 AP181 Pay Vendor The pay vendor associated with the AP20.1 AP20.2 invoice payment. Represents the vendor AP20.5 AP20.6 that will receive payment for the AP20.7 AP20.8 invoice. Must be a valid record in the AP23.1 AP28.1 Vendor file. AP28.2 AP30.1 AP30.3 AP35.1 AP520 AP55.2 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-REMIT-TO-CODE Alpha 4 AP180 AP181 Remit To Location The remit-to location associated with AP20.1 AP20.2 Code the invoice payment. Must be a valid AP20.5 AP20.6 record in the Vendor Location file. AP20.7 AP20.8 AP23.1 AP28.1 AP28.2 AP30.1 AP30.3 AP35.1 AP520 AP55.1 AP55.2 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PAY-COMPANY Numeric 4 AP151 AP20.1 Pay Company The company associated with the pay AP20.2 AP20.5 vendor. Must be a valid record in the AP20.6 AP20.7 Accounts Payable Company file. AP20.8 AP23.1 AP30.3 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-CASH-CODE Alpha 4 AP150 AP151 Cash Code The cash code assigned to the invoice. AP160 AP161 Represents the bank account the invoice AP180 AP181 payment is to be paid from. Must be a AP190 AP20.1 valid record in the Cash Code file. AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP28.1 AP28.2 AP30.3 AP35.1 AP520 AP55.1 AP55.2 AP56.1 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DUE-DATE Numeric 8 (yyyymmdd) AP170 AP193 Due Date The invoice due date. AP150 and AP151 AP20.1 AP20.2 use this date to determine whether to AP20.5 AP20.6 schedule the invoice payment and whether AP20.7 AP20.8 to take a discount, if applicable. AP23.1 AP30.3 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-ENCLOSURE Alpha 1 AP20.1 AP20.2 Enclosure Indicates whether the invoice payment AP20.5 AP20.6 requires an enclosure. Valid values are: AP20.7 AP20.8 AP23.1 AP30.3 N = No. AP35.1 AP520 Y = Yes. AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-HOLD-FLAG Alpha 1 AP125 AP126 On Hold Flag Indicates whether the invoice payment AP150 AP170 is on hold. If this field is Yes, AP150 AP180 AP181 or AP151 will not select the invoice AP193 AP20.1 payment. Valid values are: AP20.2 AP20.5 AP20.6 AP20.7 Y = Yes. Invoice payment is on hold. AP23.1 AP25.1 Blank = Invoice payment is not on hold. AP25.2 AP26.1 AP28.1 AP28.2 AP30.3 AP30.4 AP32.1 AP35.1 AP36.1 AP40.1 AP520 AP55.2 AP56.2 AP952 AP983 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO122 PO20.1 PO21.3 PO22.2 PO22.3 PO30.1 PO31.1 PO34.1 PO35.1 PO52.1 PO530 RQ10.1 RQ10.2 APP-VEN-CLASS Alpha 3 AP20.1 AP20.2 Vendor Class The vendor class associated with the AP20.5 AP20.6 invoice payment. Must be a valid record AP20.7 AP20.8 in the Vendor Class file. AP23.1 AP30.3 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-VEN-PRIORITY Numeric 2 AP20.1 AP20.2 Vendor Priority The payment priority defined for the AP20.5 AP20.6 vendor. Valid values are 1 (highest AP20.7 AP20.8 priority) through 99 (lowest priority). AP23.1 AP30.3 AP35.1 AP520 00 AP952 EE135 99 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PROC-GRP Alpha 4 (Lower Case) AP102 AP20.1 Process Group The process group assigned to the AP20.2 AP20.5 payment. A process group is an AP20.6 AP20.7 identifier used for separating vendors AP20.8 AP23.1 into different groups to enable AP30.3 AP35.1 concurrent processing within the cash AP520 EE135 payment cycle. Must be a valid record in EE35.1 EE35.2 the Process Group file. EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-BASE-PMT-AMT Signed 15.2 AP170 AP193 Base Payment Amount The amount of the invoice payment in AP20.1 AP20.2 (at entry) the company base currency. This amount AP20.5 AP20.6 is calculated using the currency AP20.7 AP20.8 exchange rate in effect when the invoice AP23.1 AP25.1 payment was created. AP25.2 AP28.1 AP28.2 AP30.1 AP30.3 AP35.1 AP520 AP55.2 AP56.1 AP56.2 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.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 AP20.1 AP20.2 updated when currency revaluation takes AP20.5 AP20.6 place to account for exchange rate AP20.7 AP20.8 fluctuations. AP23.1 AP30.1 AP30.3 AP30.4 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-BASE-ND Numeric 1 AP20.1 AP20.2 Base Number Of The number of decimal places defined AP20.5 AP20.6 Decimals for the company base currency. AP20.7 AP20.8 AP23.1 AP30.3 AP35.1 AP520 AP55.2 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-TRAN-PMT-AMT Signed 15.2 AP20.1 AP20.2 Payment Amount The amount of the invoice payment in AP20.5 AP20.6 the currency of the invoice. AP20.7 AP20.8 AP23.1 AP25.1 AP25.2 AP28.1 AP28.2 AP30.1 AP30.3 AP30.4 AP35.1 AP520 AP55.2 AP56.1 AP56.2 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-TRAN-ND Numeric 1 AP20.1 AP20.2 Transaction Number The number of decimal places defined AP20.5 AP20.6 of Decimals for the invoice currency. AP20.7 AP20.8 AP23.1 AP30.3 AP35.1 AP520 AP55.2 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-BANK-CHK-AMT Signed 15.2 AP150 AP170 Bank Account The amount of the invoice payment in AP190 AP20.1 Currency Amount the currency of the bank account (cash AP20.2 AP20.5 code). AP20.6 AP20.7 AP23.1 AP520 AP55.1 AP55.2 AP952 CB06.2 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-BANK-ND Numeric 1 AP150 AP170 Bank Account The number of decimal places defined AP20.1 AP20.2 Currency Decimals for the bank account currency. AP20.5 AP20.6 AP20.7 AP23.1 AP520 AP55.1 AP55.2 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-BASE-DISC-AMT Signed 15.2 AP150 AP170 Base Discount Amount The amount of the available discount AP190 AP191 for the invoice payment in the company AP193 AP20.1 base currency. AP20.2 AP20.5 AP20.7 AP20.8 AP23.1 AP30.1 AP30.3 AP32.2 AP35.1 AP520 AP55.2 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-TRAN-DISC-AMT Signed 15.2 AP150 AP20.1 Discount Amount The amount of the available discount AP20.2 AP20.5 for the invoice payment in the currency AP20.7 AP20.8 of the invoice. AP23.1 AP30.1 AP30.3 AP32.2 AP35.1 AP520 AP55.2 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.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 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP35.1 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 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 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP35.1 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-BASE-INC-WH Signed 15.2 AP150 AP170 Base Income Withheld The reportable income withholding AP190 AP193 amount in the company base currency. AP35.1 AP952 APP-TRAN-INC-WH Signed 15.2 AP150 AP170 Income Withholding The reportable income withholding AP190 AP35.1 amount in the currency of the invoice. AP520 AP952 APP-TRAN-INC-AMT Signed 15.2 AP170 AP193 Income Amount The portion of the invoice amount AP20.1 AP20.2 classified as reportable income. AP20.5 AP20.7 AP23.1 AP35.1 AP45.1 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-GAINLOS-AMT Signed 15.2 AP170 AP190 Gain or Loss Amount The currency gain or loss amount. This AP193 AP952 amount is calculated when the invoice is revalued to account for currency exchange rate fluctuations. APP-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP191 AP952 Last Revaluation The date of the last currency Date revaluation that resulted in the creation of an unrealized gain or loss 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.5 AP20.6 revalued. AP20.7 AP20.8 AP23.1 AP30.3 AP35.1 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DSC-ACCT-UNIT Alpha 15 AP170 AP193 Discount Accounting The accounting unit used for posting AP20.1 AP20.2 Unit the discount amount to the general AP20.5 AP20.6 ledger. Must be a valid accounting unit AP20.7 AP20.8 in the Lawson General Ledger system. AP23.1 AP30.3 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DSC-ACCOUNT Numeric 6 AP170 AP193 Discount Account The account number used for posting the AP20.1 AP20.2 discount amount to the general ledger. AP20.5 AP20.6 Must be a valid account in the Lawson AP20.7 AP20.8 General Ledger system. AP23.1 AP30.3 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DSC-SUB-ACCT Numeric 4 AP170 AP193 Discount Subaccount The subaccount number used for posting AP20.1 AP20.2 Number the discount amount to the general AP20.5 AP20.6 ledger. Must be a valid subaccount in AP20.7 AP20.8 the Lawson General Ledger system. AP23.1 AP30.3 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DISCOUNT-RT Signed 5.3 AP20.1 AP20.2 Discount Rate The rate used to calculate the discount AP20.5 AP20.7 amount of the invoice payment. AP20.8 AP23.1 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DISC-DATE Numeric 8 (yyyymmdd) AP150 AP170 Discount Date The date through which the available AP193 AP20.1 discount amount of the invoice can be AP20.2 AP20.5 taken. AP20.7 AP20.8 AP23.1 AP30.1 AP30.3 AP32.2 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.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 AP20.1 payments. Used to link the Invoice AP20.2 AP20.5 Payment record with the associated AP20.6 AP20.7 Accounts Payable Cash Payment record. AP20.8 AP23.1 AP28.1 AP28.2 AP520 AP55.1 AP55.2 AP56.1 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-ACCR-CODE Alpha 4 AP20.1 AP20.2 Invoice Accrual Code The invoice accrual code assigned to AP20.5 AP20.6 the invoice. Used to default a general AP20.7 AP20.8 ledger accrual account to the invoice. AP23.1 AP30.1 Must be a valid record in the Invoice AP30.3 AP35.1 Accrual Code file. AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PROC-LEVEL Alpha 5 AP20.1 AP20.2 Process Level The process level associated with the AP20.5 AP20.6 invoice. Must be a valid record in the AP20.7 AP20.8 Accounts Payable Process Level file. AP23.1 AP30.1 AP30.3 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-REC-STATUS Numeric 1 AP125 AP126 Record Status The record status. Valid values are: AP150 AP151 AP155 AP157 0 = Unreleased AP160 AP161 1 = Released AP170 AP180 2 = Selected for Payment AP181 AP190 3 = Paid with a System Cash Payment AP193 AP20.8 4 = Paid with a Manual Payment AP25.1 AP25.2 5 = Paid with a Bill of Exchange Payment AP26.1 AP28.1 AP28.2 AP30.3 7 = Unreleased Manual Payment AP35.1 AP520 8 = Canceled (bill of exchange) AP55.1 AP55.2 9 = Historical AP56.1 AP56.2 AP952 CB06.2 Note: All void status invoice payment CB191 EE135 records should have a historical status. EE35.1 EE35.2 EE520 MA530 MA540 PO31.1 APP-TRANS-NBR Alpha 10 (Right Justified) AP151 AP155 Payment Number The system or manual payment number AP157 AP160 used to pay the invoice payment. AP161 AP170 AP180 AP181 AP190 AP193 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP28.1 AP28.2 AP520 AP55.1 AP55.2 AP56.1 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-CHK-SUFFIX Numeric 3 AP20.8 AP56.1 Payment Suffix The system or manual payment suffix AP56.2 AP952 Number number used to pay the invoice payment. APP-BANK-INST-CODE Alpha 3 AP150 AP160 Payment Code The payment code assigned to the AP161 AP180 invoice payment. Represents a type of AP181 AP190 cash or bill of exchange payment used to AP20.1 AP20.2 pay the invoice payment. Must be a valid AP20.5 AP20.6 cash payment or bill of exchange payment AP20.7 AP20.8 transaction code record in the Bank AP23.1 AP28.1 Transaction Code file. AP28.2 AP30.3 AP35.1 AP520 AP55.1 AP55.2 AP56.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-CHECK-DATE Numeric 8 (yyyymmdd) AP155 AP157 Payment Date The date assigned to the system or AP160 AP161 manual payment associated with the AP170 AP180 invoice payment record. AP181 AP190 AP193 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP35.1 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 APP-INCOME-CODE Alpha 4 AP20.1 AP20.2 Income Code The income code assigned to the invoice AP20.5 AP20.6 payment record. Used to track vendor AP20.7 AP20.8 reportable income. Must be a valid AP23.1 AP30.3 record in the Income Code file. AP35.1 AP45.1 AP520 AP952 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-SEP-CHK-FLAG Alpha 1 AP170 AP20.1 Separate Payment Indicates whether the payment should be AP20.2 AP20.5 made on a separate payment form from AP20.6 AP20.7 other payments to the same vendor. Valid AP20.8 AP23.1 values are: AP30.3 AP35.1 AP520 AP952 N = No. EE135 EE35.1 Y = Yes. EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PAY-IMM-FLAG Alpha 1 AP170 AP20.1 Pay Immediately Indicates whether the invoice is to be AP20.2 AP20.5 paid immediately regardless of the AP20.6 AP20.7 invoice due date. Valid values are: AP20.8 AP23.1 AP30.3 AP35.1 N = No. AP40.1 AP520 Y = Yes. AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DISC-LOST-FLG Alpha 1 AP150 AP170 Discount Lost Indicates whether the available AP190 AP193 discount for the invoice payment was AP20.1 AP20.2 lost. Valid values are: AP20.5 AP20.6 AP20.7 AP20.8 N = No. AP23.1 AP30.3 Y = Yes. AP35.1 AP520 AP55.1 AP55.2 AP952 CB06.2 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-ANTICIPATION Alpha 1 AP20.1 AP20.2 Anticipation Indicates whether anticipation criteria AP20.5 AP20.6 Discount should be used to calculate the discount AP20.7 AP20.8 amount for the invoice payment. Valid AP23.1 AP30.3 values are: AP35.1 AP520 AP952 EE135 Y = Yes. EE35.1 EE35.2 N = No. EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-INVOICE-GROUP Alpha 4 AP170 AP193 Invoice Group The invoice group assigned to the AP20.1 AP20.2 invoice payment. An invoice group is a AP20.5 AP20.7 user-defined character expression that AP20.8 AP23.1 can be used to select invoices for AP30.3 AP35.1 payment. AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-VENDOR-GROUP Alpha 4 AP20.1 AP20.2 Vendor Group The vendor group associated with the AP20.5 AP20.6 invoice payment. Must be a valid record AP20.7 AP20.8 in the Vendor Group file. AP23.1 AP30.3 AP35.1 AP520 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-PAY-GROUP Alpha 4 AP101 AP180 Pay Group The pay group associated with the AP181 AP20.1 invoice payment. A pay group is used for AP20.2 AP20.5 processing accounts payable payments. AP20.6 AP20.7 Must be a valid record in the Pay Group AP20.8 AP23.1 file. AP28.1 AP28.2 AP30.3 AP35.1 AP520 AP55.2 AP56.2 AP952 EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-DISCOUNT-CODE Alpha 10 AP20.1 AP20.2 Discount Code The discount code assigned to the AP20.5 AP20.6 invoice payment. Used to default a AP20.7 AP20.8 general ledger discount account to the AP23.1 AP30.3 invoice. Must be a valid record in the AP520 AP952 Discount Code file. MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-INC-ACCR-CODE Alpha 10 AP20.1 AP20.2 Income Withholding The withholding code assigned to the AP20.5 AP20.6 Code invoice payment. Used to default a AP20.7 AP20.8 general ledger withholding accrual AP23.1 AP520 account to the invoice. Must be a valid AP952 MA40.1 record in the Income Withholding Code MA40.2 MA41.1 file. MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 PO31.1 APP-RECON-STMT-NBR Numeric 12 AP190 AP55.2 Reconciliation The bank-assigned reconciliation CB06.2 Statement statement number. Used only for cash codes that require reconciliation statements. 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 Invoice 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 Invoice Date Used by Lawson SEA programs. APP-AP-PO-NBR Derived Purchase Order Used by Lawson SEA programs. Number APP-AP-INV-TYPE Derived Invoice Type Used by Lawson SEA programs. APP-AP-BASE-INV Derived Base Invoice Used by Lawson SEA programs. APP-AP-FORMAT-NBR Derived Format Number Used by Lawson SEA programs. APPAYMENT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN APPSET1 COMPANY This index is used to access payment AP125 AP126 VENDOR records for a specific invoice. AP150 AP151 INVOICE AP170 AP180 SUFFIX AP181 AP190 CANCEL-SEQ AP191 AP193 SEQ-NBR AP195 AP197 VOID-SEQ AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8 AP213 AP225 AP226 AP23.1 AP240 AP25.1 AP25.2 AP26.1 AP260 AP28.1 AP28.2 AP282 ... APPSET10 REC-STATUS This index is used to access payment AP00.7 AP101 COMPANY records by a specific status. AP145 AP146 PROC-LEVEL AP230 AP245 VENDOR KeyChange 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 CANCEL-SEQ KeyChange, Subset SEQ-NBR Where (REC-STATUS = 1 ) VOID-SEQ Or (REC-STATUS = 2 ) COMPANY APPSET2 PAY-GROUP This index is used to access payment AP10.1 AP102 REC-STATUS records for a specific invoice by AP270 AP40.1 VENDOR payment status. AP92.2 INVOICE SUFFIX KeyChange 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 SUFFIX KeyChange 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 CANCEL-SEQ KeyChange, Subset SEQ-NBR Where REC-STATUS = 1 VOID-SEQ Or REC-STATUS = 2 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 AP157 VENDOR associated with a specific transaction AP160 AP161 INVOICE ID by pay group and payment code. AP180 AP181 SUFFIX AP190 AP25.1 CANCEL-SEQ KeyChange, Subset AP25.2 AP26.1 SEQ-NBR Where TRANS-IDENT != Zeroes AP265 AP28.1 VOID-SEQ AP28.2 AP32.1 COMPANY AP55.1 AP55.2 AP56.1 AP56.2 CB06.2 CB191 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 VENDOR KeyChange 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 Cbstatemnt 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 Invcurrency CUCODES Required APP-INV-CURRENCY -> CUC-CURRENCY-CODE APPAYMENT FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH 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 Apinvcomments APCOMMENTS "I" -> APC-REC-TYPE APP-COMPANY -> APC-COMPANY APP-VENDOR -> APC-VENDOR Spaces -> APC-LOCATION-CODE APP-INVOICE -> APC-INVOICE APP-SUFFIX -> APC-SUFFIX APC-SEQ-NBR 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 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-INVOICE APC-SUFFIX APC-SEQ-NBR |