 |
Lawson Insight Technical Documentation |
|
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 DA290 IC28.1 MA180 MA530 MA531
MA66.3 MA67.1 MA67.2 MAED.1 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 PR277 RQ10.1 RQ10.2 WH20.2 WH20.7
AP00.5 AP145 AP146 AP230 AP245 AP250
AP270 AP10.1 AP92.2 API3.1 API4.1 IC840
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 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 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA60.2 MA60.4 MA61.1 MA65.1
MA70.1 MAI1.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APP-COMPANY Numeric 4 AP180 AP181
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
AP260 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
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 AP260
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
Invoice Number 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
AP23.1 AP260
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
Invoice Suffix The 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 AP260
AP27.1 AP28.1
AP28.2 AP30.3
AP32.1 AP35.1
AP45.1 AP520
APP-CANCEL-SEQ Numeric 4 AP180 AP181
Cancel Sequence The sequence number assigned upon the AP190 AP260
cancellation of a distributed invoice. AP28.1 AP28.2
The first sequence assigned is 9999. AP30.4 AP32.1
AP45.1
APP-SEQ-NBR Numeric 4 AP170 AP180
Sequence Number An automatically assigned sequence AP181 AP190
number. 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
Void Sequence The void sequence for the invoice AP190 AP28.1
payment. Used by the system to keep AP28.2 AP32.1
payment records unique each time a AP45.1
payment is voided and the invoice is
reinstated for payment.
APP-VOID-DATE Numeric 8 (yyyymmdd) AP180 AP181
Void Date The date assigned to a voided payment AP190 AP28.1
associated with the invoice payment AP28.2 AP45.1
record.
APP-INV-CURRENCY Alpha 5 AP180 AP181
Invoice Currency The currency of the invoice. Must be a AP190 AP20.1
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
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 AP180
Remit To Location The remit-to location associated with AP181 AP190
Code 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
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
MA41.2 MA43.2
APP-PAY-COMPANY Numeric 4 AP151 AP180
Pay Company The company associated with the pay AP181 AP190
vendor. Must be a valid record in the 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
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
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) AP170 AP180
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 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
MA61.1 MAI1.1
APP-ENCLOSURE Alpha 1 AP180 AP181
Enclosure 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
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 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
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-VEN-CLASS Alpha 3 AP115 AP180
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
Vendor 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
00 AP20.5 AP20.6
99 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-PROC-GRP Alpha 4 (Lower Case) AP102 AP115
Process Group The process group assigned to the AP180 AP181
payment. A process group is an AP190 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 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 AP23.1
AP25.1 AP25.2
AP28.1 AP28.2
AP30.1 AP30.3
AP35.1 AP45.1
AP520 AP55.2
AP56.1 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
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 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
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 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
Base Number Of The number of decimal places defined AP190 AP20.1
Decimals 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 AP180 AP181
Payment Amount 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 AP23.1
AP25.1 AP25.2
AP28.1 AP28.2
AP30.1 AP30.3
AP30.4 AP35.1
AP45.1 AP520
AP55.2 AP56.1
AP56.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 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
Transaction Number The number of decimal places defined AP190 AP20.1
of Decimals 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
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 AP150 AP170
Base Discount Amount The amount of the available discount AP180 AP181
for the invoice payment in the company AP190 AP191
base currency. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP23.1 AP28.1
AP28.2 AP30.1
AP30.3 AP32.2
AP35.1 AP45.1
AP520 AP55.2
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MAI1.1
APP-TRAN-DISC-AMT Signed 15.2 AP150 AP180
Discount Amount The amount of the available discount AP181 AP190
for the invoice payment in the currency AP20.1 AP20.2
of the invoice. AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP35.1
AP45.1 AP520
AP55.2 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MAI1.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.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
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.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
APP-BASE-INC-WH Signed 15.2 AP150 AP170
Base Income Withheld The reportable income withholding AP180 AP181
amount in the company base currency. AP190 AP193
AP28.1 AP28.2
AP35.1 AP45.1
APP-TRAN-INC-WH Signed 15.2 AP150 AP170
Income Withholding The reportable income withholding AP180 AP181
amount in the currency of the invoice. AP190 AP28.1
AP28.2 AP35.1
AP45.1 AP520
APP-TRAN-INC-AMT Signed 15.2 AP170 AP180
Income Amount The portion of the invoice amount AP181 AP190
classified as reportable income. AP193 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
Gain or Loss Amount The currency gain or loss amount. This AP181 AP190
amount is calculated when the invoice is AP193 AP28.1
revalued to account for currency AP28.2 AP45.1
exchange rate fluctuations.
APP-UNRL-REV-DATE Numeric 8 (yyyymmdd) AP180 AP181
Last Revaluation The date of the last currency AP190 AP191
Date revaluation that resulted in the AP28.1 AP28.2
creation of an unrealized gain or loss AP45.1
transaction.
APP-ACT-CNV-RATE Signed 12.6 AP170 AP180
Currency Exchange The currency exchange rate used to AP181 AP190
Rate convert the invoice payment amount to AP191 AP193
the company base currency. This field 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
Discount Accounting The accounting unit used for posting AP181 AP190
Unit 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
Discount 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
Discount Subaccount The subaccount number used for posting AP181 AP190
Number 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) AP180 AP181
Discount Rate 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
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MAI1.1
APP-DISC-DATE Numeric 8 (yyyymmdd) AP150 AP170
Discount Date The date through which the available AP180 AP181
discount amount of the invoice can be AP190 AP193
taken. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP23.1
AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2 MA61.1
MAI1.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.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
APP-ACCR-CODE Alpha 4 AP180 AP181
Invoice Accrual Code The 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
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
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 MA61.1
MA70.1 MAI1.1
APP-TRANS-NBR Alpha 10 (Right Justified) AP151 AP155
Payment Number The system or manual payment number AP160 AP161
used to pay the invoice payment. AP170 AP180
AP181 AP190
AP193 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
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
APP-BANK-INST-CODE Alpha 3 AP115 AP150
Payment Code The payment code assigned to the AP160 AP161
invoice payment. Represents a type of AP180 AP181
cash or bill of exchange payment used to AP190 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
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
APP-INCOME-CODE Alpha 4 AP180 AP181
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 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
Separate Payment Indicates 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
Pay Immediately Indicates 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
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
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
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
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
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 AP180 AP181
Match Discount Taken Indicates if a discount was taken AP190 AP28.1
during the invoice matching process. AP28.2 AP45.1
" " AP520 MA61.1
Y = Yes MA70.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
Open Invoice Amount The amount of the invoice remaining to
be paid in the currency of the invoice.
APP-BASE-NET-PMT Derived
Base Invoice Amount The net invoice amount paid in the
Paid company base currency.
APP-TRAN-NET-PMT Derived
Invoice Amount Paid The net invoice amount paid in the
currency of the invoice.
APP-PMT-STATUS Derived
Payment Status Displays the payment status when Drill
Around(TM) is used. Valid values are:
OPEN = The payment record has an open
status.
PAID = The payment record has a paid
status.
APP-BANK-STATUS Derived
Bank Status The reconciliation status of the
payment record associated with the
invoice payment.
APP-NO-REINSTATE Derived
Payment Not If the invoice payment was paid and the
Reinstated payment was voided, this field indicates
if the split invoice has not been
reinstated by AP190 (Invoice
Reinstatement).
APP-PAID-DOC-DATE Derived
Payment Document If the invoice payment was paid with a
Date cash payment, this field contains the
date assigned to the cash payment. If
the invoice payment was paid with a bill
of exchange payment, this field contains
the date the bill of exchange was
cashed.
APP-DRAFT-ACCRUED Derived
Bill of Exchange If the invoice payment was paid with a
Accrued bill of exchange, this field indicates
whether the bill of exchange has been
accrued in the general ledger.
APP-AP-INV-DATE Derived
Ap Inv Date
APP-AP-PO-NBR Derived
Ap Po Nbr
APP-AP-INV-TYPE Derived
Ap Inv Type
APP-AP-BASE-INV Derived
Ap Base Inv
APP-AP-FORMAT-NBR Derived
Ap Format Nbr
APPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APPSET1 COMPANY This index is used to access payment AC550 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 AP10.1 AP102
REC-STATUS records for a specific invoice by AP141 AP270
VENDOR payment status. AP40.1 AP92.2
INVOICE KeyChange API3.1 API4.1
SUFFIX IC840
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET3 PAY-GROUP This index is used to access open AP150 AP151
REC-STATUS payment records for cash requirements. AP170
PAY-IMM-FLAG The index is also used by AP170 (Payment
PROC-GRP Closing) to aid in concurrent
VENDOR processing.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
APPSET4 COMPANY This index is used to access open AP191 AP30.3
VENDOR payment records for a specific vendor AP35.1 EE30.1
INVOICE and/or invoice.
SUFFIX KeyChange, Subset
CANCEL-SEQ Where REC-STATUS = 1
SEQ-NBR Or REC-STATUS = 2
VOID-SEQ
APPSET6 PAY-GROUP This index is used to link the payment 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
CB06.2 CB191
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-VENDOR -> VEN-VENDOR
Cbbankinst CBBANKINST Required
APP-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
APP-CASH-CODE -> CBC-CASH-CODE
Cbcashform CBCASHFORM Not Required
APP-CASH-CODE -> CCF-CASH-CODE
APP-BANK-INST-CODE -> CCF-BANK-INST-CODE
Cbcheck CBCHECK Required
APP-CASH-CODE -> CHK-CASH-CODE
APP-BANK-INST-CODE -> CHK-BANK-INST-CODE
APP-TRANS-IDENT -> CHK-TRANS-IDENT
Cbcpycach CBCPYCASH Required
APP-PAY-COMPANY -> CBY-COMPANY
APP-CASH-CODE -> CBY-CASH-CODE
Cbstatement CBSTATEMNT Not Required
APP-CASH-CODE -> CSM-CASH-CODE
APP-RECON-STMT-NBR -> CSM-RECON-STMT-NBR
Cbstmtdtl CBSTMTDTL Not Required
APP-BANK-INST-CODE -> CSD-BANK-INST-CODE
APP-RECON-STMT-NBR -> CSD-RECON-STMT-NBR
APP-TRANS-NBR -> CSD-PAYMENT-NBR
"V" -> CSD-TRANS-TYPE
Cbtrans CBTRANS Not Required
Valid When APP-SERIAL-NUM = Zeroes
APP-BANK-INST-CODE -> CBT-BANK-INST-CODE
APP-TRANS-IDENT -> CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid When APP- = APP-
And APP-REC-STATUS = 2
And APP-SERIAL-NUM != Zeroes
CHK-BANK-INST-CODE -> CBT-BANK-INST-CODE
CHK-SERIAL-NUM -> CBT-SERIAL-NUM
CHK-TRANS-IDENT -> CBT-TRANS-IDENT
Invcurrency CUCODES Required
APP-INV-CURRENCY -> CUC-CURRENCY-CODE
APPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdiscacc APDISCACC
APP-COMPANY -> DSK-COMPANY
APP-VENDOR -> DSK-VENDOR
APP-INVOICE -> DSK-INVOICE
APP-SUFFIX -> DSK-SUFFIX
APP-CANCEL-SEQ -> DSK-CANCEL-SEQ
APP-SEQ-NBR -> DSK-SEQ-NBR
DSK-VOID-SEQ
DSK-DISC-TYPE
Aphldinv APHLDINV Delete Cascades
Valid When (APP-HOLD-FLAG = "Y" )
"P" -> HLI-REC-TYPE
APP-VENDOR-GROUP -> HLI-VENDOR-GROUP
APP-COMPANY -> HLI-COMPANY
APP-VENDOR -> HLI-VENDOR
APP-INVOICE -> HLI-INVOICE
APP-SUFFIX -> HLI-SUFFIX
APP-CANCEL-SEQ -> HLI-CANCEL-SEQ
APP-SEQ-NBR -> HLI-SEQ-NBR
APP-VOID-SEQ -> HLI-VOID-SEQ
HLI-HLD-CODE
Appset6 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-TRANS-IDENT -> APP-TRANS-IDENT
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
APP-COMPANY
Appset8 APPAYMENT
APP-PAY-GROUP -> APP-PAY-GROUP
APP-CASH-CODE -> APP-CASH-CODE
APP-TRANS-NBR -> APP-TRANS-NBR
APP-BANK-INST-CODE -> APP-BANK-INST-CODE
APP-COMPANY
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Apvencomments APCOMMENTS
"V" -> APC-REC-TYPE
CPY-VENDOR-GROUP -> APC-VENDOR-GROUP
APP-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
APP-COMPANY -> APC-COMPANY
APC-SEQ-NBR
|