Lawson Insight Technical Documentation |
|
APINVOICE
APINVOICE FILE
Accounts Payable Invoice
The Accounts Payable Invoice file contains accounts payable invoice records.
Each record has one or more associated records in the Invoice Payment File.
REFERENCED BY
POA3.1 AP00.4 AP00.5 AP01.1 AP13.2 AP141
AP150 AP151 AP155 AP156 AP160 AP161
AP175 AP176 AP197 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 IC28.1 MA00.1
MA05.1 MA126 MA180 MA278 MA530 MA531
MA540 MA63.1 MA64.6 MA67.1 MA67.2 MA68.1
MA80.1 MAED.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PO100 PO101
PO122 PO131 PO135 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 UK277 RQ10.1 RQ10.2
WH20.2 WH20.7 PO58.2 MA236 AP236 AP235
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP10.1 AP251 API3.1 API4.1
IC840 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1
UPDATED BY
AP101 AP115 AP125 AP126 AP130 AP131
AP170 AP180 AP181 AP190 AP191 AP193
AP195 AP198 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 AP35.1
AP36.1 AP45.1 AP520 AP55.2 AP700 API1.1
API2.1 EE135 EE35.1 EE35.2 EE520 MA310
MA60.2 MA60.3 MA60.4 MA61.1 MA65.1 MA66.2
MA66.3 MA70.1 MA75.1 MAI1.1 TX101
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. 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The invoiced vendor number. Must be a AP126 AP150
valid record in the Vendor file. AP180 AP181
AP190 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberThe invoice number. Must be a unique AP126 AP150
invoice number for the vendor. AP180 AP181
AP190 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe invoice suffix number. Represents AP150 AP170
the occurrence value of the invoice. AP180 AP181
Used to identify the recurrence value of AP190 AP193
a recurring invoice and for AP25.1 AP25.2
system-generated credit memos created AP26.1 AP27.1
for prepayments and employee advances. AP28.1 AP28.2
AP30.2 AP30.3
AP300 AP32.1
AP45.1 AP520
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeThe sequence number assigned upon the AP150 AP180
cancellation of a distributed invoice. AP181 AP190
The first sequence assigned is 9999. 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.1
MA67.2 MA68.1
MA70.1 MA75.1
API-CANCEL-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Cancel Date The cancellation date assigned to a AP190 AP26.1
canceled invoice. AP27.1 AP28.1
AP28.2 AP30.4
AP45.1 MA70.1
MA75.1
API-BATCH-NUM Numeric 6 AP125 AP126
Element: Batch Number The batch number associated with the AP180 AP181
invoice. Used only if the company has AP190 AP25.1
Yes selected in the Batch Release Option AP25.2 AP25.3
field. AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-BATCH-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Batch Date The batch date assigned to the batch AP190 AP26.1
number. Must be a valid record in the AP27.1 AP28.1
Batch file. AP28.2 AP45.1
AP520 API1.1
API2.1
API-VOUCHER-NBR Alpha 10 AP125 AP126
Element: Voucher The voucher number assigned to the AP180 AP181
invoice. Used only if the company has AP190 AP25.1
Yes selected in the Invoice Registration AP25.2 AP26.1
Option field. AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-AUTH-CODE Alpha 3 AP125 AP126
Element: Authority CodeThe authority code assigned to the AP180 AP181
invoice. Represents the person or AP190 AP25.1
department responsible for approving a AP25.2 AP26.1
registered invoice and is required AP27.1 AP28.1
before a registered invoice can be AP28.2 AP36.1
released. Used only by a company that AP45.1 AP520
has Yes selected in the Invoice Approval API1.1 API2.1
field and No in the Batch Release field. EE135 EE35.1
Must be a valid record in the Authority EE35.2 EE520
Code file. MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-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 AP25.1
Accounts Payable Process Level file. 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-ACCR-CODE Alpha 4 AP125 AP126
Element: Invoice AccruaThe invoice accrual code assigned to AP180 AP181
the invoice. Used to default a general AP190 AP25.1
ledger accrual account to the invoice. AP25.2 AP26.1
Must be a valid record in the Invoice AP27.1 AP28.1
Accrual Code file. AP28.2 AP30.1
AP32.1 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 MA75.1
API-INVOICE-TYPE Alpha 1 AP125 AP126
Element: Invoice Type Identifies the type of invoice. Valid AP170 AP180
values are: AP181 AP190
AP25.1 AP25.2
Blank = Invoice. Increases the amount AP26.1 AP27.1
owed to the vendor. If the invoice is AP28.1 AP28.2
fully processed, the vendor's purchase AP45.1 AP520
and payment balances will be increased. API1.1 API2.1
EE135 EE35.1
C = Credit Memo. Reduces the amount EE35.2 EE520
owed to the vendor. If the invoice is MA310 MA60.1
fully processed, the vendor's purchase MA60.2 MA60.3
and payment balances will be decreased. MA60.4 MA61.1
MA63.1 MA65.1
D = Debit Memo. Processed just like an MA67.1 MA67.2
invoice. Increase the vendor's purchase MA68.1 MA70.1
and payment balances. MA75.1
P = Prepayment. Processed just like an
invoice. Used to pay a vendor for goods
or services not yet received.
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.
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 AP25.1
If left blank, the vendor currency AP25.2 AP26.1
defaults. AP27.1 AP28.1
AP28.2 AP30.3
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
MA75.1
API-PAY-CURRENCY Alpha 5 AP125 AP126
To Company Base The currency used to pay the invoice. AP180 AP181
Currency Must be a valid record in the Currency AP190 AP25.1
Code file. 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 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 AP25.1
defaults. 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 MA75.1
API-PURCH-FR-LOC Alpha 4 AP115 AP125
Purchase From The purchase-from location code AP126 AP180
Location Code associated with the invoice. Must be a AP181 AP190
valid record in the Vendor Location AP25.1 AP25.2
file. AP26.1 AP27.1
AP28.1 AP28.2
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP180 AP181
representing the purchase order. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumThe purchase order release number AP180 AP181
associated with the invoice. Used to AP190 AP25.1
identify a purchase order release AP25.2 AP26.1
created from a blanket or standing AP27.1 AP28.1
order. AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-PO-CODE Alpha 4 AP125 AP126
Element: Purchase OrderPurchase order number code. Used to AP180 AP181
keep purchase orders unique. Can be used AP190 AP25.1
for reporting purposes. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-DESCRIPTION Alpha 30 (Lower Case) AP180 AP181
Element: Description The invoice description. AP190 AP28.1
AP28.2 AP30.1
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
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 AP25.1
exchange rate in effect when the invoice AP25.2 AP26.1
was created or entered. AP27.1 AP28.1
AP28.2 AP30.1
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
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 AP25.1 AP25.2
place. AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 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 MA75.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 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 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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-TRAN-ALOW-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The amount of the invoice available for AP180 AP181
discount in the currency of the invoice. AP190 AP25.1
Used to calculate the discount amount AP25.2 AP26.1
based on the discount rate. If left AP27.1 AP28.1
blank, the invoice amount defaults. AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-ND Numeric 1 AP125 AP126
Account Currency The number of decimal places defined AP180 AP181
Code for the invoice currency. AP190 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 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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BASE-DISC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The discount amount of the invoice in AP170 AP180
the company base currency. AP181 AP190
AP191 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.1 AP30.3
AP45.1 AP520
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-DISC-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The discount amount of the invoice in AP180 AP181
the currency of the invoice. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.3 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-TRAN-TOT-PMT Signed 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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BASE-TOT-DIST Signed 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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-DIST Signed 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 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-TAX Signed 18.2 AP125 AP126
Element: Intl Amt The total tax amount of the invoice in AP180 AP181
the currency of the invoice. AP190 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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-TRAN-TOT-TXBL Signed 18.2 AP520 AP700
Element: Intl Amt The total taxable amount for the invoice API1.1
distributions in currency of invoice.
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: Account Rate The currency exchange rate used to AP170 AP180
convert the invoice amount to the AP181 AP190
company base currency. This field may be AP193 AP25.1
updated if the invoice is revalued to AP25.2 AP26.1
account for exchange rate fluctuations. 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 MA75.1
API-ANTICIPATION Alpha 1 AP180 AP181
Element: Anticipation FIndicates whether anticipation criteria AP190 AP28.1
will be used to calculate the discount AP28.2 AP45.1
amount of the invoice. Valid values are: AP520 API1.1
API2.1 EE135
N = No. EE35.1 EE35.2
Y = Yes. EE520
API-DISCOUNT-RT Percent 5.3 (Percent) AP125 AP126
Element: Discount Rate The discount rate used to calculate the AP180 AP181
discount amount of the invoice. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.1
AP30.3 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-NBR-SPLIT-PMT Numeric 3 AP180 AP181
Element: Nbr Of Invcs Used for split payment invoices to AP190 AP28.1
indicate the total number of payments to AP28.2 AP30.3
be made for the invoice. AP45.1
API-SPLIT-PMT-SCH Alpha 1 AP180 AP181
Split Payment Used for split payment invoices to AP190 AP28.1
Schedule indicate the frequency of payments to be AP28.2 AP30.3
made for the invoice. The invoice, due, 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 AP28.1 AP28.2
recur. AP30.1 AP45.1
AP520 API1.1
API2.1
API-RECUR-FREQ Alpha 1 AP180 AP181
Element: Recurring FreqUsed for recurring invoices to indicate AP190 AP193
how often the invoice should recur. AP28.1 AP28.2
Valid values are: AP30.1 AP45.1
AP520 API1.1
W = Weekly. API2.1
M = Monthly.
Q = Quarterly.
S = Semiannually.
Y = Yearly.
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 AP28.1 AP28.2
in the Vendor Location file. AP30.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
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 AP28.1 AP28.2
is to be paid from. Must be a valid AP45.1 AP520
record in the Cash Code file. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
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 AP28.1 AP28.2
payment or bill of exchange payment used AP45.1 AP520
to pay the invoice. Must be a valid cash API1.1 API2.1
payment transaction code record in the EE135 EE35.1
Bank Transaction Code file. EE35.2 EE520
API-CURR-RECALC Alpha 1 AP180 AP181
Currency Used for non-base currency invoices to AP190 AP28.1
Recalculation indicate whether the invoice will be AP28.2 AP45.1
revalued when it is scheduled for AP520 AP55.2
payment to account for currency exchange API1.1 API2.1
rate fluctuations. Valid values are: EE135 EE35.1
EE35.2 EE520
N = No.
Y = Yes.
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 AP25.1
invoice tax information. Must be a valid AP25.2 AP26.1
record in the Tax Code file. 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 MA75.1
API-INCOME-CODE Alpha 4 AP180 AP181
Element: Income Code The income code associated with the AP190 AP28.1
invoice. Used to track vendor income for AP28.2 AP45.1
the invoice. Must be a valid record in AP520 API1.1
the Income Code file. API2.1
API-DIST-CODE Alpha 9 AP180 AP181
Element: Distribution CThe distribution code assigned to the AP190 AP28.1
invoice. Used during invoice entry to AP28.2 AP45.1
automatically create distributions for AP520
the invoice. Must be a valid record in
the Distribution Code file.
API-REC-STATUS Numeric 1 AP125 AP126
Element: Record Status The status of the invoice record. Valid AP170 AP180
values are: AP181 AP190
AP25.1 AP25.2
0 = Unreleased. Not available for AP26.1 AP27.1
payment. AP28.1 AP28.2
1 = Released. Available for payment. AP30.4 AP45.1
9 = Historical. Paid and closed. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1 MAI1.1
API-CREATE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Creation Date The date the invoice was created in the AP181 AP190
Lawson Accounts Payable system. AP193 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
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
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
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-OPERATOR Alpha 10 AP125 AP126
Element: Operator Code The operator associated with the AP180 AP181
invoice. AP190 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 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 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
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 AP25.1
Vendor Group file. 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 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 AP28.1 AP28.2
payment for the invoice. Must be a valid AP30.1 AP45.1
record in the Vendor file. AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
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. AP25.1 AP25.2
Must be a valid record in the Pay Group AP26.1 AP27.1
file. AP28.1 AP28.2
AP30.1 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 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 AP28.1 AP28.2
user-defined character expression that AP45.1 AP520
can be used to select invoices for API1.1 API2.1
payment. The same invoice group can be EE135 EE35.1
assigned to more than one invoice. EE35.2 EE520
API-LAST-DIST-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeUsed by the system to track the number AP170 AP180
of the last distribution line created AP181 AP190
for the invoice. AP191 AP193
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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-LAST-PMT-SEQ Numeric 4 AP170 AP180
Element: Sequence NumbeUsed by the system to track the last AP181 AP190
payment record number used for the AP193 AP28.1
invoice. AP28.2 AP30.3
AP35.1 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-DISCOUNT-CODE Alpha 10 AP125 AP126
Element: Discount Code The discount code assigned to the AP180 AP181
invoice. Represents a general ledger AP190 AP25.1
discount account. Must be a valid record AP25.2 AP26.1
in the Discount Code file. AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-INVOICE-SOURCE Alpha 1 AP180 AP181
Element: Invoice SourceIndicates the source for creation of AP190 AP28.1
the invoice. Valid values are: AP28.2 AP45.1
AP520 API1.1
Blank = Manual entry. API2.1
E = Electronic Data Interchange (EDI).
R = Evaluated Receipts Settlement (ERS).
P = Payroll
T = Tax
G = Garnishment
L = Lease
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 AP28.1
Type is providing to reference the invoice. AP28.2 AP45.1
Valid values are: AP520 API1.1
API2.1
BM = Bill of Lading.
IN = Invoice.
OW = Service Order.
PL = Packing List.
PO = Purchase Order Number.
VN = Vendor Order.
WO = Work Order.
WP = Warehouse Pick Ticket.
ZZ = Mutually Defined.
API-APPROVED-FLAG Alpha 1 AP125 AP126
Element: Approved Indicates whether the invoice is AP170 AP180
approved for payment. Valid values are: AP181 AP190
AP25.1 AP25.2
Y = Yes. AP26.1 AP27.1
N = No. AP28.1 AP28.2
D = Disapproved AP32.1 AP36.1
M = Message Exists AP45.1 AP520
P = Message Pending Action API1.1 API2.1
R = Match Prepayment EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.3 MA60.4
MA61.1 MA65.1
MA66.2 MA66.3
MA70.1 MA75.1
MAI1.1
API-APPRV-OPERATOR Alpha 10 AP180 AP181
Element: Operator Code 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 AP28.1
invoice were returned, this field AP28.2 AP45.1
contains the optional return number API1.1 API2.1
assigned to the return.
API-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Element: Journal Book The journal book assigned to the AP190 AP28.1
transaction. AP28.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-TAX-POINT Alpha 1 AP180 AP181
Element: Tax Point Indicates when the tax amount is AP190 AP28.1
calculated for the invoice, if AP28.2 AP30.2
applicable. Valid values are: AP45.1 AP520
API1.1 API2.1
I = Invoice.
P = Payment.
G = GL Post Date
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 AP25.1
Detail records that are associated with AP25.2 AP26.1
the invoice. Also used for Drill Around AP27.1 AP28.1
purposes. AP28.2 AP32.1
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
MA75.1
API-RECON-DATE Numeric 8 (yyyymmdd) AP125 AP126
Reconciliation or Represents the date the transaction AP180 AP181
Void Date cleared the bank or was voided. AP190 AP25.1
AP25.2 AP26.1
AP260 AP27.1
AP28.1 AP28.2
AP45.1 API1.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-POD-PRINTED Numeric 1 AP125 AP126
Proof of Delivery Indicates is a proof of delivery has AP130 AP180
Printed been printed for this invoice. AP181 AP190
AP25.1 AP25.2
Valid values are: AP26.1 AP27.1
AP28.1 AP28.2
Y = Yes AP45.1 AP520
" " = No API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-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 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-MATCH-FL Alpha 1 AP125 AP126
Element: Match Invoice Indicates if the invoice is a match AP180 AP181
invoice. AP190 AP25.1
A = AOC Invoice AP25.2 AP26.1
Y = PO Invoice AP27.1 AP28.1
N = Exp Invoice 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 MA75.1
API-TERMS-CD Alpha 5 AP125 AP126
Element: Terms Code Invoice payment terms code. AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 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 MA75.1
API-RETAIL-AMT Signed 18.2 AP125 AP126
Element: Retail Amount The retail amount of the item. AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-MATCH-STATUS Numeric 1 AP125 AP126
Element: Match Status Indicates the match status of the AP180 AP181
invoice. AP190 AP25.1
AP25.2 AP26.1
Valid values are: AP27.1 AP28.1
AP28.2 AP45.1
0 = Unmatched AP520 API1.1
1 = Out of tolerance API2.1 MA310
2 = Matched MA60.1 MA60.2
3 = Matched out of tolerance MA60.3 MA60.4
4 = Matched in tolerance MA61.1 MA63.1
5 = Matched with auto chargeback MA65.1 MA66.2
6 = Approved No Receipt (MA61) MA66.3 MA67.1
MA67.2 MA68.1
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 AP25.1
memos. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 AP25.1
for invoice matching. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-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 AP25.1
to a receipt. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-AOC-ALLOW-AMT Signed 18.2 AP125 AP126
Element: Add On Cost AmAdd on cost amount. AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP180 AP181
location within the company inventory. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-MATCH-OBJ-ID Numeric 12 AP125 AP126
Element: Match Object IA system generated matching object AP180 AP181
identifier. AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA66.2 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-CBPRINT-FL Alpha 1 AP131 AP180
Element: Print ChargebaIndicates whether to print chargebacks. AP181 AP190
N = No AP28.1 AP28.2
Y = Yes AP30.1 AP45.1
" " = spaces AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
API-MATCH-TABLE Alpha 10 AP125 AP126
Element: Match Table Match table. Contains matching and AP180 AP181
match processing rules. AP190 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 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 AP25.1
AP25.2 AP26.1
For PO Invoices, if set to O (Override) AP27.1 AP28.1
all lines approved for payment will use AP28.2 AP45.1
the tax code defined for the whole API1.1 API2.1
invoice. MA310 MA60.1
MA60.2 MA60.3
If set to I (Ignore) no PO lines MA60.4 MA61.1
approved for payment will be taxed. MA63.1 MA65.1
0 = No Tax MA67.1 MA67.2
1 = Override Product Only MA68.1 MA70.1
2 = Ignore Product Only MA75.1
3 = Calculate
4 = Overide Product and AOC
5 = Ignore Product and AOC
6 = ignore tax tol ovr goods tax
7 = ignore tax tol ovr goods/aoc t
API-LAST-MATCH-LN Numeric 4 AP125 AP126
Element: Last Match LinLast matched line number. AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
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 AP25.1
add on costs and taxable purchase order AP25.2 AP26.1
receipt lines assigned to the invoice. AP27.1 AP28.1
The resulting value is then used to AP28.2 AP45.1
compute the invoice match amount when no API1.1 MA310
tax code has been assigned to the MA60.1 MA60.2
invoice. MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
MAI1.1
API-BYPASS-MATCH Alpha 1 AP125 AP126
Element: All Flag AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-SERVICE-FL Alpha 1 AP125 AP126
Element: Service Fl This field indicates a transaction is a AP180 AP181
Service only transaction. AP190 AP25.1
Y = Yes AP25.2 AP26.1
N = No AP27.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-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 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-BUYER Alpha 3 AP125 AP126
Element: Buyer AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-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 AP28.1
be a valid code defined in IN07.1 (NOTC AP28.2 AP45.1
Maintenance). API1.1
API-STAT-PROC Alpha 6 AP180 AP181
Element: Stat Proc The statistical procedure code applied AP190 AP28.1
to the data. The code must be defined AP28.2 AP45.1
in IN06.1. (Statistical Procedure API1.1
Maintenance).
API-SHIP-VIA Alpha 12 (Lower Case) AP180 AP181
Element: Ship Via Description AP190 AP28.1
AP28.2 AP45.1
API1.1
API-UNLOADING-PORT Alpha 5 AP180 AP181
Element: Unloading PortThe prot where the goods are unloaded if AP190 AP28.1
required. Must be defined in IN04.1 AP28.2 AP45.1
(Port Maintenance) API1.1
API-INTRASTAT-NBR Numeric 12 AP125 AP126
Element: Intrastat Nbr The number assigned by the Intrastat AP180 AP181
system to a transaction that involves AP190 AP25.1
Intrastat reporting after it has been AP25.2 AP26.1
added. AP27.1 AP28.1
AP28.2 AP45.1
API1.1
API-DROPSHIP-FL Alpha 1 AP125 AP126
Element: Dropship Flag This flag indicates whether goods being AP180 AP181
shipped by the vendor directly to a non AP190 AP25.1
standard location need to have the AP25.2 AP26.1
receiving process performed. AP27.1 AP28.1
AP28.2 AP45.1
API1.1 MA310
MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
API-FOB-CODE Alpha 3 AP180 AP181
Element: Shipping Term The user defined Free On Board Code. AP190 AP28.1
AP28.2 AP45.1
API1.1
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
Journal Book The journal book sequence number AP181 AP190
Sequence Number assigned to a journal book transaction AP193 AP28.1
when it is added or interfaced to the AP28.2 AP45.1
Lawson system. Used only when Auto AP520 API1.1
Journal Book Seq Nbr is set to Yes in API2.1 EE135
GL10.1 (Company). EE35.1 EE35.2
EE520
API-DIVERSE-CODE Alpha 5 AP115 AP520
Element: Diverse Code Diversity Code for Account Payable API1.1
Vendors
API-FLEX-FLAG Alpha 1 AP520
Element: Flex Deduction
API-RULE-GROUP Alpha 10 AP125 AP126
Element: Rule Group AP180 AP181
AP190 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP45.1
API1.1 API2.1
MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.1
API-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
Element: Mtch Prepay FlFlag that notes if the invoice will be
prepaid. This is for match invocies.
" " = Blank
1 = Yes
2 = No
API-MTCH-PREPAY-MT Numeric 1
Element: Mtch Prepay MtFlag denotes the method of match
prepayment.
0 = No
1 = Prepay from Invoice
2 = Eligible for Prepayment
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
Element: Coco Fl This is the flag when added to the
handling code denotes that the invoice
will be reviewed for match based on
header, line, and Cost components (AOC)
API-MATCH-AOC Signed 18.2
Element: Intl Amt This is the amount of the AOC that has
been matched.
API-HASH-QTY Signed 15.4
Element: Hash Qty This is the total qty of the goods on
the invoice. This field will be used to
match on qty.
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
Element: Mtch Err Type This is the reason the match was not
successful for Invoice Match.
01 = Match Invoice
02 = Cost error
03 = No receipt information
04 = Hash quantity error
05 = No AOC on purchase order
06 = No AOC cost
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 API2.1
Element: Disc Point This is the flag that will note if the
discounts will be applied to the cost of
the goods or the cost of the goods and
the AOC.
1 = Cost of goods
2 = Cost of Goods and AOC
API-TAX-FLAG Alpha 1 TX101
Element: All Flag " " = Not interfaced
I = Interfaced
API-TAX-OUT-BAL Derived
Tax Out of Balance The amount of the invoice that is
Amount out-of-balance due to tax applications
made for the invoice.
API-TXB-OUT-BAL Derived
Element: Txb Out Bal Derived field to show difference between
header taxable input and total taxable
amount from distributions.
API-PMT-OUT-BAL Derived
Payment Out Of The amount of the invoice that is
Balance Amount out-of-balance due to payment
applications made for the invoice.
API-DIST-OUT-BAL Derived
Distrib. Out Of The amount of the invoice that is
Balance Amount out-of-balance due to expense
distribution applications made for the
invoice.
API-OUT-BAL-FLAG Derived
Out of Balance Indicates whether the invoice is
Indicator out-of-balance. Valid values are:
N = No.
Y = Yes.
API-INV-STATUS Derived
Element: Invoice StatusIndicates the status of the invoice.
Valid values are:
Unreleased.
Released.
Historical.
API-REV-SIGN-AMT Derived
Reversed Signed The invoice amount * -1.
Amount
API-TYPE-SHORT-NME Derived
Short Invoice Type The translation of the invoice type.
Name
API-PO-RELEASE-3 Derived
Purchase Order The purchase order release number
Release Number associated with the invoice. Used to
identify a purchase order release
created from a blanket or standing
order.
APINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APISET1 COMPANY This index is used to access invoice AP00.4 AP00.5
VENDOR records for a specific vendor and AP01.1 AP101
INVOICE company. AP115 AP125
SUFFIX AP126 AP13.2
CANCEL-SEQ AP131 AP141
AP150 AP151
AP155 AP156
AP160 AP161
AP170 AP175
AP176 AP180
AP181 AP190
AP191 AP193
AP195 AP197
AP198 AP212
AP213 AP220
...
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 MA75.1
MAI1.1
APISET13 COMPANY KeyChange AP125 AP126
VENDOR AP131 AP25.1
MATCH-OBJ-ID AP25.2 AP26.1
INVOICE AP27.1 AP30.4
SUFFIX API1.1 MA310
CANCEL-SEQ MA60.1 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
PO58.2
APISET14 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where((MATCH-STATUS = Zeroes ) AP130 AP25.1
DUE-DATE Or (MATCH-STATUS = 1 )) AP25.2 AP26.1
INVOICE And (MATCH-FL = "Y" ) AP27.1 API1.1
SUFFIX And ((REC-STATUS = Zeroes ) MA126 MA236
CANCEL-SEQ Or (REC-STATUS = 1 )) MA310 MA60.1
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA65.1
MA67.1 MA67.2
MA68.1 MA70.1
MA75.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 AP236
BATCH-NUM authority code in entry order. AP25.2 AP300
AUTH-CODE KeyChange AP36.1 AP700
OPERATOR
CREATE-DATE
CREATION-TIME
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
APISET4 COMPANY This index is used to access invoice AP00.4 AP235
VOUCHER-NBR records for a specific voucher number. AP260 AP30.1
REC-STATUS KeyChange AP520 AP90.3
VENDOR API1.1 API2.1
INVOICE AR48.3 TX101
SUFFIX
CANCEL-SEQ
APISET5 VENDOR-GROUP This index is used to access invoice AM115 AM117
VENDOR records not on hold for a specific hold AM15.1 AM15.2
INVOICE code. AM15.3 AM15.4
SUFFIX KeyChange AM20.1 AM20.3
CANCEL-SEQ AM21.1 AM21.3
COMPANY AM500 AM51.1
AM551 AM97.1
AP10.1 AP115
AP251 AP295
AP91.1 AP92.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APISET6 COMPANY This index is used to access invoice AP251 AP300
VENDOR records for a specific vendor in invoice AP90.2
INVOICE-DTE* date sequence.
INVOICE KeyChange
SUFFIX
CANCEL-SEQ
APISET7 COMPANY This index is used to access invoice AP125 AP126
REC-STATUS records that are out of balance. AP240 AP25.1
BATCH-NUM KeyChange, Subset AP25.2 AP26.1
VENDOR Where TRAN-TOT-DIST != TRAN-INV-AMT AP27.1
INVOICE Or TRAN-TOT-PMT != TRAN-INV-AMT
SUFFIX Or BASE-TOT-PMT != BASE-INV-AMT
CANCEL-SEQ Or TRAN-TOT-TAX != TRAN-TAX-AMT
APISET8 COMPANY This index is used to access invoices AP125 AP126
DUE-DATE for a specific vendor in descending AP25.1 AP25.2
VENDOR invoice date sequence. AP252 AP26.1
INVOICE KeyChange, Subset AP27.1 API1.1
SUFFIX Where((MATCH-STATUS = Zeroes ) MA126 MA310
CANCEL-SEQ Or (MATCH-STATUS = 1 )) MA60.1 MA60.2
And (MATCH-FL = "Y" ) MA60.3 MA60.4
And ((REC-STATUS = Zeroes ) MA61.1 MA63.1
Or (REC-STATUS = 1 )) MA65.1 MA67.1
MA67.2 MA68.1
MA70.1 MA75.1
APISET9 COMPANY This index is used to access invoice AP125 AP126
VENDOR records for a specific purchase order. AP141 AP25.1
PO-NUMBER KeyChange AP25.2 AP26.1
PO-RELEASE AP27.1 AP90.4
PO-CODE API1.1 MA126
LOCATION MA310 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
MA75.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
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
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
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
|