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 AM19.1 AM19.2 AM19.4 AP00.4 AP01.1
AP13.2 AP141 AP150 AP151 AP155 AP156
AP160 AP161 AP175 AP176 AP178 AP197
AP211 AP212 AP213 AP220 AP230 AP237
AP240 AP245 AP250 AP252 AP255 AP270
AP272 AP275 AP282 AP284 AP295 AP40.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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
CB06.2 EE20.1 EE20.2 EE20.4 EE230 EE30.1
EE90.1 EE90.2 ET530 MA00.1 MA05.1 MA126
MA180 MA278 MA279 MA530 MA531 MA540
MA63.1 MA64.6 MA67.2 MA67.3 MA67.4 MA67.1
MA69.1 MA69.2 MA80.1 MA90.1 MA90.2 MA90.3
MA90.5 MA91.1 PD10.1 PD10.2 PD130 PO100
PO101 PO122 PO131 PO135 PO136 PO139
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO278 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO64.1 POI3.1 POID.1 POII.1 POIJ.1
PR277 UK277 MM280 MM80.1 MM80.2 RQ10.1
RQ10.2 TX226 WH20.2 WH20.7 PO58.2 MA167
MA236 AP236 AP235 AC160 AM115 AM117
AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.3
AM21.1 AM21.3 AM500 AM51.1 AM551 AM97.1
AP03.3 AP10.1 AP110 AP210 AP251 AP510
API3.1 API4.1 MX123 MX500 PD235 PO10.1
PO120 PO220 PO223 PO233 PO253 PO254
PO54.1 PO54.2 PO54.3 PO54.4 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
AP221
UPDATED BY
AP101 AP115 AP125 AP126 AP130 AP131
AP136 AP170 AP180 AP181 AP190 AP191
AP193 AP195 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.6 AP20.7 AP20.8 AP21.1 AP23.1
AP25.1 AP25.2 AP25.3 AP26.1 AP27.1 AP28.1
AP28.2 AP30.1 AP30.2 AP30.3 AP30.4 AP300
AP305 AP32.1 AP35.1 AP36.1 AP45.1 AP520
AP55.2 AP700 API1.1 API2.1 EE135 EE35.1
EE35.2 EE520 MA168 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA60.2 MA60.3 MA60.4 MA61.1 MA65.1
MA66.2 MA66.3 MA68.2 MA68.3 MA68.4 MA70.1
MA75.1 MAED.1 MAI1.1 PD20.1 PD20.2 PD20.3
TX101 AP198
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.3
AP300 AP32.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.3 AP300
AP32.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr 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
AP45.1 API1.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 Nbr 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
AP21.1 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.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-BATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: 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
AP21.1 AP23.1
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
API-VOUCHER-NBR Alpha 10 AP125 AP126
Element: Voucher Nbr 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
AP21.1 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 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-AUTH-CODE Alpha 3 AP125 AP126
Element: Auth Code The 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 AP21.1 AP23.1
has Yes selected in the Invoice Approval AP25.1 AP25.2
field and No in the Batch Release field. AP26.1 AP27.1
Must be a valid record in the Authority AP28.1 AP28.2
Code file. AP36.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
and payment balances will be increased. AP23.1 AP25.1
AP25.2 AP26.1
C = Credit Memo. Reduces the amount AP27.1 AP28.1
owed to the vendor. If the invoice is AP28.2 AP45.1
fully processed, the vendor's purchase AP520 API1.1
and payment balances will be decreased. API2.1 EE135
EE35.1 EE35.2
D = Debit Memo. Processed just like an EE520 MA310
invoice. Increase the vendor's purchase MA41.1 MA41.2
and payment balances. MA41.4 MA41.7
MA43.2 MA60.1
P = Prepayment. Processed just like an MA60.2 MA60.3
invoice. Used to pay a vendor for goods MA60.4 MA61.1
or services not yet received. MA63.1 MA65.1
MA67.2 MA67.3
Y = Prepayment Credit Memo. Created by MA67.4 MA68.1
AP170 (Payment Closing) to offset a MA68.2 MA68.3
prepayment and are applied to the MA68.4 MA69.1
vendor's invoice after it has been MA69.2 MA70.1
received. MA75.1
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 Payment Closing (AP170) 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.
R = Match Prepayment
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 AP21.1
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.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-PAY-CURRENCY Alpha 5 AP125 AP126
Element: To Base Curr The currency used to pay the invoice. AP180 AP181
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
AP21.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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
AP21.1 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
MA279 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-PURCH-FR-LOC Alpha 4 AP115 AP125
Element: Purch Fr Loc The purchase-from location code AP126 AP180
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 AP21.1
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.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-PO-RELEASE Numeric 4 AP125 AP126
Element: Po Release 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
AP21.1 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-BASE-INV-AMT Signed 18.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
AP21.1 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-BASE-ACT-AMT Signed 18.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 AP21.1
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.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
...
API-BASE-ND Numeric 1 AP125 AP126
Element: Base Nd The number of decimal places defined AP180 AP181
for the company base currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-TRAN-INV-AMT Signed 18.2 AP125 AP126
Element: Intl Amt 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
AP21.1 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.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1
API-TRAN-ALOW-AMT Signed 18.2 AP125 AP126
Element: Intl 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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-TRAN-TXBL-AMT Signed 18.2 AP125 AP126
Element: Intl 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
AP21.1 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-TRAN-ND Numeric 1 AP125 AP126
Element: Acct Nd The number of decimal places defined AP180 AP181
for the invoice currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-TRAN-TAX-AMT Signed 18.2 AP125 AP126
Element: Intl 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.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.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1
API-BASE-DISC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt 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
AP21.1 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
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1
API-TRAN-DISC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The discount amount of the invoice in AP170 AP180
the currency of the invoice. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 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
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1
API-BASE-TOT-PMT Signed 18.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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
...
API-TRAN-TOT-PMT Signed 18.2 AP125 AP126
Element: Intl Amt 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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
...
API-BASE-TOT-DIST Signed 18.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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
...
API-TRAN-TOT-DIST Signed 18.2 AP125 AP126
Element: Intl Amt 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
...
API-TRAN-TOT-TAX Signed 18.2 AP125 AP126
Element: Intl Amt 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-TXBL Signed 18.2 AP20.1 AP20.2
Element: Intl Amt AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP520 AP700
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-TRAN-PAID-AMT Signed 18.2 AP170 AP180
Element: Intl 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 14.7 AP125 AP126
Element: Acct 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
AP21.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-ANTICIPATION Alpha 1 AP180 AP181
Element: Anticipation 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. AP21.1 AP23.1
Y = Yes. AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
API-DISCOUNT-RT Percent 5.3 (Percent) AP125 AP126
Element: Discount Rt 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 AP21.1
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.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
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 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
Element: Split Pmt Sch Used for split payment invoices to AP190 AP20.8
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
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-RECUR-FREQ Alpha 1 AP180 AP181
Element: Recur Freq 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. AP21.1 AP23.1
M = Monthly. AP28.1 AP28.2
Q = Quarterly. AP30.1 AP45.1
S = Semiannually. AP520 API1.1
Y = Yearly. API2.1 MA41.1
Blank = Not a recurring invoice. MA41.2 MA41.4
E = End of Month MA41.7 MA43.2
API-REMIT-TO-CODE Alpha 4 AP115 AP125
Element: Remit To Code The remit-to location code associated AP126 AP180
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 AP21.1
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.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-CASH-CODE Alpha 4 AP115 AP180
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 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 AP21.1
Bank Transaction Code file. AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 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: AP21.1 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.1
MA41.2 MA41.4
MA41.7 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
AP21.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-INCOME-CODE Alpha 4 AP180 AP181
Element: 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
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
API-DIST-CODE Alpha 9 AP180 AP181
Element: Dist 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 AP21.1
the Distribution Code file. AP23.1 AP28.1
AP28.2 AP45.1
AP520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-REC-STATUS Numeric 1 AP125 AP126
Element: Rec Status The status of the invoice record. Valid AP170 AP180
values are: AP181 AP190
AP20.1 AP20.2
0 = Unreleased. Not available for AP20.3 AP20.4
payment. AP20.5 AP20.7
1 = Released. Available for payment. AP21.1 AP23.1
9 = Historical. Paid and closed. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA168
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Create 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
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.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.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
...
API-OPERATOR Alpha 10 AP125 AP126
Element: Operator The operator associated with the AP180 AP181
invoice. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-CREATION-TIME Numeric 6 (hhmmss) AP170 AP180
Element: 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
AP21.1 AP23.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
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
AP21.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
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 AP21.1
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.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
assigned to more than one invoice. AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-LAST-DIST-SEQ Numeric 6 AP125 AP126
Element: Dist Seq Nbr Used 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1 PD20.1
...
API-LAST-PMT-SEQ Numeric 4 AP170 AP180
Element: Seq Nbr Used 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
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
AP21.1 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.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
E = Electronic Data Interchange (EDI). AP23.1 AP28.1
R = Evaluated Receipts Settlement (ERS). AP28.2 AP45.1
P = Payroll AP520 API1.1
T = Tax API2.1 MA41.1
G = Garnishment MA41.2 MA41.4
L = Lease MA41.7 MA43.2
C = AR Transfer
S = Sub Contractor
X = Expense Interface
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 AP21.1
BM = Bill of Lading. AP23.1 AP28.1
IN = Invoice. AP28.2 AP45.1
OW = Service Order. AP520 API1.1
PL = Packing List. API2.1 MA41.1
PO = Purchase Order Number. MA41.2 MA41.4
VN = Vendor Order. MA41.7 MA43.2
WO = Production Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
API-APPROVED-FLAG Alpha 1 AP125 AP126
Element: Approved Flag 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 AP21.1
M = Message Exists AP23.1 AP25.1
P = Message Pending Action AP25.2 AP26.1
R = Match Prepayment AP27.1 AP28.1
AP28.2 AP30.4
AP32.1 AP36.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA168 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA60.3
MA61.1 MA66.2
MA66.3 MA68.3
MA70.1 MA75.1
MAI1.1
API-APPRV-OPERATOR Alpha 10 AP180 AP181
Element: 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
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 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
API-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Element: Jrnl Book Nbr The journal book assigned to the AP190 AP20.1
transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 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. AP21.1 AP23.1
P = Payment. AP28.1 AP28.2
G = GL Post Date AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 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
AP21.1 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.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-RECON-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Recon Date Represents the date the transaction AP136 AP180
cleared the bank or was voided. AP181 AP190
AP25.1 AP25.2
AP26.1 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.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1 AP23.1
" " = No 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.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 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
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-TERMS-CD Alpha 5 AP125 AP126
Element: Term Code Invoice payment terms code. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
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.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
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 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-RETAIL-AMT Signed 18.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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
0 = Unmatched AP23.1 AP25.1
1 = Out of tolerance AP25.2 AP26.1
2 = Matched AP27.1 AP28.1
3 = Matched out of tolerance AP28.2 AP45.1
4 = Matched in tolerance AP520 API1.1
5 = Matched with auto chargeback API2.1 MA310
6 = Approved No Receipt (MA61) MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-REASON-CODE Alpha 4 AP125 AP126
Element: 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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
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.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-MATCH-AMT Signed 18.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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-AOC-ALLOW-AMT Signed 18.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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-LOCATION Alpha 5 AP125 AP126
Element: Location 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 AP21.1
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.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
MA168 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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
AP21.1 AP23.1
AP28.1 AP28.2
AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 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 AP21.1
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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
the tax code defined for the whole AP23.1 AP25.1
invoice. AP25.2 AP26.1
AP27.1 AP28.1
If set to I (Ignore) no PO lines AP28.2 AP45.1
approved for payment will be taxed. API1.1 API2.1
0 = No Tax MA310 MA41.1
1 = Override Product Only MA41.2 MA41.4
2 = Ignore Product Only MA41.7 MA43.2
3 = Calculate MA60.1 MA60.2
4 = Overide Product and AOC MA60.3 MA60.4
5 = Ignore Product and AOC MA61.1 MA63.1
6 = ignore tax tol ovr goods tax MA65.1 MA67.2
7 = ignore tax tol ovr goods/aoc t MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAI1.1
API-MATCH-LEVEL Alpha 3 AP180 AP181
Element: 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 MA75.1
MAI1.1
API-MATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Match Date The date the invoice was matched. AP190 AP28.1
AP28.2 AP45.1
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1
API-PO-INV-TAX Signed 18.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 AP21.1
compute the invoice match amount when no AP23.1 AP25.1
tax code has been assigned to the AP25.2 AP26.1
invoice. AP27.1 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
AP23.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
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 AP21.1
AP23.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-SERVICE-AMT Signed 18.2 AP125 AP126
Element: Intl 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.6 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-BUYER Alpha 3 AP125 AP126
Element: Buyer AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-SHIP-VIA Alpha 12 (Lower Case) AP180 AP181
Element: Ship Via AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-UNLOADING-PORT Alpha 5 AP180 AP181
Element: Unloading PortThe prot where the goods are unloaded AP190 AP20.1
if required. Must be defined in IN04.1 AP20.2 AP20.3
(Port Maintenance) AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 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 AP30.1
AP30.2 AP45.1
AP520 API1.1
API-DROPSHIP-FL Alpha 1 AP125 AP126
Element: Dropship Fl 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1
API-FOB-CODE Alpha 3 AP180 AP181
Element: Fob Code The user defined Free On Board Code. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-NET-PAYABLE Derived
Element: Net Apyable The net payment amount in the currency
of the invoice.
API-JBK-SEQ-NBR Numeric 10 AP170 AP180
Element: Jbk Seq Nbr The journal book sequence number AP181 AP190
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 AP21.1
GL10.1 (Company). AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-DIVERSE-CODE Alpha 5 AP115 AP20.1
Element: Diverse Code Diversity Code for Account Payable AP20.2 AP20.3
Vendors AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-FLEX-FLAG Alpha 1 AP20.1 AP20.2
Element: Flex Flag AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
API-RULE-GROUP Alpha 10 AP125 AP126
Element: Rule Group This is the rule group entered on the AP180 AP181
AP20 invoice entry screen. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
MA41.7 MA43.2
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
API-FLOAT-DAYS Numeric 3
Element: Float Days This is a number of days to add to best
terms calculation if the vendor will
allow a specific number of days for
payment to reach them and still receive
the discount.
API-MTCH-PREPAY-FL Alpha 1 AP20.1 AP20.2
Element: Mtch Prepay FlFlag that notes if the invoice will be AP20.3 AP20.4
prepaid. This is for match invoices. AP20.5 AP20.7
AP21.1 AP23.1
" " = Blank MA41.1 MA41.2
1 = Yes MA41.4 MA41.7
2 = No MA43.2
API-MTCH-PREPAY-MT Numeric 1 AP20.1 AP20.2
Element: Mtch Prepay MtFlag denotes the method of match AP20.3 AP20.4
prepayment. AP20.5 AP20.7
AP21.1 AP23.1
0 = No MA41.1 MA41.2
1 = Prepay from Invoice MA41.4 MA41.7
2 = Eligible for Prepayment MA43.2
API-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
API-PRPY-DISC-CODE Alpha 10
Element: Prpy Disc Code
API-PRPY-REF-NBR Alpha 22
Element: Prpy Ref Nbr
API-PRPY-RTL-AMT Signed 18.2
Element: Intl Amt
API-PRPY-AMT Signed 18.2
Element: Intl Amt
API-PRPY-AOC-AMT Signed 18.2
Element: Intl Amt
API-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt
API-PRPY-SERV-AMT Signed 18.2
Element: Intl Amt
API-COCO-FL Numeric 1 AP20.1 AP20.2
Element: Coco Fl This is the flag when added to the AP20.3 AP20.4
handling code denotes that the invoice AP20.5 AP20.7
will be reviewed for match based on AP21.1 AP23.1
header, line, and Cost components (AOC) API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
API-MATCH-AOC Signed 18.2 AP20.1 AP20.2
Element: Intl Amt This is the amount of the AOC that has AP20.3 AP20.4
been matched. AP20.5 AP20.7
AP21.1 AP23.1
AP30.2 API1.1
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
API-HASH-QTY Signed 15.4 AP20.1 AP20.2
Element: Hash Qty This is the total qty of the goods on AP20.3 AP20.4
the invoice. This field will be used to AP20.5 AP20.7
match on quantity. AP21.1 AP23.1
API1.1 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4
API-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor This is a vendor that is supported on a
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
API-MTCH-ERR-TYPE Numeric 2 AP125 AP126
Element: Mtch Err Type This is the reason the match was not AP20.1 AP20.2
successful for Invoice Match. AP20.3 AP20.4
01 = Match Invoice AP20.5 AP20.7
02 = Cost error AP21.1 AP23.1
03 = No receipt information AP25.1 AP25.2
04 = Hash quantity error AP26.1 AP27.1
05 = No AOC on purchase order API1.1 MA310
06 = No AOC cost MA41.1 MA41.2
07 = Tax out of balance MA41.4 MA41.7
MA43.2 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.2 MA67.3
MA67.4 MA68.1
MA68.2 MA68.3
MA68.4 MA69.1
MA69.2 MA70.1
MA75.1 MAED.1
MAI1.1
API-BT-AMT Signed 18.2
Element: Intl Amt This is the amount of the discount based
on best terms
API-DISC-POINT Numeric 1 AP20.1 AP20.2
Element: Disc Point This is the flag that will note if the AP20.3 AP20.4
discounts will be applied to the cost of AP20.5 AP20.7
the goods or the cost of the goods and AP21.1 AP23.1
the AOC. API2.1 MA41.1
1 = Cost of goods MA41.2 MA41.4
2 = Cost of Goods and AOC MA41.7 MA43.2
API-TAX-FLAG Alpha 1 TX101
Element: All Flag " " = Not interfaced
I = Interfaced
API-TAX-OUT-BAL Derived
Element: Tax Out Bal The amount of the invoice that is
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
Element: Pmt Out Bal The amount of the invoice that is
out-of-balance due to payment
applications made for the invoice.
API-DIST-OUT-BAL Derived
Element: Dist Out Bal The amount of the invoice that is
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: Inv Status Indicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
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-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl
API-ORIGIN-COUNTRY Alpha 2
Element: Origin CountryThe country from which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance)
API-ORIGIN-REGION Alpha 2
Element: Origin Region The region of the country from which the
goods were shipped, if required. Must be
a valid region in IN02.1 (Region
Maintenance)
API-DEST-COUNTRY Alpha 2
Element: Dest Country The country to which the goods were
shipped. Must be a valid country in
IN01.1 (Country Maintenance).
API-DEST-REGION Alpha 2
Element: Dest Region The region of the country to which the
goods were shipped, if required. Must
be a valid region in IN02.1 (Region
Maintenance)
API-TRANSPORT-MODE Alpha 1
Element: Transport ModeThe mode of transportation at the
border crossing. Code 7 is used for the
Channel Tunnel.
API-STATEMENT Alpha 22 API1.1
Element: Invoice Used to identify the invoice.
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY AM19.1 AM19.2
VENDOR AM19.4 AP00.4
INVOICE AP01.1 AP101
SUFFIX AP115 AP125
CANCEL-SEQ AP126 AP13.2
AP131 AP136
AP141 AP150
AP151 AP155
AP156 AP160
AP161 AP170
AP175 AP176
AP178 AP180
AP181 AP190
AP191 AP193
AP195 AP197
...
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.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MAI1.1
APISET13 COMPANY KeyChange AP125 AP126
VENDOR AP131 AP136
MATCH-OBJ-ID AP25.1 AP25.2
INVOICE AP26.1 AP27.1
SUFFIX API1.1 MA310
CANCEL-SEQ MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
MA90.2 MA90.3
...
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 MA167
CANCEL-SEQ Or (REC-STATUS = 1 )) MA168 MA236
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
...
APISET2 COMPANY KeyChange, Subset AP00.4 AP125
BATCH-NUM Where REC-STATUS = Zeroes AP126 AP195
AUTH-CODE AP220 AP25.1
VOUCHER-NBR AP25.2 AP25.3
VENDOR AP26.1 AP27.1
INVOICE
SUFFIX
CANCEL-SEQ
APISET3 REC-STATUS KeyChange AP136 AP193
COMPANY AP195 AP198
BATCH-NUM AP20.1 AP20.2
AUTH-CODE AP20.3 AP20.4
OPERATOR AP20.5 AP20.6
CREATE-DATE AP20.7 AP21.1
CREATION-TIME AP23.1 AP236
VENDOR AP25.2 AP300
INVOICE AP36.1 AP700
SUFFIX MA41.1 MA41.2
CANCEL-SEQ MA41.4 MA41.7
MA43.2
APISET4 COMPANY KeyChange AP00.4 AP20.1
VOUCHER-NBR AP20.2 AP20.3
REC-STATUS AP20.4 AP20.5
VENDOR AP20.6 AP20.7
INVOICE AP21.1 AP23.1
SUFFIX AP235 AP30.1
CANCEL-SEQ AP520 AP90.3
API1.1 API2.1
AR48.3 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
TX101
APISET5 VENDOR-GROUP KeyChange AC160 AM115
VENDOR AM117 AM15.1
INVOICE AM15.2 AM15.3
SUFFIX AM15.4 AM19.1
CANCEL-SEQ AM19.2 AM20.1
COMPANY AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
APISET6 COMPANY KeyChange AP221 AP251
VENDOR AP300 AP90.2
INVOICE-DTE* MA126
INVOICE
SUFFIX
CANCEL-SEQ
APISET7 COMPANY KeyChange, Subset AP125 AP126
REC-STATUS Where TRAN-TOT-DIST != TRAN-INV-AMT AP240 AP25.1
BATCH-NUM Or TRAN-TOT-PMT != TRAN-INV-AMT AP25.2 AP26.1
VENDOR Or BASE-TOT-PMT != BASE-INV-AMT AP27.1
INVOICE Or TRAN-TOT-TAX != TRAN-TAX-AMT
SUFFIX
CANCEL-SEQ
APISET8 COMPANY KeyChange, Subset AP125 AP126
DUE-DATE Where((MATCH-STATUS = Zeroes ) AP25.1 AP25.2
VENDOR Or (MATCH-STATUS = 1 )) AP252 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.2
MA67.3 MA67.4
MA68.1 MA68.2
MA68.3 MA68.4
MA69.1 MA69.2
MA70.1 MA75.1
APISET9 COMPANY KeyChange AP125 AP126
VENDOR AP131 AP141
PO-NUMBER AP20.1 AP20.2
PO-RELEASE AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
LOCATION AP21.1 AP23.1
INVOICE AP25.1 AP25.2
SUFFIX AP26.1 AP27.1
CANCEL-SEQ AP30.4 AP90.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
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
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
"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
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
"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
Mainvhand MAINVHAND Required
API-COMPANY -> MAH-COMPANY
API-HANDLING-CODE -> MAH-HANDLING-CODE
Mamtchrule MAMTCHRULE Required
API-RULE-GROUP -> MAU-MATCH-RULE
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
Apvendiv APVENDIV
API-VENDOR-GROUP -> VDC-VENDOR-GROUP
API-VENDOR -> VDC-VENDOR
API-LOCATION -> VDC-LOCATION-CODE
VDC-DIVERSE-CODE
VDC-DCERT-DATE
Maaocdtl MAAOCDTL
API-COMPANY -> MAA-COMPANY
API-VENDOR -> MAA-VENDOR
API-INVOICE -> MAA-INVOICE
API-SUFFIX -> MAA-SUFFIX
API-PO-NUMBER -> MAA-PO-NUMBER
API-PO-RELEASE -> MAA-PO-RELEASE
API-PO-CODE -> MAA-PO-CODE
MAA-LINE-NBR
MAA-AOC-CODE
MAA-SEQ-NBR
Maaocdtl 2 MAAOCDTL
API-COMPANY -> MAA-COMPANY
API-VENDOR -> MAA-VENDOR
API-INVOICE -> MAA-INVOICE
API-SUFFIX -> MAA-SUFFIX
MAA-PO-NUMBER
MAA-PO-RELEASE
MAA-PO-CODE
MAA-LINE-NBR
MAA-AOC-CODE
MAA-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-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-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
Pomatchobj POMATCHOBJ
API-COMPANY -> PMJ-COMPANY
API-MATCH-OBJ-ID -> PMJ-MATCH-OBJ-ID
PMJ-MATCH-SEQ-NBR
PMJ-REC-NUMBER
PMJ-LINE-NBR
PMJ-AOC-CODE
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
|