APPAYMENT

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 AP10.1 AP10.2 AP100
AP109 AP110 AP111 AP131 AP136 AP14.1
AP14.2 AP14.5 AP16.1 AP16.2 AP178 AP197
AP213 AP220 AP225 AP232 AP233 AP240
AP256 AP271 AP282 AP284 AP510 AP57.2
AP590 AP97.1 AP97.2 AP97.3 AP97.5 APBD.2
CB00.1 CB10.1 CB150 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 EE20.1 EE20.2 EE230 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA126
MA180 MA278 MA279 MA53.1 MA530 MA531
MA540 MA63.1 MA67.2 MA67.3 MA69.1 MA80.1
MAED.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO22.2 PO22.5 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 PO54.1
PO54.2 PO54.3 PO54.4 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 PR277 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 AP00.5 AP145 AP146 AP195
AP245 AP246 AP250 AC160 AM115 AM117
AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.3
AM21.1 AM21.3 AM22.1 AM500 AM51.1 AM551
AM97.1 AP03.3 AP210 AP90.1 AP90.5 AP91.1
AP92.2 API3.1 API4.1 IC840 MX123 MX500
PD235 PO192 PO195 PO223 PO233 PO253
PO254 PO278 PO529 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 RQ260 EE30.1
AP156 CB170 CB186 CB187 CB286 AP255


