Lawson Insight Technical Documentation |
|
APVENMAST
APVENMAST FILE
Vendor
The Vendor file contains accounts payable vendor records, including one-time
vendors defined during invoice entry. If the vendor has default codes defined
at a company level, the vendor record has one or more associated records in
the Vendor Company Codes file.
REFERENCED BY
AC210 AM18.1 AP00.1 AP00.3 AP03.1 AP03.2
AP03.3 AP03.4 AP109 AP12.1 AP125 AP126
AP13.2 AP130 AP131 AP135 AP14.1 AP14.3
AP141 AP145 AP146 AP150 AP151 AP155
AP156 AP161 AP166 AP175 AP176 AP178
AP180 AP181 AP185 AP190 AP191 AP193
AP195 AP197 AP200 AP210 AP211 AP212
AP213 AP220 AP230 AP235 AP236 AP237
AP240 AP245 AP25.1 AP25.2 AP25.4 AP250
AP251 AP252 AP26.1 AP260 AP266 AP27.1
AP270 AP272 AP275 AP28.1 AP28.2 AP282
AP284 AP290 AP295 AP30.1 AP30.2 AP30.3
AP30.4 AP32.1 AP35.1 AP36.2 AP41.1 AP45.1
AP51.2 AP51.3 AP52.7 AP54.1 AP55.1 AP55.2
AP56.1 AP56.2 AP80.1 AP90.1 AP90.2 AP90.5
AP90.6 AP90.7 AP91.1 AP91.5 AP91.6 AP92.1
AP92.2 AP92.3 AP92.4 AP93.1 AP93.2 AP93.3
AP93.4 AP95.1 AP95.2 AP95.3 AP96.1 API1.1
API2.1 CB06.2 EE135 EE175 EE20.1 EE20.2
EE20.3 EE20.4 EE220 EE230 EE235 EE275
EE30.1 EE35.1 EE35.2 EE520 EE90.1 EE90.2
GL284 GL285 IAVO.1 IC282 IC522 IC526
IC527 IC530 IC531 IC81.1 MA00.1 MA236
MA531 MA540 MA61.1 MA63.1 MA64.1 MA64.4
MA64.6 MA66.1 MA66.2 MA66.3 MA70.1 MA75.1
MA80.1 MA95.1 MA95.2 MAI1.1 OE13.1 PO120
PO132 PO150 PO16.1 PO16.2 PO204 PO223
PO226 PO227 PO231 PO25.6 PO25.7 PO254
PO30.1 PO30.2 PO30.3 PO33.1 PO34.1 PO36.1
PO36.2 PO52.1 PO536 PO54.1 PO54.2 PO54.3
PO54.4 PO58.2 PR198 IN120 IN20.1 WH30.4
WH31.4 WH32.4 WH38.1 WH40.1 WH40.2 AP02.3
AP202 MA05.1 MA05.2
UPDATED BY
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.3 AP10.7 AP100 AP102
AP11.1 AP110 AP115 AP15.1 AP16.1 AP160
AP170 AP300 AP40.2 AP510 AP520 API3.1
API4.1 AR09.1 IC840 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 UK47.1 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP Alpha 4 AM115 AM117
Element: Vendor Group The vendor group to which the vendor AM15.1 AM15.2
belongs. Must be a valid record in the AM15.3 AM15.4
Vendor Group file. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP16.1 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor The identification number assigned to AM15.1 AM15.2
the vendor. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP16.1 AP510
AP520 API3.1
API4.1 IC282
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VEN-CLASS Alpha 3 AM115 AM117
Element: Vendor Class The vendor class the vendor is assigned AM15.1 AM15.2
to. Represents a group of vendors that AM15.3 AM15.4
share common characteristics within a AM20.1 AM20.3
vendor group. Must be a valid record in AM21.1 AM21.3
the Vendor Class file. AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VENDOR-VNAME Alpha 30 (Lower Case) AM115 AM117
Element: Vendor Name The vendor name or description. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP166 AP510
AP520 API3.1
API4.1 IC282
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
WH30.4 WH31.4
WH32.4 WH38.1
WH40.1 WH40.2
VEN-VENDOR-SNAME Alpha 30 AM115 AM117
Element: Search Name The search name for the vendor. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VENDOR-CONTCT Alpha 30 AM115 AM117
Element: Contact The name of the main contact for the AM15.1 AM15.2
vendor. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-REMIT-TO-CODE Alpha 4 AM115 AM117
Normal Remit-To The normal remittance location for the AM15.1 AM15.2
Location vendor, if defined. Must be a valid AM15.3 AM15.4
record in the Vendor Location file. If AM20.1 AM20.3
present, the address defined for the AM21.1 AM21.3
location overrides the vendor address on AM500 AM51.1
vendor payments when invoices are added. AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-PURCH-FR-LOC Alpha 4 AM115 AM117
Normal The normal purchasing location for the AM15.1 AM15.2
Purchase-From Location vendor, if defined. Must be a valid AM15.3 AM15.4
record in the Vendor Location file. If AM20.1 AM20.3
present, the address defined for the AM21.1 AM21.3
location overrides the vendor address AM500 AM51.1
for storing vendor purchase activity AM551 AM97.1
balances. AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-PAY-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Pay Vendor The pay vendor for the vendor, if AM15.1 AM15.2
applicable. Used to send invoice AM15.3 AM15.4
payments to another vendor within the AM20.1 AM20.3
same vendor group. If present, the pay AM21.1 AM21.3
vendor relationship overrides the normal AM500 AM51.1
remit-to information for the vendor, AM551 AM97.1
including remit-to name and address, AP10.3 AP100
cash code, and payment code. Must be a AP11.1 AP510
valid record in the Vendor file. AP520 API3.1
API4.1 IC840
Although payments are remitted to the PR05.1 PR05.3
pay vendor, the invoiced vendor PR226 PR247
accumulates the payment balance. If more PR26.1 PR47.1
than one vendor shares the same pay UK47.1
vendor, the system creates a single
payment for the pay vendor and lists
individual invoiced vendors and invoice
numbers that are included in the payment
on the remittance.
VEN-VENDOR-STATUS Alpha 1 AM115 AM117
Element: Status The vendor status. Invoices cannot be AM15.1 AM15.2
entered for a vendor with an Inactive AM15.3 AM15.4
status. Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
A = Active. AM500 AM51.1
I = Inactive. AM551 AM97.1
AP10.3 AP100
AP115 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VEN-PRIORITY Numeric 2 AM115 AM117
Element: Priority The payment priority assigned to the AM15.1 AM15.2
vendor. Valid values are 1 (highest AM15.3 AM15.4
priority) through 99 (lowest priority). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP110 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-PHONE-PREFIX Alpha 6 AM115 AM117
Telephone Country The country code for the vendor AM15.1 AM15.2
Code telephone number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-PHONE-NUM Alpha 15 AM115 AM117
Element: Telephone NumbThe telephone number for the vendor. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-PHONE-EXT Alpha 5 AM115 AM117
Element: Telephone ExteThe telephone extension number for the AM15.1 AM15.2
vendor. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-FAX-PREFIX Alpha 6 AM115 AM117
Telephone Country The country code for the fax machine AM15.1 AM15.2
Code telephone number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-FAX-NUM Alpha 15 AM115 AM117
Element: Telephone NumbThe fax machine telephone number. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-FAX-EXT Alpha 5 AM115 AM117
Element: Telephone ExteThe fax machine telephone number AM15.1 AM15.2
extension. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TELEX-NUM Alpha 15 AM115 AM117
Element: Telex The telex number for the vendor. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TERM-CODE Alpha 5 AM115 AM117
Element: Payment Terms The payment terms code assigned to the AM15.1 AM15.2
vendor. Used to automatically calculate AM15.3 AM15.4
invoice due date and discount AM20.1 AM20.3
information for the vendor's invoices. AM21.1 AM21.3
Must be a valid record in the Terms Code AM500 AM51.1
file. AM551 AM97.1
AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INV-CURRENCY Alpha 5 AM115 AM117
Element: Invoice CurrenThe currency used to add invoices for AM15.1 AM15.2
the vendor. The currency code defaults AM15.3 AM15.4
on the vendor's invoices during entry. AM20.1 AM20.3
Must be a valid record in the Currency AM21.1 AM21.3
Code file. If left blank, the vendor AM500 AM51.1
uses the invoice currency assigned to AM551 AM97.1
the vendor class, if assigned, or the AP100 AP110
company base currency. AP510 API3.1
API4.1 IC840
If the Balance Currency field contains PR05.1 PR05.3
a non-base currency, the Invoice PR226 PR247
Currency must be either the same PR26.1 PR47.1
non-base currency or the company base UK47.1
currency. If the Balance Currency field
contains the company base currency, the
Invoice Currency can be a non-base
currency.
VEN-BAL-CURRENCY Alpha 5 AM115 AM117
Element: Vendor BalanceThe currency used to store vendor AM15.1 AM15.2
balance information. Must be a valid AM15.3 AM15.4
record in the Currency Code file. If AM20.1 AM20.3
left blank, the company base currency is AM21.1 AM21.3
used. AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-CURR-RECALC Alpha 1 AM115 AM117
Currency If the Invoice Currency is different AM15.1 AM15.2
Recalculation from the company base currency, this AM15.3 AM15.4
field indicates whether the system will AM20.1 AM20.3
recalculate the invoice currency when AM21.1 AM21.3
the invoice is paid to account for AM500 AM51.1
exchange rate fluctuations. If Yes is AM551 AM97.1
selected in this field, the system AP100 AP510
compares the exchange rate in effect API3.1 API4.1
when the invoice was entered to the IC840 PR05.1
exchange rate in effect when the invoice PR05.3 PR226
is scheduled for payment by AP150 (Cash PR247 PR26.1
Requirements). If a difference exists, PR47.1 UK47.1
AP170 (Payment Closing) creates a
currency gain or loss transaction. Valid
values are:
N = No.
Y = Yes.
VEN-SEP-CHK-FLAG Alpha 1 AM115 AM117
Element: Separate PaymeIndicates whether to create a separate AM15.1 AM15.2
payment for each invoice entered for the AM15.3 AM15.4
vendor. Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
N = No. AM500 AM51.1
Y = Yes. AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TAX-ID Alpha 20 AM115 AM117
Element: Tax ID The tax identification number for the AM15.1 AM15.2
vendor. Used for reporting reportable AM15.3 AM15.4
vendor income. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TAX-EXEMPT-CD Alpha 1 AM115 AM117
Element: Tax Exempt CodCode indicating the taxing status. E - AM15.1 AM15.2
Exempt, T - Taxable. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TAX-CODE Alpha 10 AM115 AM117
Element: Tax Code The tax code assigned to the vendor. AM15.1 AM15.2
Used to automatically calculate invoice AM15.3 AM15.4
tax information. Must be a valid record AM20.1 AM20.3
in the Tax Code file. If left blank, the AM21.1 AM21.3
tax code assigned to the vendor class AM500 AM51.1
defaults. AM551 AM97.1
AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
TX140 UK47.1
VEN-HOLD-FLAG Alpha 1 AM115 AM117
Element: Hold Code This field enables this entire lot to AM15.1 AM15.2
be put on hold, not allowing any issues AM15.3 AM15.4
or transfers to be made for this lot. AM20.1 AM20.3
Y = Yes AM21.1 AM21.3
" " AM500 AM51.1
AM551 AM97.1
AP100 AP170
AP40.2 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-DIST-CODE Alpha 9 AM115 AM117
Element: Distribution CThe distribution code assigned to the AM15.1 AM15.2
vendor. Used to automatically create AM15.3 AM15.4
distribution lines for the vendor's AM20.1 AM20.3
invoices. Must be a valid record in the AM21.1 AM21.3
Distribution Code file. If left blank, AM500 AM51.1
the distribution code assigned to the AM551 AM97.1
vendor class, if assigned, defaults. AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ACCR-CODE Alpha 4 AM115 AM117
Element: Invoice AccruaThe invoice accrual code assigned to AM15.1 AM15.2
the vendor. Used to default a general AM15.3 AM15.4
ledger accrual account to the vendor's AM20.1 AM20.3
invoices during entry. Must be a valid AM21.1 AM21.3
record in the Invoice Accrual Code file. AM500 AM51.1
If left blank, the invoice accrual code AM551 AM97.1
assigned to the vendor class, if AP100 AP110
assigned, or the company defaults. AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-BANK-INST-CODE Alpha 3 AM115 AM117
Element: Payment Code The payment code assigned to the AM15.1 AM15.2
vendor. Represents a type of cash AM15.3 AM15.4
payment, such as a check or payment AM20.1 AM20.3
tape, or a bill of exchange payment. AM21.1 AM21.3
Must be a valid cash or bill of exchange AM500 AM51.1
payment transaction code record in the AM551 AM97.1
Bank Transaction Code file. AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-CASH-CODE Alpha 4 AM115 AM117
Element: Cash Code The cash code assigned to the vendor. AM15.1 AM15.2
Represents a bank account. Must be a AM15.3 AM15.4
valid record in the Cash Code file. If AM20.1 AM20.3
left blank, the cash code assigned to AM21.1 AM21.3
the vendor class, if assigned, defaults, AM500 AM51.1
or the vendor uses the cash code AM551 AM97.1
assigned to the company or the pay AP100 AP110
group. AP125 AP126
AP151 AP156
AP180 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP510
AP56.1 AP56.2
AP80.1 API3.1
API4.1 IC840
MA61.1 MAI1.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-BANK-ENTITY Alpha 15 AM115 AM117
Element: Bank The bank identification used to deposit AM15.1 AM15.2
electronic payments for the vendor. This AM15.3 AM15.4
field is required for ACH or BACS AM20.1 AM20.3
payment types. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-BANK-CURRENCY Alpha 5 AP16.1 AP510
Element: Currency Code This field contains the bank currency
code
VEN-VBANK-ACCT-NO Alpha 35 AM115 AM117
Element: Bank Account NThe bank account number used to deposit AM15.1 AM15.2
electronic payments for the vendor. This AM15.3 AM15.4
field is required for ACH or BACS AM20.1 AM20.3
payment types. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VBANK-ACCT-TP Alpha 1 AM115 AM117
Vendor Bank Account Indicates the type of bank account used AM15.1 AM15.2
Type to deposit electronic payments for the AM15.3 AM15.4
vendor. Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
C = Current/Checking Account. AM500 AM51.1
S = Savings Account. AM551 AM97.1
Blank = Electronic payment type not AP100 AP16.1
selected. AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VBANK-IDENT Alpha 1 AP16.1 AP510
Element: Vbank Ident This field indicates if the account
number is an IBAN number that requires
an account validation check.
Y = Yes
N = No
VEN-CROSS-IDENT Alpha 1 AP16.1 AP510
Element: Cross Ident This field is used to distinquish
between SWIFT ID numbers and Rounting
numbers.
S = SWIFT
R = Routing Number
VEN-INCOME-CODE Alpha 4 AM115 AM117
Element: Income Code The income code assigned to the vendor. AM15.1 AM15.2
Used to track reportable income for the AM15.3 AM15.4
vendor. Must be a valid record in the AM20.1 AM20.3
Income Code file. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP110 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-INCOME-WH-FLG Alpha 1 AM115 AM117
Element: Income WithholIndicates whether invoices for the AM15.1 AM15.2
vendor are subject to reportable income AM15.3 AM15.4
withholding. Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
N = No. AM500 AM51.1
Y = Yes. AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-EDI-NBR Alpha 15 AM115 AM117
Element: EDI Number The vendor's electronic data AM15.1 AM15.2
interchange (EDI) number. Used for AM15.3 AM15.4
reference. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ACH-PRENOT Alpha 1 AM115 AM117
ACH Prenotification Used in conjunction with ACH payments AM15.1 AM15.2
Status created for the vendor. Indicates the AM15.3 AM15.4
status of the electronic payment between AM20.1 AM20.3
the vendor and the processing bank. AM21.1 AM21.3
Valid values are: AM500 AM51.1
AM551 AM97.1
N = Notified. AP160 (Payment Tape AP100 AP110
Creation) automatically changes the AP16.1 AP160
status from Prenotified to Notified to AP510 API3.1
indicate that the processing bank has API4.1 IC840
been notified but has not yet accepted PR05.1 PR05.3
the electronic payment tape. PR226 PR247
PR26.1 PR47.1
P = Prenotified. Select this status UK47.1
when first entering ACH information to
prenotify the processing bank.
A = Accepted. Change the status to
Accepted once the processing bank
accepts the electronic payment tape.
Blank = ACH payment type not selected.
VEN-MAX-INV-AMT Signed 18.2 AM115 AM117
Maximum Invoice The maximum single invoice amount that AM15.1 AM15.2
Amount can be entered for the vendor. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-CREATE-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Creation Date The date the vendor record was created AM15.1 AM15.2
in the Lawson Accounts Payable system. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-ORIGIN-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Date The origin date for the vendor. Can be AM15.1 AM15.2
used record additional information, such AM15.3 AM15.4
as the date the vendor relationship AM20.1 AM20.3
began. If left blank, the system date AM21.1 AM21.3
defaults. AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-OPERATOR Alpha 10 AM115 AM117
Element: Operator Code The operator associated with AM15.1 AM15.2
maintaining the vendor record. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-USER-NAME-01 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the first AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-USER-NAME-02 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the second AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-USER-NAME-03 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the third AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-USER-NAME-04 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the fourth AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-USER-NAME-05 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the fifth AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-USER-NAME-06 Alpha 20 AM115 AM117
Element: User Defined FThe value of the information being AM15.1 AM15.2
tracked for the vendor in the sixth AM15.3 AM15.4
vendor group user field. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-CUST-GROUP Alpha 5 AM115 AM117
Element: Customer GroupIf the accounts payable vendor is also AM15.1 AM15.2
a customer in the Lawson Accounts AM15.3 AM15.4
Receivable system, this field can be AM20.1 AM20.3
used to identify the customer group AM21.1 AM21.3
associated with the corresponding AM500 AM51.1
accounts receivable customer. Used to AM551 AM97.1
update the accounts receivable customer AP100 AP510
record. API3.1 API4.1
AR09.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-CUSTOMER Alpha 9 (Right Justified) AM115 AM117
Element: Customer If the accounts payable vendor is also AM15.1 AM15.2
a customer in the Lawson Accounts AM15.3 AM15.4
Receivable system, this field can be AM20.1 AM20.3
used to identify the corresponding AM21.1 AM21.3
accounts receivable customer number. AM500 AM51.1
Used to update the accounts receivable AM551 AM97.1
customer record. AP100 AP510
API3.1 API4.1
AR09.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-LEGAL-NAME Alpha 80 (Lower Case) AM115 AM117
Element: Legal Name The legal name for the vendor. Used for AM15.1 AM15.2
reporting reportable vendor income. If AM15.3 AM15.4
left blank, the Vendor Name defaults. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-PRIME-RATE Signed 7.5 AM115 AM117
Anticipation The percentage used to calculate AM15.1 AM15.2
Discount Rate anticipation discount invoices; most AM15.3 AM15.4
often the prime rate plus one percent. AM20.1 AM20.3
To calculate the discount for an AM21.1 AM21.3
anticipation invoice, the system AM500 AM51.1
subtracts the invoice payment date from AM551 AM97.1
the invoice due date to calculate the AP100 AP510
number of days paid early, multiplies API3.1 API4.1
the number of days paid early by 365 IC840 PR05.1
days, multiplies the result by the PR05.3 PR226
anticipation discount rate, and PR247 PR26.1
multiplies the result by the payment PR47.1 UK47.1
amount to calculate the discount amount.
Anticipation discount terms codes are
defined in the Lawson Terms system.
VEN-INVOICE-GROUP Alpha 4 AM115 AM117
Element: Invoice Group A user-defined invoice group assigned AM15.1 AM15.2
to the vendor. This value defaults on AM15.3 AM15.4
invoices entered for the vendor. Can be AM20.1 AM20.3
used to select invoices for payment in AM21.1 AM21.3
AP150 (Cash Requirements). AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-DISCOUNT-CODE Alpha 10 AM115 AM117
Element: Discount Code The discount code assigned to the AM15.1 AM15.2
vendor. Used to default a general ledger AM15.3 AM15.4
discount account on the vendor's AM20.1 AM20.3
invoices during entry. Must be a valid AM21.1 AM21.3
record in the Discount Code file. AM500 AM51.1
AM551 AM97.1
AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ERS-CAPABLE Alpha 1 AM115 AM117
Element: ERS Capable Indicates whether the vendor location AM15.1 AM15.2
has the capability to process ERS. Valid AM15.3 AM15.4
values are: AM20.1 AM20.3
AM21.1 AM21.3
N = No. AM500 AM51.1
Y = Yes. AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-INVC-REF-TYPE Alpha 2 AM115 AM117
ERS Invoice Indicates the type of number the vendor AM15.1 AM15.2
Reference is providing to reference the invoice. AM15.3 AM15.4
Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
BM = Bill of Lading Number. AM500 AM51.1
IN = Invoice Number. AM551 AM97.1
OW = Service Order Number. AP100 AP16.1
PL = Packing List Number. AP510 API3.1
PO = PO Number. API4.1 IC840
VN = Vendor Order Number. PR05.1 PR05.3
WO = Work Order Number. PR226 PR247
WP = Warehouse Pick Ticket Number. PR26.1 PR47.1
ZZ = Mutually Defined Number. UK47.1
VEN-EDI-AUTO-REL Alpha 1 AM115 AM117
EDI Invoice Auto Indicates whether the company AM15.1 AM15.2
Release automatically releases EDI invoices. AM15.3 AM15.4
Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
N = No. AM500 AM51.1
Y = Yes. AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-AUTH-CODE Alpha 3 AM115 AM117
Element: Authority CodeThe authority code assigned to the AM15.1 AM15.2
vendor, if assigned. Represents a person AM15.3 AM15.4
or department responsible for approving AM20.1 AM20.3
registered invoices for the vendor. This AM21.1 AM21.3
code defaults on the vendor's invoices AM500 AM51.1
during entry. Must be a valid authority AM551 AM97.1
code in the Authority Code file. AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-APPRVL-EXISTS Alpha 1 AM115 AM117
Approval Indicates whether approval criteria is AM15.1 AM15.2
Information Exists defined for the vendor. If Yes, one or AM15.3 AM15.4
more associated approval records exist AM20.1 AM20.3
for the vendor in the Invoice Approval AM21.1 AM21.3
file. Valid values are: AM500 AM51.1
AM551 AM97.1
N = No. AP10.7 AP100
Y = Yes. API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-ACTIVITY Alpha 15 AM115 AM117
Element: Activity The activity assigned to the vendor, if AM15.1 AM15.2
assigned. Activities are the tasks that AM15.3 AM15.4
make up an activity group. Activities AM20.1 AM20.3
identify work being done, such as work AM21.1 AM21.3
orders, phases, products, and so on. AM500 AM51.1
Must be a valid record in the Activity AM551 AM97.1
file. AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ACCT-CATEGORY Alpha 5 AM115 AM117
Element: Account CategoThe account category assigned to the AM15.1 AM15.2
vendor. Account categories are the AM15.3 AM15.4
Activity Management accounts by which AM20.1 AM20.3
activity transactions are grouped for AM21.1 AM21.3
budgeting and reporting. Must be a valid AM500 AM51.1
record in the Activity Account Category AM551 AM97.1
file. AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-CHARGE-CODE Alpha 1 AM115 AM117
Element: Charge Code Indicates who pays service charges or AM15.1 AM15.2
fees associated with a SWIFT payment. AM15.3 AM15.4
Valid values are: AM20.1 AM20.3
AM21.1 AM21.3
I = Issuer. AM500 AM51.1
R = Receiver. AM551 AM97.1
Blank = Not defined for the vendor. AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-PMT-CAT-CODE Alpha 6 AM115 AM117
Payment Category Indicates the payment category of the AM15.1 AM15.2
Code SWIFT payment. Valid values are: AM15.3 AM15.4
AM20.1 AM20.3
G = Goods. AM21.1 AM21.3
T = Transit Trade. AM500 AM51.1
S = Service and Capital. AM551 AM97.1
X = Transfer. AP100 AP16.1
O = Other. AP510 API3.1
Blank = Not defined for the vendor. API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-NORM-EXP-CODE Alpha 1 AM115 AM117
Normal or Express Indicates whether the SWIFT payment is AM15.1 AM15.2
Code a normal or express payment. Valid AM15.3 AM15.4
values are: AM20.1 AM20.3
AM21.1 AM21.3
N = Normal. AM500 AM51.1
E = Express. AM551 AM97.1
Blank = Not defined for the vendor. AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-PMT-FORM Alpha 2 AM115 AM117
Element: Payment Form Indicates how the SWIFT payment is AM15.1 AM15.2
made. Valid values are: AM15.3 AM15.4
AM20.1 AM20.3
C = Check. AM21.1 AM21.3
B = Foreign Bank. AM500 AM51.1
Blank = Not defined for the vendor. AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-SWIFT-ID Alpha 12 AM115 AM117
Element: Swift ID The SWIFT identification number AM15.1 AM15.2
assigned to the vendor. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-PROC-GRP Alpha 4 (Lower Case) AM115 AM117
Element: Process Group A process group is an identifier used AM15.1 AM15.2
for separating vendors into different AM15.3 AM15.4
groups to enable concurrent processing AM20.1 AM20.3
within the cash payment cycle. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP102
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-MATCH-TABLE Alpha 10 AM115 AM117
Element: Match Table A code representing a match table. A AM15.1 AM15.2
match table contains the processing AM15.3 AM15.4
rules that will be used during matching. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-DISC-CALC-DATE Alpha 1 AM115 AM117
Discount Indicates which date to use when AM15.1 AM15.2
Calculation Date calculating discounts. AM15.3 AM15.4
AM20.1 AM20.3
You can use the invoice date, receipt AM21.1 AM21.3
date, or the date the invoice was AM500 AM51.1
received. AM551 AM97.1
" " AP100 AP510
D = Receipt of Invoice Date API3.1 API4.1
I = Invoice Date IC840 PR05.1
R = Latest Receipt Date PR05.3 PR226
E = Earliest Receipt Date PR247 PR26.1
S = Ship To Arrive Date PR47.1 UK47.1
VEN-CREATE-POD-FL Alpha 1 AM115 AM117
Proof of Delivery Indicates whether to create a proof of AM15.1 AM15.2
Created delivery. AM15.3 AM15.4
AM20.1 AM20.3
Valid values are: AM21.1 AM21.3
AM500 AM51.1
N = No AM551 AM97.1
Y = Yes AP100 AP510
" " API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-HANDLING-CODE Alpha 4 AM115 AM117
Invoice Handling Invoice handling code. Determines the AM15.1 AM15.2
Code processing rules that will be used AM15.3 AM15.4
during matching. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ENCLOSURE Alpha 1 AM115 AM117
Element: Enclosure Indicates whether the invoice requires AM15.1 AM15.2
an enclosure with its payment. AM15.3 AM15.4
Y = Yes AM20.1 AM20.3
N = No AM21.1 AM21.3
" " AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-REQ-MATCH-REF Alpha 1 AM115 AM117
Match Reference Indicates whether a match reference AM15.1 AM15.2
Required number is required for invoices for this AM15.3 AM15.4
vendor. AM20.1 AM20.3
Y = Yes AM21.1 AM21.3
N = No AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-POOL-OPTION Numeric 1 AM115 AM117
Element: Au Flag 1 = Company Vendor AM15.1 AM15.2
2 = Company Vendor PO AM15.3 AM15.4
3 = Company Vendor PO ShipTo AM20.1 AM20.3
0 = MA Company Default AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-HOLD-INSP-FLAG Alpha 1 AM115 AM117
Element: Hold Insp FlagIf set to "Y", this flag will keep AM15.1 AM15.2
receiving lines requiring inspection AM15.3 AM15.4
from being matched until they have been AM20.1 AM20.3
inspected. AM21.1 AM21.3
Y = Yes AM500 AM51.1
N = No AM551 AM97.1
" " = Use Company AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-WRITE-OFF-AMT Signed 18.2 AM115 AM117
Element: Intl Amt AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VEN-CLAIM-TYPE Alpha 2 AM115 AM117
Element: Vendor Claim TCB = Chargeback AM15.1 AM15.2
CM = Credit Memo AM15.3 AM15.4
N = None AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PO52.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-CLAIM-HOLD-CD Alpha 4 AM115 AM117
Element: Hold Code AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-CB-HOLD-CODE Alpha 4 AM115 AM117
Vendor Claims AM15.1 AM15.2
Chargeback Hold AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-CB-MINIMUM-AMT Signed 18.2 AM115 AM117
Element: Minimum Claim Amount AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-REPLACE-GOODS Alpha 1 AM115 AM117
Element: Replace Goods Y = Yes AM15.1 AM15.2
N = No AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-SHIP-OR-HOLD Alpha 1 AM115 AM117
Element: Ship or Hold GS = Ship AM15.1 AM15.2
H = Hold AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PO52.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-ERS-HANDLING Alpha 4 AM115 AM117
Element: Handling Code AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP16.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-E-MAIL-ADDRESS Alpha 60 (Lower Case) AM115 AM117
Element: Email Address AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-URL-ADDR Alpha 60 (Lower Case) AM115 AM117
Element: Url Addr AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VEND-ACCT Alpha 30 AM115 AM117
Element: Vend Acct The customer number the vendor has AM15.1 AM15.2
assigned to you. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-LANGUAGE-CODE Alpha 10 AM115 AM117
Element: Language Code Language Code (LOCALE). AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-TAX-USAGE-CD Alpha 10 AM115 AM117
Element: Tax Usage Cd The tax usage coe for the vendor. This AM15.1 AM15.2
filed is required if the AP Company AM15.3 AM15.4
inidcates that VAT reporting required. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-VAT-REG-CTRY Alpha 2 AM115 AM117
Element: Vat Reg Ctry The country component of the VAT AM15.1 AM15.2
Registration Number. This field, AM15.3 AM15.4
together with the Registration Number AM20.1 AM20.3
for the company on the tax transaction. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VAT-REG-NBR Alpha 12 AM115 AM117
Element: Vat Reg Nbr The number component of the VAT AM15.1 AM15.2
Registration Number. This field together AM15.3 AM15.4
with the Registration Country field make AM20.1 AM20.3
up the VAT Registration Number. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-VALIDATE-PO Alpha 1 AM115 AM117
Element: Validate Po " " = MA Company Default AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
N = No AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-REQUIRE-PO Alpha 1 AM115 AM117
Element: Require Po " " = MA Company Default AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
N = No AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-LOC-INDICATOR Derived
Element: Locations ExisWhen selecting a vendor from a list of
available vendors, an asterisk (*)
displays if alternate locations exist
for a vendor.
VEN-SHORT-VNAME Derived
Element: Short Vendor NA short name for the vendor. Used for
display purposes.
VEN-VCOMMENT-EXIST Derived
Vendor Comments When selecting a vendor from a list of
Exist available vendors, an asterisk (*)
displays if comments exist for a vendor.
VEN-VDR-ADDR1 Derived
Element: Vdr Addr1 Vendor address line 1.
VEN-VDR-ADDR2 Derived
Element: Vdr Addr2 Vendor address line 2.
VEN-VDR-ADDR3 Derived
Element: Vdr Addr3 Vendor address line 3.
VEN-VDR-ADDR4 Derived
Element: Vdr Addr4 Vendor address line 4.
VEN-VDR-CITY-ADDR5 Derived
Element: Vdr City Addr5Vendor city or address line 5.
VEN-VDR-STATE Derived
Element: Vdr State Vendor state or province.
VEN-VDR-POSTAL Derived
Element: Vdr Postal Vendor postal code.
VEN-VDR-COUNTY Derived
Element: Vdr County Vendor county.
VEN-VDR-COUNTRY Derived
Element: Vdr Country Vendor country.
VEN-VAT-NBR Derived
Element: Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
VEN-WORKFLOW-GROUP Alpha 20 AM115 AM117
Element: Workflow Group AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-MBL-INT-PREFIX Alpha 6 AM115 AM117
Element: Mbl Int PrefixThis field contains the country code of AM15.1 AM15.2
the mobile phone number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-MOBILE-NUM Alpha 15 AM115 AM117
Element: Mobile Num This field contains the mobile phone AM15.1 AM15.2
number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-MOBILE-EXT Alpha 5 AM115 AM117
Element: Mobile Ext This field contains the mobile phone AM15.1 AM15.2
extension number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-PAY-IMM-FLAG Alpha 1 AM115 AM117
Element: All Flag AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-DIVERSE-CODE Alpha 5 AM115 AM117
Element: Diverse Code Diversity Code for Account Payable AM15.1 AM15.2
Vendors AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-BANK-ENT Alpha 15 AM115 AM117
Element: Bank Type the intermediary bank AM15.1 AM15.2
identification used to deposit AM15.3 AM15.4
electronic payments for the vendor. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-BANK-ACCT Alpha 35 AM115 AM117
Element: Bank Account NType the intermediary bank account AM15.1 AM15.2
number used to deposit electronic AM15.3 AM15.4
payments for the vendor. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-BANK-IDNT Alpha 1 AP16.1 AP510
Element: Intm Bank IdntThis field indicates if the account
number is and IBAN number that requires
an account validation check.
Y = Yes
N = No
VEN-INTM-BANK-CURR Alpha 5 AP16.1 AP510
Element: Currency Code This field contains the intermediary
bank currency code.
VEN-INTM-PRENOT Alpha 1 AM115 AM117
ACH Prenotification If you create intermediary ACH payments AM15.1 AM15.2
Status for the vendor, select the AM15.3 AM15.4
prenotification status. Indicates the AM20.1 AM20.3
status of the electronic payment between AM21.1 AM21.3
the vendor and the processing bank. AM500 AM51.1
A = Accepted AM551 AM97.1
N = Not prenotified AP16.1 AP510
P = Prenotified API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-SWIFT-ID Alpha 12 AM115 AM117
Element: Patient ID Use SWIFT Payment Options (AP10.8) to AM15.1 AM15.2
define SWIFT payment options if you AM15.3 AM15.4
create Intermediary SWIFT payments for AM20.1 AM20.3
the vendor. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-PMT-CAT Alpha 6 AM115 AM117
Element: Pmt Cat Code Select the Intermediary SWIFT payment AM15.1 AM15.2
category. AM15.3 AM15.4
G = Goods AM20.1 AM20.3
T = Transit Trade AM21.1 AM21.3
S = Service and Capital AM500 AM51.1
X = Transfer AM551 AM97.1
O = Other AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-NORM-EXP Alpha 1 AM115 AM117
Element: Charge Code Indicates whether the SWIFT payment is a AM15.1 AM15.2
normal or express payment. AM15.3 AM15.4
N = Normal AM20.1 AM20.3
E = Express AM21.1 AM21.3
" " = Not defined for the vendor AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-PMT-FORM Alpha 2 AM115 AM117
Element: Pmt Form Indicates how the Intermediary SWIFT AM15.1 AM15.2
payment is made. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-CHRG-CD Alpha 1 AM115 AM117
Element: Charge Code Indicates who pays service charges or AM15.1 AM15.2
fees associated with a Intermediary AM15.3 AM15.4
SWIFT payment. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-INTM-CRS-IDENT Alpha 1 AP16.1 AP510
Element: Intm Crs IdentThis field is used to distiguish between
SWIFT ID numbers and Routing numbers
S = Swift
R = Routing Number
VEN-RULE-GROUP Alpha 10 AM115 AM117
Element: Rule Group AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP100 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-FLOAT-DAYS Numeric 3 AM115 AM117
Element: Float Days This is the number of days to add to the AM15.1 AM15.2
best terms calculation if the vendor AM15.3 AM15.4
will allow a specific number of days for AM20.1 AM20.3
the payment to reach them and still AM21.1 AM21.3
receive the discount. AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VEN-MTCH-PREPAY-FL Alpha 1 AM115 AM117
Element: Mtch Prepay FlFlag that notes if the invoice will be AM15.1 AM15.2
prepaid. This is for match invoices. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-MTCH-PREPAY-MT Numeric 1 AM115 AM117
Element: Mtch Prepay MtFlag denotes the method of match AM15.1 AM15.2
prepayment. AM15.3 AM15.4
0 = No AM20.1 AM20.3
1 = Prepay from Invoice AM21.1 AM21.3
2 = Eligible for Prepayment AM500 AM51.1
AM551 AM97.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-BUILD-SOC-REF Alpha 18 AM115 AM117
Element: Build Soc Ref This field holds an individual account AM15.1 AM15.2
number reference for the Building AM15.3 AM15.4
Society AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-BUILD-ACCT-NM Alpha 18 AM115 AM117
Element: Account Name AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP16.1 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VEN-XREF-FLAG Alpha 1 AP15.1
Element: Xref Flag Use a cross reference table for this
vendor
0 = Xref Vendor does not exist
1 = Xref record exist
VEN-GIRO-NUMBER Alpha 15 AP16.1 AP510
Element: Giro Number This field is the Bankgiro or Postgiro
account number
VEN-CR-CARD-NUMBER Alpha 16 AP16.1 AP510
Element: Cr Card NumberThis field contains the credit card
number.
VEN-BANK-INSTRUCT1 Alpha 35 AP16.1 AP510
Element: Bank Instruct1This field contains bank instructions.
VEN-BANK-INSTRUCT2 Alpha 35 AP16.1 AP510
Element: Bank Instruct2This field contains bank instructions.
VEN-BANK-INSTRUCT3 Alpha 35 AP16.1 AP510
Element: Bank Instruct3This field contains bank instructions.
VEN-BANK-INSTRUCT4 Alpha 35 AP16.1 AP510
Element: Bank Instruct4This field contains bank instructions.
VEN-AP-OBJ-ID Numeric 12 AM115 AM117
Object AM15.1 AM15.2
Identification AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
APVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP This index is used to access and AC210 AM115
VENDOR validate vendor records for a specific AM117 AM15.1
vendor group. AM15.2 AM15.3
AM15.4 AM18.1
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.1 AP03.1
AP03.2 AP03.3
AP03.4 AP10.1
AP10.2 AP10.3
AP10.5 AP10.6
AP10.7 AP10.9
AP100 AP102
...
VENSET10 VENDOR-GROUP KeyChange AP130
CREATE-POD-FL
VENDOR
VENSET11 AP-OBJ-ID Subset AM115 AM117
Where AP-OBJ-ID != Zeroes AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP03.4
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VENSET2 VENDOR-GROUP This index is used to access vendor AP00.3 AP100
VEN-CLASS records within a specific vendor class AP102 AP110
VENDOR for a vendor group. AP251 AP252
KeyChange AP300 IAVO.1
PO120
VENSET3 VENDOR-GROUP This index is used to access vendor
USER-NAME-01 records by using the first vendor group
VENDOR-SNAME user-defined field.
VENDOR KeyChange
VENSET4 VENDOR-GROUP This index is used to access vendor
VEN-CLASS records within a specific vendor class
VENDOR-SNAME in search name sequence.
VENDOR KeyChange
VENSET5 VENDOR-GROUP This index is used to access vendor AM115 AM117
VENDOR-SNAME records in search name sequence. AM15.1 AM15.2
VENDOR KeyChange AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP200
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VENSET6 PROC-GRP This index is used to access vendors AP02.3 AP202
VENDOR-GROUP not on hold or vendors assigned a
VENDOR specific hold code.
KeyChange
VENSET7 VENDOR-GROUP This index is used to access and AC210 AM115
EDI-NBR validate vendor records by EDI number. AM117 AM15.1
VENDOR KeyChange AM15.2 AM15.3
AM15.4 AM18.1
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP520 API3.1
API4.1 IC530
IC840 MA63.1
MA80.1 PR05.1
PR05.3 PR198
PR226 PR247
PR26.1 PR47.1
...
VENSET8 VENDOR-GROUP This index is used to access vendor AP160
VENDOR records set up for ACH processing that
have not been prenotified.
Subset
Where ACH-PRENOT = "N"
Or ACH-PRENOT = "P"
VENSET9 HANDLING-CODE This index is used to display vendors AP102 MA05.1
VENDOR-GROUP assisgned a handling code. MA05.2
VENDOR KeyChange
APVENMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Address1 APVENADDR Required
VEN-VENDOR-GROUP -> VDR-VENDOR-GROUP
VEN-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
"Y" -> VDR-CUR-ADDR
Approcgrp APPROCGRP Not Required
VEN-PROC-GRP -> APQ-PROC-GRP
Apvengroup APVENGROUP Required
VEN-VENDOR-GROUP -> VGP-VENDOR-GROUP
Mamtchrule MAMTCHRULE Required
VEN-RULE-GROUP -> MAU-MATCH-RULE
Procuregrp PROCUREGRP Required
VEN-VENDOR-GROUP -> PCG-VENDOR-GROUP
APVENMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST
VEN-VENDOR-GROUP -> AH1-VENDOR-GROUP
VEN-VENDOR -> AH1-VENDOR
AH1-INVOICE
AH1-SUFFIX
AH1-CANCEL-SEQ
AH1-COMPANY
Apaudit APAUDIT
VEN-VENDOR-GROUP -> APA-VENDOR-GROUP
Zeroes -> APA-COMPANY
Spaces -> APA-PROC-LEVEL
VEN-VENDOR -> APA-VENDOR
Spaces -> APA-INVOICE
Zeroes -> APA-SUFFIX
Zeroes -> APA-CANCEL-SEQ
APA-SEQ-NBR
APA-TRANS-DATE
APA-TRANS-TIME
Apcomments APCOMMENTS Delete Cascades
"V" -> APC-REC-TYPE
VEN-VENDOR-GROUP -> APC-VENDOR-GROUP
VEN-VENDOR -> APC-VENDOR
APC-LOCATION-CODE
APC-COMPANY
APC-SEQ-NBR
Apcontacts APCONTACT Delete Cascades
VEN-VENDOR-GROUP -> VCT-VENDOR-GROUP
VEN-VENDOR -> VCT-VENDOR
VCT-RESP-CODE
VCT-CONTACT-LVL
VCT-LOCATION-CODE
Apcpyvnd APCPYVND
VEN-VENDOR-GROUP -> APX-VENDOR-GROUP
VEN-VENDOR -> APX-VENDOR
Spaces -> APX-LOCATION-CODE
APX-COMPANY
Aphldinv APHLDINV Delete Cascades
Valid When (VEN-HOLD-FLAG = "Y" )
"V" -> HLI-REC-TYPE
VEN-VENDOR-GROUP -> HLI-VENDOR-GROUP
Zeroes -> HLI-COMPANY
VEN-VENDOR -> HLI-VENDOR
HLI-INVOICE
HLI-SUFFIX
HLI-CANCEL-SEQ
HLI-SEQ-NBR
HLI-VOID-SEQ
HLI-HLD-CODE
Apinvoice APINVOICE
VEN-VENDOR-GROUP -> API-VENDOR-GROUP
VEN-VENDOR -> API-VENDOR
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
API-COMPANY
Apvcomments APCOMMENTS
"V" -> APC-REC-TYPE
VEN-VENDOR-GROUP -> APC-VENDOR-GROUP
VEN-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
APC-COMPANY
APC-SEQ-NBR
Apvenaddr APVENADDR
VEN-VENDOR-GROUP -> VDR-VENDOR-GROUP
VEN-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
VDR-EFFECTIVE-DATE
Apvenbal APVENBAL Delete Cascades
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
VBA-COMPANY
VBA-LOCATION-CODE
Apvenbalmaster APVENBAL Delete Cascades
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
Spaces -> VBA-LOCATION-CODE
VBA-COMPANY
Apvencert APVENCERT
VEN-VENDOR-GROUP -> AVT-VENDOR-GROUP
VEN-VENDOR -> AVT-VENDOR
AVT-LOCATION-CODE
AVT-CERTIF-CODE
AVT-CERTIF-EFF-DT
Apvendorbal APVENBAL
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
VBA-LOCATION-CODE
VBA-COMPANY
Apvenloc APVENLOC Delete Cascades
VEN-VENDOR-GROUP -> VLO-VENDOR-GROUP
VEN-VENDOR -> VLO-VENDOR
VLO-LOCATION-CODE
Apvenpay APVENPAY
VEN-VENDOR-GROUP -> VPY-VENDOR-GROUP
VEN-VENDOR -> VPY-VENDOR
VPY-PAY-VENDOR
Apvnmxval APVNMXVAL Delete Cascades
VEN-AP-OBJ-ID -> VMX-AP-OBJ-ID
VMX-MATRIX-CAT
Cbcheck CBCHECK
VEN-VENDOR-GROUP -> CHK-VENDOR-GROUP
VEN-VENDOR -> CHK-PAID-VENDOR
CHK-COMPANY
CHK-CHECK-DATE
CHK-BANK-INST-CODE
CHK-CASH-CODE
CHK-TRANS-IDENT
Povagrmthd POVAGRMTHD
PCG-PROCURE-GROUP -> PVH-PROCURE-GROUP
VEN-VENDOR -> PVH-VENDOR
PVH-PURCH-FR-LOC
PVH-VEN-AGRMT-REF
|