|
|
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
AP12.1 AP125 AP126 AP135 AP150 AP151
AP155 AP156 AP157 AP161 AP170 AP180
AP191 AP193 AP20.1 AP20.2 AP20.5 AP20.6
AP20.7 AP20.8 AP210 AP23.1 AP25.1 AP25.2
AP26.1 AP265 AP28.1 AP28.2 AP290 AP30.1
AP30.2 AP30.4 AP30.3 AP32.1 AP32.2 AP520
AP54.2 AP55.1 AP56.1 AP56.2 AP80.1 AP90.5
AP90.6 AP90.7 AP90.8 AP91.4 BL92.1 CB06.2
EE12.1 EE135 EE20.1 EE20.2 EE20.4 EE35.1
EE35.2 EE520 DR100 IC12.1 IC141 IC142
IC81.1 IC81.2 IC812 IC83.1 IC840 IN20.1
MA140 MA190 MA278 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 MA520 MA530 MA540
MA95.1 MA95.2 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PO10.2 PO100
PO115 PO120 PO121 PO123 PO130 PO132
PO14.1 PO15.1 PO150 PO20.1 PO21.1 PO21.2
PO21.5 PO21.6 PO210 PO214 PO216 PO22.1
PO22.2 PO22.3 PO220 PO221 PO223 PO225
PO227 PO23.1 PO23.2 PO230 PO231 PO233
PO236 PO25.1 PO25.2 PO25.3 PO25.4 PO26.1
PO272 PO275 PO276 PO277 PO28.3 PO28.4
PO28.5 PO28.7 PO28.8 PO30.1 PO31.1 PO35.1
PO529 PO530 PO560 PO60.1 PO61.1 PO63.1
PO66.1 PO72.2 PO81.1 PO820 PO821 RQ10.1
RQ10.3 RQ11.1 RQ111 RQ20.1 RQ20.2 RQ20.3
RQ20.4 RQ35.1 RQ500 TX40.1 WH20.2 WH20.7
AP92.3 AP92.4 PO16.1 PO16.2 RQ125
UPDATED BY
AP10.2 AP10.1 AP100 AP110 AP160 AP300
AP510 AP951 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLO-VENDOR-GROUP Alpha 4 AP10.2 AP100
Vendor Group The vendor group to which the vendor AP510 AP951
and location belong. Must be a valid
record in the Vendor Group file.
VLO-VENDOR Alpha 9 AP10.2 AP100
Vendor ID The identification number assigned to AP510 AP951
the vendor. Must be a valid record in
the Vendor file.
VLO-LOCATION-CODE Alpha 4 AP10.2 AP100
Location Code A user-defined code representing an AP510 AP951
alternate remittance or purchasing
location for the vendor.
VLO-LOC-TYPE Alpha 1 AP10.2 AP100
Location Type Indicates the type of alternate vendor AP510 AP951
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) AP10.2 AP100
Vendor Name The name of the alternate vendor AP135 AP510
location. AP951 IC81.1
VLO-VENDOR-CONTCT Alpha 30 AP10.2 AP100
Vendor Contact The name of the main contact for the AP510 AP951
alternate vendor location.
VLO-ADDR1 Alpha 30 (Lower Case) AP10.2 AP100
Address 1 The first line of address information AP510 AP951
for the alternate vendor location.
VLO-ADDR2 Alpha 30 (Lower Case) AP10.2 AP100
Address 2 The second line of address information AP510 AP951
for the alternate vendor location.
VLO-ADDR3 Alpha 30 (Lower Case) AP10.2 AP100
Address 3 The third line of address information AP510 AP951
for the alternate vendor location.
VLO-ADDR4 Alpha 30 (Lower Case) AP10.2 AP100
Address 4 The fourth line of address information AP510 AP951
for the alternate vendor location.
VLO-CITY-ADDR5 Alpha 18 (Lower Case) AP10.2 AP100
City or Address 5 The city or fifth line of address AP510 AP951
information for the alternate vendor
location.
VLO-STATE-PROV Alpha 2 AP10.2 AP100
State or Province The state or province for the alternate AP510 AP951
vendor location address.
VLO-POSTAL-CODE Alpha 10 (Lower Case) AP10.2 AP100
Postal Code The postal code for the alternate AP510 AP951
vendor location address.
VLO-COUNTRY Alpha 30 (Lower Case) AP10.2 AP100
Country or Other The country for the alternate vendor AP510 AP951
location address. Can also be used for
additional information such as attention
name.
VLO-NORM-REMIT Alpha 1 AP10.2 AP100
Normal Remit To If the Location Type = R or B, this AP510 AP951
Location 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 AP10.2 AP100
Normal Purchase If the Location Type = P or B, this AP510 AP951
From Location 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 AP10.2 AP100
Remit To Location If the Normal Purchase From Location AP510 AP951
Code 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 AP10.2 AP100
Telephone Country The country code for the alternate AP510 AP951
Code vendor location telephone number.
VLO-PHONE-NUM Alpha 15 AP10.2 AP100
Telephone Number The telephone number for the alternate AP510 AP951
vendor location.
VLO-PHONE-EXT Alpha 5 AP10.2 AP100
Telephone Extension The telephone extension number for the AP510 AP951
alternate vendor location.
VLO-FAX-PREFIX Alpha 6 AP10.2 AP100
Fax Country Code The country code for the fax machine AP510 AP951
telephone number.
VLO-FAX-NUM Alpha 15 AP10.2 AP100
Fax Number The fax machine telephone number. AP510 AP951
VLO-FAX-EXT Alpha 5 AP10.2 AP100
Fax Extension The fax machine telephone number AP510 AP951
extension.
VLO-TELEX-NUM Alpha 15 AP10.2 AP100
Telex Number The telex number for the alternate AP510 AP951
vendor location.
VLO-TAX-CODE Alpha 10 AP10.2 AP100
Tax Code The tax code assigned to the alternate AP110 AP510
vendor location. Used to automatically AP951 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 AP10.2 AP100
Terms Code The payment terms code assigned to the AP110 AP510
alternate vendor location. Used to AP951
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 AP10.2 AP100
Invoice Currency The currency used to add invoices for AP110 AP125
the alternate vendor location. The AP126 AP151
currency code defaults on the location's AP156 AP180
invoices during invoice entry. Must be a AP20.1 AP20.2
valid record in the Currency Code file. AP20.5 AP20.7
If left blank, the location uses the AP20.8 AP23.1
invoice currency assigned to the vendor. AP25.1 AP25.2
AP26.1 AP28.1
AP28.2 AP510
AP56.1 AP56.2
AP80.1 AP951
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
VLO-CURR-RECALC Alpha 1 AP10.2 AP100
Currency Indicates whether invoices for this AP510 AP951
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 AP10.2 AP100
Payment Code The payment code assigned to the AP110 AP510
alternate vendor location. Represents a AP951
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 AP10.2 AP100
Cash Code The cash code assigned to the alternate AP110 AP125
vendor location. Represents a bank AP126 AP151
account. Must be a valid record in the AP156 AP180
Cash Code file. If left blank, the cash AP20.1 AP20.2
code assigned to the vendor, if AP20.5 AP20.7
assigned, defaults. Valid only if the AP20.8 AP23.1
location type is remit to or both. AP25.1 AP25.2
AP26.1 AP28.1
AP28.2 AP510
AP56.1 AP56.2
AP80.1 AP951
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
VLO-BANK-ENTITY Alpha 15 AP10.2 AP100
Bank The bank identification used to deposit AP510 AP951
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 AP10.2 AP100
Vendor Bank Account The bank account number used to deposit AP510 AP951
Number 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 AP10.2 AP100
Vendor Bank Account Indicates the type of bank account used AP510 AP951
Type 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 AP10.2 AP100
EDI Number The electronic data interchange (EDI) AP510 AP951
number for the alternate vendor
location. Used for reference.
VLO-ACH-PRENOT Alpha 1 AP10.2 AP100
ACH Prenotification Required only for ACH payment types. AP110 AP160
Status Indicates the status of electronic AP510 AP951
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 AP10.2 AP100
Operator Code The operator associated with AP510 AP951
maintaining the alternate vendor
location record.
VLO-USER-NAME-01 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 1 tracked by the first user-defined vendor
group field.
VLO-USER-NAME-02 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 2 tracked by the second user-defined
vendor group field.
VLO-USER-NAME-03 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 3 tracked by the third user-defined vendor
group field.
VLO-USER-NAME-04 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 4 tracked by the fourth user-defined
vendor group field.
VLO-USER-NAME-05 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 5 tracked by the fifth user-defined vendor
group field.
VLO-USER-NAME-06 Alpha 15 AP10.2 AP100
Vendor Group - User The value of the information being AP510 AP951
Name 6 tracked by the sixth user-defined vendor
group field.
VLO-INVOICE-GROUP Alpha 4 AP10.2 AP100
Invoice Group A user-defined invoice group assigned AP951
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-ACTIVE-STATUS Alpha 1 AP10.2 AP100
Status The status of the account. If Inactive, AP510 AP951
no posting can be done to the account.
A = Active
I = Inactive
VLO-ERS-CAPABLE Alpha 1 AP10.2 AP100
ERS Capable Indicates whether the vendor location AP510 AP951
can process Evaluated Receipt Settlement
(ERS).
VLO-INVC-REF-TYPE Alpha 2 AP10.2 AP100
Invoice Reference Indicates the type of number the vendor AP510 AP951
Type is providing to reference the invoice.
VLO-ERS-AUTO-REL Alpha 1 AP10.2 AP100
ERS Invoice Auto Indicates whether the location AP510 AP951
Release automatically releases invoices created
from receipts in the evaluated receipts
settlements process (pay on receipt).
VLO-EDI-AUTO-REL Alpha 1 AP10.2 AP100
EDI Invoice Auto If interfacing EDI invoices for the AP510 AP951
Release location using MA540 (EDI Line Level
Match), this field indicates whether to
interface invoices in a released status.
If this field is Yes, then invoices that
are matched or interfaced cleanly are
interfaced to Accounts Payable in a
released status. If left blank, the
option defined for the vendor defaults.
Valid values are:
N = No.
Y = Yes.
VLO-TAX-USAGE-CD Alpha 10 AP10.2
Tax Usage Code The tax usage code for the vendor.
This field is required if the AP Company
indicates that VAT reporting required
VLO-COUNTRY-CODE Alpha 2 AP10.2 AP510
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
VLO-REGION Alpha 2 AP10.2 AP510
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
VLO-VAT-REG-CTRY Alpha 2 AP10.2 AP510
VAT Registration The country component of the VAT
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
VLO-VAT-REG-NBR Alpha 12 AP10.2 AP510
VAT Registration The number component of the VAT
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
VLO-VAT-NBR Derived
VAT Number 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. AP12.1 AP125
AP126 AP135
AP150 AP151
AP155 AP156
AP157 AP160
AP161 AP170
AP180 AP191
AP193 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP210
AP23.1 AP25.1
AP25.2 AP26.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
Where LOC-TYPE != "P"
VLOSET3 VENDOR-GROUP This index is used to access remit-to AP20.6 AP32.1
VENDOR location codes for a vendor. AP92.3 AP92.4
LOCATION-CODE KeyChange, Subset PO16.1 PO16.2
Where LOC-TYPE != "R" RQ125
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 BL92.1
EDI-NBR locations by EDI number. DR100 IC12.1
VENDOR KeyChange IC141 IC142
LOCATION-CODE IC81.2 IC812
IC83.1 IC840
IN20.1 MA140
MA190 MA278
MA520 MA530
MA540 MA95.1
MA95.2 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
...
APVENLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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-INVOICE
APC-SUFFIX
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
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
|