UPDATED BY
AP101 AP102 AP115 AP125 AP126 AP133
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 AP30.2 AP32.1 AP33.1 AP35.1 AP36.1
AP40.1 AP45.1 AP520 AP55.1 AP55.2 AP56.1
AP56.2 API1.1 API2.1 ZA161 CB06.2 CB191
EE135 EE35.1 EE35.2 EE520 EX542 EX545
MA168 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA44.1 MA44.2 MA60.2 MA60.4 MA61.1 MA64.9
MA65.1 MA66.2 MA66.3 MA68.2 MA68.4 MA70.1
MA75.1 MAI1.1 AP198 AP300 AP305 AP230
AP270 CB55.1 AP265

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APP-COMPANY
Element: Company
Numeric 4
The company number associated with the invoice payment. Must be a valid record in the Accounts Payable Company file.
AP180 AP181
AP190 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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APP-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number associated with the invoice payment. Must be a valid record in the Vendor file.
AP115 AP180
AP181 AP190
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-INVOICE
Element: Invoice
Alpha 22
The invoice number. Must be a valid record in the Accounts Payable Invoice file.
AP115 AP180
AP181 AP190
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-SUFFIX
Element: Suffix
Numeric 3
The invoice suffix number. Represents the occurrence value of the invoice for recurring invoices, employee advances, and prepayment credit memos.
AP170 AP180
AP181 AP190
AP193 AP20.8
AP25.1 AP25.2
AP28.1 AP28.2
AP30.3 AP32.1
AP35.1 AP45.1
AP520 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
APP-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999.
AP180 AP181
AP190 AP28.1
AP28.2 AP30.4
AP32.1 AP45.1
MA61.1 MA70.1
MA75.1 MAI1.1
APP-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP133 AP170
AP180 AP181
AP190 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 AP33.1
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-VOID-SEQ
Element: Seq Nbr
Numeric 4
The void sequence for the invoice payment. Used by the system to keep payment records unique each time a payment is voided and the invoice is reinstated for payment.
AP180 AP181
AP190 AP28.1
AP28.2 AP32.1
AP45.1 MA61.1
MAI1.1
APP-VOID-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date assigned to a voided payment associated with the invoice payment record.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
MA61.1 MAI1.1
APP-INV-CURRENCY
Element: To Base Curr
Alpha 5
The currency of the invoice. Must be a valid record in the Currency Code file.
AP180 AP181
AP190 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 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-PAY-VENDOR
Element: Pay Vendor
Alpha 9 (Right Justified)
The pay vendor associated with the invoice payment. Represents the vendor that will receive payment for the invoice. Must be a valid record in the Vendor file.
AP115 AP180
AP181 AP190
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.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
MA42.2 MA43.2
MA44.1 MA44.2
APP-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
The remit-to location associated with the invoice payment. Must be a valid record in the Vendor Location file.
AP115 AP180
AP181 AP190
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.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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-PAY-COMPANY
Element: Pay Company
Numeric 4
The company associated with the pay vendor. Must be a valid record in the Accounts Payable Company file.
AP151 AP180
AP181 AP190
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 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
MA42.2 MA43.2
MA44.1 MA44.2
APP-CASH-CODE
Element: Cash Code
Alpha 4
The cash code assigned to the invoice. Represents the bank account the invoice payment is to be paid from. Must be a valid record in the Cash Code file.
AP115 AP150
AP151 AP160
AP161 AP180
AP181 AP190
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 MA42.2
MA43.2 MA44.1
MA44.2 ZA161
APP-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The invoice due date. AP150 and AP151 use this date to determine whether to schedule the invoice payment and whether to take a discount, if applicable.
AP133 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
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APP-ENCLOSURE
Element: All Flag
Alpha 1
Indicates whether the invoice payment requires an enclosure. Valid values are: N = No. Y = Yes.
AP180 AP181
AP190 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 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-HOLD-FLAG
Element: Hold Flag
Alpha 1
Indicates whether the invoice payment is on hold. If this field is Yes, AP150 or AP151 will not select the invoice payment. Valid values are: Y = Yes. Invoice payment is on hold. Blank = Invoice payment is not on hold.
...
AP125 AP126
AP133 AP141
AP150 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 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
AP33.1 AP35.1
AP36.1 AP40.1
AP45.1 AP520
AP55.2 AP56.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
EX542 EX545
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
APP-VEN-CLASS
Element: Ven Class
Alpha 3
The vendor class associated with the invoice payment. Must be a valid record in the Vendor Class file.
AP115 AP180
AP181 AP190
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
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-VEN-PRIORITY
Element: Ven Priority
Numeric 2
The payment priority defined for the vendor. Valid values are 1 (highest priority) through 99 (lowest priority).
00
99
AP115 AP180
AP181 AP190
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.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 MA42.2
MA43.2 MA44.1
MA44.2
APP-PROC-GRP
Element: Process Group
Alpha 4 (Lower Case)
The process group assigned to the payment. A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle. Must be a valid record in the Process Group file.
AP102 AP115
AP180 AP181
AP190 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 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-BASE-PMT-AMT
Base Payment Amount
(at entry)
Signed 18.2
The amount of the invoice payment in the company base currency. This amount is calculated using the currency exchange rate in effect when the invoice payment was created.
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 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
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA66.2
MA68.2 MA68.4
MA70.1 MA75.1
MAI1.1
APP-BASE-ACT-AMT
Base Payment Amount
(revalued)
Signed 18.2
The amount of the invoice payment in the company base currency. For non-base currency invoices, this amount may be updated when currency revaluation takes place to account for exchange rate fluctuations.
AP133 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 AP28.1
AP28.2 AP30.1
AP30.3 AP30.4
AP33.1 AP35.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MA70.1
MA75.1 MAI1.1
APP-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal places defined for the company base currency.
AP180 AP181
AP190 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.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-TRAN-PMT-AMT
Element: Intl Amt
Signed 18.2
The amount of the invoice payment in the currency of the invoice.
AP133 AP180
AP181 AP190
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.1 AP30.3
AP30.4 AP33.1
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 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA66.2 MA68.2
MA68.4 MA70.1
MA75.1 MAI1.1
APP-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal places defined for the invoice currency.
AP180 AP181
AP190 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.2
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-BANK-CHK-AMT
Bank Account
Currency Amount
Signed 18.2
The amount of the invoice payment in the currency of the bank account (cash code).
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP45.1
AP520 AP55.1
AP55.2 CB06.2
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
APP-BANK-ND
Bank Account
Currency Decimals
Numeric 1
The number of decimal places defined for the bank account currency.
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP28.1 AP28.2
AP30.3 AP45.1
AP520 AP55.1
AP55.2 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-BASE-DISC-AMT
Element: Intl Amt
Signed 18.2
The amount of the available discount for the invoice payment in the company base currency.
AP150 AP170
AP180 AP181
AP190 AP191
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
APP-TRAN-DISC-AMT
Element: Intl Amt
Signed 18.2
The amount of the available discount for the invoice payment in the currency of the invoice.
AP150 AP170
AP180 AP181
AP190 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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
APP-BASE-CHK-AMT
Element: Intl Amt
Signed 18.2
The net payment amount for the invoice in the company base currency.
AP150 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
AP30.3 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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
APP-TRAN-CHK-AMT
Element: Intl Amt
Signed 18.2
The net payment amount for the invoice in the currency of the invoice.
AP150 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
AP30.3 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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
APP-BASE-INC-WH
Element: Intl Amt
Signed 18.2
The reportable income withholding amount in the company base currency.
AP150 AP170
AP180 AP181
AP190 AP193
AP28.1 AP28.2
AP30.3 AP35.1
AP45.1 MA61.1
MA70.1 MA75.1
MAI1.1
APP-TRAN-INC-WH
Element: Intl Amt
Signed 18.2
The reportable income withholding amount in the currency of the invoice.
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 MA61.1
MA70.1 MA75.1
MAI1.1
APP-TRAN-INC-AMT
Element: Intl Amt
Signed 18.2
The portion of the invoice amount classified as reportable income.
AP170 AP180
AP181 AP190
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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MA70.1
MA75.1 MAI1.1
APP-GAINLOS-AMT
Element: Gain or Loss Amount
Signed 18.2
The currency gain or loss amount. This amount is calculated when the invoice is revalued to account for currency exchange rate fluctuations.
AP170 AP180
AP181 AP190
AP193 AP28.1
AP28.2 AP45.1
MA61.1 MA70.1
MA75.1 MAI1.1
APP-UNRL-REV-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date of the last currency revaluation that resulted in the creation of an unrealized gain or loss transaction.
AP180 AP181
AP190 AP191
AP28.1 AP28.2
AP30.3 AP45.1
APP-ACT-CNV-RATE
Currency Exchange
Rate
Signed 14.7
The currency exchange rate used to convert the invoice payment amount to the company base currency. This field may be updated when the invoice is revalued.
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
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 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-DSC-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit used for posting the discount amount to the general ledger. Must be a valid accounting unit in the Lawson General Ledger system.
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 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-DSC-ACCOUNT
Element: Account
Numeric 6
The account number used for posting the discount amount to the general ledger. Must be a valid account in the Lawson General Ledger system.
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 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-DSC-SUB-ACCT
Element: Sub Acct
Numeric 4
The subaccount number used for posting the discount amount to the general ledger. Must be a valid subaccount in the Lawson General Ledger system.
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 AP30.3
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-DISCOUNT-RT
Element: Discount Rt
Percent 5.3 (Percent)
The rate used to calculate the discount amount of the invoice payment.
AP150 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APP-DISC-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date through which the available discount amount of the invoice can be taken.
AP150 AP170
AP180 AP181
AP190 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 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MAI1.1
APP-TRANS-IDENT
Element: Transaction ID
Numeric 10
A sequencing number created by AP150 (Cash Requirements) or AP151 (Bill of Exchange Generation) to sequence payments. Used to link the Invoice Payment record with the associated Accounts Payable Cash Payment record.
AP133 AP150
AP151 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
AP30.3 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
MA42.2 MA43.2
MA44.1 MA44.2
MA70.1 MA75.1
APP-TRANS-ID-CBT
Element: Trans Id Cbt
Numeric 10
APP-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
The invoice accrual code assigned to the invoice. Used to default a general ledger accrual account to the invoice. Must be a valid record in the Invoice Accrual Code file.
AP180 AP181
AP190 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.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
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APP-PROC-LEVEL
Element: Process Level
Alpha 5
The process level associated with the invoice. Must be a valid record in the Accounts Payable Process Level file.
AP180 AP181
AP190 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.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
MA42.2 MA43.2
MA44.1 MA44.2
APP-REC-STATUS
Element: Rec Status
Numeric 1
The record status. Valid values are: 0 = Unreleased 1 = Released 2 = Selected for Payment 3 = Paid with a System Cash Payment 4 = Paid with a Manual Payment 5 = Paid with a Bill of Exchange Payment 7 = Unreleased Manual Payment 8 = Canceled (bill of exchange) 9 = Historical NOTE All void status invoice payment records should have a historical status.
...
AP125 AP126
AP133 AP150
AP151 AP155
AP160 AP161
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.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 CB191
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA44.1 MA44.2
MA61.1 MA64.9
MA66.3 MA70.1
MA75.1 MAI1.1
APP-TRANS-NBR
Element: Payment Number
Alpha 10 (Right Justified)
The system or manual payment number used to pay the invoice payment.
AP151 AP155
AP160 AP161
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
MA42.2 MA43.2
MA44.1 MA44.2
MA70.1 MA75.1
ZA161
APP-CHK-SUFFIX
Payment Suffix
Number
Numeric 3
The system or manual payment suffix number used to pay the invoice payment.
AP180 AP181
AP190 AP20.8
AP28.1 AP28.2
AP45.1 AP56.1
AP56.2 MA70.1
MA75.1
APP-BANK-INST-CODE
Element: Payment Code
Alpha 3
The payment code assigned to the invoice payment. Represents a type of cash or bill of exchange payment used to pay the invoice payment. Must be a valid cash payment or bill of exchange payment transaction code record in the Bank Transaction Code file.
AP115 AP150
AP160 AP161
AP180 AP181
AP190 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.2
API1.1 API2.1
CB06.2 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 ZA161
APP-CHECK-DATE
Element: Payment Date
Numeric 8 (yyyymmdd)
The date assigned to the system or manual payment associated with the invoice payment record.
AP155 AP160
AP161 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
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 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 ZA161
APP-INCOME-CODE
Element: Income Code
Alpha 4
The income code assigned to the invoice payment record. Used to track vendor reportable income. Must be a valid record in the Income Code file.
AP180 AP181
AP190 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 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-SEP-CHK-FLAG
Element: Separate Payment
Alpha 1
Indicates whether the payment should be made on a separate payment form from other payments to the same vendor. Valid values are: N = No. Y = Yes.
AP170 AP180
AP181 AP190
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
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-PAY-IMM-FLAG
Element: Pay Immediately
Alpha 1
Indicates whether the invoice is to be paid immediately regardless of the invoice due date. Valid values are: N = No. Y = Yes.
AP133 AP170
AP180 AP181
AP190 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 AP40.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA168 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-DISC-LOST-FLG
Element: Discount Lost
Alpha 1
Indicates whether the available discount for the invoice payment was lost. Valid values are: N = No. Y = Yes.
AP150 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
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 MA42.2
MA43.2 MA44.1
MA44.2
APP-ANTICIPATION
Anticipation
Discount
Alpha 1
Indicates whether anticipation criteria should be used to calculate the discount amount for the invoice payment. Valid values are: Y = Yes. N = No.
AP180 AP181
AP190 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 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-INVOICE-GROUP
Element: Invoice Group
Alpha 4
The invoice group assigned to the invoice payment. An invoice group is a user-defined character expression that can be used to select invoices for payment.
AP115 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
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
MA42.2 MA43.2
MA44.1 MA44.2
APP-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group associated with the invoice payment. Must be a valid record in the Vendor Group file.
AP180 AP181
AP190 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 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group associated with the invoice payment. A pay group is used for processing accounts payable payments. Must be a valid record in the Pay Group file.
AP101 AP180
AP181 AP190
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.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 MA42.2
MA43.2 MA44.1
MA44.2
APP-DISCOUNT-CODE
Element: Discount Code
Alpha 10
The discount code assigned to the invoice payment. Used to default a general ledger discount account to the invoice. Must be a valid record in the Discount Code file.
AP180 AP181
AP190 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
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-INC-ACCR-CODE
Element: Inc Accr Code
Alpha 10
The withholding code assigned to the invoice payment. Used to default a general ledger withholding accrual account to the invoice. Must be a valid record in the Income Withholding Code file.
AP150 AP180
AP181 AP190
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 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-RECON-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
CB06.2
APP-MATCH-DISC-TAK
Element: Match Discount Taken
Alpha 1
Indicates if a discount was taken during the invoice matching process.
" "
Y = Yes
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
AP520 MA61.1
MA66.2 MA70.1
MA75.1 MAI1.1
APP-OPEN-BASE-PMT
Element: Open Base Pmt
Derived
The amount of the invoice remaining to be paid in the company base currency.
APP-OPEN-TRAN-PMT
Element: Open Tran Pmt
Derived
The amount of the invoice remaining to be paid in the currency of the invoice.
APP-BASE-NET-PMT
Element: Base Net Pmt
Derived
The net invoice amount paid in the company base currency.
APP-TRAN-NET-PMT
Element: Tran Net Pmt
Derived
The net invoice amount paid in the currency of the invoice.
APP-PMT-STATUS
Element: Payment Status
Derived
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
Element: Bank Status
Derived
The reconciliation status of the payment record associated with the invoice payment.
APP-NO-REINSTATE
Payment Not
Reinstated
Derived
If the invoice payment was paid and the payment was voided, this field indicates if the split invoice has not been reinstated by AP190 (Invoice Reinstatement).
APP-PAID-DOC-DATE
Payment Document
Date
Derived
If the invoice payment was paid with a 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
Bill of Exchange
Accrued
Derived
If the invoice payment was paid with a bill of exchange, this field indicates whether the bill of exchange has been accrued in the general ledger.
APP-AP-INV-DATE
Element: Ap Inv Date
Derived
APP-AP-PO-NBR
Element: Ap Po Nbr
Derived
APP-AP-INV-TYPE
Element: Ap Inv Type
Derived
APP-AP-BASE-INV
Element: Ap Base Inv
Derived
APP-AP-FORMAT-NBR
Element: Ap Format Nbr
Derived
APP-STATEMENT
Element: Invoice
Alpha 22
Used to identify the invoice.
API1.1
APP-RETAINAGE-PMT
Element: Flag Num
Numeric 1

