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
AM19.1 AM19.2 AM19.4 AP131 AP136 AP178
AP195 AP197 AP198 AP213 AP220 AP240
AP282 AP284 AP57.2 AR48.3 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.1 EE230 MA168
MA180 MA279 MA530 MA531 MA63.1 MA67.2
MA67.3 MA80.1 MAED.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 PR277
UK277 RQ10.1 RQ10.2 WH20.2 WH20.7 AP00.5
AP145 AP146 AP230 AP245 AP250 AP270
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP03.3 AP10.1 AP110
AP210 AP510 AP90.1 AP90.5 AP91.1 AP92.2
API3.1 API4.1 MX123 MX500 PD235 PO10.1
PO120 PO220 PO223 PO233 PO253 PO254
PO278 PO54.1 PO54.2 PO54.3 PO54.4 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 EE30.1 AP156 AP265 CB186 CB187
CB286 AP255 CB170
UPDATED BY
AP101 AP102 AP115 AP125 AP126 AP141
AP150 AP151 AP155 AP160 AP161 AP170
AP180 AP181 AP190 AP191 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP20.8 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP30.1 AP30.3 AP30.4
AP300 AP32.1 AP35.1 AP36.1 AP40.1 AP45.1
AP520 AP55.1 AP55.2 AP56.1 AP56.2 API1.1
API2.1 CB06.2 CB191 EE135 EE35.1 EE35.2
EE520 ET542 ET545 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA60.2 MA60.4 MA61.1 MA65.1 MA66.2
MA66.3 MA68.2 MA68.4 MA70.1 MA75.1 MAI1.1
AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APP-COMPANY Numeric 4 AP180 AP181
Element: Company The company number associated with the AP190 AP20.1
invoice payment. Must be a valid record AP20.2 AP20.3
in the Accounts Payable Company file. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP32.1 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Element: Vendor The vendor number associated with the AP181 AP190
invoice payment. Must be a valid record AP20.1 AP20.2
in the Vendor file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-INVOICE Alpha 22 AP115 AP180
Element: Invoice The invoice number. Must be a valid AP181 AP190
record in the Accounts Payable Invoice AP20.1 AP20.2
file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-SUFFIX Numeric 3 AP170 AP180
Element: Suffix The invoice suffix number. Represents AP181 AP190
the occurrence value of the invoice for AP193 AP20.8
recurring invoices, employee advances, AP25.1 AP25.2
and prepayment credit memos. AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API2.1
MA70.1 MA75.1
APP-CANCEL-SEQ Numeric 4 AP180 AP181
Element: Seq Nbr The sequence number assigned upon the AP190 AP28.1
cancellation of a distributed invoice. AP28.2 AP30.4
The first sequence assigned is 9999. AP32.1 AP45.1
APP-SEQ-NBR Numeric 4 AP170 AP180
Element: Seq Nbr An automatically assigned sequence AP181 AP190
number. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-VOID-SEQ Numeric 4 AP180 AP181
Element: Seq Nbr The void sequence for the invoice AP190 AP28.1
payment. Used by the system to keep AP28.2 AP32.1
payment records unique each time a AP45.1
payment is voided and the invoice is
reinstated for payment.
APP-VOID-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Date The date assigned to a voided payment AP190 AP28.1
associated with the invoice payment AP28.2 AP45.1
record.
APP-INV-CURRENCY Alpha 5 AP180 AP181
Element: To Base Curr The currency of the invoice. Must be a AP190 AP20.1
valid record in the Currency Code file. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP180
Element: Pay Vendor The pay vendor associated with the AP181 AP190
invoice payment. Represents the vendor AP20.1 AP20.2
that will receive payment for the AP20.3 AP20.4
invoice. Must be a valid record in the AP20.5 AP20.6
Vendor file. AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.2
AP56.2 API1.1
API2.1 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-REMIT-TO-CODE Alpha 4 AP115 AP180
Element: Remit To Code The remit-to location associated with AP181 AP190
the invoice payment. Must be a valid AP20.1 AP20.2
record in the Vendor Location file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.1
AP55.2 AP56.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APP-PAY-COMPANY Numeric 4 AP151 AP180
Element: Pay Company The company associated with the pay AP181 AP190
vendor. Must be a valid record in the AP20.1 AP20.2
Accounts Payable Company file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP45.1
AP520 AP55.1
AP55.2 API1.1
API2.1 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-CASH-CODE Alpha 4 AP115 AP150
Element: Cash Code The cash code assigned to the invoice. AP151 AP160
Represents the bank account the invoice AP161 AP180
payment is to be paid from. Must be a AP181 AP190
valid record in the Cash Code file. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
AP55.1 AP55.2
AP56.1 AP56.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-DUE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Due Date The invoice due date. AP150 and AP151 AP181 AP190
use this date to determine whether to AP193 AP20.1
schedule the invoice payment and whether AP20.2 AP20.3
to take a discount, if applicable. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APP-ENCLOSURE Alpha 1 AP180 AP181
Element: All Flag Indicates whether the invoice payment AP190 AP20.1
requires an enclosure. Valid values are: AP20.2 AP20.3
AP20.4 AP20.5
N = No. AP20.6 AP20.7
Y = Yes. AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-HOLD-FLAG Alpha 1 AP125 AP126
Element: Hold Flag Indicates whether the invoice payment AP141 AP150
is on hold. If this field is Yes, AP150 AP170 AP180
or AP151 will not select the invoice AP181 AP190
payment. Valid values are: AP193 AP20.1
AP20.2 AP20.3
Y = Yes. Invoice payment is on hold. AP20.4 AP20.5
Blank = Invoice payment is not on hold. AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.3 AP30.4
AP32.1 AP35.1
AP36.1 AP40.1
AP45.1 AP520
AP55.2 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
ET542 ET545
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MA70.1 MA75.1
...
APP-VEN-CLASS Alpha 3 AP115 AP180
Element: Ven Class The vendor class associated with the AP181 AP190
invoice payment. Must be a valid record AP20.1 AP20.2
in the Vendor Class file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-VEN-PRIORITY Numeric 2 AP115 AP180
Element: Ven Priority The payment priority defined for the AP181 AP190
vendor. Valid values are 1 (highest AP20.1 AP20.2
priority) through 99 (lowest priority). AP20.3 AP20.4
AP20.5 AP20.6
00 AP20.7 AP20.8
99 AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-PROC-GRP Alpha 4 (Lower Case) AP102 AP115
Element: Process Group The process group assigned to the AP180 AP181
payment. A process group is an AP190 AP20.1
identifier used for separating vendors AP20.2 AP20.3
into different groups to enable AP20.4 AP20.5
concurrent processing within the cash AP20.6 AP20.7
payment cycle. Must be a valid record in AP20.8 AP21.1
the Process Group file. AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-BASE-PMT-AMT Signed 18.2 AP170 AP180
Base Payment Amount The amount of the invoice payment in AP181 AP190
(at entry) the company base currency. This amount AP193 AP20.1
is calculated using the currency AP20.2 AP20.3
exchange rate in effect when the invoice AP20.4 AP20.5
payment was created. AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP35.1
AP45.1 AP520
AP55.2 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
APP-BASE-ACT-AMT Signed 18.2 AP170 AP180
Base Payment Amount The amount of the invoice payment in AP181 AP190
(revalued) the company base currency. For non-base AP191 AP193
currency invoices, this amount may be AP20.1 AP20.2
updated when currency revaluation takes AP20.3 AP20.4
place to account for exchange rate AP20.5 AP20.6
fluctuations. AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP30.4 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
APP-BASE-ND Numeric 1 AP180 AP181
Element: Base Nd The number of decimal places defined AP190 AP20.1
for the company base currency. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-TRAN-PMT-AMT Signed 18.2 AP180 AP181
Element: Intl Amt The amount of the invoice payment in AP190 AP20.1
the currency of the invoice. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP30.4
AP35.1 AP45.1
AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
APP-TRAN-ND Numeric 1 AP180 AP181
Element: Acct Nd The number of decimal places defined AP190 AP20.1
for the invoice currency. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-BANK-CHK-AMT Signed 18.2 AP150 AP170
Bank Account The amount of the invoice payment in AP180 AP181
Currency Amount the currency of the bank account (cash AP190 AP20.1
code). AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
AP55.1 AP55.2
CB06.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA70.1 MA75.1
APP-BANK-ND Numeric 1 AP150 AP170
Bank Account The number of decimal places defined AP180 AP181
Currency Decimals for the bank account currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
AP55.1 AP55.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-BASE-DISC-AMT Signed 18.2 AP150 AP170
Element: Intl Amt The amount of the available discount AP180 AP181
for the invoice payment in the company AP190 AP191
base currency. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1
APP-TRAN-DISC-AMT Signed 18.2 AP150 AP170
Element: Intl Amt The amount of the available discount AP180 AP181
for the invoice payment in the currency AP190 AP20.1
of the invoice. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1
APP-BASE-CHK-AMT Signed 18.2 AP150 AP170
Element: Intl Amt The net payment amount for the invoice AP180 AP181
in the company base currency. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA70.1
MA75.1
APP-TRAN-CHK-AMT Signed 18.2 AP150 AP170
Element: Intl Amt The net payment amount for the invoice AP180 AP181
in the currency of the invoice. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA70.1
MA75.1
APP-BASE-INC-WH Signed 18.2 AP150 AP170
Element: Intl Amt The reportable income withholding AP180 AP181
amount in the company base currency. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
APP-TRAN-INC-WH Signed 18.2 AP150 AP170
Element: Intl Amt The reportable income withholding AP180 AP181
amount in the currency of the invoice. AP190 AP28.1
AP28.2 AP35.1
AP45.1 AP520
APP-TRAN-INC-AMT Signed 18.2 AP170 AP180
Element: Intl Amt The portion of the invoice amount AP181 AP190
classified as reportable income. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP35.1
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-GAINLOS-AMT Signed 18.2 AP170 AP180
Element: Gain or Loss AThe currency gain or loss amount. This AP181 AP190
amount is calculated when the invoice is AP193 AP28.1
revalued to account for currency AP28.2 AP45.1
exchange rate fluctuations. MA70.1 MA75.1
APP-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Date The date of the last currency AP190 AP191
revaluation that resulted in the AP28.1 AP28.2
creation of an unrealized gain or loss AP30.3 AP45.1
transaction.
APP-ACT-CNV-RATE Signed 14.7 AP170 AP180
Currency Exchange The currency exchange rate used to AP181 AP190
Rate convert the invoice payment amount to AP191 AP193
the company base currency. This field AP20.1 AP20.2
may be updated when the invoice is AP20.3 AP20.4
revalued. AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
AP55.1 AP55.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-DSC-ACCT-UNIT Alpha 15 AP170 AP180
Element: Acct Unit The accounting unit used for posting AP181 AP190
the discount amount to the general AP193 AP20.1
ledger. Must be a valid accounting unit AP20.2 AP20.3
in the Lawson General Ledger system. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-DSC-ACCOUNT Numeric 6 AP170 AP180
Element: Account The account number used for posting the AP181 AP190
discount amount to the general ledger. AP193 AP20.1
Must be a valid account in the Lawson AP20.2 AP20.3
General Ledger system. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-DSC-SUB-ACCT Numeric 4 AP170 AP180
Element: Sub Acct The subaccount number used for posting AP181 AP190
the discount amount to the general AP193 AP20.1
ledger. Must be a valid subaccount in AP20.2 AP20.3
the Lawson General Ledger system. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-DISCOUNT-RT Percent 5.3 (Percent) AP180 AP181
Element: Discount Rt The rate used to calculate the discount AP190 AP20.1
amount of the invoice payment. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MAI1.1
APP-DISC-DATE Numeric 8 (yyyymmdd) AP150 AP170
Element: Date The date through which the available AP180 AP181
discount amount of the invoice can be AP190 AP193
taken. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
APP-TRANS-IDENT Numeric 10 AP150 AP151
Element: Transaction IDA sequencing number created by AP150 AP170 AP180
(Cash Requirements) or AP151 (Bill of AP181 AP190
Exchange Generation) to sequence AP193 AP20.1
payments. Used to link the Invoice AP20.2 AP20.3
Payment record with the associated AP20.4 AP20.5
Accounts Payable Cash Payment record. AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 AP55.1
AP55.2 AP56.1
AP56.2 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA70.1
MA75.1
APP-ACCR-CODE Alpha 4 AP180 AP181
Element: Invoice AccruaThe invoice accrual code assigned to AP190 AP20.1
the invoice. Used to default a general AP20.2 AP20.3
ledger accrual account to the invoice. AP20.4 AP20.5
Must be a valid record in the Invoice AP20.6 AP20.7
Accrual Code file. AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-PROC-LEVEL Alpha 5 AP180 AP181
Element: Process Level The process level associated with the AP190 AP20.1
invoice. Must be a valid record in the AP20.2 AP20.3
Accounts Payable Process Level file. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-REC-STATUS Numeric 1 AP125 AP126
Element: Rec Status The record status. Valid values are: AP150 AP151
AP155 AP160
0 = Unreleased AP161 AP170
1 = Released AP180 AP181
2 = Selected for Payment AP190 AP193
3 = Paid with a System Cash Payment AP20.1 AP20.2
4 = Paid with a Manual Payment AP20.3 AP20.4
5 = Paid with a Bill of Exchange Payment AP20.5 AP20.7
7 = Unreleased Manual Payment AP20.8 AP21.1
8 = Canceled (bill of exchange) AP23.1 AP25.1
9 = Historical AP25.2 AP26.1
AP27.1 AP28.1
Note: All void status invoice payment AP28.2 AP30.3
records should have a historical status. AP35.1 AP45.1
AP520 AP55.1
AP55.2 AP56.1
AP56.2 API1.1
API2.1 CB06.2
CB191 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA61.1
MA66.3 MA70.1
MA75.1 MAI1.1
APP-TRANS-NBR Alpha 10 (Right Justified) AP151 AP155
Element: Payment NumberThe system or manual payment number AP160 AP161
used to pay the invoice payment. AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 AP55.1
AP55.2 AP56.1
AP56.2 CB06.2
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA70.1
MA75.1
APP-CHK-SUFFIX Numeric 3 AP180 AP181
Payment Suffix The system or manual payment suffix AP190 AP20.8
Number number used to pay the invoice payment. AP28.1 AP28.2
AP45.1 AP56.1
AP56.2 MA70.1
MA75.1
APP-BANK-INST-CODE Alpha 3 AP115 AP150
Element: Payment Code The payment code assigned to the AP160 AP161
invoice payment. Represents a type of AP180 AP181
cash or bill of exchange payment used to AP190 AP20.1
pay the invoice payment. Must be a valid AP20.2 AP20.3
cash payment or bill of exchange payment AP20.4 AP20.5
transaction code record in the Bank AP20.6 AP20.7
Transaction Code file. AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 AP55.1
AP55.2 AP56.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-CHECK-DATE Numeric 8 (yyyymmdd) AP155 AP160
Element: Payment Date The date assigned to the system or AP161 AP170
manual payment associated with the AP180 AP181
invoice payment record. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP35.1 AP45.1
AP520 AP55.1
AP55.2 CB06.2
EE135 EE35.1
EE35.2 EE520
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA70.1 MA75.1
APP-INCOME-CODE Alpha 4 AP180 AP181
Element: Income Code The income code assigned to the invoice AP190 AP20.1
payment record. Used to track vendor AP20.2 AP20.3
reportable income. Must be a valid AP20.4 AP20.5
record in the Income Code file. AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-SEP-CHK-FLAG Alpha 1 AP170 AP180
Element: Separate PaymeIndicates whether the payment should be AP181 AP190
made on a separate payment form from AP20.1 AP20.2
other payments to the same vendor. Valid AP20.3 AP20.4
values are: AP20.5 AP20.6
AP20.7 AP20.8
N = No. AP21.1 AP23.1
Y = Yes. AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-PAY-IMM-FLAG Alpha 1 AP170 AP180
Element: Pay ImmediatelIndicates whether the invoice is to be AP181 AP190
paid immediately regardless of the AP20.1 AP20.2
invoice due date. Valid values are: AP20.3 AP20.4
AP20.5 AP20.6
N = No. AP20.7 AP20.8
Y = Yes. AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP40.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-DISC-LOST-FLG Alpha 1 AP150 AP170
Element: Discount Lost Indicates whether the available AP180 AP181
discount for the invoice payment was AP190 AP193
lost. Valid values are: AP20.1 AP20.2
AP20.3 AP20.4
N = No. AP20.5 AP20.6
Y = Yes. AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
AP55.1 AP55.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-ANTICIPATION Alpha 1 AP180 AP181
Anticipation Indicates whether anticipation criteria AP190 AP20.1
Discount should be used to calculate the discount AP20.2 AP20.3
amount for the invoice payment. Valid AP20.4 AP20.5
values are: AP20.6 AP20.7
AP20.8 AP21.1
Y = Yes. AP23.1 AP28.1
N = No. AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-INVOICE-GROUP Alpha 4 AP115 AP170
Element: Invoice Group The invoice group assigned to the AP180 AP181
invoice payment. An invoice group is a AP190 AP20.1
user-defined character expression that AP20.2 AP20.3
can be used to select invoices for AP20.4 AP20.5
payment. AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-VENDOR-GROUP Alpha 4 AP180 AP181
Element: Vendor Group The vendor group associated with the AP190 AP20.1
invoice payment. Must be a valid record AP20.2 AP20.3
in the Vendor Group file. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-PAY-GROUP Alpha 4 AP101 AP180
Element: Pay Group The pay group associated with the AP181 AP190
invoice payment. A pay group is used for AP20.1 AP20.2
processing accounts payable payments. AP20.3 AP20.4
Must be a valid record in the Pay Group AP20.5 AP20.6
file. AP20.7 AP20.8
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.2
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APP-DISCOUNT-CODE Alpha 10 AP180 AP181
Element: Discount Code The discount code assigned to the AP190 AP20.1
invoice payment. Used to default a AP20.2 AP20.3
general ledger discount account to the AP20.4 AP20.5
invoice. Must be a valid record in the AP20.6 AP20.7
Discount Code file. AP20.8 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-INC-ACCR-CODE Alpha 10 AP180 AP181
Element: Inc Accr Code The withholding code assigned to the AP190 AP20.1
invoice payment. Used to default a AP20.2 AP20.3
general ledger withholding accrual AP20.4 AP20.5
account to the invoice. Must be a valid AP20.6 AP20.7
record in the Income Withholding Code AP20.8 AP21.1
file. AP23.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APP-RECON-STMT-NBR Numeric 12 AP180 AP181
Element: Recon Stmt NbrThe bank-assigned reconciliation AP190 AP28.1
statement number. Used only for cash AP28.2 AP45.1
codes that require reconciliation CB06.2
statements.
APP-MATCH-DISC-TAK Alpha 1 AP180 AP181
Element: Match DiscountIndicates if a discount was taken AP190 AP28.1
during the invoice matching process. AP28.2 AP45.1
" " AP520 MA61.1
Y = Yes MA66.2 MA70.1
MA75.1 MAI1.1
APP-OPEN-BASE-PMT Derived
Element: Open Base Pmt The amount of the invoice remaining to
be paid in the company base currency.
APP-OPEN-TRAN-PMT Derived
Element: Open Tran Pmt The amount of the invoice remaining to
be paid in the currency of the invoice.
APP-BASE-NET-PMT Derived
Element: Base Net Pmt The net invoice amount paid in the
company base currency.
APP-TRAN-NET-PMT Derived
Element: Tran Net Pmt The net invoice amount paid in the
currency of the invoice.
APP-PMT-STATUS Derived
Element: Payment StatusDisplays the payment status when Drill
Around(TM) is used. Valid values are:
OPEN = The payment record has an open
status.
PAID = The payment record has a paid
status.
APP-BANK-STATUS Derived
Element: Bank Status The reconciliation status of the
payment record associated with the
invoice payment.
APP-NO-REINSTATE Derived
Payment Not If the invoice payment was paid and the
Reinstated payment was voided, this field indicates
if the split invoice has not been
reinstated by AP190 (Invoice
Reinstatement).
APP-PAID-DOC-DATE Derived
Payment Document If the invoice payment was paid with a
Date cash payment, this field contains the
date assigned to the cash payment. If
the invoice payment was paid with a bill
of exchange payment, this field contains
the date the bill of exchange was
cashed.
APP-DRAFT-ACCRUED Derived
Bill of Exchange If the invoice payment was paid with a
Accrued bill of exchange, this field indicates
whether the bill of exchange has been
accrued in the general ledger.
APP-AP-INV-DATE Derived
Element: Ap Inv Date
APP-AP-PO-NBR Derived
Element: Ap Po Nbr
APP-AP-INV-TYPE Derived
Element: Ap Inv Type
APP-AP-BASE-INV Derived
Element: Ap Base Inv
APP-AP-FORMAT-NBR Derived
Element: Ap Format Nbr
APP-STATEMENT Alpha 22 API1.1
Element: Invoice Used to identify the invoice.
APPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APPSET1 COMPANY AM19.1 AM19.2
VENDOR AM19.4 AP115
INVOICE AP125 AP126
SUFFIX AP131 AP136
CANCEL-SEQ AP141 AP150
SEQ-NBR AP151 AP170
VOID-SEQ AP178 AP180
AP181 AP190
AP191 AP193
AP195 AP197
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
...
APPSET10 REC-STATUS KeyChange AP00.5 AP101
COMPANY AP145 AP146
PROC-LEVEL AP230 AP245
VENDOR AP250 AP270
INVOICE MA168
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
APPSET12 PAY-GROUP KeyChange, Subset AP55.2 AP56.2
VENDOR Where (REC-STATUS = 1 )
INVOICE Or (REC-STATUS = 2 )
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET2 PAY-GROUP KeyChange AC160 AM115
REC-STATUS AM117 AM15.1
VENDOR AM15.2 AM15.3
INVOICE AM15.4 AM19.1
SUFFIX AM19.2 AM20.1
CANCEL-SEQ AM20.3 AM21.1
SEQ-NBR AM21.3 AM500
VOID-SEQ AM51.1 AM551
COMPANY AM97.1 AP03.3
AP10.1 AP102
AP110 AP115
AP125 AP126
AP131 AP141
AP20.1 AP20.2
AP20.3 AP20.4
...
APPSET3 PAY-GROUP KeyChange AP150 AP151
REC-STATUS AP170
PAY-IMM-FLAG
PROC-GRP
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET4 COMPANY KeyChange, Subset AP191 AP30.3
VENDOR Where REC-STATUS = 1 AP35.1 EE30.1
INVOICE Or REC-STATUS = 2
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
APPSET6 PAY-GROUP KeyChange, Subset AP125 AP126
BANK-INST-CODEWhere TRANS-IDENT != Zeroes AP151 AP155
TRANS-IDENT AP156 AP160
VENDOR AP161 AP180
INVOICE AP181 AP190
SUFFIX AP25.1 AP25.2
CANCEL-SEQ AP26.1 AP265
SEQ-NBR AP27.1 AP28.1
VOID-SEQ AP28.2 AP32.1
COMPANY AP55.1 AP55.2
AP56.1 AP56.2
CB06.2 CB186
CB187 CB191
CB286 MA61.1
MAI1.1
APPSET8 PAY-GROUP KeyChange AP255 AP90.5
CASH-CODE CB170
TRANS-NBR
BANK-INST-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
APPAYMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APP-COMPANY -> CPY-COMPANY
Apdrafts APDRAFTS Not Required
APP-BANK-INST-CODE -> APT-BANK-INST-CODE
APP-TRANS-IDENT -> APT-TRANS-IDENT
Apinvoice APINVOICE Required
APP-COMPANY -> API-COMPANY
APP-VENDOR -> API-VENDOR
APP-INVOICE -> API-INVOICE
APP-SUFFIX -> API-SUFFIX
APP-CANCEL-SEQ -> API-CANCEL-SEQ
Appayvendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APP-PAY-VENDOR -> VEN-VENDOR
Approclev APPROCLEV Required
APP-COMPANY -> APR-COMPANY
APP-PROC-LEVEL -> APR-PROC-LEVEL
Apvenclass APVENCLASS Required
CPY-VENDOR-GROUP -> VCL-VENDOR-GROUP
APP-VEN-CLASS -> VCL-VEN-CLASS
Apvencurrbal APVENBAL Not Required
CPY-VENDOR-GROUP -> VBA-VENDOR-GROUP
APP-COMPANY -> VBA-COMPANY
APP-VENDOR -> VBA-VENDOR
APP-REMIT-TO-CODE -> VBA-LOCATION-CODE
Apvengroup APVENGROUP Required
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP
Apvenloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
APP-PAY-VENDOR -> VLO-VENDOR
APP-REMIT-TO-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APP-VENDOR -> VEN-VENDOR
Cbbankinst CBBANKINST Required
APP-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
APP-CASH-CODE -> CBC-CASH-CODE
Cbcashform CBCASHFORM Not Required
APP-CASH-CODE -> CCF-CASH-CODE
APP-BANK-INST-CODE -> CCF-BANK-INST-CODE
APP-PROC-GRP -> CCF-PROC-GRP
Cbcheck CBCHECK Required
APP-CASH-CODE -> CHK-CASH-CODE
APP-BANK-INST-CODE -> CHK-BANK-INST-CODE
APP-TRANS-IDENT -> CHK-TRANS-IDENT
Cbcpycach CBCPYCASH Required
APP-PAY-COMPANY -> CBY-COMPANY
APP-CASH-CODE -> CBY-CASH-CODE
Cbstatement CBSTATEMNT Not Required
APP-CASH-CODE -> CSM-CASH-CODE
APP-RECON-STMT-NBR -> CSM-RECON-STMT-NBR
Cbtrans CBTRANS Not Required
Valid When CHK-SERIAL-NUM = Zeroes
APP-BANK-INST-CODE -> CBT-BANK-INST-CODE
APP-TRANS-IDENT -> CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid When CHK- = APP-
And CHK-REC-STATUS = 2
And CHK-SERIAL-NUM != Zeroes
CHK-BANK-INST-CODE -> CBT-BANK-INST-CODE
CHK-SERIAL-NUM -> CBT-SERIAL-NUM
CHK-TRANS-IDENT -> CBT-TRANS-IDENT
Invcurrency CUCODES Required
APP-INV-CURRENCY -> CUC-CURRENCY-CODE
APPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdiscacc APDISCACC
APP-COMPANY -> DSK-COMPANY
APP-VENDOR -> DSK-VENDOR
APP-INVOICE -> DSK-INVOICE
APP-SUFFIX -> DSK-SUFFIX
APP-CANCEL-SEQ -> DSK-CANCEL-SEQ
APP-SEQ-NBR -> DSK-SEQ-NBR
DSK-VOID-SEQ
DSK-DISC-TYPE
Aphldinv APHLDINV Delete Cascades
Valid When (APP-HOLD-FLAG = "Y" )
"P" -> HLI-REC-TYPE
APP-VENDOR-GROUP -> HLI-VENDOR-GROUP
APP-COMPANY -> HLI-COMPANY
APP-VENDOR -> HLI-VENDOR
APP-INVOICE -> HLI-INVOICE
APP-SUFFIX -> HLI-SUFFIX
APP-CANCEL-SEQ -> HLI-CANCEL-SEQ
APP-SEQ-NBR -> HLI-SEQ-NBR
APP-VOID-SEQ -> HLI-VOID-SEQ
HLI-HLD-CODE
Appset6 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-TRANS-IDENT -> APP-TRANS-IDENT
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
APP-COMPANY
Appset8 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-CASH-CODE -> APP-CASH-CODE
APP-TRANS-NBR -> APP-TRANS-NBR
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-COMPANY
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Apvencomments APCOMMENTS
"V" -> APC-REC-TYPE
CPY-VENDOR-GROUP -> APC-VENDOR-GROUP
APP-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
APP-COMPANY -> APC-COMPANY
APC-SEQ-NBR
Apvendiv APVENDIV
APP-VENDOR-GROUP -> VDC-VENDOR-GROUP
APP-VENDOR -> VDC-VENDOR
API-LOCATION -> VDC-LOCATION-CODE
VDC-DIVERSE-CODE
VDC-DCERT-DATE
Cbstmtdtl CBSTMTDTL
APP-BANK-INST-CODE -> CSD-BANK-INST-CODE
APP-RECON-STMT-NBR -> CSD-RECON-STMT-NBR
APP-TRANS-NBR -> CSD-PAYMENT-NBR
"V" -> CSD-TRANS-TYPE
APP-CASH-CODE -> CSD-CASH-CODE
CSD-LINE-NBR
|