 |
Lawson Insight Technical Documentation |
|
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 AP00.5 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 AP40.1 AP43.1 AP56.2
AP90.1 AP90.3 AP90.2 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 DA290 IC28.1 MA126 MA180 MA278
MA530 MA531 MA540 MA63.1 MA64.6 MA67.1
MA67.2 MA68.1 MAED.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
PR277 RQ10.1 RQ10.2 WH20.2 WH20.7 AP236
AP10.1 AP251 API3.1 API4.1 IC840
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 API1.1 API2.1 EE135 EE35.1
EE35.2 EE520 MA310 MA41.1 MA41.2 MA41.4
MA43.1 MA43.2 MA43.3 MA43.4 MA43.5 MA43.7
MA43.8 MA60.2 MA60.3 MA60.4 MA61.1 MA65.1
MA66.2 MA66.3 MA70.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
API-COMPANY Numeric 4 AP125 AP126
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
API-VENDOR Alpha 9 (Right Justified) AP115 AP125
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
API-INVOICE Alpha 22 AP115 AP125
Invoice Number The 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
API-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The 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
API-CANCEL-SEQ Numeric 4 AP125 AP126
Cancel Sequence The 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
API-CANCEL-DATE Numeric 8 (yyyymmdd) AP180 AP181
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
API-BATCH-NUM Numeric 6 AP125 AP126
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
API-BATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Batch 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
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
API-AUTH-CODE Alpha 3 AP180 AP181
Authority Code The authority code assigned to the AP190 AP20.1
invoice. Represents the person or AP20.2 AP20.3
department responsible for approving a AP20.4 AP20.5
registered invoice and is required AP20.6 AP20.7
before a registered invoice can be AP23.1 AP26.1
released. Used only by a company that AP27.1 AP28.1
has Yes selected in the Invoice Approval AP28.2 AP36.1
field and No in the Batch Release field. AP45.1 AP520
Must be a valid record in the Authority API1.1 API2.1
Code file. EE135 EE35.1
EE35.2 EE520
MA41.2 MA43.2
API-PROC-LEVEL Alpha 5 AP125 AP126
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
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
MAI1.1
API-ACCR-CODE Alpha 4 AP125 AP126
Invoice Accrual Code The 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
API-INVOICE-TYPE Alpha 1 AP125 AP126
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
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
Invoice Currency The 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
API-PAY-CURRENCY Alpha 5 AP125 AP126
Payment Currency The currency used to pay the invoice. AP180 AP181
Must be a valid record in the Currency AP190 AP20.6
Code file. 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
API-INVOICE-DTE Numeric 8 (yyyymmdd) AP125 AP126
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
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
API-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
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
API-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number The 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
API-PO-CODE Alpha 4 AP125 AP126
Purchase Order Code Purchase 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
API-DESCRIPTION Alpha 30 (Lower Case) AP180 AP181
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
Base Invoice Amount The 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
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
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 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 MAI1.1
API-BASE-ND Numeric 1 AP125 AP126
Base Number Of The number of decimal places defined AP180 AP181
Decimals 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
API-TRAN-INV-AMT Signed 15.2 AP125 AP126
Invoice Amount The 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 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 MAI1.1
API-TRAN-ALOW-AMT Signed 15.2 AP125 AP126
Allowable Amount 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 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 MAI1.1
API-TRAN-TXBL-AMT Signed 15.2 AP125 AP126
Taxable Amount 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 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 MAI1.1
API-TRAN-ND Numeric 1 AP125 AP126
Transaction Number The number of decimal places defined AP180 AP181
of Decimals 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
API-TRAN-TAX-AMT Signed 15.2 AP125 AP126
Tax Amount 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
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
MAI1.1
API-BASE-DISC-AMT Signed 15.2 AP125 AP126
Base Discount Amount 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
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MAI1.1
API-TRAN-DISC-AMT Signed 15.2 AP125 AP126
Discount Amount 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 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 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
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
MAI1.1
API-TRAN-TOT-PMT Signed 15.2 AP125 AP126
Total Payment Amount 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
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
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
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 MAI1.1
API-TRAN-TOT-DIST Signed 15.2 AP125 AP126
Total Distribution The total distribution amount of the AP170 AP180
Amount 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
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 MAI1.1
API-TRAN-TOT-TAX Signed 15.2 AP125 AP126
Total Tax Amount 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
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 MAI1.1
API-TRAN-PAID-AMT Signed 15.2 AP170 AP180
Paid Amount 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
API-ORIG-CNV-RATE Signed 12.6 AP125 AP126
Exchange 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
API-ANTICIPATION Alpha 1 AP180 AP181
Anticipation 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
Discount Rate 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
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MAI1.1
API-DISC-DATE Numeric 8 (yyyymmdd) AP125 AP126
Discount 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 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 MAI1.1
API-DUE-DATE Numeric 8 (yyyymmdd) AP125 AP126
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
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
MAI1.1
API-NBR-SPLIT-PMT Numeric 3 AP180 AP181
Number of Split Used for split payment invoices to AP190 AP20.8
Payments 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
Number of Used for recurring invoices to indicate AP190 AP193
Recurrences 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
Recurring Frequency Used 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 AP180
Remit To Location The remit-to location code associated AP181 AP190
Code with the invoice. Must be a valid record AP20.1 AP20.2
in the Vendor Location file. 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 MA41.2
MA43.2
API-CASH-CODE Alpha 4 AP115 AP180
Cash Code The cash code assigned to the invoice. AP181 AP190
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
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 AP170 AP180
Currency Used for non-base currency invoices to AP181 AP190
Recalculation indicate whether the invoice will be AP20.1 AP20.2
revalued when it is scheduled for AP20.3 AP20.4
payment to account for currency exchange AP20.5 AP20.6
rate fluctuations. Valid values are: AP20.7 AP23.1
AP28.1 AP28.2
N = No. AP45.1 AP520
Y = Yes. AP55.2 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2
API-TAX-CODE Alpha 10 AP125 AP126
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
API-INCOME-CODE Alpha 4 AP180 AP181
Income Code The income code associated with the AP190 AP20.1
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
Distribution Code The 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
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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MAI1.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Creation 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
API-DISTRIB-DATE Numeric 8 (yyyymmdd) AP125 AP126
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
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
MAI1.1
API-OPERATOR Alpha 10 AP180 AP181
Operator Code The operator associated with the AP190 AP20.1
invoice. 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
API-CREATION-TIME Numeric 6 (hhmmss) AP170 AP180
Creation 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
API-VENDOR-GROUP Alpha 4 AP125 AP126
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
API-PAY-VENDOR Alpha 9 (Right Justified) AP115 AP180
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
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
API-INVOICE-GROUP Alpha 4 AP115 AP180
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
Last Distribution Used by the system to track the number AP170 AP180
Sequence Nbr 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 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MAI1.1
API-LAST-PMT-SEQ Numeric 4 AP170 AP180
Last Payment Used by the system to track the last AP181 AP190
Sequence 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
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
API-INVOICE-SOURCE Alpha 1 AP180 AP181
Invoice Source Indicates 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
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
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 MA43.2
MA60.3 MA61.1
MA66.2 MA70.1
MAI1.1
API-APPRV-OPERATOR Alpha 10 AP180 AP181
Approval Operator If the invoice required approval, this AP190 AP28.1
field contains the operator that AP28.2 AP32.1
approved the invoice. AP36.1 AP45.1
MA61.1 MA70.1
MAI1.1
API-RETURN-NUMBER Numeric 10 AP180 AP181
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
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
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
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
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
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
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
API-MATCH-FL Alpha 1 AP125 AP126
Match Invoice Flag 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
API-TERMS-CD Alpha 5 AP125 AP126
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
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.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
API-RETAIL-AMT Signed 15.2 AP125 AP126
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
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
MAI1.1
API-MATCH-STATUS Numeric 1 AP125 AP126
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
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
MAI1.1
API-REASON-CODE Alpha 4 AP125 AP126
Reason Code This field contains the reason code, AP180 AP181
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
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
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
API-MATCH-AMT Signed 15.2 AP125 AP126
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
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
MAI1.1
API-AOC-ALLOW-AMT Signed 15.2 AP125 AP126
Add On Cost Amount Add 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
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
MAI1.1
API-LOCATION Alpha 5 AP125 AP126
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
API-MATCH-OBJ-ID Numeric 12 AP125 AP126
Match Object ID A 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.1
MA67.2 MA68.1
MA70.1 MAI1.1
API-CBPRINT-FL Alpha 1 AP131 AP180
Print Chargebacks Indicates 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
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
API-TAX-CODE-CNTL Alpha 1 AP125 AP126
Tax Code Control This 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
API-LAST-MATCH-LN Numeric 4 AP125 AP126
Last Match Line Last 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
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
MAI1.1
API-MATCH-LEVEL Alpha 3 AP180 AP181
Match Level Indicates whether the invoice was AP190 AP28.1
matched at the invoice or detail level. AP28.2 AP45.1
MA61.1 MA66.2
MA70.1 MAI1.1
API-MATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Match Date The date the invoice was matched. AP190 AP28.1
AP28.2 AP45.1
MA61.1 MA66.2
MA70.1 MAI1.1
API-PO-INV-TAX Signed 15.2 AP125 AP126
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
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
MAI1.1
API-BYPASS-MATCH Alpha 1 AP125 AP126
Bypass Match 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
API-SERVICE-FL Alpha 1 AP125 AP126
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
API-SERVICE-AMT Signed 15.2 AP125 AP126
Service 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
API-BUYER Alpha 3 AP20.1 AP20.2
Buyer AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
API-FINAL-DST-FLAG Alpha 1 AP30.2
Final Dst Flag
API-NOTC Alpha 2 AP180 AP181
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
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
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
Unloading Port The 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
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 AP180 AP181
Dropship Flag This flag indicates whether goods being AP190 AP20.1
shipped by the vendor directly to a non AP20.2 AP20.3
standard location need to have the AP20.4 AP20.5
receiving process performed. AP20.7 AP23.1
AP28.1 AP28.2
AP45.1 API1.1
MA41.2 MA43.2
API-FOB-CODE Alpha 3 AP180 AP181
Shipping Term Code 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-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-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
Invoice Status Indicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
API-NET-PAYABLE Derived
Net Payment Amount The 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.
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
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY This index is used to access invoice AP00.4 AP00.5
VENDOR records for a specific vendor and AP01.1 AP101
INVOICE company. AP115 AP125
SUFFIX AP126 AP131
CANCEL-SEQ AP141 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
...
APISET10 COMPANY This index is used by AP260 (Invoice AP260
RECON-DATE Accrual Reconciliation) to quickly
VENDOR access invoice records that have not
INVOICE been reconciled by a previous AP260 run.
SUFFIX KeyChange
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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.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 API1.1
SUFFIX MA310 MA60.1
CANCEL-SEQ MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
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 MA310
CANCEL-SEQ Or (REC-STATUS = 1 )) MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.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 MA41.2
INVOICE 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 AP30.1
SUFFIX AP520 AP90.3
CANCEL-SEQ API1.1 API2.1
AR48.3 MA41.2
MA43.2
APISET5 VENDOR-GROUP This index is used to access invoice AP10.1 AP115
VENDOR records not on hold for a specific hold AP251 AP91.1
INVOICE code. AP92.1 API3.1
SUFFIX KeyChange API4.1 IC840
CANCEL-SEQ
COMPANY
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
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 MA60.1
INVOICE MA60.2 MA60.3
SUFFIX MA60.4 MA61.1
CANCEL-SEQ MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MAI1.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 (API-POOL-OPTION = 3 )
Or ((API-POOL-OPTION = Zeroes )
And (API-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 (API- = 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
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 API-POOL-OPTION = 1
Or (API-POOL-OPTION = Zeroes
And API-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 (API-POOL-OPTION = 2 )
Or ((API-POOL-OPTION = Zeroes )
And (API-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
|