Lawson Insight Technical Documentation |
|
APINVOICE
APINVOICE FILE
Accounts Payable Invoice
The Accounts Payable Invoice file contains accounts payable invoice records.
Each record has one or more associated records in the Invoice Payment File.
REFERENCED BY
POA3.1 AP00.4 AP01.1 AP141 AP150 AP151
AP155 AP156 AP160 AP161 AP175 AP176
AP197 AP212 AP213 AP220 AP230 AP240
AP245 AP250 AP252 AP255 AP270 AP275
AP282 AP284 AP295 AP31.3 AP40.1 AP43.1
AP56.2 AP90.1 AP90.2 AP90.3 AP90.4 AP91.1
AP92.2 AP92.1 AP95.1 APCP.1 APH1.1 AR48.3
CB06.2 EE20.1 EE20.2 EE20.4 EE230 EE30.1
EE90.1 EE90.2 IC28.1 MA00.1 MA05.1 MA126
MA180 MA278 MA530 MA531 MA540 MA63.1
MA64.6 MA67.1 MA67.2 MA68.1 MA80.1 MAED.1
PO100 PO101 PO122 PO131 PO135 PO139
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO64.1 POI3.1
POII.1 POIJ.1 PR277 UK277 MM280 MM80.1
MM80.2 RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2
WH20.7 PO58.2 MA236 AP236 AP235 TX226
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP10.1 AP251 API3.1 API4.1 IC840
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1
UPDATED BY
AP101 AP115 AP125 AP126 AP130 AP131
AP170 AP180 AP181 AP190 AP191 AP193
AP195 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP25.1
AP25.2 AP25.3 AP26.1 AP260 AP27.1 AP28.1
AP28.2 AP30.1 AP30.2 AP30.3 AP30.4 AP300
AP305 AP32.1 AP32.2 AP35.1 AP36.1 AP45.1
AP520 AP55.2 AP700 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA60.2 MA60.3 MA60.4
MA61.1 MA65.1 MA66.2 MA66.3 MA70.1 MA75.1
MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
API-COMPANY Numeric 4 AP125 AP126
Element: Company The company associated with the AP150 AP180
invoice. Must be a valid record in the AP181 AP190
Accounts Payable Company file. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The invoiced vendor number. Must be a AP126 AP150
valid record in the Vendor file. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.3
AP300 AP32.1
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberThe invoice number. Must be a unique AP126 AP150
invoice number for the vendor. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.3
AP300 AP32.1
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe invoice suffix number. Represents AP150 AP170
the occurrence value of the invoice. AP180 AP181
Used to identify the recurrence value of AP190 AP193
a recurring invoice and for AP20.8 AP25.1
system-generated credit memos created AP25.2 AP26.1
for prepayments and employee advances. AP27.1 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP32.2
AP45.1 AP520
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeThe sequence number assigned upon the AP150 AP180
cancellation of a distributed invoice. AP181 AP190
The first sequence assigned is 9999. AP20.8 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.3 AP30.4
AP300 AP32.1
AP32.2 AP45.1
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CANCEL-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Cancel Date The cancellation date assigned to a AP190 AP26.1
canceled invoice. AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 MA70.1
MA75.1
API-BATCH-NUM Numeric 6 AP125 AP126
Element: Batch Number The batch number associated with the AP180 AP181
invoice. Used only if the company has AP190 AP20.1
Yes selected in the Batch Release Option AP20.2 AP20.3
field. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP25.3
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-BATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Date The batch date assigned to the batch AP190 AP20.1
number. Must be a valid record in the AP20.2 AP20.3
Batch file. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2
API-VOUCHER-NBR Alpha 10 AP125 AP126
Element: Voucher The voucher number assigned to the AP180 AP181
invoice. Used only if the company has AP190 AP20.1
Yes selected in the Invoice Registration AP20.2 AP20.3
Option field. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-AUTH-CODE Alpha 3 AP125 AP126
Element: Authority CodeThe authority code assigned to the AP180 AP181
invoice. Represents the person or AP190 AP20.1
department responsible for approving a AP20.2 AP20.3
registered invoice and is required AP20.4 AP20.5
before a registered invoice can be AP20.6 AP20.7
released. Used only by a company that AP23.1 AP25.1
has Yes selected in the Invoice Approval AP25.2 AP26.1
field and No in the Batch Release field. AP27.1 AP28.1
Must be a valid record in the Authority AP28.2 AP36.1
Code file. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PROC-LEVEL Alpha 5 AP125 AP126
Element: Process Level The process level assigned to the AP180 AP181
invoice. Must be a valid record in the AP190 AP20.1
Accounts Payable Process Level file. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-ACCR-CODE Alpha 4 AP125 AP126
Element: Invoice AccruaThe invoice accrual code assigned to AP180 AP181
the invoice. Used to default a general AP190 AP20.1
ledger accrual account to the invoice. AP20.2 AP20.3
Must be a valid record in the Invoice AP20.4 AP20.5
Accrual Code file. AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP32.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE-TYPE Alpha 1 AP125 AP126
Element: Invoice Type Identifies the type of invoice. Valid AP170 AP180
values are: AP181 AP190
AP20.1 AP20.2
Blank = Invoice. Increases the amount AP20.3 AP20.4
owed to the vendor. If the invoice is AP20.5 AP20.6
fully processed, the vendor's purchase AP20.7 AP23.1
and payment balances will be increased. AP25.1 AP25.2
AP26.1 AP27.1
C = Credit Memo. Reduces the amount AP28.1 AP28.2
owed to the vendor. If the invoice is AP45.1 AP520
fully processed, the vendor's purchase API1.1 API2.1
and payment balances will be decreased. EE135 EE35.1
EE35.2 EE520
D = Debit Memo. Processed just like an MA310 MA41.2
invoice. Increase the vendor's purchase MA43.2 MA60.1
and payment balances. MA60.2 MA60.3
MA60.4 MA61.1
P = Prepayment. Processed just like an MA63.1 MA65.1
invoice. Used to pay a vendor for goods MA67.1 MA67.2
or services not yet received. MA68.1 MA70.1
MA75.1
Y = Prepayment Credit Memo. Created by
AP170 (Payment Closing) to offset a
prepayment and are applied to the
vendor's invoice after it has been
received.
A = Employee Advance. Processed just
like an invoice. Used to pay an employee
for expenses not yet incurred.
M = Employee Advance Credit Memo.
Created by AP170 (Payment Closing) to
offset an employee advance. Can be
applied to the employee's expense after
it has been received.
E = Employee Expense. Processed just
like an invoice.
API-INV-CURRENCY Alpha 5 AP125 AP126
Element: Invoice CurrenThe currency of the invoice. Must be a AP180 AP181
valid record in the Currency Code file. AP190 AP20.1
If left blank, the vendor currency AP20.2 AP20.3
defaults. AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.3 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-PAY-CURRENCY Alpha 5 AP125 AP126
To Company Base The currency used to pay the invoice. AP180 AP181
Currency Must be a valid record in the Currency AP190 AP20.1
Code file. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE-DTE Numeric 8 (yyyymmdd) AP125 AP126
Element: Invoice Date The date assigned to the invoice. Used AP170 AP180
when updating the vendor's purchase AP181 AP190
balance. If left blank, the system date AP193 AP20.1
defaults. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-PURCH-FR-LOC Alpha 4 AP115 AP125
Purchase From The purchase-from location code AP126 AP180
Location Code associated with the invoice. Must be a AP181 AP190
valid record in the Vendor Location AP20.1 AP20.2
file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP180 AP181
representing the purchase order. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumThe purchase order release number AP180 AP181
associated with the invoice. Used to AP190 AP20.1
identify a purchase order release AP20.2 AP20.3
created from a blanket or standing AP20.4 AP20.5
order. AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-CODE Alpha 4 AP125 AP126
Element: Purchase OrderPurchase order number code. Used to AP180 AP181
keep purchase orders unique. Can be used AP190 AP20.1
for reporting purposes. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-DESCRIPTION Alpha 30 (Lower Case) AP180 AP181
Element: Description The invoice description. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-BASE-INV-AMT Signed 15.2 AP125 AP126
Element: Base Invoice AThe amount of the invoice in the AP170 AP180
company base currency. This amount is AP181 AP190
calculated based on the currency AP193 AP20.1
exchange rate in effect when the invoice AP20.2 AP20.3
was created or entered. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BASE-ACT-AMT Signed 15.2 AP125 AP126
Revalued Base The amount of the invoice in the AP170 AP180
Invoice Amount company base currency. For non-base AP181 AP190
currency invoices, this amount is AP191 AP193
updated when currency revaluation takes AP20.1 AP20.2
place. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-BASE-ND Numeric 1 AP125 AP126
Account Currency The number of decimal places defined AP180 AP181
Code for the company base currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-TRAN-INV-AMT Signed 15.2 AP125 AP126
Element: Invoice AmountThe amount of the invoice in the AP180 AP181
currency of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP25.3
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-ALOW-AMT Signed 15.2 AP125 AP126
Element: Adj Amt The amount of the invoice available for AP180 AP181
discount in the currency of the invoice. AP190 AP20.1
Used to calculate the discount amount AP20.2 AP20.3
based on the discount rate. If left AP20.4 AP20.5
blank, the invoice amount defaults. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP32.2 AP45.1
AP520 API1.1
API2.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TXBL-AMT Signed 15.2 AP125 AP126
Element: Adj Amt The taxable amount of the invoice in AP180 AP181
the currency of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 AP700
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-TRAN-ND Numeric 1 AP125 AP126
Account Currency The number of decimal places defined AP180 AP181
Code for the invoice currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-TRAN-TAX-AMT Signed 15.2 AP125 AP126
Element: Adj Amt The tax amount of the invoice in the AP180 AP181
currency of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BASE-DISC-AMT Signed 15.2 AP125 AP126
Element: Actual Disc The discount amount of the invoice in AP170 AP180
the company base currency. AP181 AP190
AP191 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.3 AP32.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-TRAN-DISC-AMT Signed 15.2 AP125 AP126
Element: Actual Disc The discount amount of the invoice in AP180 AP181
the currency of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP45.1
AP520 API1.1
API2.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-BASE-TOT-PMT Signed 15.2 AP125 AP126
Base Total Payment The total payment amount created for AP170 AP180
Amount the invoice in the company base AP181 AP190
currency. AP193 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
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-TRAN-TOT-PMT Signed 15.2 AP125 AP126
Element: Detail Total The total payment amount created for AP170 AP180
the invoice in the currency of the AP181 AP190
invoice. AP193 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
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BASE-TOT-DIST Signed 15.2 AP125 AP126
Base Total The total distribution amount of the AP170 AP180
Distribution Amount invoice in the company base currency. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-DIST Signed 15.2 AP125 AP126
Element: Detail Total The total distribution amount of the AP170 AP180
invoice in the currency of the invoice. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-TAX Signed 15.2 AP125 AP126
Element: Detail Total The total tax amount of the invoice in AP180 AP181
the currency of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-TXBL Signed 15.2 AP20.1 AP20.2
Element: Total Taxable The total taxable amount for the invoice AP20.3 AP20.4
distributions in currency of invoice. AP20.5 AP20.7
AP23.1 AP520
AP700 API1.1
MA41.2 MA43.2
API-TRAN-PAID-AMT Signed 15.2 AP170 AP180
Element: Adj Amt The total amount of the invoice paid to AP181 AP190
date in the currency of the invoice. AP193 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA70.1
MA75.1
API-ORIG-CNV-RATE Signed 12.6 AP125 AP126
Element: Account Rate The currency exchange rate used to AP170 AP180
convert the invoice amount to the AP181 AP190
company base currency. This field may be AP193 AP20.1
updated if the invoice is revalued to AP20.2 AP20.3
account for exchange rate fluctuations. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-ANTICIPATION Alpha 1 AP180 AP181
Element: All Flag Indicates whether anticipation criteria AP190 AP20.1
will be used to calculate the discount AP20.2 AP20.3
amount of the invoice. Valid values are: AP20.4 AP20.5
AP20.6 AP20.7
N = No. AP23.1 AP28.1
Y = Yes. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2
API-DISCOUNT-RT Percent 5.3 (Percent) AP125 AP126
Element: Cost Pct The discount rate used to calculate the AP180 AP181
discount amount of the invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-DISC-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date The discount date of the invoice. Used AP170 AP180
to determine whether a discount will be AP181 AP190
taken on an invoice. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.3
AP32.2 AP45.1
AP520 API1.1
API2.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-DUE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Due Date The invoice due date. Used to schedule AP170 AP180
the invoice for payment. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.3
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-NBR-SPLIT-PMT Numeric 3 AP180 AP181
Element: Nbr Of Invcs Used for split payment invoices to AP190 AP20.8
indicate the total number of payments to AP28.1 AP28.2
be made for the invoice. AP30.3 AP45.1
API-SPLIT-PMT-SCH Alpha 1 AP180 AP181
Split Payment Used for split payment invoices to AP190 AP20.8
Schedule indicate the frequency of payments to be AP28.1 AP28.2
made for the invoice. The invoice, due, AP30.3 AP45.1
and discount dates are incremented
according the schedule selected. Valid
values are:
W = Weekly.
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
Blank = Not a split payment invoice.
API-NBR-RECUR-PMT Numeric 3 AP180 AP181
Element: Nbr Of Invcs Used for recurring invoices to indicate AP190 AP193
the number of times the invoice will AP20.1 AP20.2
recur. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA41.2 MA43.2
API-RECUR-FREQ Alpha 1 AP180 AP181
Element: Recurring FreqUsed for recurring invoices to indicate AP190 AP193
how often the invoice should recur. AP20.1 AP20.2
Valid values are: AP20.3 AP20.4
AP20.5 AP20.7
W = Weekly. AP23.1 AP28.1
M = Monthly. AP28.2 AP30.1
Q = Quarterly. AP45.1 AP520
S = Semiannually. API1.1 API2.1
Y = Yearly. MA41.2 MA43.2
Blank = Not a recurring invoice.
E = End of Month
API-REMIT-TO-CODE Alpha 4 AP115 AP125
Purchase From The remit-to location code associated AP126 AP180
Location Code with the invoice. Must be a valid record AP181 AP190
in the Vendor Location file. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CASH-CODE Alpha 4 AP115 AP180
Accounts Receivable The cash code assigned to the invoice. AP181 AP190
Code Represents the bank account the invoice AP20.1 AP20.2
is to be paid from. Must be a valid AP20.3 AP20.4
record in the Cash Code file. AP20.5 AP20.6
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-BANK-INST-CODE Alpha 3 AP115 AP180
Element: Payment Code The payment code assigned to the AP181 AP190
invoice. Represents the type of cash AP20.1 AP20.2
payment or bill of exchange payment used AP20.3 AP20.4
to pay the invoice. Must be a valid cash AP20.5 AP20.6
payment transaction code record in the AP20.7 AP23.1
Bank Transaction Code file. AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-CURR-RECALC Alpha 1 AP180 AP181
Currency Used for non-base currency invoices to AP190 AP20.1
Recalculation indicate whether the invoice will be AP20.2 AP20.3
revalued when it is scheduled for AP20.4 AP20.5
payment to account for currency exchange AP20.6 AP20.7
rate fluctuations. Valid values are: AP23.1 AP28.1
AP28.2 AP45.1
N = No. AP520 AP55.2
Y = Yes. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code The tax code or tax table code applied AP180 AP181
to the invoice. Used to calculate AP190 AP20.1
invoice tax information. Must be a valid AP20.2 AP20.3
record in the Tax Code file. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INCOME-CODE Alpha 4 AP180 AP181
Accounts Receivable The income code associated with the AP190 AP20.1
Code invoice. Used to track vendor income for AP20.2 AP20.3
the invoice. Must be a valid record in AP20.4 AP20.5
the Income Code file. AP20.6 AP20.7
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2
API-DIST-CODE Alpha 9 AP180 AP181
Element: Distribution CThe distribution code assigned to the AP190 AP20.1
invoice. Used during invoice entry to AP20.2 AP20.3
automatically create distributions for AP20.4 AP20.5
the invoice. Must be a valid record in AP20.7 AP23.1
the Distribution Code file. AP28.1 AP28.2
AP45.1 AP520
MA41.2 MA43.2
API-REC-STATUS Numeric 1 AP125 AP126
Element: Record Status The status of the invoice record. Valid AP170 AP180
values are: AP181 AP190
AP25.1 AP25.2
0 = Unreleased. Not available for AP26.1 AP27.1
payment. AP28.1 AP28.2
1 = Released. Available for payment. AP30.4 AP45.1
9 = Historical. Paid and closed. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.7 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Date The date the invoice was created in the AP181 AP190
Lawson Accounts Payable system. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA70.1
MA75.1
API-DISTRIB-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Post Date The date used for posting invoice AP170 AP180
distributions to the general ledger. AP181 AP190
AP193 AP195
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-OPERATOR Alpha 10 AP125 AP126
Element: Operator Code The operator associated with the AP180 AP181
invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CREATION-TIME Numeric 6 (hhmmss) AP170 AP180
Element: Sys Time The time the invoice was created in the AP181 AP190
Lawson Accounts Payable system. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA70.1
MA75.1
API-VENDOR-GROUP Alpha 4 AP125 AP126
Element: Vendor Group The vendor group associated with the AP180 AP181
invoice. Must be a valid record in the AP190 AP20.1
Vendor Group file. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP180
Element: Pay Vendor The pay vendor for the invoice. AP181 AP190
Represents the vendor that receives AP20.1 AP20.2
payment for the invoice. Must be a valid AP20.3 AP20.4
record in the Vendor file. AP20.5 AP20.6
AP20.7 AP23.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2
API-PAY-GROUP Alpha 4 AP101 AP125
Element: Pay Group The pay group associated with the AP126 AP180
invoice. A pay group is used for AP181 AP190
processing accounts payable payments. AP20.1 AP20.2
Must be a valid record in the Pay Group AP20.3 AP20.4
file. AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE-GROUP Alpha 4 AP115 AP180
Element: Invoice Group The invoice group assigned to the AP181 AP190
invoice. An invoice group is a AP20.1 AP20.2
user-defined character expression that AP20.3 AP20.4
can be used to select invoices for AP20.5 AP20.6
payment. The same invoice group can be AP20.7 AP23.1
assigned to more than one invoice. AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-LAST-DIST-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeUsed by the system to track the number AP170 AP180
of the last distribution line created AP181 AP190
for the invoice. AP191 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.2 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-LAST-PMT-SEQ Numeric 4 AP170 AP180
Element: Sequence NumbeUsed by the system to track the last AP181 AP190
payment record number used for the AP193 AP20.1
invoice. 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
API-DISCOUNT-CODE Alpha 10 AP125 AP126
Element: Discount Code The discount code assigned to the AP180 AP181
invoice. Represents a general ledger AP190 AP20.1
discount account. Must be a valid record AP20.2 AP20.3
in the Discount Code file. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE-SOURCE Alpha 1 AP180 AP181
Element: Invoice SourceIndicates the source for creation of AP190 AP20.1
the invoice. Valid values are: AP20.2 AP20.3
AP20.4 AP20.5
Blank = Manual entry. AP20.7 AP23.1
E = Electronic Data Interchange (EDI). AP28.1 AP28.2
R = Evaluated Receipts Settlement (ERS). AP45.1 AP520
P = Payroll API1.1 API2.1
T = Tax MA41.2 MA43.2
G = Garnishment
L = Lease
C = AR Transfer
S = Sub Contractor
I = Interface Expense (PSA)
X = Expense (AC542)
API-INVC-REF-TYPE Alpha 2 AP180 AP181
Invoice Reference Indicates the type of number the vendor AP190 AP20.1
Type is providing to reference the invoice. AP20.2 AP20.3
Valid values are: AP20.4 AP20.5
AP20.7 AP23.1
BM = Bill of Lading. AP28.1 AP28.2
IN = Invoice. AP45.1 AP520
OW = Service Order. API1.1 API2.1
PL = Packing List. MA41.2 MA43.2
PO = Purchase Order Number.
VN = Vendor Order.
WO = Work Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
API-APPROVED-FLAG Alpha 1 AP125 AP126
Element: Approved Indicates whether the invoice is AP170 AP180
approved for payment. Valid values are: AP181 AP190
AP20.1 AP20.2
Y = Yes. AP20.3 AP20.4
N = No. AP20.5 AP20.6
D = Disapproved AP20.7 AP23.1
M = Message Exists AP25.1 AP25.2
P = Message Pending Action AP26.1 AP27.1
AP28.1 AP28.2
AP32.1 AP36.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA41.7
MA43.2 MA60.3
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
API-APPRV-OPERATOR Alpha 10 AP125 AP126
Element: Operator Code If the invoice required approval, this AP180 AP181
field contains the operator that AP190 AP25.1
approved the invoice. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP32.1
AP36.1 AP45.1
API1.1 MA41.7
MA61.1 MA70.1
MA75.1 MAI1.1
API-RETURN-NUMBER Numeric 10 AP180 AP181
Element: Return Number If the goods associated with the AP190 AP20.1
invoice were returned, this field AP20.2 AP20.3
contains the optional return number AP20.4 AP20.5
assigned to the return. AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
API2.1 MA41.2
MA43.2
API-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Element: Journal Book The journal book assigned to the AP190 AP20.1
transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2
API-TAX-POINT Alpha 1 AP180 AP181
Element: Tax Point Indicates when the tax amount is AP190 AP20.1
calculated for the invoice, if AP20.2 AP20.3
applicable. Valid values are: AP20.4 AP20.5
AP20.6 AP20.7
I = Invoice. AP23.1 AP28.1
P = Payment. AP28.2 AP30.2
AP32.2 AP45.1
AP520 API1.1
API2.1 MA41.2
MA43.2
API-OBJ-ID Numeric 12 AP125 AP126
Element: Object ID A subsystem object interface AP170 AP180
identification number. Used to identify AP181 AP190
the Invoice Distribution and Asset AP193 AP20.1
Detail records that are associated with AP20.2 AP20.3
the invoice. Also used for Drill Around AP20.4 AP20.5
purposes. AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP32.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-RECON-DATE Numeric 8 (yyyymmdd) AP125 AP126
Reconciliation or Represents the date the transaction AP180 AP181
Void Date cleared the bank or was voided. AP190 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-POD-PRINTED Numeric 1 AP125 AP126
Proof of Delivery Indicates is a proof of delivery has AP130 AP180
Printed been printed for this invoice. AP181 AP190
AP20.1 AP20.2
Valid values are: AP20.3 AP20.4
AP20.5 AP20.7
Y = Yes AP23.1 AP25.1
" " = No AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-MATCH-REF-NBR Alpha 22 AP125 AP126
Match Reference Matching reference number. This is a AP180 AP181
Number user defined number used for matching. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-MATCH-FL Alpha 1 AP125 AP126
Element: Match Invoice Indicates if the invoice is a match AP180 AP181
invoice. AP190 AP20.1
A = AOC Invoice AP20.2 AP20.3
Y = PO Invoice AP20.4 AP20.5
N = Exp Invoice AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 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.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-TERMS-CD Alpha 5 AP125 AP126
Element: Terms Code Invoice payment terms code. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-RCPT-INV-DATE Numeric 8 (yyyymmdd) AP125 AP126
Receipt of Invoice The date the invoice was received. If AP180 AP181
Date left blank, the system date defaults. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-RETAIL-AMT Signed 15.2 AP125 AP126
Element: Retail Amount The retail amount of the item. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-MATCH-STATUS Numeric 1 AP125 AP126
Element: Match Status Indicates the match status of the AP180 AP181
invoice. AP190 AP20.1
AP20.2 AP20.3
Valid values are: AP20.4 AP20.5
AP20.7 AP23.1
0 = Unmatched AP25.1 AP25.2
1 = Out of tolerance AP26.1 AP27.1
2 = Matched AP28.1 AP28.2
3 = Matched out of tolerance AP45.1 AP520
4 = Matched in tolerance API1.1 API2.1
5 = Matched with auto chargeback MA310 MA41.1
6 = Approved No Receipt (MA61) MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-REASON-CODE Alpha 4 AP125 AP126
Accounts Receivable This field contains the reason code, AP180 AP181
Code which indicates the cause for credit AP190 AP20.1
memos. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-HANDLING-CODE Alpha 4 AP125 AP126
Invoice Handling Invoice handling code. The invoice AP180 AP181
Code handling code contains processing rules AP190 AP20.1
for invoice matching. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-MATCH-AMT Signed 15.2 AP125 AP126
Element: Match Amount Match amount. Represents the goods AP180 AP181
amount on which the invoice will match AP190 AP20.1
to a receipt. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-AOC-ALLOW-AMT Signed 15.2 AP125 AP126
Element: Add On Cost AmAdd on cost amount. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP180 AP181
location within the company inventory. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-MATCH-OBJ-ID Numeric 12 AP125 AP126
Element: Match Object IA system generated matching object AP180 AP181
identifier. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
MA310 MA41.7
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-CBPRINT-FL Alpha 1 AP131 AP180
Element: Print ChargebaIndicates whether to print chargebacks. AP181 AP190
N = No AP20.1 AP20.2
Y = Yes AP20.3 AP20.4
" " = spaces AP20.5 AP20.7
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-MATCH-TABLE Alpha 10 AP125 AP126
Element: Match Table Match table. Contains matching and AP180 AP181
match processing rules. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
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.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-TAX-CODE-CNTL Alpha 1 AP125 AP126
Element: Tax Code ContrThis control field defines the tax code AP180 AP181
usage in invoicing and approving taxes. AP190 AP20.1
AP20.2 AP20.3
For PO Invoices, if set to O (Override) AP20.4 AP20.5
all lines approved for payment will use AP20.7 AP23.1
the tax code defined for the whole AP25.1 AP25.2
invoice. AP26.1 AP27.1
AP28.1 AP28.2
If set to I (Ignore) no PO lines AP45.1 API1.1
approved for payment will be taxed. API2.1 MA310
0 = No Tax MA41.2 MA43.2
1 = Override Product Only MA60.1 MA60.2
2 = Ignore Product Only MA60.3 MA60.4
3 = Calculate MA61.1 MA63.1
4 = Overide Product and AOC MA65.1 MA67.1
5 = Ignore Product and AOC MA67.2 MA68.1
MA70.1 MA75.1
API-LAST-MATCH-LN Numeric 4 AP125 AP126
Element: Last Match LinLast matched line number. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-MATCH-LEVEL Alpha 3 AP125 AP126
Element: Match Level Indicates whether the invoice was AP180 AP181
matched at the invoice or detail level. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 MA41.7
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
API-MATCH-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Match Date The date the invoice was matched. AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 MA41.7
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
API-PO-INV-TAX Signed 15.2 AP125 AP126
Element: Invoiced Tax The amount of invoiced tax that will be AP180 AP181
generated on the invoice from taxable AP190 AP20.1
add on costs and taxable purchase order AP20.2 AP20.3
receipt lines assigned to the invoice. AP20.4 AP20.5
The resulting value is then used to AP20.7 AP23.1
compute the invoice match amount when no AP25.1 AP25.2
tax code has been assigned to the AP26.1 AP27.1
invoice. AP28.1 AP28.2
AP45.1 API1.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BYPASS-MATCH Alpha 1 AP125 AP126
Element: All Flag AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
API2.1 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-SERVICE-FL Alpha 1 AP125 AP126
Element: Service Fl This field indicates a transaction is a AP180 AP181
Service only transaction. AP190 AP20.1
Y = Yes AP20.2 AP20.3
N = No AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
API2.1 MA310
MA41.2 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-SERVICE-AMT Signed 15.2 AP125 AP126
Element: Adj Amt AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-BUYER Alpha 3 AP125 AP126
Element: Buyer AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-FINAL-DST-FLAG Alpha 1 AP30.2
Element: Final Dst Flag
API-NOTC Alpha 2 AP180 AP181
Element: Notc The Nature of Transaction code. Must AP190 AP20.1
be a valid code defined in IN07.1 (NOTC AP20.2 AP20.3
Maintenance). AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-STAT-PROC Alpha 6 AP180 AP181
Element: Stat Proc The statistical procedure code applied AP190 AP20.1
to the data. The code must be defined AP20.2 AP20.3
in IN06.1. (Statistical Procedure AP20.4 AP20.5
Maintenance). AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-SHIP-VIA Alpha 12 (Lower Case) AP180 AP181
Element: Ship Via Description AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-UNLOADING-PORT Alpha 5 AP180 AP181
Element: Unloading PortThe prot where the goods are unloaded if AP190 AP20.1
required. Must be defined in IN04.1 AP20.2 AP20.3
(Port Maintenance) AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-INTRASTAT-NBR Numeric 12 AP125 AP126
Element: Intrastat Nbr The number assigned by the Intrastat AP180 AP181
system to a transaction that involves AP190 AP25.1
Intrastat reporting after it has been AP25.2 AP26.1
added. AP27.1 AP28.1
AP28.2 AP45.1
API1.1
API-DROPSHIP-FL Alpha 1 AP125 AP126
Element: Dropship Flag This flag indicates whether goods being AP180 AP181
shipped by the vendor directly to a non AP190 AP20.1
standard location need to have the AP20.2 AP20.3
receiving process performed. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
MA310 MA41.2
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-FOB-CODE Alpha 3 AP180 AP181
Element: Shipping Term The user defined Free On Board Code. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-JBK-SEQ-NBR Numeric 10 AP170 AP180
Journal Book The journal book sequence number AP181 AP190
Sequence Number assigned to a journal book transaction AP193 AP20.1
when it is added or interfaced to the AP20.2 AP20.3
Lawson system. Used only when Auto AP20.4 AP20.5
Journal Book Seq Nbr is set to Yes in AP20.7 AP23.1
GL10.1 (Company). AP28.1 AP28.2
AP45.1 AP520
API1.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2
API-TAX-OUT-BAL Derived
Tax Out of Balance The amount of the invoice that is
Amount out-of-balance due to tax applications
made for the invoice.
API-TXB-OUT-BAL Derived
Element: Txb Out Bal Derived field to show difference between
header taxable input and total taxable
amount from distributions.
API-PMT-OUT-BAL Derived
Payment Out Of The amount of the invoice that is
Balance Amount out-of-balance due to payment
applications made for the invoice.
API-DIST-OUT-BAL Derived
Distrib. Out Of The amount of the invoice that is
Balance Amount out-of-balance due to expense
distribution applications made for the
invoice.
API-OUT-BAL-FLAG Derived
Out of Balance Indicates whether the invoice is
Indicator out-of-balance. Valid values are:
N = No.
Y = Yes.
API-INV-STATUS Derived
Element: Invoice StatusIndicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
API-NET-PAYABLE Derived
Element: Net Payment AmThe net payment amount in the currency
of the invoice.
API-REV-SIGN-AMT Derived
Reversed Signed The invoice amount * -1.
Amount
API-TYPE-SHORT-NME Derived
Short Invoice Type The translation of the invoice type.
Name
API-PO-RELEASE-3 Derived
Purchase Order The purchase order release number
Release Number associated with the invoice. Used to
identify a purchase order release
created from a blanket or standing
order.
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY This index is used to access invoice AP00.4 AP01.1
VENDOR records for a specific vendor and AP101 AP115
INVOICE company. AP125 AP126
SUFFIX AP131 AP141
CANCEL-SEQ AP150 AP151
AP155 AP156
AP160 AP161
AP170 AP175
AP176 AP180
AP181 AP190
AP191 AP193
AP195 AP197
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
...
APISET10 COMPANY This index is used by AP260 (Invoice AP260
RECON-DATE Accrual Reconciliation) to quickly
ACCR-CODE access invoice records that have not
VENDOR been reconciled by a previous AP260 run.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
APISET11 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where MATCH-REF-NBR != Spaces AP25.1 AP25.2
MATCH-REF-NBR AP26.1 AP27.1
OBJ-ID API1.1 MA310
MA41.7 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
APISET12 COMPANY This index is used to access and AP131
CBPRINT-FL inquire on invoices released but not
VENDOR approved.
INVOICE-DTE KeyChange, Subset
INVOICE Where INVOICE-TYPE = "C"
SUFFIX
CANCEL-SEQ
APISET13 COMPANY KeyChange AP125 AP126
VENDOR AP131 AP25.1
MATCH-OBJ-ID AP25.2 AP26.1
INVOICE AP27.1 AP30.4
SUFFIX API1.1 MA310
CANCEL-SEQ MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
PO58.2
APISET14 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where((MATCH-STATUS = Zeroes ) AP130 AP25.1
DUE-DATE Or (MATCH-STATUS = 1 )) AP25.2 AP26.1
INVOICE And (MATCH-FL = "Y" ) AP27.1 API1.1
SUFFIX And ((REC-STATUS = Zeroes ) MA126 MA236
CANCEL-SEQ Or (REC-STATUS = 1 )) MA310 MA41.7
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
APISET2 COMPANY This index is used to access unreleased AP00.4 AP125
BATCH-NUM invoice records for a specific batch or AP126 AP195
AUTH-CODE authority code. AP220 AP25.1
VOUCHER-NBR KeyChange, Subset AP25.2 AP25.3
VENDOR Where REC-STATUS = Zeroes AP26.1 AP27.1
INVOICE
SUFFIX
CANCEL-SEQ
APISET3 REC-STATUS This index is used to access unreleased AP193 AP195
COMPANY invoice records for a specific batch or AP198 AP20.1
BATCH-NUM authority code in entry order. AP20.2 AP20.3
AUTH-CODE KeyChange AP20.4 AP20.5
OPERATOR AP20.6 AP20.7
CREATE-DATE AP23.1 AP236
CREATION-TIME AP25.2 AP300
VENDOR AP36.1 AP700
INVOICE MA41.2 MA43.2
SUFFIX
CANCEL-SEQ
APISET4 COMPANY This index is used to access invoice AP00.4 AP20.1
VOUCHER-NBR records for a specific voucher number. AP20.2 AP20.3
REC-STATUS KeyChange AP20.4 AP20.5
VENDOR AP20.6 AP20.7
INVOICE AP23.1 AP235
SUFFIX AP30.1 AP520
CANCEL-SEQ AP90.3 API1.1
API2.1 AR48.3
MA41.2 MA43.2
TX226
APISET5 VENDOR-GROUP This index is used to access invoice AM115 AM15.1
VENDOR records not on hold for a specific hold AM15.2 AM15.3
INVOICE code. AM15.4 AM20.1
SUFFIX KeyChange AM20.3 AM21.1
CANCEL-SEQ AM21.3 AM500
COMPANY AM51.1 AM551
AM97.1 AP10.1
AP115 AP251
AP295 AP300
AP91.1 AP92.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
...
APISET6 COMPANY This index is used to access invoice AP251 AP300
VENDOR records for a specific vendor in invoice AP90.2
INVOICE-DTE date sequence.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
APISET7 COMPANY This index is used to access invoice AP125 AP126
REC-STATUS records that are out of balance. AP240 AP25.1
BATCH-NUM KeyChange, Subset AP25.2 AP26.1
VENDOR Where TRAN-TOT-DIST != TRAN-INV-AMT AP27.1
INVOICE Or TRAN-TOT-PMT != TRAN-INV-AMT
SUFFIX Or BASE-TOT-PMT != BASE-INV-AMT
CANCEL-SEQ Or TRAN-TOT-TAX != TRAN-TAX-AMT
APISET8 COMPANY This index is used to access invoices AP125 AP126
DUE-DATE for a specific vendor in descending AP25.1 AP25.2
VENDOR invoice date sequence. AP252 AP26.1
INVOICE KeyChange, Subset AP27.1 API1.1
SUFFIX Where((MATCH-STATUS = Zeroes ) MA126 MA310
CANCEL-SEQ Or (MATCH-STATUS = 1 )) MA60.1 MA60.2
And (MATCH-FL = "Y" ) MA60.3 MA60.4
And ((REC-STATUS = Zeroes ) MA61.1 MA63.1
Or (REC-STATUS = 1 )) MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
APISET9 COMPANY This index is used to access invoice AP125 AP126
VENDOR records for a specific purchase order. AP141 AP25.1
PO-NUMBER KeyChange AP25.2 AP26.1
PO-RELEASE AP27.1 AP90.4
PO-CODE API1.1 MA126
LOCATION MA310 MA41.7
INVOICE MA60.1 MA60.2
SUFFIX MA60.3 MA60.4
CANCEL-SEQ MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1 POII.1
APINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apauthor APAUTHOR Required
When API-AUTH-CODE > Spaces
API-COMPANY -> ATR-COMPANY
API-AUTH-CODE -> ATR-AUTH-CODE
Apbatch APBATCH Required
When API-BATCH-NUM != Zeroes
API-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
API-COMPANY -> CPY-COMPANY
Apinccode APINCCODE Not Required
API-INCOME-CODE -> TYP-INCOME-CODE
Appayvenaddr APVENADDR Not Required
CPY-VENDOR-GROUP -> VDR-VENDOR-GROUP
API-PAY-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
"Y" -> VDR-CUR-ADDR
Appayvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
API-PAY-VENDOR -> VEN-VENDOR
Approclev APPROCLEV Required
API-COMPANY -> APR-COMPANY
API-PROC-LEVEL -> APR-PROC-LEVEL
Apuaval APUAVAL Not Required
"I" -> UAV-SEG-TYPE
API-OBJ-ID -> UAV-API-OBJ-ID
Zeroes -> UAV-DIST-SEQ-NBR
Apvenlocaddr APVENADDR Not Required
CPY-VENDOR-GROUP -> VDR-VENDOR-GROUP
API-PAY-VENDOR -> VDR-VENDOR
API-REMIT-TO-CODE -> VDR-LOCATION-CODE
"Y" -> VDR-CUR-ADDR
Apvenlocpurch APVENLOC Required
When API-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
API-VENDOR -> VLO-VENDOR
API-PURCH-FR-LOC -> VLO-LOCATION-CODE
Apvenlocremit APVENLOC Required
When API-REMIT-TO-CODE != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
API-PAY-VENDOR -> VLO-VENDOR
API-REMIT-TO-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
API-VENDOR -> VEN-VENDOR
Cbcashcode CBCASHCODE Required
API-CASH-CODE -> CBC-CASH-CODE
Eeadvance A EEADVANCE Required
When API-INVOICE-TYPE = "A"
API-COMPANY -> EEA-COMPANY
API-VENDOR -> EEA-VENDOR
API-INVOICE -> EEA-ADVANCE-NBR
Eeadvance M EEADVANCE Required
When API-INVOICE-TYPE = "M"
API-COMPANY -> EEA-COMPANY
API-VENDOR -> EEA-VENDOR
API-INVOICE -> EEA-ADVANCE-NBR
Eeexpense EEEXPENSE Required
When API-INVOICE-TYPE = "E"
API-COMPANY -> EXP-COMPANY
API-VENDOR -> EXP-VENDOR
API-INVOICE -> EXP-EXPENSE-NBR
Invusrfld APINUSRFLD Not Required
API-OBJ-ID -> ISR-OBJ-ID
Macompany MACOMPANY Not Required
API-COMPANY -> MAY-COMPANY
Mapool3 MAPOOLCNT Not Required
Valid When (VEN-POOL-OPTION = 3 )
Or ((VEN-POOL-OPTION = Zeroes )
And (MAY-POOL-OPTION = 3 ))
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
API-PO-NUMBER -> MAC-PO-NUMBER
API-PO-RELEASE -> MAC-PO-RELEASE
API-PO-CODE -> MAC-PO-CODE
API-LOCATION -> MAC-LOCATION
Pocompany POCOMPANY Not Required
API-COMPANY -> PCY-COMPANY
Poreceive PORECEIVE Not Required
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-INVOICE -> POR-INVOICE
Poreturnhd PORETURNHD Not Required
API-COMPANY -> PTH-COMPANY
API-RETURN-NUMBER -> PTH-RETURN-NUMBER
Povagrmthd POVAGRMTHD Not Required
Valid When (PVH- = API-)
PCY-PROCURE-GROUP -> PVH-PROCURE-GROUP
API-VENDOR -> PVH-VENDOR
API-PO-NUMBER -> PVH-PO-NUMBER
Purchorder PURCHORDER Not Required
API-COMPANY -> PCR-COMPANY
API-PO-CODE -> PCR-PO-CODE
API-PO-NUMBER -> PCR-PO-NUMBER
API-PO-RELEASE -> PCR-PO-RELEASE
Reasoncd MAREASONCD Not Required
API-REASON-CODE -> MAR-REASON-CODE
Taxcode TXTAXCODE Not Required
API-COMPANY -> TAC-COMPANY
API-TAX-CODE -> TAC-TAX-CODE
Txcompany TXCOMPANY Not Required
API-COMPANY -> TXC-COMPANY
APINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apaudit APAUDIT
CPY-VENDOR-GROUP -> APA-VENDOR-GROUP
API-COMPANY -> APA-COMPANY
API-PROC-LEVEL -> APA-PROC-LEVEL
API-VENDOR -> APA-VENDOR
API-INVOICE -> APA-INVOICE
API-SUFFIX -> APA-SUFFIX
API-CANCEL-SEQ -> APA-CANCEL-SEQ
APA-SEQ-NBR
APA-TRANS-DATE
APA-TRANS-TIME
Apcrmemo APCRMEMO
API-COMPANY -> CRM-COMPANY
API-VENDOR -> CRM-VENDOR
API-INVOICE -> CRM-INVOICE
API-SUFFIX -> CRM-SUFFIX
CRM-SEQ-NBR
CRM-CR-MEMO-NBR
CRM-CR-MEMO-SUFFIX
CRM-CR-SEQ-NBR
Apcrmemo2 APCRMEMO
API-COMPANY -> CRM-COMPANY
API-VENDOR -> CRM-VENDOR
API-INVOICE -> CRM-CR-MEMO-NBR
API-SUFFIX -> CRM-CR-MEMO-SUFFIX
CRM-CR-SEQ-NBR
CRM-INVOICE
CRM-SUFFIX
CRM-SEQ-NBR
Apdiscacc APDISCACC
API-COMPANY -> DSK-COMPANY
API-VENDOR -> DSK-VENDOR
API-INVOICE -> DSK-INVOICE
API-SUFFIX -> DSK-SUFFIX
API-CANCEL-SEQ -> DSK-CANCEL-SEQ
DSK-SEQ-NBR
DSK-VOID-SEQ
DSK-DISC-TYPE
Apdistcode APDISTCODE
API-COMPANY -> DTC-COMPANY
API-DIST-CODE -> DTC-DIST-CODE
DTC-SEQ-NBR
Apdistrib APDISTRIB Delete Cascades
API-OBJ-ID -> APD-API-OBJ-ID
APD-DIST-SEQ-NBR
Appayment APPAYMENT Delete Cascades
API-COMPANY -> APP-COMPANY
API-VENDOR -> APP-VENDOR
API-INVOICE -> APP-INVOICE
API-SUFFIX -> APP-SUFFIX
API-CANCEL-SEQ -> APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Apvencomments2 APCOMMENTS
"V" -> APC-REC-TYPE
CPY-VENDOR-GROUP -> APC-VENDOR-GROUP
API-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
API-COMPANY -> APC-COMPANY
APC-SEQ-NBR
Mainvdtl MAINVDTL
API-COMPANY -> MAD-COMPANY
API-VENDOR -> MAD-VENDOR
API-INVOICE -> MAD-INVOICE
API-SUFFIX -> MAD-SUFFIX
API-PO-NUMBER -> MAD-PO-NUMBER
API-PO-RELEASE -> MAD-PO-RELEASE
API-PO-CODE -> MAD-PO-CODE
MAD-LINE-NBR
MAD-AOC-CODE
MAD-SEQ-NBR
Mainvdtl 2 MAINVDTL
API-COMPANY -> MAD-COMPANY
API-VENDOR -> MAD-VENDOR
API-INVOICE -> MAD-INVOICE
API-SUFFIX -> MAD-SUFFIX
MAD-PO-NUMBER
MAD-PO-RELEASE
MAD-PO-CODE
MAD-LINE-NBR
MAD-AOC-CODE
MAD-SEQ-NBR
Mainvmsg MAINVMSG
API-COMPANY -> MAG-COMPANY
API-VENDOR -> MAG-VENDOR
API-INVOICE -> MAG-INVOICE
API-SUFFIX -> MAG-SUFFIX
API-CANCEL-SEQ -> MAG-CANCEL-SEQ
MAG-MAD-SEQ-NBR
MAG-SEQ-NBR
Mapoinv MAPOINV Delete Restricted
API-COMPANY -> AOI-COMPANY
API-VENDOR -> AOI-VENDOR
API-INVOICE -> AOI-INVOICE
API-SUFFIX -> AOI-SUFFIX
AOI-PO-NUMBER
AOI-PO-RELEASE
AOI-PO-CODE
Mapool1 MAPOOLCNT
Valid When VEN-POOL-OPTION = 1
Or (VEN-POOL-OPTION = Zeroes
And MAY-POOL-OPTION = 1 )
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
MAC-PO-NUMBER
MAC-PO-RELEASE
MAC-PO-CODE
MAC-LOCATION
Mapool2 MAPOOLCNT
Valid When (VEN-POOL-OPTION = 2 )
Or ((VEN-POOL-OPTION = Zeroes )
And (MAY-POOL-OPTION = 2 ))
API-COMPANY -> MAC-COMPANY
API-VENDOR -> MAC-VENDOR
API-PO-NUMBER -> MAC-PO-NUMBER
API-PO-RELEASE -> MAC-PO-RELEASE
API-PO-CODE -> MAC-PO-CODE
MAC-LOCATION
Match Trans APINVOICE
API-COMPANY -> API-COMPANY
API-VENDOR -> API-VENDOR
API-MATCH-OBJ-ID -> API-MATCH-OBJ-ID
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
Pomessage POMESSAGE
API-COMPANY -> POM-COMPANY
API-BATCH-NUM -> POM-BATCH-NBR
API-VENDOR -> POM-VENDOR
API-INVOICE -> POM-INVOICE
API-SUFFIX -> POM-SUFFIX
POM-PO-NUMBER
POM-PO-RELEASE
POM-LINE-NBR
Por Match Ref PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-MATCH-REF-NBR -> POR-MATCH-REF-NBR
POR-REC-NUMBER
Porecline PORECLINE
API-COMPANY -> PRL-COMPANY
API-MATCH-OBJ-ID -> PRL-MATCH-OBJ-ID
PRL-MATCH-SEQ-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
Poreset9 Ven PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
Porset3 PORECEIVE
API-AOC-ALLOW-AMT -> POR-COMPANY
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-PO-LOCATION
POR-REC-NUMBER
Porset9 PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
API-PO-CODE -> POR-PO-CODE
API-PO-NUMBER -> POR-PO-NUMBER
API-PO-RELEASE -> POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
Porset9 Ven PORECEIVE
API-COMPANY -> POR-COMPANY
API-VENDOR -> POR-VENDOR
POR-PO-CODE
POR-PO-NUMBER
POR-PO-RELEASE
POR-LOCATION
POR-REC-NUMBER
|