0 = No
1 = Yes
AP133 MA61.1
MAI1.1
APP-SEC-WTH-CODE1
Element: Sec Wth Code
Alpha 10
AP180 AP181
AP190 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
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-SEC-WTH-PCT1
Element: Withhold Pct
Percent 5.3 (Percent)
AP150 AP180
AP181 AP190
AP28.1 AP28.2
AP30.3 AP45.1
APP-BASE-SEC-WTH1
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-TRAN-SEC-WTH1
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-SEC-WTH-CODE2
Element: Sec Wth Code
Alpha 10
AP180 AP181
AP190 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
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-SEC-WTH-PCT2
Element: Withhold Pct
Percent 5.3 (Percent)
AP150 AP180
AP181 AP190
AP28.1 AP28.2
AP30.3 AP45.1
APP-BASE-SEC-WTH2
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-TRAN-SEC-WTH2
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-SEC-WTH-CODE3
Element: Sec Wth Code
Alpha 10
AP180 AP181
AP190 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
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
APP-SEC-WTH-PCT3
Element: Withhold Pct
Percent 5.3 (Percent)
AP150 AP180
AP181 AP190
AP28.1 AP28.2
AP30.3 AP45.1
APP-BASE-SEC-WTH3
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-TRAN-SEC-WTH3
Element: Intl Amt
Signed 18.2
AP150 AP170
AP180 AP181
AP190 AP28.1
AP28.2 AP30.3
AP45.1
APP-CREATED-BY
Element: Operator
Alpha 10
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
AP30.3 AP30.4
AP32.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
APP-LAST-UPDATE-BY
Element: Operator
Alpha 10
...
AP101 AP102
AP115 AP125
AP126 AP133
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 AP32.1
AP33.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
EX542 EX545
MA168 MA41.1
APP-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
AP101 AP102
AP115 AP125
AP126 AP133
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 AP32.1
AP33.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
EX542 EX545
MA168 MA41.1
APP-LAST-UPDT-TIME
Element: Time
Numeric 8
...
AP101 AP102
AP115 AP125
AP126 AP133
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 AP32.1
AP33.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
EX542 EX545
MA168 MA41.1
APP-TEMP-HOLD
Element: Temp Hold
Alpha 1

