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
AM18.1 AP00.1 AP00.3 AP12.1 AP130 AP135
AP141 AP145 AP146 AP150 AP151 AP155
AP156 AP161 AP166 AP175 AP176 AP180
AP181 AP185 AP190 AP191 AP193 AP195
AP197 AP200 AP210 AP212 AP213 AP220
AP230 AP236 AP240 AP245 AP250 AP251
AP252 AP260 AP266 AP270 AP275 AP28.1
AP28.2 AP282 AP284 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 AR48.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 IC522 IC526 IC527
IC530 IC531 IC81.1 IC840 MA63.1 MA64.1
MA64.4 MA66.1 MA66.2 MA66.3 MA95.1 MA95.2
PO120 PO132 PO16.1 PO16.2 PO204 PO226
PO227 PO231 POAV.1 PR05.1 PR05.3 PR198
PR226 PR247 PR26.1 PR47.1 PR514 IN120
IN20.1 TX100 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 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.
VEN-VENDOR Alpha 9 (Right Justified) AP10.3 AP100
Vendor The identification number assigned to AP510 AP520
the vendor. API3.1 API4.1
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
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
VEN-VENDOR-SNAME Alpha 30 AP10.3 AP100
Search Name The search name for the vendor. AP510 AP520
API3.1 API4.1
VEN-VENDOR-CONTCT Alpha 30 AP100 AP510
Contact The name of the main contact for the API3.1 API4.1
vendor.
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
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
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
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
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
VEN-PHONE-PREFIX Alpha 6 AP100 AP510
Telephone Country The country code for the vendor API3.1 API4.1
Code telephone number.
VEN-PHONE-NUM Alpha 15 AP100 AP510
Telephone Number The telephone number for the vendor. API3.1 API4.1
VEN-PHONE-EXT Alpha 5 AP100 AP510
Telephone Extension The telephone extension number for the API3.1 API4.1
vendor.
VEN-FAX-PREFIX Alpha 6 AP100 AP510
Fax Country Code The country code for the fax machine API3.1 API4.1
telephone number.
VEN-FAX-NUM Alpha 15 AP100 AP510
Fax Number The fax machine telephone number. API3.1 API4.1
VEN-FAX-EXT Alpha 5 AP100 AP510
Fax Extension The fax machine telephone number API3.1 API4.1
extension.
VEN-TELEX-NUM Alpha 15 AP100 AP510
Telex The telex number for the vendor. API3.1 API4.1
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
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
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
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
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:
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.
VEN-TAX-EXEMPT-CD Alpha 1 API3.1 API4.1
Tax Exempt Code
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 TX140
tax information. Must be a valid record
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.
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
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
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
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. AP151 AP156
Represents a bank account. Must be a AP180 AP28.1
valid record in the Cash Code file. If AP28.2 AP510
left blank, the cash code assigned to AP56.1 AP56.2
the vendor class, if assigned, defaults, AP80.1 API3.1
or the vendor uses the cash code API4.1
assigned to the company or the pay
group.
VEN-BANK-ENTITY Alpha 15 AP100 AP510
Bank The bank identification used to deposit API3.1 API4.1
electronic payments for the vendor. This
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
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
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
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:
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
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
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.
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
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
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
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
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
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
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
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
vendor group user field.
VEN-USER-NAME-06 Alpha 15 AP100 AP510
User Defined Field 6 The value of the information being API3.1 API4.1
tracked for the vendor in the sixth
vendor group user field.
VEN-CUST-GROUP Alpha 5 AP100 API3.1
Customer Group If the accounts payable vendor is also API4.1
a customer in the Lawson Accounts
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
a customer in the Lawson Accounts
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.
VEN-PRIME-RATE Signed 7.5 AP100 AP510
Anticipation The percentage used to calculate API3.1 API4.1
Discount Rate anticipation discount invoices; most
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
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
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
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.
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.
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
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
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
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
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.
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:
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
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:
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.
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
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
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.
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.
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
during matching.
VEN-ENCLOSURE Alpha 1 AP100 AP510
Enclosure Indicates whether the invoice requires API3.1 API4.1
an enclosure with its payment.
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
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
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
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
VEN-VEN-CLAIM-TYPE Alpha 2 AP100 AP510
Vendor Claim Type CB = Chargeback API3.1 API4.1
CM = Credit Memo
N = None
VEN-CLAIM-HOLD-CD Alpha 4 AP100 AP510
Claim Hold Cd API3.1 API4.1
VEN-CB-HOLD-CODE Alpha 4 AP100 AP510
Vendor Claims API3.1 API4.1
Chargeback Hold
VEN-CB-MINIMUM-AMT Signed 15.2 AP100 AP510
Minimum Claim Amount API3.1 API4.1
VEN-REPLACE-GOODS Alpha 1 AP100 AP510
Replace Goods Y = Yes API3.1 API4.1
N = No
VEN-SHIP-OR-HOLD Alpha 1 AP100 AP510
Ship or Hold Goods S = Ship API3.1 API4.1
H = Hold
VEN-ERS-HANDLING Alpha 4 AP100 AP510
Ers Handling API3.1 API4.1
VEN-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP100 AP510
E Mail Address API3.1 API4.1
VEN-URL-ADDR Alpha 60 (Lower Case) AP100 AP510
Url Addr API3.1 API4.1
VEN-VEND-ACCT Alpha 30 AP100 AP510
Vend Acct The customer number the vendor has API3.1 API4.1
assigned to you.
VEN-LANGUAGE-CODE Alpha 10 AP100 AP510
Language Code Language Code (LOCALE). API3.1 API4.1
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
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
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
with the Registration Country field make
up the VAT Registration Number.
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.
APVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP This index is used to access and AM18.1 AP00.1
VENDOR validate vendor records for a specific AP10.1 AP10.2
vendor group. AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP100
AP102 AP110
AP115 AP12.1
AP130 AP135
AP141 AP145
AP146 AP150
AP151 AP155
AP156 AP160
AP161 AP166
AP170 AP175
AP176 AP180
...
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
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 AM18.1 AP520
EDI-NBR validate vendor records by EDI number. API3.1 API4.1
VENDOR KeyChange 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 MA05.1 MA05.2
VENDOR-GROUP assisgned a handling code.
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
|
