Lawson Insight Technical Documentation |
|
APVENLOC
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 AP109 AP115 AP12.1 AP125
AP126 AP135 AP150 AP151 AP155 AP156
AP161 AP170 AP180 AP191 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP20.8 AP210 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP290 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 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.5 MA43.7 MA43.8 MA531
MA61.1 MA65.1 MA70.1 MA75.1 MAI1.1 PO120
PO150 PO204 PO216 PO223 PO227 PO231
PO25.6 PO25.7 PO254 PO36.2 PO52.1 PO536
PO54.1 PO54.2 PO54.3 PO54.4 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIJ.1 AP92.3 AP92.4 AP93.3
AP93.4 PO16.1 PO16.2
UPDATED BY
AP100 AP110 AP160 AP300 AP510 API3.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 TX140 AM115 AM15.1 AM15.2
AM15.3 AM15.4 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 API4.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLO-VENDOR-GROUP Alpha 4 AP100 AP510
Element: Vendor Group The vendor group to which the vendor API3.1 PR05.1
and location belong. Must be a valid PR05.3 PR226
record in the Vendor Group file. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-VENDOR Alpha 9 (Right Justified) AP100 AP510
Element: Vendor The identification number assigned to API3.1 PR05.1
the vendor. Must be a valid record in PR05.3 PR226
the Vendor file. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-LOCATION-CODE Alpha 4 AP100 AP510
Element: Location Code A user-defined code representing an API3.1 PR05.1
alternate remittance or purchasing PR05.3 PR226
location for the vendor. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-LOC-TYPE Alpha 1 AP100 AP510
Element: Location Type Indicates the type of alternate vendor API3.1 PR05.1
location. Valid values are: PR05.3 PR226
PR247 PR26.1
B = Both. The location code represents PR47.1 PR514
both a purchasing and a remittance UK47.1
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
Element: Name The name of the alternate vendor AP510 API3.1
location. PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VLO-VENDOR-CONTCT Alpha 30 AP100 AP510
Element: Contact The name of the main contact for the API3.1 PR05.1
alternate vendor location. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-NORM-REMIT Alpha 1 AP100 AP510
Element: Normal Remit TIf the Location Type = R or B, this API3.1 PR05.1
field indicates whether the location is PR05.3 PR226
the normal remit-to location for the PR247 PR26.1
vendor. If Yes is selected in this PR47.1 PR514
field, the location address UK47.1
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
Element: Normal PurchasIf the Location Type = P or B, this API3.1 PR05.1
field indicates whether the location is PR05.3 PR226
the normal purchase-from location for PR247 PR26.1
the vendor. If Yes is selected in this PR47.1 PR514
field, the location address UK47.1
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
Element: Remit Payment If the Normal Purchase From Location API3.1 PR05.1
field = Yes, this field indicates which PR05.3 PR226
alternate remit-to location will be used PR247 PR26.1
when the purchase-from location code is PR47.1 PR514
used. Must be a valid remit-to location UK47.1
(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 PR05.1
Code vendor location telephone number. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-PHONE-NUM Alpha 15 AP100 AP510
Element: Telephone NumbThe telephone number for the alternate API3.1 PR05.1
vendor location. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-PHONE-EXT Alpha 5 AP100 AP510
Element: Telephone ExteThe telephone extension number for the API3.1 PR05.1
alternate vendor location. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-FAX-PREFIX Alpha 6 AP100 AP510
Telephone Country The country code for the fax machine API3.1 PR05.1
Code telephone number. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-FAX-NUM Alpha 15 AP100 AP510
Element: Telephone NumbThe fax machine telephone number. API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-FAX-EXT Alpha 5 AP100 AP510
Element: Telephone ExteThe fax machine telephone number API3.1 PR05.1
extension. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-TELEX-NUM Alpha 15 AP100 AP510
Element: Telex The telex number for the alternate API3.1 PR05.1
vendor location. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-TAX-EXEMPT-CD Alpha 1 API3.1 PR05.1
Element: Tax Exempt Code PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-TAX-CODE Alpha 10 AP100 AP110
Element: Tax Code The tax code assigned to the alternate AP510 API3.1
vendor location. Used to automatically PR05.1 PR05.3
calculate invoice tax information. Must PR226 PR247
be a valid record in the Tax Code file. PR26.1 PR47.1
If left blank, the tax code assigned to PR514 TX140
the vendor, if assigned, defaults. Valid UK47.1
only if the location type is purchase
from or both.
VLO-TERM-CODE Alpha 5 AP110 AP510
Element: Payment Terms The payment terms code assigned to the API3.1 PR05.1
alternate vendor location. Used to PR05.3 PR226
automatically calculate invoice due date PR247 PR26.1
and discount information for the PR47.1 PR514
location's invoices. Must be a valid UK47.1
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
Element: Invoice CurrenThe currency used to add invoices for AP125 AP126
the alternate vendor location. The AP151 AP156
currency code defaults on the location's AP180 AP20.1
invoices during invoice entry. Must be a AP20.2 AP20.3
valid record in the Currency Code file. AP20.4 AP20.5
If left blank, the location uses the AP20.7 AP20.8
invoice currency assigned to the vendor. 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 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VLO-CURR-RECALC Alpha 1 AP100 AP510
Currency Indicates whether invoices for this API3.1 PR05.1
Recalculation alternate vendor location will be PR05.3 PR226
automatically revalued to account for PR247 PR26.1
currency rate fluctuations when they are PR47.1 PR514
scheduled for payment. This revaluation UK47.1
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
Element: Payment Code The payment code assigned to the AP510 API3.1
alternate vendor location. Represents a PR05.1 PR05.3
type of cash payment, such as a check or PR226 PR247
payment tape, or a bill of exchange PR26.1 PR47.1
payment. Must be a valid cash or bill of PR514 UK47.1
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
Element: Cash Code The cash code assigned to the alternate AP125 AP126
vendor location. Represents a bank AP151 AP156
account. Must be a valid record in the AP180 AP20.1
Cash Code file. If left blank, the cash AP20.2 AP20.3
code assigned to the vendor, if AP20.4 AP20.5
assigned, defaults. Valid only if the AP20.7 AP20.8
location type is remit to or both. 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 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VLO-BANK-ENTITY Alpha 15 AP100 AP510
Element: Bank The bank identification used to deposit API3.1 PR05.1
electronic payments for the vendor. This PR05.3 PR226
field is required for ACH or BACS PR247 PR26.1
payment types. Valid only if the PR47.1 PR514
location type is remit to or both. UK47.1
VLO-VBANK-ACCT-NO Alpha 17 AP100 AP510
Element: Bank Account The bank account number used to deposit API3.1 PR05.1
electronic payments for the alternate PR05.3 PR226
vendor location. This field is required PR247 PR26.1
for ACH or BACS payment types. Valid PR47.1 PR514
only if the location type is remit to or UK47.1
both.
VLO-VBANK-ACCT-TP Alpha 1 AP100 AP510
Element: Bank Account TIndicates the type of bank account used API3.1 PR05.1
to deposit electronic payments for the PR05.3 PR226
alternate vendor location. Valid only if PR247 PR26.1
the location type is remit to or both. PR47.1 PR514
Valid values are: UK47.1
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type was not
selected.
VLO-EDI-NBR Alpha 15 AP100 AP510
Element: EDI Number The electronic data interchange (EDI) API3.1 PR05.1
number for the alternate vendor PR05.3 PR226
location. Used for reference. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-ACH-PRENOT Alpha 1 AP100 AP110
Prenotification Required only for ACH payment types. AP160 AP510
Status Indicates the status of electronic API3.1 PR05.1
payment processing between the alternate PR05.3 PR226
vendor location and the processing bank. PR247 PR26.1
Valid values are: PR47.1 PR514
UK47.1
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
Element: Operator Code The operator associated with API3.1 PR05.1
maintaining the alternate vendor PR05.3 PR226
location record. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-01 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the first user-defined vendor PR05.3 PR226
group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-02 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the second user-defined PR05.3 PR226
vendor group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-03 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the third user-defined vendor PR05.3 PR226
group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-04 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the fourth user-defined PR05.3 PR226
vendor group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-05 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the fifth user-defined vendor PR05.3 PR226
group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-USER-NAME-06 Alpha 20 AP100 AP510
Element: Vendor User FiThe value of the information being API3.1 PR05.1
tracked by the sixth user-defined vendor PR05.3 PR226
group field. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-INVOICE-GROUP Alpha 4 AP100 AP510
Element: Invoice Group A user-defined invoice group assigned API3.1 PR05.1
to the location. This value defaults on PR05.3 PR226
invoices entered for the location. Can PR247 PR26.1
be used to select invoices for payment PR47.1 PR514
in AP150 (Cash Requirements). UK47.1
VLO-SEP-CHK-FLAG Alpha 1 AP100 AP510
Element: Separate Payment API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-ACTIVE-STATUS Alpha 1 AP100 AP510
Element: Status The status of the account. If Inactive, API3.1 PR05.1
no posting can be done to the account. PR05.3 PR226
A = Active PR247 PR26.1
I = Inactive PR47.1 PR514
UK47.1
VLO-ERS-CAPABLE Alpha 1 AP100 AP510
Element: ERS Capable Y = Yes API3.1 PR05.1
N = No PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-ERS-HANDLING Alpha 4 AP100 AP510
Element: ERS Handling API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-INVC-REF-TYPE Alpha 2 AP100 AP510
ERS Invoice Indicates the type of number the vendor API3.1 PR05.1
Reference is providing to reference the invoice. PR05.3 PR226
BM = Bill of Lading PR247 PR26.1
IN = Invoice PR47.1 PR514
OW = Service Order Number UK47.1
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 PR05.1
Release automatically releases EDI invoices. PR05.3 PR226
Y = Yes PR247 PR26.1
N = No PR47.1 PR514
UK47.1
VLO-WRITE-OFF-AMT Signed 15.2 AP100 AP510
Element: Minimum Claim Amount API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-VEN-CLAIM-TYPE Alpha 2 AP100 AP510
Element: Vendor Claim TCB = Chargeback API3.1 PO52.1
CM = Credit Memo PR05.1 PR05.3
N = None PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VLO-CLAIM-HOLD-CD Alpha 4 AP100 AP510
Vendor Claims API3.1 PR05.1
Chargeback Hold PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-REPLACE-GOODS Alpha 1 AP100 AP510
Element: Replace Goods N = No API3.1 PR05.1
Y = Yes PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-SHIP-OR-HOLD Alpha 1 AP100 AP510
Element: Ship or Hold GS = Ship API3.1 PO52.1
H = Hold PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VLO-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP100 AP510
Element: Email Address API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-VEND-ACCT Alpha 30 AP100 AP510
Element: Vend Acct The customer number the vendor has API3.1 PR05.1
assigned to you. PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-TAX-USAGE-CD Alpha 10 AP100 AP510
Element: Tax Usage Cd The tax usage coe for the vendor. This API3.1 PR05.1
filed is required if the AP Company PR05.3 PR226
inidcates that VAT reporting required. PR247 PR26.1
PR47.1 PR514
UK47.1
VLO-VAT-REG-CTRY Alpha 2 AP100 AP510
Element: Vat Reg Ctry The country component of the VAT API3.1 PR05.1
Registration Number. This field, PR05.3 PR226
together with the Registration Number PR247 PR26.1
for the company on the tax transaction. PR47.1 PR514
UK47.1
VLO-VAT-REG-NBR Alpha 12 AP100 AP510
Element: Vat Reg Nbr The number component of the VAT API3.1 PR05.1
Registration Number. This field together PR05.3 PR226
with the Registration Country field make PR247 PR26.1
up the VAT Registration Number. PR47.1 PR514
UK47.1
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
Element: Vendor Postal Vendor postal code.
VLO-VDR-COUNTRY Derived
Element: Vendor CountryVendor country.
VLO-VDR-COUNTY Derived
Element: Vendor County
VLO-VAT-NBR Derived
Element: 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 AM115 AM15.1
VENDOR validate location codes for a specific AM15.2 AM15.3
LOCATION-CODE vendor. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.1
AP10.2 AP100
AP109 AP110
AP115 AP12.1
AP125 AP126
AP135 AP150
AP151 AP155
AP156 AP160
AP161 AP170
...
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 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
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 AP93.3 AP93.4
Where LOC-TYPE != "R" PO16.1 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. PR05.1 PR05.3
VENDOR KeyChange PR226 PR247
LOCATION-CODE PR26.1 PR47.1
PR514 UK47.1
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
|