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 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 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 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 DA290 GL284 GL285 IC522
IC526 IC527 IC530 IC531 IC81.1 MA41.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.5 MA43.7
MA43.8 MA531 MA540 MA61.1 MA63.1 MA64.1
MA64.4 MA64.6 MA66.1 MA66.2 MA66.3 MA70.1
MA95.1 MA95.2 MAI1.1 PO120 PO132 PO150
PO16.1 PO16.2 PO204 PO226 PO227 PO231
PO25.1 PO25.7 PO25.8 PO254 PO27.2 PO27.4
PO30.1 PO30.2 PO30.3 PO33.1 PO34.1 PO52.1
POAV.1 PR05.1 PR05.3 PR198 PR226 PR247
PR26.1 PR47.1 PR514 IN120 IN20.1 TX100
WH30.2 WH30.4 WH31.2 WH31.4 WH32.4 WH38.1
WH40.1 WH40.2 AP02.3 AP202 MA05.1 MA05.2
UPDATED BY
AP10.3 AP10.7 AP100 AP102 AP110 AP115
AP160 AP170 AP300 AP40.2 AP510 AP520
API3.1 API4.1 AR09.1 IC840 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP Alpha 4 AP10.3 AP100
Vendor Group The vendor group to which the vendor AP510 AP520
belongs. Must be a valid record in the API3.1 API4.1
Vendor Group file. IC840
VEN-VENDOR Alpha 9 (Right Justified) AP10.3 AP100
Vendor The identification number assigned to AP510 AP520
the vendor. API3.1 API4.1
IC840
VEN-VEN-CLASS Alpha 3 AP10.3 AP100
Vendor Class The vendor class the vendor is assigned AP510 AP520
to. Represents a group of vendors that API3.1 API4.1
share common characteristics within a IC840
vendor group. Must be a valid record in
the Vendor Class file.
VEN-VENDOR-VNAME Alpha 30 (Lower Case) AP10.3 AP100
Vendor Name The vendor name or description. AP166 AP510
AP520 API3.1
API4.1 IC840
WH30.2 WH30.4
WH31.2 WH31.4
WH32.4 WH38.1
WH40.1 WH40.2
VEN-VENDOR-SNAME Alpha 30 AP10.3 AP100
Search Name The search name for the vendor. AP510 AP520
API3.1 API4.1
IC840
VEN-VENDOR-CONTCT Alpha 30 AP100 AP510
Contact The name of the main contact for the API3.1 API4.1
vendor. IC840
VEN-REMIT-TO-CODE Alpha 4 AP100 AP510
Normal Remit-To The normal remittance location for the API3.1 API4.1
Location vendor, if defined. Must be a valid IC840
record in the Vendor Location file. If
present, the address defined for the
location overrides the vendor address on
vendor payments when invoices are added.
VEN-PURCH-FR-LOC Alpha 4 AP100 AP510
Normal The normal purchasing location for the API3.1 API4.1
Purchase-From Locatiovendor, if defined. Must be a valid IC840
record in the Vendor Location file. If
present, the address defined for the
location overrides the vendor address
for storing vendor purchase activity
balances.
VEN-PAY-VENDOR Alpha 9 (Right Justified) AP100 AP510
Pay Vendor The pay vendor for the vendor, if API3.1 API4.1
applicable. Used to send invoice IC840
payments to another vendor within the
same vendor group. If present, the pay
vendor relationship overrides the normal
remit-to information for the vendor,
including remit-to name and address,
cash code, and payment code. Must be a
valid record in the Vendor file.
Although payments are remitted to the
pay vendor, the invoiced vendor
accumulates the payment balance. If more
than one vendor shares the same pay
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 AP10.3 AP100
Status The vendor status. Invoices cannot be AP115 AP510
entered for a vendor with an Inactive AP520 API3.1
status. Valid values are: API4.1 IC840
A = Active.
I = Inactive.
VEN-VEN-PRIORITY Numeric 2 AP10.3 AP100
Priority The payment priority assigned to the AP110 AP510
vendor. Valid values are 1 (highest AP520 API3.1
priority) through 99 (lowest priority). API4.1 IC840
VEN-PHONE-PREFIX Alpha 6 AP100 AP510
Telephone Country The country code for the vendor API3.1 API4.1
Code telephone number. IC840
VEN-PHONE-NUM Alpha 15 AP100 AP510
Telephone Number The telephone number for the vendor. API3.1 API4.1
IC840
VEN-PHONE-EXT Alpha 5 AP100 AP510
Telephone Extension The telephone extension number for the API3.1 API4.1
vendor. IC840
VEN-FAX-PREFIX Alpha 6 AP100 AP510
Fax Country Code The country code for the fax machine API3.1 API4.1
telephone number. IC840
VEN-FAX-NUM Alpha 15 AP100 AP510
Fax Number The fax machine telephone number. API3.1 API4.1
IC840
VEN-FAX-EXT Alpha 5 AP100 AP510
Fax Extension The fax machine telephone number API3.1 API4.1
extension. IC840
VEN-TELEX-NUM Alpha 15 AP100 AP510
Telex The telex number for the vendor. API3.1 API4.1
IC840
VEN-TERM-CODE Alpha 5 AP110 AP510
Payment Terms The payment terms code assigned to the API3.1 API4.1
vendor. Used to automatically calculate IC840
invoice due date and discount
information for the vendor's invoices.
Must be a valid record in the Terms Code
file.
VEN-INV-CURRENCY Alpha 5 AP100 AP110
Invoice Currency The currency used to add invoices for AP510 API3.1
the vendor. The currency code defaults API4.1 IC840
on the vendor's invoices during entry.
Must be a valid record in the Currency
Code file. If left blank, the vendor
uses the invoice currency assigned to
the vendor class, if assigned, or the
company base currency.
If the Balance Currency field contains
a non-base currency, the Invoice
Currency must be either the same
non-base currency or the company base
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 AP100 AP510
Vendor Balance The currency used to store vendor API3.1 API4.1
balance information. Must be a valid IC840
record in the Currency Code file. If
left blank, the company base currency is
used.
VEN-CURR-RECALC Alpha 1 AP100 AP510
Currency If the Invoice Currency is different API3.1 API4.1
Recalculation from the company base currency, this IC840
field indicates whether the system will
recalculate the invoice currency when
the invoice is paid to account for
exchange rate fluctuations. If Yes is
selected in this field, the system
compares the exchange rate in effect
when the invoice was entered to the
exchange rate in effect when the invoice
is scheduled for payment by AP150 (Cash
Requirements). If a difference exists,
AP170 (Payment Closing) creates a
currency gain or loss transaction. Valid
values are:
N = No.
Y = Yes.
VEN-SEP-CHK-FLAG Alpha 1 AP10.3 AP100
Separate Payment Indicates whether to create a separate AP510 AP520
payment for each invoice entered for the API3.1 API4.1
vendor. Valid values are: IC840
N = No.
Y = Yes.
VEN-TAX-ID Alpha 20 AP10.3 AP100
Tax ID The tax identification number for the AP510 AP520
vendor. Used for reporting reportable API3.1 API4.1
vendor income. IC840
VEN-TAX-EXEMPT-CD Alpha 1 API3.1 API4.1
Tax Exempt Code IC840
VEN-TAX-CODE Alpha 10 AP100 AP110
Tax Code The tax code assigned to the vendor. AP510 API3.1
Used to automatically calculate invoice API4.1 IC840
tax information. Must be a valid record TX140
in the Tax Code file. If left blank, the
tax code assigned to the vendor class
defaults.
VEN-HOLD-FLAG Alpha 1 AP100 AP170
Hold Code This field enables this entire lot to AP40.2 AP510
be put on hold, not allowing any issues API3.1 API4.1
or transfers to be made for this lot. IC840
Y = Yes
" "
VEN-DIST-CODE Alpha 9 AP100 AP110
Distribution Code The distribution code assigned to the AP510 API3.1
vendor. Used to automatically create API4.1 IC840
distribution lines for the vendor's
invoices. Must be a valid record in the
Distribution Code file. If left blank,
the distribution code assigned to the
vendor class, if assigned, defaults.
VEN-ACCR-CODE Alpha 4 AP100 AP110
Invoice Accrual Code The invoice accrual code assigned to AP510 API3.1
the vendor. Used to default a general API4.1 IC840
ledger accrual account to the vendor's
invoices during entry. Must be a valid
record in the Invoice Accrual Code file.
If left blank, the invoice accrual code
assigned to the vendor class, if
assigned, or the company defaults.
VEN-BANK-INST-CODE Alpha 3 AP100 AP110
Payment Code The payment code assigned to the AP510 API3.1
vendor. Represents a type of cash API4.1 IC840
payment, such as a check or payment
tape, or a bill of exchange payment.
Must be a valid cash or bill of exchange
payment transaction code record in the
Bank Transaction Code file.
VEN-CASH-CODE Alpha 4 AP100 AP110
Cash Code The cash code assigned to the vendor. AP125 AP126
Represents a bank account. Must be a AP151 AP156
valid record in the Cash Code file. If AP180 AP20.1
left blank, the cash code assigned to AP20.2 AP20.3
the vendor class, if assigned, defaults, AP20.4 AP20.5
or the vendor uses the cash code AP20.7 AP20.8
assigned to the company or the pay AP23.1 AP25.1
group. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP510
AP56.1 AP56.2
AP80.1 API3.1
API4.1 IC840
MA41.2 MA43.2
MA61.1 MAI1.1
VEN-BANK-ENTITY Alpha 15 AP100 AP510
Bank The bank identification used to deposit API3.1 API4.1
electronic payments for the vendor. This IC840
field is required for ACH or BACS
payment types.
VEN-VBANK-ACCT-NO Alpha 17 AP100 AP510
Vendor Bank Account The bank account number used to deposit API3.1 API4.1
Number electronic payments for the vendor. This IC840
field is required for ACH or BACS
payment types.
VEN-VBANK-ACCT-TP Alpha 1 AP100 AP510
Vendor Bank Account Indicates the type of bank account used API3.1 API4.1
Type to deposit electronic payments for the IC840
vendor. Valid values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type not
selected.
VEN-INCOME-CODE Alpha 4 AP10.3 AP100
Income Code The income code assigned to the vendor. AP110 AP510
Used to track reportable income for the AP520 API3.1
vendor. Must be a valid record in the API4.1 IC840
Income Code file.
VEN-INCOME-WH-FLG Alpha 1 AP10.3 AP100
Income Withholding Indicates whether invoices for the AP510 AP520
vendor are subject to reportable income API3.1 API4.1
withholding. Valid values are: IC840
N = No.
Y = Yes.
VEN-EDI-NBR Alpha 15 AP100 AP510
EDI Number The vendor's electronic data API3.1 API4.1
interchange (EDI) number. Used for IC840
reference.
VEN-ACH-PRENOT Alpha 1 AP100 AP110
ACH Prenotification Used in conjunction with ACH payments AP160 AP510
Status created for the vendor. Indicates the API3.1 API4.1
status of the electronic payment between IC840
the vendor and the processing bank.
Valid values are:
N = Notified. AP160 (Payment Tape
Creation) automatically changes the
status from Prenotified to Notified to
indicate that the processing bank has
been notified but has not yet accepted
the electronic payment tape.
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 AP100 AP510
Maximum Invoice The maximum single invoice amount that API3.1 API4.1
Amount can be entered for the vendor. IC840
VEN-CREATE-DATE Numeric 8 (yyyymmdd) AP10.3 AP100
Creation Date The date the vendor record was created AP510 AP520
in the Lawson Accounts Payable system. API3.1 API4.1
IC840
VEN-ORIGIN-DATE Numeric 8 (yyyymmdd) AP10.3 AP100
Origin Date The origin date for the vendor. Can be AP510 AP520
used record additional information, such API3.1 API4.1
as the date the vendor relationship IC840
began. If left blank, the system date
defaults.
VEN-OPERATOR Alpha 10 AP10.3 AP100
Operator Code The operator associated with AP510 API3.1
maintaining the vendor record. API4.1 IC840
VEN-USER-NAME-01 Alpha 20 AP100 AP510
User Defined Field 1 The value of the information being API3.1 API4.1
tracked for the vendor in the first IC840
vendor group user field.
VEN-USER-NAME-02 Alpha 20 AP100 AP510
User Defined Field 2 The value of the information being API3.1 API4.1
tracked for the vendor in the second IC840
vendor group user field.
VEN-USER-NAME-03 Alpha 20 AP100 AP510
User Defined Field 3 The value of the information being API3.1 API4.1
tracked for the vendor in the third IC840
vendor group user field.
VEN-USER-NAME-04 Alpha 20 AP100 AP510
User Defined Field 4 The value of the information being API3.1 API4.1
tracked for the vendor in the fourth IC840
vendor group user field.
VEN-USER-NAME-05 Alpha 20 AP100 AP510
User Defined Field 5 The value of the information being API3.1 API4.1
tracked for the vendor in the fifth IC840
vendor group user field.
VEN-USER-NAME-06 Alpha 20 AP100 AP510
User Defined Field 6 The value of the information being API3.1 API4.1
tracked for the vendor in the sixth IC840
vendor group user field.
VEN-CUST-GROUP Alpha 5 AP100 API3.1
Customer Group If the accounts payable vendor is also API4.1 AR09.1
a customer in the Lawson Accounts IC840
Receivable system, this field can be
used to identify the customer group
associated with the corresponding
accounts receivable customer. Used to
update the accounts receivable customer
record.
VEN-CUSTOMER Alpha 9 (Right Justified) AP100 API3.1
Customer If the accounts payable vendor is also API4.1 AR09.1
a customer in the Lawson Accounts IC840
Receivable system, this field can be
used to identify the corresponding
accounts receivable customer number.
Used to update the accounts receivable
customer record.
VEN-LEGAL-NAME Alpha 80 (Lower Case) AP10.3 AP100
Legal Name The legal name for the vendor. Used for AP510 AP520
reporting reportable vendor income. If API3.1 API4.1
left blank, the Vendor Name defaults. IC840
VEN-PRIME-RATE Signed 7.5 AP100 AP510
Anticipation The percentage used to calculate API3.1 API4.1
Discount Rate anticipation discount invoices; most IC840
often the prime rate plus one percent.
To calculate the discount for an
anticipation invoice, the system
subtracts the invoice payment date from
the invoice due date to calculate the
number of days paid early, multiplies
the number of days paid early by 365
days, multiplies the result by the
anticipation discount rate, and
multiplies the result by the payment
amount to calculate the discount amount.
Anticipation discount terms codes are
defined in the Lawson Terms system.
VEN-INVOICE-GROUP Alpha 4 AP100 AP510
Invoice Group A user-defined invoice group assigned API3.1 API4.1
to the vendor. This value defaults on IC840
invoices entered for the vendor. Can be
used to select invoices for payment in
AP150 (Cash Requirements).
VEN-DISCOUNT-CODE Alpha 10 AP100 AP110
Discount Code The discount code assigned to the AP510 API3.1
vendor. Used to default a general ledger API4.1 IC840
discount account on the vendor's
invoices during entry. Must be a valid
record in the Discount Code file.
VEN-ERS-CAPABLE Alpha 1 AP100 AP510
ERS Capable Indicates whether the vendor location API3.1 API4.1
has the capability to process ERS. Valid IC840
values are:
N = No.
Y = Yes.
VEN-INVC-REF-TYPE Alpha 2 AP100 AP510
ERS Invoice Indicates the type of number the vendor API3.1 API4.1
Reference is providing to reference the invoice. IC840
Valid values are:
BM = Bill of Lading Number.
IN = Invoice Number.
OW = Service Order Number.
PL = Packing List Number.
PO = PO Number.
VN = Vendor Order Number.
WO = Work Order Number.
WP = Warehouse Pick Ticket Number.
ZZ = Mutually Defined Number.
VEN-EDI-AUTO-REL Alpha 1 AP100 AP510
EDI Invoice Auto Indicates whether the company API3.1 API4.1
Release automatically releases EDI invoices. IC840
Valid values are:
N = No.
Y = Yes.
VEN-AUTH-CODE Alpha 3 AP100 AP110
Authority Code The authority code assigned to the AP510 API3.1
vendor, if assigned. Represents a person API4.1 IC840
or department responsible for approving
registered invoices for the vendor. This
code defaults on the vendor's invoices
during entry. Must be a valid authority
code in the Authority Code file.
VEN-APPRVL-EXISTS Alpha 1 AP10.7 AP100
Approval Indicates whether approval criteria is API3.1 API4.1
Information Exists defined for the vendor. If Yes, one or IC840
more associated approval records exist
for the vendor in the Invoice Approval
file. Valid values are:
N = No.
Y = Yes.
VEN-ACTIVITY Alpha 15 AP100 AP110
Activity The activity assigned to the vendor, if AP510 API3.1
assigned. Activities are the tasks that API4.1 IC840
make up an activity group. Activities
identify work being done, such as work
orders, phases, products, and so on.
Must be a valid record in the Activity
file.
VEN-ACCT-CATEGORY Alpha 5 AP100 AP110
Account Category The account category assigned to the AP510 API3.1
vendor. Account categories are the API4.1 IC840
Activity Management accounts by which
activity transactions are grouped for
budgeting and reporting. Must be a valid
record in the Activity Account Category
file.
VEN-CHARGE-CODE Alpha 1 AP100 AP510
Charge Code Indicates who pays service charges or API3.1 API4.1
fees associated with a SWIFT payment. IC840
Valid values are:
I = Issuer.
R = Receiver.
Blank = Not defined for the vendor.
VEN-PMT-CAT-CODE Alpha 1 AP100 AP510
Payment Category Indicates the payment category of the API3.1 API4.1
Code SWIFT payment. Valid values are: IC840
G = Goods.
T = Transit Trade.
S = Service and Capital.
X = Transfer.
O = Other.
Blank = Not defined for the vendor.
VEN-NORM-EXP-CODE Alpha 1 AP100 AP510
Normal or Express Indicates whether the SWIFT payment is API3.1 API4.1
Code a normal or express payment. Valid IC840
values are:
N = Normal.
E = Express.
Blank = Not defined for the vendor.
VEN-PMT-FORM Alpha 1 AP100 AP510
Payment Form Indicates how the SWIFT payment is API3.1 API4.1
made. Valid values are: IC840
C = Check.
B = Foreign Bank.
Blank = Not defined for the vendor.
F = Foreign Bank
VEN-SWIFT-ID Alpha 12 AP100 AP510
Swift ID The SWIFT identification number API3.1 API4.1
assigned to the vendor. IC840
VEN-PROC-GRP Alpha 4 (Lower Case) AP100 AP102
Process Group A process group is an identifier used AP510 API3.1
for separating vendors into different API4.1 IC840
groups to enable concurrent processing
within the cash payment cycle.
VEN-MATCH-TABLE Alpha 10 AP100 AP110
Match Table A code representing a match table. A AP510 API3.1
match table contains the processing API4.1 IC840
rules that will be used during matching.
VEN-DISC-CALC-DATE Alpha 1 AP100 AP510
Discount Indicates which date to use when API3.1 API4.1
Calculation Date calculating discounts. IC840
You can use the invoice date, receipt
date, or the date the invoice was
received.
" "
D = Receipt of Invoice Date
I = Invoice Date
R = Receipt Date
VEN-CREATE-POD-FL Alpha 1 AP100 AP510
Proof of Delivery Indicates whether to create a proof of API3.1 API4.1
Created delivery. IC840
Valid values are:
N = No
Y = Yes
" "
VEN-HANDLING-CODE Alpha 4 AP100 AP110
Invoice Handling Invoice handling code. Determines the AP510 API3.1
Code processing rules that will be used API4.1 IC840
during matching.
VEN-ENCLOSURE Alpha 1 AP100 AP510
Enclosure Indicates whether the invoice requires API3.1 API4.1
an enclosure with its payment. IC840
Y = Yes
N = No
" "
VEN-REQ-MATCH-REF Alpha 1 AP100 AP510
Match Reference Indicates whether a match reference API3.1 API4.1
Required number is required for invoices for this IC840
vendor.
Y = Yes
N = No
VEN-POOL-OPTION Numeric 1 AP100 AP510
Pool Option 1 = Company Vendor API3.1 API4.1
2 = Company Vendor PO IC840
3 = Company Vendor PO ShipTo
0 = MA Company Default
VEN-HOLD-INSP-FLAG Alpha 1 AP100 AP510
Hold Insp Flag If set to "Y", this flag will keep API3.1 API4.1
receiving lines requiring inspection IC840
from being matched until they have been
inspected.
Y = Yes
N = No
" " = Use Company
VEN-WRITE-OFF-AMT Signed 15.2 AP100 AP510
Write Off Amt API3.1 API4.1
IC840
VEN-VEN-CLAIM-TYPE Alpha 2 AP100 AP510
Vendor Claim Type CB = Chargeback API3.1 API4.1
CM = Credit Memo IC840 PO52.1
N = None
VEN-CLAIM-HOLD-CD Alpha 4 AP100 AP510
Claim Hold Cd API3.1 API4.1
IC840
VEN-CB-HOLD-CODE Alpha 4 AP100 AP510
Vendor Claims API3.1 API4.1
Chargeback Hold IC840
VEN-CB-MINIMUM-AMT Signed 15.2 AP100 AP510
Minimum Claim Amount API3.1 API4.1
IC840
VEN-REPLACE-GOODS Alpha 1 AP100 AP510
Replace Goods Y = Yes API3.1 API4.1
N = No IC840
VEN-SHIP-OR-HOLD Alpha 1 AP100 AP510
Ship or Hold Goods S = Ship API3.1 API4.1
H = Hold IC840 PO52.1
VEN-ERS-HANDLING Alpha 4 AP100 AP510
Ers Handling API3.1 API4.1
IC840
VEN-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP100 AP510
E Mail Address API3.1 API4.1
IC840
VEN-URL-ADDR Alpha 60 (Lower Case) AP100 AP510
Url Addr API3.1 API4.1
IC840
VEN-VEND-ACCT Alpha 30 AP100 AP510
Vend Acct The customer number the vendor has API3.1 API4.1
assigned to you. IC840
VEN-LANGUAGE-CODE Alpha 10 AP100 AP510
Language Code Language Code (LOCALE). API3.1 API4.1
IC840
VEN-TAX-USAGE-CD Alpha 10 AP100 AP510
Tax Usage Cd The tax usage coe for the vendor. This API3.1 API4.1
filed is required if the AP Company IC840
inidcates that VAT reporting required.
VEN-VAT-REG-CTRY Alpha 2 AP10.3 AP100
Vat Reg Ctry The country component of the VAT AP510 API3.1
Registration Number. This field, API4.1 IC840
together with the Registration Number
for the company on the tax transaction.
VEN-VAT-REG-NBR Alpha 12 AP10.3 AP100
Vat Reg Nbr The number component of the VAT AP510 API3.1
Registration Number. This field together API4.1 IC840
with the Registration Country field make
up the VAT Registration Number.
VEN-VALIDATE-PO Alpha 1 AP100 AP510
Validate Po " " = Use Default API3.1 API4.1
Y = Yes IC840
N = No
VEN-REQUIRE-PO Alpha 1 AP100 AP510
Require Po " " = Use Default API3.1 API4.1
Y = Yes IC840
N = No
VEN-LOC-INDICATOR Derived
Locations Exist When selecting a vendor from a list of
available vendors, an asterisk (*)
displays if alternate locations exist
for a vendor.
VEN-SHORT-VNAME Derived
Short Vendor Name A 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
Vendor Postal Code Vendor postal code.
VEN-VDR-COUNTY Derived
Vendor County Vendor county.
VEN-VDR-COUNTRY Derived
Vendor Country Vendor country.
VEN-VAT-NBR Derived
Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
VEN-WORKFLOW-GROUP Alpha 20 API3.1 API4.1
Workflow Group IC840
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 AM18.1 AP00.1
vendor group. AP10.1 AP10.2
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP100
AP102 AP110
AP115 AP12.1
AP125 AP126
AP130 AP131
AP135 AP141
AP145 AP146
AP150 AP151
AP155 AP156
AP160 AP161
...
VENSET10 VENDOR-GROUP KeyChange AP130
CREATE-POD-FL
VENDOR
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 PO120
POAV.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 AP10.1 AP200
VENDOR-SNAME records in search name sequence. API3.1 API4.1
VENDOR KeyChange IC840
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. AM18.1 AP520
VENDOR KeyChange API3.1 API4.1
IC530 IC840
MA63.1 PR05.1
PR05.3 PR198
PR226 PR247
PR26.1 PR47.1
PR514
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
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
|