S = Sent for Approval
A = Approved by Engine
AP141 AP150
AP30.3 AP40.1
APP-FATCA-BASE-INC
Element: Intl Amt
Signed 18.2
AP150 AP170
AP190
APP-FATCA-INC-CODE
Element: Income Code
Alpha 4
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
APP-FATCA-TRAN-INC
Element: Intl Amt
Signed 18.2
AP150 AP170
AP190


APPAYMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APPSET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
...
AM19.1 AM19.2
AM19.4 AP10.1
AP10.2 AP100
AP109 AP110
AP111 AP115
AP125 AP126
AP131 AP133
AP136 AP14.1
AP14.2 AP14.5
AP141 AP150
AP151 AP16.1
AP16.2 AP160
AP161 AP170
AP178 AP180
AP181 AP190
APPSET10 REC-STATUS
COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
PAY-GROUP
KeyChange
AP00.5 AP101
AP145 AP146
AP195 AP230
AP245 AP246
AP250 AP270
MA168
APPSET12 PAY-GROUP
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange, Subset
Where(REC-STATUS =1)
Or(REC-STATUS =2)
AP55.2 AP56.2
APPSET13 COMPANY
CHECK-DATE
LAST-UPDT-DATE
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
KeyChange
APPSET2 PAY-GROUP
REC-STATUS
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP102 AP110
AP115 AP125
AP126 AP131
AP141 AP150
AP20.1 AP20.2
APPSET3 PAY-GROUP
REC-STATUS
PAY-IMM-FLAG
PROC-GRP
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange
AP150 AP151
AP170
APPSET4 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
KeyChange, Subset
WhereREC-STATUS =1
OrREC-STATUS =2
AP191 AP30.3
AP35.1 EE30.1
APPSET6 PAY-GROUP
BANK-INST-CODE
TRANS-IDENT
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
COMPANY
KeyChange, Subset
WhereTRANS-IDENT !=Zeroes
...
AP125 AP126
AP151 AP155
AP156 AP160
AP161 AP180
AP181 AP190
AP25.1 AP25.2
AP26.1 AP265
AP27.1 AP28.1
AP28.2 AP30.3
AP32.1 AP55.1
AP55.2 AP56.1
AP56.2 ZA161
CB06.2 CB170
CB186 CB187
CB191 CB286
APPSET8 PAY-GROUP
CASH-CODE
TRANS-NBR
BANK-INST-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
KeyChange
AP255 AP90.5


APPAYMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Appmtbod APPMTBOD Not Required, Delete Cascades
APP-COMPANY->YBA-COMPANY
APP-VENDOR->YBA-VENDOR
APP-INVOICE->YBA-INVOICE
APP-SUFFIX->YBA-SUFFIX
APP-CANCEL-SEQ->YBA-CANCEL-SEQ
APP-SEQ-NBR->YBA-SEQ-NBR
APP-VOID-SEQ->YBA-VOID-SEQ
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
Cbcheck Drill CBCHECK Required
APP-CASH-CODE->CHK-CASH-CODE
APP-BANK-INST-CODE->CHK-BANK-INST-CODE
APP-TRANS-IDENT->CHK-TRANS-IDENT
APP-TRANS-ID-CBT->CHK-TRANS-ID-CBT
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 CBI-TAPE-PMT-SUMM !="S"
APP-BANK-INST-CODE->CBT-BANK-INST-CODE
APP-TRANS-IDENT->CBT-TRANS-IDENT
Cbtrans Drill CBTRANS Not Required
APP-BANK-INST-CODE->CBT-BANK-INST-CODE
APP-TRANS-ID-CBT->CBT-TRANS-IDENT
Cbtrans Drl CBTRANS Not Required
APP-BANK-INST-CODE->CBT-BANK-INST-CODE
APP-TRANS-IDENT->CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid When CHK- =APP-
AndCHK-REC-STATUS =2
AndCHK-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
NAME
RELATED 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
Apdistpay APDISTPAY
APP-COMPANY->DTY-COMPANY
APP-VENDOR->DTY-VENDOR
APP-INVOICE->DTY-INVOICE
APP-SUFFIX->DTY-SUFFIX
APP-SEQ-NBR->DTY-PMT-SEQ-NBR
  DTY-LINE-NBR
  DTY-MAD-SEQ-NBR
  DTY-DIST-SEQ-NBR
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


File created: Thu Jun 09 02:07:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.