Lawson Insight Technical Documentation |
|
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
|