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 AC297 AM18.1 AP00.1 AP00.3 AP109
AP12.1 AP125 AP126 AP130 AP131 AP135
AP141 AP145 AP146 AP150 AP151 AP155
AP156 AP161 AP166 AP175 AP176 AP180
AP181 AP185 AP190 AP191 AP193 AP195
AP197 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP200 AP210 AP212
AP213 AP220 AP23.1 AP230 AP235 AP236
AP240 AP245 AP25.1 AP25.2 AP25.4 AP250
AP251 AP252 AP26.1 AP260 AP266 AP27.1
AP270 AP275 AP28.1 AP28.2 AP282 AP284
AP290 AP295 AP30.1 AP30.2 AP30.3 AP30.4
AP32.1 AP32.2 AP35.1 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 IC28.1 IC282 IC522 IC526 IC527
IC530 IC531 IC81.1 IC83.1 MA00.1 MA180
MA236 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.5 MA43.7 MA43.8 MA43.9 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA64.1 MA64.4 MA64.6 MA66.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MA95.1 MA95.2 MAI1.1 PO100 PO101 PO120
PO122 PO131 PO132 PO150 PO16.1 PO16.2
PO20.1 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO223 PO226 PO227 PO23.1
PO231 PO25.1 PO25.5 PO25.6 PO25.7 PO254
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.1 PO54.2
PO54.3 PO54.4 PO58.2 POAV.1 POI3.1 POID.1
POII.1 POIJ.1 PR198 MM280 MM80.2 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1
RQ500 RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1
RQIJ.1 IN120 IN20.1 WH20.2 WH20.7 WH30.4
WH31.4 WH32.4 WH38.1 WH40.1 WH40.2 AP02.3
AP202 MA05.1 MA05.2
UPDATED BY
AM115 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 AP160 AP170 AP300 AP40.2
AP510 AP520 API3.1 API4.1 AR09.1 IC840
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP Alpha 4 AM115 AM15.1
Element: Vendor Group The vendor group to which the vendor AM15.2 AM15.3
belongs. Must be a valid record in the AM15.4 AM20.1
Vendor Group file. 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
PR514 UK47.1
VEN-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Element: Vendor The identification number assigned to AM15.2 AM15.3
the vendor. 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 IC282
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-VEN-CLASS Alpha 3 AM115 AM15.1
Element: Vendor Class The vendor class the vendor is assigned AM15.2 AM15.3
to. Represents a group of vendors that AM15.4 AM20.1
share common characteristics within a AM20.3 AM21.1
vendor group. Must be a valid record in AM21.3 AM500
the Vendor Class file. 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
PR514 UK47.1
VEN-VENDOR-VNAME Alpha 30 (Lower Case) AM115 AM15.1
Element: Vendor Name The vendor name or description. 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
PR514 UK47.1
WH30.4 WH31.4
WH32.4 WH38.1
WH40.1 WH40.2
VEN-VENDOR-SNAME Alpha 30 AM115 AM15.1
Element: Search Name The search name for the vendor. 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
PR514 UK47.1
VEN-VENDOR-CONTCT Alpha 30 AM115 AM15.1
Element: Contact The name of the main contact for the AM15.2 AM15.3
vendor. 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
PR514 UK47.1
VEN-REMIT-TO-CODE Alpha 4 AP100 AP510
Normal Remit-To The normal remittance location for the API3.1 PR05.1
Location vendor, if defined. Must be a valid PR05.3 PR226
record in the Vendor Location file. If PR247 PR26.1
present, the address defined for the PR47.1 PR514
location overrides the vendor address on UK47.1
vendor payments when invoices are added.
VEN-PURCH-FR-LOC Alpha 4 AP100 AP510
Normal The normal purchasing location for the API3.1 PR05.1
Purchase-From Location vendor, if defined. Must be a valid PR05.3 PR226
record in the Vendor Location file. If PR247 PR26.1
present, the address defined for the PR47.1 PR514
location overrides the vendor address UK47.1
for storing vendor purchase activity
balances.
VEN-PAY-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Element: Pay Vendor The pay vendor for the vendor, if AM15.2 AM15.3
applicable. Used to send invoice AM15.4 AM20.1
payments to another vendor within the AM20.3 AM21.1
same vendor group. If present, the pay AM21.3 AM500
vendor relationship overrides the normal AM51.1 AM551
remit-to information for the vendor, AM97.1 AP10.3
including remit-to name and address, AP100 AP11.1
cash code, and payment code. Must be a AP510 AP520
valid record in the Vendor file. API3.1 API4.1
IC840 PR05.1
Although payments are remitted to the PR05.3 PR226
pay vendor, the invoiced vendor PR247 PR26.1
accumulates the payment balance. If more PR47.1 PR514
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 AM15.1
Element: Status The vendor status. Invoices cannot be AM15.2 AM15.3
entered for a vendor with an Inactive AM15.4 AM20.1
status. Valid values are: AM20.3 AM21.1
AM21.3 AM500
A = Active. AM51.1 AM551
I = Inactive. AM97.1 AP10.3
AP100 AP115
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-VEN-PRIORITY Numeric 2 AM115 AM15.1
Element: Priority The payment priority assigned to the AM15.2 AM15.3
vendor. Valid values are 1 (highest AM15.4 AM20.1
priority) through 99 (lowest priority). 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 PR514
UK47.1
VEN-PHONE-PREFIX Alpha 6 AM115 AM15.1
Telephone Country The country code for the vendor AM15.2 AM15.3
Code telephone number. 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
PR514 UK47.1
VEN-PHONE-NUM Alpha 15 AM115 AM15.1
Element: Telephone NumbThe telephone number for the vendor. 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
PR514 UK47.1
VEN-PHONE-EXT Alpha 5 AM115 AM15.1
Element: Telephone ExteThe telephone extension number for the AM15.2 AM15.3
vendor. 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
PR514 UK47.1
VEN-FAX-PREFIX Alpha 6 AM115 AM15.1
Telephone Country The country code for the fax machine AM15.2 AM15.3
Code telephone number. 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
PR514 UK47.1
VEN-FAX-NUM Alpha 15 AM115 AM15.1
Element: Telephone NumbThe fax machine telephone number. 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
PR514 UK47.1
VEN-FAX-EXT Alpha 5 AM115 AM15.1
Element: Telephone ExteThe fax machine telephone number AM15.2 AM15.3
extension. 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
PR514 UK47.1
VEN-TELEX-NUM Alpha 15 AM115 AM15.1
Element: Telex The telex number for the vendor. 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
PR514 UK47.1
VEN-TERM-CODE Alpha 5 AM115 AM15.1
Element: Payment Terms The payment terms code assigned to the AM15.2 AM15.3
vendor. Used to automatically calculate AM15.4 AM20.1
invoice due date and discount AM20.3 AM21.1
information for the vendor's invoices. AM21.3 AM500
Must be a valid record in the Terms Code AM51.1 AM551
file. AM97.1 AP110
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-INV-CURRENCY Alpha 5 AM115 AM15.1
Element: Invoice CurrenThe currency used to add invoices for AM15.2 AM15.3
the vendor. The currency code defaults AM15.4 AM20.1
on the vendor's invoices during entry. AM20.3 AM21.1
Must be a valid record in the Currency AM21.3 AM500
Code file. If left blank, the vendor AM51.1 AM551
uses the invoice currency assigned to AM97.1 AP100
the vendor class, if assigned, or the AP110 AP510
company base currency. API3.1 API4.1
IC840 PR05.1
If the Balance Currency field contains PR05.3 PR226
a non-base currency, the Invoice PR247 PR26.1
Currency must be either the same PR47.1 PR514
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 AM15.1
Element: Vendor BalanceThe currency used to store vendor AM15.2 AM15.3
balance information. Must be a valid AM15.4 AM20.1
record in the Currency Code file. If AM20.3 AM21.1
left blank, the company base currency is AM21.3 AM500
used. AM51.1 AM551
AM97.1 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-CURR-RECALC Alpha 1 AM115 AM15.1
Currency If the Invoice Currency is different AM15.2 AM15.3
Recalculation from the company base currency, this AM15.4 AM20.1
field indicates whether the system will AM20.3 AM21.1
recalculate the invoice currency when AM21.3 AM500
the invoice is paid to account for AM51.1 AM551
exchange rate fluctuations. If Yes is AM97.1 AP10.3
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 PR514
AP170 (Payment Closing) creates a UK47.1
currency gain or loss transaction. Valid
values are:
N = No.
Y = Yes.
VEN-SEP-CHK-FLAG Alpha 1 AM115 AM15.1
Element: Separate PaymeIndicates whether to create a separate AM15.2 AM15.3
payment for each invoice entered for the AM15.4 AM20.1
vendor. Valid values are: AM20.3 AM21.1
AM21.3 AM500
N = No. AM51.1 AM551
Y = Yes. AM97.1 AP10.3
AP100 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-TAX-ID Alpha 20 AM115 AM15.1
Element: Tax ID The tax identification number for the AM15.2 AM15.3
vendor. Used for reporting reportable AM15.4 AM20.1
vendor income. 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
PR514 UK47.1
VEN-TAX-EXEMPT-CD Alpha 1 AM115 AM15.1
Element: Tax Exempt Code AM15.2 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
PR514 UK47.1
VEN-TAX-CODE Alpha 10 AM115 AM15.1
Element: Tax Code The tax code assigned to the vendor. AM15.2 AM15.3
Used to automatically calculate invoice AM15.4 AM20.1
tax information. Must be a valid record AM20.3 AM21.1
in the Tax Code file. If left blank, the AM21.3 AM500
tax code assigned to the vendor class AM51.1 AM551
defaults. AM97.1 AP100
AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
TX140 UK47.1
VEN-HOLD-FLAG Alpha 1 AM115 AM15.1
Element: Hold Code This field enables this entire lot to AM15.2 AM15.3
be put on hold, not allowing any issues AM15.4 AM20.1
or transfers to be made for this lot. AM20.3 AM21.1
Y = Yes 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
PR514 UK47.1
VEN-DIST-CODE Alpha 9 AM115 AM15.1
Element: Distribution CThe distribution code assigned to the AM15.2 AM15.3
vendor. Used to automatically create AM15.4 AM20.1
distribution lines for the vendor's AM20.3 AM21.1
invoices. Must be a valid record in the AM21.3 AM500
Distribution Code file. If left blank, AM51.1 AM551
the distribution code assigned to the AM97.1 AP100
vendor class, if assigned, defaults. AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-ACCR-CODE Alpha 4 AM115 AM15.1
Element: Invoice AccruaThe invoice accrual code assigned to AM15.2 AM15.3
the vendor. Used to default a general AM15.4 AM20.1
ledger accrual account to the vendor's AM20.3 AM21.1
invoices during entry. Must be a valid AM21.3 AM500
record in the Invoice Accrual Code file. AM51.1 AM551
If left blank, the invoice accrual code AM97.1 AP100
assigned to the vendor class, if AP110 AP510
assigned, or the company defaults. API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-BANK-INST-CODE Alpha 3 AM115 AM15.1
Element: Payment Code The payment code assigned to the AM15.2 AM15.3
vendor. Represents a type of cash AM15.4 AM20.1
payment, such as a check or payment AM20.3 AM21.1
tape, or a bill of exchange payment. AM21.3 AM500
Must be a valid cash or bill of exchange AM51.1 AM551
payment transaction code record in the AM97.1 AP100
Bank Transaction Code file. AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-CASH-CODE Alpha 4 AM115 AM15.1
Element: Cash Code The cash code assigned to the vendor. AM15.2 AM15.3
Represents a bank account. Must be a AM15.4 AM20.1
valid record in the Cash Code file. If AM20.3 AM21.1
left blank, the cash code assigned to AM21.3 AM500
the vendor class, if assigned, defaults, AM51.1 AM551
or the vendor uses the cash code AM97.1 AP100
assigned to the company or the pay AP110 AP125
group. AP126 AP151
AP156 AP180
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP20.8 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP510 AP56.1
AP56.2 AP80.1
API1.1 API3.1
API4.1 IC840
MA41.2 MA41.7
MA43.2 MA61.1
MAI1.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-BANK-ENTITY Alpha 15 AM115 AM15.1
Element: Bank The bank identification used to deposit AM15.2 AM15.3
electronic payments for the vendor. This AM15.4 AM20.1
field is required for ACH or BACS AM20.3 AM21.1
payment types. 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
PR514 UK47.1
VEN-VBANK-ACCT-NO Alpha 17 AM115 AM15.1
Element: Bank Account NThe bank account number used to deposit AM15.2 AM15.3
electronic payments for the vendor. This AM15.4 AM20.1
field is required for ACH or BACS AM20.3 AM21.1
payment types. 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
PR514 UK47.1
VEN-VBANK-ACCT-TP Alpha 1 AM115 AM15.1
Vendor Bank Account Indicates the type of bank account used AM15.2 AM15.3
Type to deposit electronic payments for the AM15.4 AM20.1
vendor. Valid values are: AM20.3 AM21.1
AM21.3 AM500
C = Current/Checking Account. AM51.1 AM551
S = Savings Account. AM97.1 AP100
Blank = Electronic payment type not AP510 API3.1
selected. API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-INCOME-CODE Alpha 4 AM115 AM15.1
Element: Income Code The income code assigned to the vendor. AM15.2 AM15.3
Used to track reportable income for the AM15.4 AM20.1
vendor. Must be a valid record in the AM20.3 AM21.1
Income Code file. 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 PR514
UK47.1
VEN-INCOME-WH-FLG Alpha 1 AM115 AM15.1
Element: Income WithholIndicates whether invoices for the AM15.2 AM15.3
vendor are subject to reportable income AM15.4 AM20.1
withholding. Valid values are: AM20.3 AM21.1
AM21.3 AM500
N = No. AM51.1 AM551
Y = Yes. AM97.1 AP10.3
AP100 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-EDI-NBR Alpha 15 AM115 AM15.1
Element: EDI Number The vendor's electronic data AM15.2 AM15.3
interchange (EDI) number. Used for AM15.4 AM20.1
reference. 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
PR514 UK47.1
VEN-ACH-PRENOT Alpha 1 AM115 AM15.1
ACH Prenotification Used in conjunction with ACH payments AM15.2 AM15.3
Status created for the vendor. Indicates the AM15.4 AM20.1
status of the electronic payment between AM20.3 AM21.1
the vendor and the processing bank. AM21.3 AM500
Valid values are: AM51.1 AM551
AM97.1 AP100
N = Notified. AP160 (Payment Tape AP110 AP160
Creation) automatically changes the AP510 API3.1
status from Prenotified to Notified to API4.1 IC840
indicate that the processing bank has PR05.1 PR05.3
been notified but has not yet accepted PR226 PR247
the electronic payment tape. PR26.1 PR47.1
PR514 UK47.1
P = Prenotified. Select this status
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 15.2 AM115 AM15.1
Maximum Invoice The maximum single invoice amount that AM15.2 AM15.3
Amount can be entered for the vendor. 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
PR514 UK47.1
VEN-CREATE-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Element: Date The date the vendor record was created AM15.2 AM15.3
in the Lawson Accounts Payable system. 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
PR514 UK47.1
VEN-ORIGIN-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Element: Date The origin date for the vendor. Can be AM15.2 AM15.3
used record additional information, such AM15.4 AM20.1
as the date the vendor relationship AM20.3 AM21.1
began. If left blank, the system date AM21.3 AM500
defaults. 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
PR514 UK47.1
VEN-OPERATOR Alpha 10 AM115 AM15.1
Element: Operator Code The operator associated with AM15.2 AM15.3
maintaining the vendor record. 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 PR514
UK47.1
VEN-USER-NAME-01 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the first AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-USER-NAME-02 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the second AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-USER-NAME-03 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the third AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-USER-NAME-04 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the fourth AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-USER-NAME-05 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the fifth AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-USER-NAME-06 Alpha 20 AM115 AM15.1
Element: User Defined FThe value of the information being AM15.2 AM15.3
tracked for the vendor in the sixth AM15.4 AM20.1
vendor group user field. 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
PR514 UK47.1
VEN-CUST-GROUP Alpha 5 AM115 AM15.1
Element: Customer GroupIf the accounts payable vendor is also AM15.2 AM15.3
a customer in the Lawson Accounts AM15.4 AM20.1
Receivable system, this field can be AM20.3 AM21.1
used to identify the customer group AM21.3 AM500
associated with the corresponding AM51.1 AM551
accounts receivable customer. Used to AM97.1 AP100
update the accounts receivable customer API3.1 API4.1
record. AR09.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-CUSTOMER Alpha 9 (Right Justified) AM115 AM15.1
Element: Customer If the accounts payable vendor is also AM15.2 AM15.3
a customer in the Lawson Accounts AM15.4 AM20.1
Receivable system, this field can be AM20.3 AM21.1
used to identify the corresponding AM21.3 AM500
accounts receivable customer number. AM51.1 AM551
Used to update the accounts receivable AM97.1 AP100
customer record. API3.1 API4.1
AR09.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-LEGAL-NAME Alpha 80 (Lower Case) AM115 AM15.1
Element: Legal Name The legal name for the vendor. Used for AM15.2 AM15.3
reporting reportable vendor income. If AM15.4 AM20.1
left blank, the Vendor Name defaults. 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
PR514 UK47.1
VEN-PRIME-RATE Signed 7.5 AM115 AM15.1
Anticipation The percentage used to calculate AM15.2 AM15.3
Discount Rate anticipation discount invoices; most AM15.4 AM20.1
often the prime rate plus one percent. AM20.3 AM21.1
To calculate the discount for an AM21.3 AM500
anticipation invoice, the system AM51.1 AM551
subtracts the invoice payment date from AM97.1 AP100
the invoice due date to calculate the AP510 API3.1
number of days paid early, multiplies API4.1 IC840
the number of days paid early by 365 PR05.1 PR05.3
days, multiplies the result by the PR226 PR247
anticipation discount rate, and PR26.1 PR47.1
multiplies the result by the payment PR514 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 AM15.1
Element: Invoice Group A user-defined invoice group assigned AM15.2 AM15.3
to the vendor. This value defaults on AM15.4 AM20.1
invoices entered for the vendor. Can be AM20.3 AM21.1
used to select invoices for payment in AM21.3 AM500
AP150 (Cash Requirements). AM51.1 AM551
AM97.1 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-DISCOUNT-CODE Alpha 10 AM115 AM15.1
Element: Discount Code The discount code assigned to the AM15.2 AM15.3
vendor. Used to default a general ledger AM15.4 AM20.1
discount account on the vendor's AM20.3 AM21.1
invoices during entry. Must be a valid AM21.3 AM500
record in the Discount Code file. AM51.1 AM551
AM97.1 AP100
AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-ERS-CAPABLE Alpha 1 AM115 AM15.1
Element: ERS Capable Indicates whether the vendor location AM15.2 AM15.3
has the capability to process ERS. Valid AM15.4 AM20.1
values are: AM20.3 AM21.1
AM21.3 AM500
N = No. AM51.1 AM551
Y = Yes. AM97.1 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-INVC-REF-TYPE Alpha 2 AM115 AM15.1
ERS Invoice Indicates the type of number the vendor AM15.2 AM15.3
Reference is providing to reference the invoice. AM15.4 AM20.1
Valid values are: AM20.3 AM21.1
AM21.3 AM500
BM = Bill of Lading Number. AM51.1 AM551
IN = Invoice Number. AM97.1 AP100
OW = Service Order Number. AP510 API3.1
PL = Packing List Number. API4.1 IC840
PO = PO Number. PR05.1 PR05.3
VN = Vendor Order Number. PR226 PR247
WO = Work Order Number. PR26.1 PR47.1
WP = Warehouse Pick Ticket Number. PR514 UK47.1
ZZ = Mutually Defined Number.
VEN-EDI-AUTO-REL Alpha 1 AM115 AM15.1
EDI Invoice Auto Indicates whether the company AM15.2 AM15.3
Release automatically releases EDI invoices. AM15.4 AM20.1
Valid values are: AM20.3 AM21.1
AM21.3 AM500
N = No. AM51.1 AM551
Y = Yes. AM97.1 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-AUTH-CODE Alpha 3 AM115 AM15.1
Element: Authority CodeThe authority code assigned to the AM15.2 AM15.3
vendor, if assigned. Represents a person AM15.4 AM20.1
or department responsible for approving AM20.3 AM21.1
registered invoices for the vendor. This AM21.3 AM500
code defaults on the vendor's invoices AM51.1 AM551
during entry. Must be a valid authority AM97.1 AP100
code in the Authority Code file. AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-APPRVL-EXISTS Alpha 1 AM115 AM15.1
Approval Indicates whether approval criteria is AM15.2 AM15.3
Information Exists defined for the vendor. If Yes, one or AM15.4 AM20.1
more associated approval records exist AM20.3 AM21.1
for the vendor in the Invoice Approval AM21.3 AM500
file. Valid values are: AM51.1 AM551
AM97.1 AP10.7
N = No. AP100 API3.1
Y = Yes. API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-ACTIVITY Alpha 15 AM115 AM15.1
Element: Activity The activity assigned to the vendor, if AM15.2 AM15.3
assigned. Activities are the tasks that AM15.4 AM20.1
make up an activity group. Activities AM20.3 AM21.1
identify work being done, such as work AM21.3 AM500
orders, phases, products, and so on. AM51.1 AM551
Must be a valid record in the Activity AM97.1 AP100
file. AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-ACCT-CATEGORY Alpha 5 AM115 AM15.1
Element: Account CategoThe account category assigned to the AM15.2 AM15.3
vendor. Account categories are the AM15.4 AM20.1
Activity Management accounts by which AM20.3 AM21.1
activity transactions are grouped for AM21.3 AM500
budgeting and reporting. Must be a valid AM51.1 AM551
record in the Activity Account Category AM97.1 AP100
file. AP110 AP510
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VEN-CHARGE-CODE Alpha 1 AM115 AM15.1
Element: Charge Code Indicates who pays service charges or AM15.2 AM15.3
fees associated with a SWIFT payment. AM15.4 AM20.1
Valid values are: AM20.3 AM21.1
AM21.3 AM500
I = Issuer. AM51.1 AM551
R = Receiver. AM97.1 AP100
Blank = Not defined for the vendor. AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-PMT-CAT-CODE Alpha 1 AM115 AM15.1
Payment Category Indicates the payment category of the AM15.2 AM15.3
Code SWIFT payment. Valid values are: AM15.4 AM20.1
AM20.3 AM21.1
G = Goods. AM21.3 AM500
T = Transit Trade. AM51.1 AM551
S = Service and Capital. AM97.1 AP100
X = Transfer. AP510 API3.1
O = Other. API4.1 IC840
Blank = Not defined for the vendor. PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-NORM-EXP-CODE Alpha 1 AM115 AM15.1
Normal or Express Indicates whether the SWIFT payment is AM15.2 AM15.3
Code a normal or express payment. Valid AM15.4 AM20.1
values are: AM20.3 AM21.1
AM21.3 AM500
N = Normal. AM51.1 AM551
E = Express. AM97.1 AP100
Blank = Not defined for the vendor. AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-PMT-FORM Alpha 1 AM115 AM15.1
Element: Payment Form Indicates how the SWIFT payment is AM15.2 AM15.3
made. Valid values are: AM15.4 AM20.1
AM20.3 AM21.1
C = Check. AM21.3 AM500
B = Foreign Bank. AM51.1 AM551
Blank = Not defined for the vendor. AM97.1 AP100
F = Foreign Bank AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-SWIFT-ID Alpha 12 AM115 AM15.1
Element: Swift ID The SWIFT identification number AM15.2 AM15.3
assigned to the vendor. 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
PR514 UK47.1
VEN-PROC-GRP Alpha 4 (Lower Case) AM115 AM15.1
Element: Process Group A process group is an identifier used AM15.2 AM15.3
for separating vendors into different AM15.4 AM20.1
groups to enable concurrent processing AM20.3 AM21.1
within the cash payment cycle. 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 PR514
UK47.1
VEN-MATCH-TABLE Alpha 10 AM115 AM15.1
Element: Match Table A code representing a match table. A AM15.2 AM15.3
match table contains the processing AM15.4 AM20.1
rules that will be used during matching. 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 PR514
UK47.1
VEN-DISC-CALC-DATE Alpha 1 AM115 AM15.1
Discount Indicates which date to use when AM15.2 AM15.3
Calculation Date calculating discounts. AM15.4 AM20.1
AM20.3 AM21.1
You can use the invoice date, receipt AM21.3 AM500
date, or the date the invoice was AM51.1 AM551
received. AM97.1 AP100
" " AP510 API3.1
D = Receipt of Invoice Date API4.1 IC840
I = Invoice Date PR05.1 PR05.3
R = Latest Receipt Date PR226 PR247
E = Earliest Receipt Date PR26.1 PR47.1
PR514 UK47.1
VEN-CREATE-POD-FL Alpha 1 AM115 AM15.1
Proof of Delivery Indicates whether to create a proof of AM15.2 AM15.3
Created delivery. AM15.4 AM20.1
AM20.3 AM21.1
Valid values are: AM21.3 AM500
AM51.1 AM551
N = No AM97.1 AP100
Y = Yes AP510 API3.1
" " API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-HANDLING-CODE Alpha 4 AM115 AM15.1
Invoice Handling Invoice handling code. Determines the AM15.2 AM15.3
Code processing rules that will be used AM15.4 AM20.1
during matching. 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 PR514
UK47.1
VEN-ENCLOSURE Alpha 1 AM115 AM15.1
Element: Enclosure Indicates whether the invoice requires AM15.2 AM15.3
an enclosure with its payment. AM15.4 AM20.1
Y = Yes AM20.3 AM21.1
N = No 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
PR514 UK47.1
VEN-REQ-MATCH-REF Alpha 1 AM115 AM15.1
Match Reference Indicates whether a match reference AM15.2 AM15.3
Required number is required for invoices for this AM15.4 AM20.1
vendor. AM20.3 AM21.1
Y = Yes AM21.3 AM500
N = No AM51.1 AM551
AM97.1 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-POOL-OPTION Numeric 1 AM115 AM15.1
Element: Au Flag 1 = Company Vendor AM15.2 AM15.3
2 = Company Vendor PO AM15.4 AM20.1
3 = Company Vendor PO ShipTo AM20.3 AM21.1
0 = MA Company Default 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
PR514 UK47.1
VEN-HOLD-INSP-FLAG Alpha 1 AM115 AM15.1
Element: Hold Insp FlagIf set to "Y", this flag will keep AM15.2 AM15.3
receiving lines requiring inspection AM15.4 AM20.1
from being matched until they have been AM20.3 AM21.1
inspected. AM21.3 AM500
Y = Yes AM51.1 AM551
N = No AM97.1 AP100
" " = Use Company AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VEN-WRITE-OFF-AMT Signed 15.2 AM115 AM15.1
Element: Invoice Amount 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
PR514 UK47.1
VEN-VEN-CLAIM-TYPE Alpha 2 AM115 AM15.1
Element: Vendor Claim TCB = Chargeback AM15.2 AM15.3
CM = Credit Memo AM15.4 AM20.1
N = None 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 PR514
UK47.1
VEN-CLAIM-HOLD-CD Alpha 4 AM115 AM15.1
Element: Hold Code 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
PR514 UK47.1
VEN-CB-HOLD-CODE Alpha 4 AM115 AM15.1
Vendor Claims AM15.2 AM15.3
Chargeback Hold 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
PR514 UK47.1
VEN-CB-MINIMUM-AMT Signed 15.2 AM115 AM15.1
Element: Minimum Claim Amount 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
PR514 UK47.1
VEN-REPLACE-GOODS Alpha 1 AM115 AM15.1
Element: Replace Goods Y = Yes AM15.2 AM15.3
N = No 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
PR514 UK47.1
VEN-SHIP-OR-HOLD Alpha 1 AM115 AM15.1
Element: Ship or Hold GS = Ship AM15.2 AM15.3
H = Hold 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 PR514
UK47.1
VEN-ERS-HANDLING Alpha 4 AM115 AM15.1
Element: Handling Code 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
PR514 UK47.1
VEN-E-MAIL-ADDRESS Alpha 60 (Lower Case) AM115 AM15.1
Element: Email Address 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
PR514 UK47.1
VEN-URL-ADDR Alpha 60 (Lower Case) AM115 AM15.1
Element: Url Addr 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
PR514 UK47.1
VEN-VEND-ACCT Alpha 30 AM115 AM15.1
Element: Vend Acct The customer number the vendor has AM15.2 AM15.3
assigned to you. 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
PR514 UK47.1
VEN-LANGUAGE-CODE Alpha 10 AM115 AM15.1
Element: Language Code Language Code (LOCALE). 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
PR514 UK47.1
VEN-TAX-USAGE-CD Alpha 10 AM115 AM15.1
Element: Tax Usage Cd The tax usage coe for the vendor. This AM15.2 AM15.3
filed is required if the AP Company AM15.4 AM20.1
inidcates that VAT reporting required. 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
PR514 UK47.1
VEN-VAT-REG-CTRY Alpha 2 AM115 AM15.1
Element: Vat Reg Ctry The country component of the VAT AM15.2 AM15.3
Registration Number. This field, AM15.4 AM20.1
together with the Registration Number AM20.3 AM21.1
for the company on the tax transaction. 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 PR514
UK47.1
VEN-VAT-REG-NBR Alpha 12 AM115 AM15.1
Element: Vat Reg Nbr The number component of the VAT AM15.2 AM15.3
Registration Number. This field together AM15.4 AM20.1
with the Registration Country field make AM20.3 AM21.1
up the VAT Registration Number. 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 PR514
UK47.1
VEN-VALIDATE-PO Alpha 1 AM115 AM15.1
Element: Validate Po " " = MA Company Default AM15.2 AM15.3
Y = Yes AM15.4 AM20.1
N = No 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
PR514 UK47.1
VEN-REQUIRE-PO Alpha 1 AM115 AM15.1
Element: Require Po " " = MA Company Default AM15.2 AM15.3
Y = Yes AM15.4 AM20.1
N = No 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
PR514 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
Vendor Address Line Vendor address line 1.
1
VEN-VDR-ADDR2 Derived
Vendor Address Line Vendor address line 2.
2
VEN-VDR-ADDR3 Derived
Vendor Address Line Vendor address line 3.
3
VEN-VDR-ADDR4 Derived
Vendor Address Line Vendor address line 4.
4
VEN-VDR-CITY-ADDR5 Derived
Vendor City or Vendor city or address line 5.
Address Line 5
VEN-VDR-STATE Derived
Vendor State or Vendor state or province.
Province
VEN-VDR-POSTAL Derived
Element: Vendor Postal Vendor postal code.
VEN-VDR-COUNTY Derived
Element: Vendor County Vendor county.
VEN-VDR-COUNTRY Derived
Element: Vendor CountryVendor 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 AM15.1
Element: Workflow Group AM15.2 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
PR514 UK47.1
APVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP This index is used to access and AC210 AC297
VENDOR validate vendor records for a specific AM115 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 AP10.1
AP10.2 AP10.3
AP10.5 AP10.6
AP10.7 AP10.9
AP100 AP102
AP109 AP11.1
AP110 AP115
...
VENSET10 VENDOR-GROUP KeyChange AP130
CREATE-POD-FL
VENDOR
VENSET2 VENDOR-GROUP This index is used to access vendor AM115 AM15.1
VEN-CLASS records within a specific vendor class AM15.2 AM15.3
VENDOR for a vendor group. AM15.4 AM20.1
KeyChange AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP100 AP102
AP110 AP251
AP252 AP300
API3.1 API4.1
IC840 PO120
POAV.1 PR05.1
PR05.3 PR226
PR247 PR26.1
...
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 AM15.1
VENDOR-SNAME records in search name sequence. AM15.2 AM15.3
VENDOR KeyChange 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
PR514 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 AC297
EDI-NBR validate vendor records by EDI number. AM115 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
"Y" -> VDR-CUR-ADDR
Approcgrp APPROCGRP Not Required
VEN-PROC-GRP -> APQ-PROC-GRP
Apvengroup APVENGROUP Required
VEN-VENDOR-GROUP -> VGP-VENDOR-GROUP
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
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
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
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
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
|