APVENLOC FILE
Vendor Location
The Vendor Location file contains all location code records for alternate
vendor locations defined for accounts payable vendors. An alternate vendor
location can be used as a purchasing location, a remittance location, or both.
A vendor can have more than one alternate vendor location record.
REFERENCED BY
AP10.1 AP10.2 AP115 AP12.1 AP135 AP150
AP151 AP155 AP156 AP161 AP170 AP180
AP191 AP193 AP210 AP28.1 AP28.2 AP30.1
AP30.2 AP30.4 AP30.3 AP32.1 AP32.2 AP520
AP55.1 AP56.1 AP56.2 AP80.1 AP90.5 AP90.6
AP90.7 AP90.8 AP91.4 AP96.4 API1.1 API2.1
CB06.2 EE135 EE20.1 EE20.2 EE20.4 EE35.1
EE35.2 EE520 IC81.1 MA65.1 PO204 PO216
PO227 PO231 PO24.1 AP92.3 AP92.4 AP93.3
AP93.4 PO16.1 PO16.2
UPDATED BY
AP100 AP110 AP160 AP300 AP510 API3.1
TX140 API4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLO-VENDOR-GROUP Alpha 4 AP100 AP510
Vendor Group The vendor group to which the vendor API3.1
and location belong. Must be a valid
record in the Vendor Group file.
VLO-VENDOR Alpha 9 (Right Justified) AP100 AP510
Vendor The identification number assigned to API3.1
the vendor. Must be a valid record in
the Vendor file.
VLO-LOCATION-CODE Alpha 4 AP100 AP510
Location Code A user-defined code representing an API3.1
alternate remittance or purchasing
location for the vendor.
VLO-LOC-TYPE Alpha 1 AP100 AP510
Location Type Indicates the type of alternate vendor API3.1
location. Valid values are:
B = Both. The location code represents
both a purchasing and a remittance
location for the vendor.
P = Purchase-From. The location code
represents an alternate purchasing
location for the vendor.
R = Remit-To. The location code
represents an alternate remittance
location for the vendor.
VLO-VENDOR-VNAME Alpha 30 (Lower Case) AP100 AP135
Vendor Name The name of the alternate vendor AP510 API3.1
location.
VLO-VENDOR-CONTCT Alpha 30 AP100 AP510
Contact The name of the main contact for the API3.1
alternate vendor location.
VLO-NORM-REMIT Alpha 1 AP100 AP510
Normal Remit To If the Location Type = R or B, this API3.1
field indicates whether the location is
the normal remit-to location for the
vendor. If Yes is selected in this
field, the location address
automatically overrides the vendor
address on the Vendor file for vendor
payments when invoices are added. Only
one alternate location for a vendor can
have Yes selected in this field. Valid
values are:
N = No.
Y = Yes.
VLO-NORM-PURCH Alpha 1 AP100 AP510
Normal Purchase From If the Location Type = P or B, this API3.1
field indicates whether the location is
the normal purchase-from location for
the vendor. If Yes is selected in this
field, the location address
automatically overrides the vendor
address on the Vendor file for storing
vendor purchase activity balances. Only
one alternate location for a vendor can
have Yes selected in this field. Valid
values are:
N = No.
Y = Yes.
VLO-REMIT-TO-CODE Alpha 4 AP100 AP510
Remit Payment To If the Normal Purchase From Location API3.1
field = Yes, this field indicates which
alternate remit-to location will be used
when the purchase-from location code is
used. Must be a valid remit-to location
(type R or B) record in the Vendor
Location file. If left blank, the vendor
address defined in the Vendor file is
used as the remittance address.
VLO-PHONE-PREFIX Alpha 6 AP100 AP510
Telephone Country The country code for the alternate API3.1
Code vendor location telephone number.
VLO-PHONE-NUM Alpha 15 AP100 AP510
Telephone Number The telephone number for the alternate API3.1
vendor location.
VLO-PHONE-EXT Alpha 5 AP100 AP510
Telephone Extension The telephone extension number for the API3.1
alternate vendor location.
VLO-FAX-PREFIX Alpha 6 AP100 AP510
Fax Country Code The country code for the fax machine API3.1
telephone number.
VLO-FAX-NUM Alpha 15 AP100 AP510
Fax Number The fax machine telephone number. API3.1
VLO-FAX-EXT Alpha 5 AP100 AP510
Fax Extension The fax machine telephone number API3.1
extension.
VLO-TELEX-NUM Alpha 15 AP100 AP510
Telex The telex number for the alternate API3.1
vendor location.
VLO-TAX-EXEMPT-CD Alpha 1 API3.1
Tax Exempt Code
VLO-TAX-CODE Alpha 10 AP100 AP110
Tax Code The tax code assigned to the alternate AP510 API3.1
vendor location. Used to automatically TX140
calculate invoice tax information. Must
be a valid record in the Tax Code file.
If left blank, the tax code assigned to
the vendor, if assigned, defaults. Valid
only if the location type is purchase
from or both.
VLO-TERM-CODE Alpha 5 AP110 AP510
Payment Terms The payment terms code assigned to the API3.1
alternate vendor location. Used to
automatically calculate invoice due date
and discount information for the
location's invoices. Must be a valid
record in the Terms Code file. If left
blank, the terms code assigned to the
vendor defaults. Valid only if the
location type is purchase from or both.
VLO-INV-CURRENCY Alpha 5 AP100 AP110
Invoice Currency The currency used to add invoices for AP151 AP156
the alternate vendor location. The AP180 AP28.1
currency code defaults on the location's AP28.2 AP510
invoices during invoice entry. Must be a AP56.1 AP56.2
valid record in the Currency Code file. AP80.1 API3.1
If left blank, the location uses the
invoice currency assigned to the vendor.
VLO-CURR-RECALC Alpha 1 AP100 AP510
Currency Indicates whether invoices for this API3.1
Recalculation alternate vendor location will be
automatically revalued to account for
currency rate fluctuations when they are
scheduled for payment. This revaluation
may result in the creation of currency
gain or loss transactions. Valid values
are:
N = No.
Y = Yes.
VLO-BANK-INST-CODE Alpha 3 AP100 AP110
Payment Code The payment code assigned to the AP510 API3.1
alternate vendor location. Represents a
type of cash 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. If
left blank, the payment code assigned to
the vendor, if assigned, defaults. Valid
only if the location type is remit to or
both.
VLO-CASH-CODE Alpha 4 AP100 AP110
Cash Code The cash code assigned to the alternate AP151 AP156
vendor location. Represents a bank AP180 AP28.1
account. Must be a valid record in the AP28.2 AP510
Cash Code file. If left blank, the cash AP56.1 AP56.2
code assigned to the vendor, if AP80.1 API3.1
assigned, defaults. Valid only if the
location type is remit to or both.
VLO-BANK-ENTITY Alpha 15 AP100 AP510
Bank The bank identification used to deposit API3.1
electronic payments for the vendor. This
field is required for ACH or BACS
payment types. Valid only if the
location type is remit to or both.
VLO-VBANK-ACCT-NO Alpha 17 AP100 AP510
Bank Account The bank account number used to deposit API3.1
electronic payments for the alternate
vendor location. This field is required
for ACH or BACS payment types. Valid
only if the location type is remit to or
both.
VLO-VBANK-ACCT-TP Alpha 1 AP100 AP510
Bank Account Type Indicates the type of bank account used API3.1
to deposit electronic payments for the
alternate vendor location. Valid only if
the location type is remit to or both.
Valid values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type was not
selected.
VLO-EDI-NBR Alpha 15 AP100 AP510
EDI Number The electronic data interchange (EDI) API3.1
number for the alternate vendor
location. Used for reference.
VLO-ACH-PRENOT Alpha 1 AP100 AP110
Prenotification Required only for ACH payment types. AP160 AP510
Status Indicates the status of electronic API3.1
payment processing between the alternate
vendor location 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.
VLO-OPERATOR Alpha 10 AP100 AP510
Operator Code The operator associated with API3.1
maintaining the alternate vendor
location record.
VLO-USER-NAME-01 Alpha 20 AP100 AP510
Vendor User Field 1 The value of the information being API3.1
tracked by the first user-defined vendor
group field.
VLO-USER-NAME-02 Alpha 20 AP100 AP510
Vendor User Field 2 The value of the information being API3.1
tracked by the second user-defined
vendor group field.
VLO-USER-NAME-03 Alpha 20 AP100 AP510
Vendor User Field 3 The value of the information being API3.1
tracked by the third user-defined vendor
group field.
VLO-USER-NAME-04 Alpha 20 AP100 AP510
Vendor User Field 4 The value of the information being API3.1
tracked by the fourth user-defined
vendor group field.
VLO-USER-NAME-05 Alpha 20 AP100 AP510
Vendor User Field 5 The value of the information being API3.1
tracked by the fifth user-defined vendor
group field.
VLO-USER-NAME-06 Alpha 15 AP100 AP510
Vendor User Field 6 The value of the information being API3.1
tracked by the sixth user-defined vendor
group field.
VLO-INVOICE-GROUP Alpha 4 AP100 API3.1
Invoice Group A user-defined invoice group assigned
to the location. This value defaults on
invoices entered for the location. Can
be used to select invoices for payment
in AP150 (Cash Requirements).
VLO-SEP-CHK-FLAG Alpha 1 AP100 AP510
Separate Payment API3.1
VLO-ACTIVE-STATUS Alpha 1 AP100 AP510
Status The status of the account. If Inactive, API3.1
no posting can be done to the account.
A = Active
I = Inactive
VLO-ERS-CAPABLE Alpha 1 AP100 AP510
ERS Capable Indicates whether the vendor location API3.1
can process Evaluated Receipt Settlement
(ERS).
Y = Yes
N = No
VLO-ERS-HANDLING Alpha 4 AP100 AP510
ERS Handling API3.1
VLO-INVC-REF-TYPE Alpha 2 AP100 AP510
ERS Invoice Indicates the type of number the vendor API3.1
Reference is providing to reference the invoice.
BM = Bill of Lading
IN = Invoice
OW = Service Order Number
PL = Packing List Number
PO = PO Number
VN = Vendor Order Number
WO = Work Order
WP = Warehouse Pick Ticket
ZZ = Mutually Defined
VLO-EDI-AUTO-REL Alpha 1 AP100 AP510
EDI Invoice Auto Indicates whether the company API3.1
Release automatically releases EDI invoices.
Y = Yes
N = No
VLO-WRITE-OFF-AMT Signed 15.2 AP100 AP510
Minimum Claim Amount API3.1
VLO-VEN-CLAIM-TYPE Alpha 2 AP100 AP510
Vendor Claim Type CB = Chargeback API3.1
CM = Credit Memo
N = None
VLO-CLAIM-HOLD-CD Alpha 4 AP100 AP510
Vendor Claims API3.1
Chargeback Hold
VLO-REPLACE-GOODS Alpha 1 AP100 AP510
Replace Goods N = No API3.1
Y = Yes
VLO-SHIP-OR-HOLD Alpha 1 AP100 AP510
Ship or Hold Goods S = Ship API3.1
H = Hold
VLO-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP100 AP510
E Mail Address API3.1
VLO-VEND-ACCT Alpha 30 AP100 AP510
Vend Acct The customer number the vendor has API3.1
assigned to you.
VLO-TAX-USAGE-CD Alpha 10 AP100 AP510
Tax Usage Cd The tax usage coe for the vendor. This API3.1
filed is required if the AP Company
inidcates that VAT reporting required.
VLO-VAT-REG-CTRY Alpha 2 AP100 AP510
Vat Reg Ctry The country component of the VAT API3.1
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
VLO-VAT-REG-NBR Alpha 12 AP100 AP510
Vat Reg Nbr The number component of the VAT API3.1
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
VLO-VDR-ADDR1 Derived
Vendor Address Line Vendor location address line 1.
1
VLO-VDR-ADDR2 Derived
Vendor Address Line Vendor location address line 2.
2
VLO-VDR-ADDR3 Derived
Vendor Address Line Vendor location address line 3.
3
VLO-VDR-ADDR4 Derived
Vendor Address Line Vendor location address line 4.
4
VLO-VDR-CITY-ADDR5 Derived
Vendor City or Vendor city or address line 5.
Address Line 5
VLO-VDR-STATE Derived
Vendor State or Vendor state or province.
Province
VLO-VDR-POSTAL Derived
Vendor Postal Code Vendor postal code.
VLO-VDR-COUNTRY Derived
Vendor Country Vendor country.
VLO-VDR-COUNTY Derived
Vendor County
VLO-VAT-NBR Derived
Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
APVENLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLOSET1 VENDOR-GROUP This index is used to access and AP10.1 AP10.2
VENDOR validate location codes for a specific AP100 AP110
LOCATION-CODE vendor. AP115 AP12.1
AP135 AP150
AP151 AP155
AP156 AP160
AP161 AP170
AP180 AP191
AP193 AP210
AP28.1 AP28.2
AP30.1 AP30.2
AP30.4 AP300
AP32.1 AP32.2
AP510 AP520
AP55.1 AP56.1
...
VLOSET2 VENDOR-GROUP This index is used to access AP10.2 AP30.1
VENDOR purchase-from location type codes for a AP30.3 AP32.1
LOCATION-CODE vendor. AP92.3 AP92.4
KeyChange, Subset AP93.3 AP93.4
Where LOC-TYPE != "P" API3.1
VLOSET3 VENDOR-GROUP This index is used to access remit-to AP32.1 AP92.3
VENDOR location codes for a vendor. AP92.4 AP93.3
LOCATION-CODE KeyChange, Subset AP93.4 PO16.1
Where LOC-TYPE != "R" PO16.2
VLOSET4 VENDOR-GROUP This index is used to access vendor AP160
VENDOR location records set up for ACH
LOCATION-CODE processing that have not been
prenotified.
Subset
Where ACH-PRENOT = "N"
Or ACH-PRENOT = "P"
VLOSET5 VENDOR-GROUP This index is used to access vendor AP520 API3.1
EDI-NBR locations by EDI number.
VENDOR KeyChange
LOCATION-CODE
APVENLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Address1 APVENADDR Required
VLO-VENDOR-GROUP -> VDR-VENDOR-GROUP
VLO-VENDOR -> VDR-VENDOR
VLO-LOCATION-CODE -> VDR-LOCATION-CODE
"Y" -> VDR-CUR-ADDR
Apvenmast APVENMAST Required
VLO-VENDOR-GROUP -> VEN-VENDOR-GROUP
VLO-VENDOR -> VEN-VENDOR
APVENLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcomments APCOMMENTS Delete Cascades
"V" -> APC-REC-TYPE
VLO-VENDOR-GROUP -> APC-VENDOR-GROUP
VLO-VENDOR -> APC-VENDOR
VLO-LOCATION-CODE -> APC-LOCATION-CODE
APC-COMPANY
APC-SEQ-NBR
Apcpyvnd APCPYVND
VLO-VENDOR-GROUP -> APX-VENDOR-GROUP
VLO-VENDOR -> APX-VENDOR
VLO-LOCATION-CODE -> APX-LOCATION-CODE
APX-COMPANY
Aplocbal APVENBAL Delete Cascades
VLO-VENDOR-GROUP -> VBA-VENDOR-GROUP
VLO-VENDOR -> VBA-VENDOR
VLO-LOCATION-CODE -> VBA-LOCATION-CODE
VBA-COMPANY
Apvenaddr APVENADDR
VLO-VENDOR-GROUP -> VDR-VENDOR-GROUP
VLO-VENDOR -> VDR-VENDOR
VLO-LOCATION-CODE -> VDR-LOCATION-CODE
VDR-EFFECTIVE-DATE
Apvenbal APVENBAL Delete Cascades
VLO-VENDOR-GROUP -> VBA-VENDOR-GROUP
VLO-VENDOR -> VBA-VENDOR
VEN-BAL-CURRENCY -> VBA-BAL-CURRENCY
VLO-LOCATION-CODE -> VBA-LOCATION-CODE
VBA-COMPANY
|
