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 AP13.2 AP135 AP14.1 AP14.3 AP150
AP151 AP155 AP156 AP161 AP170 AP180
AP191 AP193 AP210 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP290 AP30.1 AP30.2
AP30.4 AP30.3 AP32.1 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 MA531 MA61.1 MA65.1 MA70.1 MA75.1
MAI1.1 OE13.1 PO150 PO204 PO216 PO223
PO227 PO231 PO25.6 PO25.7 PO254 PO36.2
PO52.1 PO536 PO54.1 PO54.2 PO54.3 PO54.4
AP92.3 AP92.4 AP93.3 AP93.4 PO16.1 PO16.2
UPDATED BY
AP100 AP110 AP16.2 AP160 AP300 AP510
API3.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1 TX140 AM115 AM117 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 AP16.2
Element: Vendor Group The vendor group to which the vendor AP510 API3.1
and location belong. Must be a valid PR05.1 PR05.3
record in the Vendor Group file. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-VENDOR Alpha 9 (Right Justified) AP100 AP16.2
Element: Vendor The identification number assigned to AP510 API3.1
the vendor. Must be a valid record in PR05.1 PR05.3
the Vendor file. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-LOCATION-CODE Alpha 4 AP100 AP16.2
Element: Location Code A user-defined code representing an AP510 API3.1
alternate remittance or purchasing PR05.1 PR05.3
location for the vendor. PR226 PR247
PR26.1 PR47.1
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 UK47.1
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
Element: Name The name of the alternate vendor AP510 API3.1
location. PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
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 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 UK47.1
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
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 UK47.1
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
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 UK47.1
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 PR05.1
Code vendor location telephone number. PR05.3 PR226
PR247 PR26.1
PR47.1 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 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 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 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 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 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 UK47.1
VLO-TAX-EXEMPT-CD Alpha 1 API3.1 PR05.1
Element: Tax Exempt CodCode indicating the taxing status. E - PR05.3 PR226
Exempt, T - Taxable. PR247 PR26.1
PR47.1 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 TX140 UK47.1
the vendor, if assigned, defaults. Valid
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 UK47.1
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
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 AP25.1
invoices during invoice entry. Must be a AP25.2 AP26.1
valid record in the Currency Code file. AP27.1 AP28.1
If left blank, the location uses the AP28.2 AP510
invoice currency assigned to the vendor. AP56.1 AP56.2
AP80.1 API3.1
MA61.1 MAI1.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-BANK-CURRENCY Alpha 5 AP16.2 AP510
Element: Currency Code This field contains the bank currency
code.
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 UK47.1
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
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 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 AP25.1
Cash Code file. If left blank, the cash AP25.2 AP26.1
code assigned to the vendor, if AP27.1 AP28.1
assigned, defaults. Valid only if the AP28.2 AP510
location type is remit to or both. AP56.1 AP56.2
AP80.1 API3.1
MA61.1 MAI1.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-BANK-ENTITY Alpha 15 AP100 AP16.2
Element: Bank The bank identification used to deposit AP510 API3.1
electronic payments for the vendor. This PR05.1 PR05.3
field is required for ACH or BACS PR226 PR247
payment types. Valid only if the PR26.1 PR47.1
location type is remit to or both. UK47.1
VLO-VBANK-ACCT-NO Alpha 35 AP100 AP16.2
Element: Bank Account The bank account number used to deposit AP510 API3.1
electronic payments for the alternate PR05.1 PR05.3
vendor location. This field is required PR226 PR247
for ACH or BACS payment types. Valid PR26.1 PR47.1
only if the location type is remit to or UK47.1
both.
VLO-VBANK-ACCT-TP Alpha 1 AP100 AP16.2
Element: Bank Account TIndicates the type of bank account used AP510 API3.1
to deposit electronic payments for the PR05.1 PR05.3
alternate vendor location. Valid only if PR226 PR247
the location type is remit to or both. PR26.1 PR47.1
Valid values are: UK47.1
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type was not
selected.
VLO-VBANK-IDENT Alpha 1 AP16.2 AP510
Element: Vbank Ident This field indicates if the account
number is and IBAN number that requires
an account validation check.
Y = Yes
N = No
VLO-EDI-NBR Alpha 15 AP100 AP16.2
Element: EDI Number The electronic data interchange (EDI) AP510 API3.1
number for the alternate vendor PR05.1 PR05.3
location. Used for reference. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-ACH-PRENOT Alpha 1 AP100 AP110
Prenotification Required only for ACH payment types. AP16.2 AP160
Status Indicates the status of electronic AP510 API3.1
payment processing between the alternate PR05.1 PR05.3
vendor location and the processing bank. PR226 PR247
Valid values are: PR26.1 PR47.1
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 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 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 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 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 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 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 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 UK47.1
in AP150 (Cash Requirements).
VLO-SEP-CHK-FLAG Alpha 1 AP100 AP510
Element: Separate Payment API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 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
PR247 PR26.1
A = Active PR47.1 UK47.1
I = Inactive
VLO-ERS-CAPABLE Alpha 1 AP100 AP16.2
Element: ERS Capable Indicates whether the vendor location AP510 API3.1
can process Evaluated Receipt Settlement PR05.1 PR05.3
(ERS). PR226 PR247
Y = Yes PR26.1 PR47.1
N = No UK47.1
VLO-ERS-HANDLING Alpha 4 AP100 AP16.2
Element: ERS Handling AP510 API3.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-INVC-REF-TYPE Alpha 2 AP100 AP16.2
ERS Invoice Indicates the type of number the vendor AP510 API3.1
Reference is providing to reference the invoice. PR05.1 PR05.3
BM = Bill of Lading PR226 PR247
IN = Invoice PR26.1 PR47.1
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 AP16.2
EDI Invoice Auto Indicates whether the company AP510 API3.1
Release automatically releases EDI invoices. PR05.1 PR05.3
Y = Yes PR226 PR247
N = No PR26.1 PR47.1
UK47.1
VLO-WRITE-OFF-AMT Signed 18.2 AP100 AP510
Element: Minimum Claim Amount API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 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
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 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 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
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 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 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 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 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 UK47.1
VLO-VDR-ADDR1 Derived
Element: Vdr Addr1 Vendor location address line 1.
VLO-VDR-ADDR2 Derived
Element: Vdr Addr2 Vendor location address line 2.
VLO-VDR-ADDR3 Derived
Element: Vdr Addr3 Vendor location address line 3.
VLO-VDR-ADDR4 Derived
Element: Vdr Addr4 Vendor location address line 4.
VLO-VDR-CITY-ADDR5 Derived
Element: Vdr City Addr5Vendor city or address line 5.
VLO-VDR-STATE Derived
Element: Vdr State Vendor state or province.
VLO-VDR-POSTAL Derived
Element: Vdr Postal Vendor postal code.
VLO-VDR-COUNTRY Derived
Element: Vdr Country Vendor country.
VLO-VDR-COUNTY Derived
Element: Vdr 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.
VLO-MBL-INT-PREFIX Alpha 6 AP510 API3.1
Element: Mbl Int PrefixThis field contains the country code of PR05.1 PR05.3
the mobile phone number. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-MOBILE-NUM Alpha 15 AP510 API3.1
Element: Mobile Num This field contains the mobile phone PR05.1 PR05.3
number. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-MOBILE-EXT Alpha 5 AP510 API3.1
Element: Mobile Ext This field contains the mobile phone PR05.1 PR05.3
extension number. PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-PAY-IMM-FLAG Alpha 1 AP510 API3.1
Element: All Flag PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VLO-DIVERSE-CODE Alpha 5 AP110 AP510
Element: Diverse Code Diversity Code for Account Payable API3.1 PR05.1
Vendors PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-BANK-ENT Alpha 15 AP16.2 AP510
Element: Bank Type the intermediary bank API3.1 PR05.1
identification used to deposit PR05.3 PR226
electronic payments for the vendor. PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-BANK-ACCT Alpha 35 AP16.2 AP510
Element: Bank Account NType the intermediary bank account API3.1 PR05.1
number used to deposit electronic PR05.3 PR226
payments for the vendor. PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-BANK-IDNT Alpha 1 AP16.2 AP510
Element: Intm Bank IdntThis field indicates if the account
umber is an IBAN number that requires an
account validation check.
Y = Yes
N = No
VLO-INTM-BANK-CURR Alpha 5 AP16.2 AP510
Element: Currency Code This field contains the intermediary
bank currency code.
VLO-INTM-PRENOT Alpha 1 AP16.2 AP510
Element: All Flag If you create Intermediary ACH payments API3.1 PR05.1
for the vendor, select the PR05.3 PR226
prenotification status. Indicates the PR247 PR26.1
status of the electronic payment between PR47.1 UK47.1
the vendor and the processing bank.
A = Accepted
N = Not Prenotified
P = Prenotified
VLO-INTM-SWIFT-ID Alpha 12 AP16.2 AP510
Element: Patient ID Use SWIFT Payment Options (AP10.8) to API3.1 PR05.1
define SWIFT payment options if you PR05.3 PR226
create Intermediary SWIFT payments for PR247 PR26.1
the vendor. PR47.1 UK47.1
VLO-INTM-PMT-CAT Alpha 6 AP16.2 AP510
Element: Pmt Cat Code Select the Intermediary SWIFT Payment API3.1 PR05.1
Category. PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-NORM-EXP Alpha 1 AP16.2 AP510
Element: Charge Code Indicates whether the SWIFT payment is a API3.1 PR05.1
normal or express payment. PR05.3 PR226
N = Normal PR247 PR26.1
E = Express PR47.1 UK47.1
" " = Not defined for the vendor
VLO-INTM-PMT-FORM Alpha 2 AP16.2 AP510
Element: Pmt Form Indicates how the Intermediary SWIFT API3.1 PR05.1
payment is made. PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-CHRG-CD Alpha 1 AP16.2 AP510
Element: Charge Code Indicates who pays service charges or API3.1 PR05.1
fees associated with a Intermediary PR05.3 PR226
SWIFT payment. PR247 PR26.1
PR47.1 UK47.1
VLO-INTM-CRS-IDENT Alpha 1 AP16.2 AP510
Element: Intm Crs IdentThis field is used to distriguish
between SWIFT ID numers and Routing
numbers.
S = SWIFT
R = Routing Number
VLO-CHARGE-CODE Alpha 1 AP16.2 AP510
Element: Charge Code API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-PMT-CAT-CODE Alpha 6 AP16.2 AP510
Element: Pmt Cat Code API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-NORM-EXP-CODE Alpha 1 AP16.2 AP510
Element: Charge Code API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-PMT-FORM Alpha 2 AP16.2 AP510
Element: Pmt Form API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-SWIFT-ID Alpha 12 AP16.2 AP510
Element: Swift Id API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-BUILD-SOC-REF Alpha 18 AP16.2 AP510
Element: Build Soc Ref This field holds an individual account API3.1 PR05.1
number reference for the Building PR05.3 PR226
Society PR247 PR26.1
PR47.1 UK47.1
VLO-BUILD-ACCT-NM Alpha 18 AP16.2 AP510
Element: Account Name API3.1 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VLO-DISCOUNT-CODE Alpha 10 API3.1 PR05.1
Element: Discount Code A user-defined code that represents a PR05.3 PR226
general ledger discount account. PR247 PR26.1
PR47.1 UK47.1
VLO-CROSS-IDENT Alpha 1 AP16.2 AP510
Element: Cross Ident This field is used to distinguish
between SWIFT ID numbers and Routing
numbers.
S = Swift
R = Routing Number
VLO-GIRO-NUMBER Alpha 15 AP16.2 AP510
Element: Giro Number This field is the Bankgiro or Postgiro
account number
VLO-CR-CARD-NUMBER Alpha 16 AP16.2 AP510
Element: Cr Card NumberThis field contains the credit card
number.
VLO-BANK-INSTRUCT1 Alpha 35 AP16.2 AP510
Element: Bank Instruct1This field contains bank instructions.
VLO-BANK-INSTRUCT2 Alpha 35 AP16.2 AP510
Element: Bank Instruct2This field contains bank instructions.
VLO-BANK-INSTRUCT3 Alpha 35 AP16.2 AP510
Element: Bank Instruct3This field contains bank instructions.
VLO-BANK-INSTRUCT4 Alpha 35 AP16.2 AP510
Element: Bank Instruct4This field contains bank instructions.
APVENLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLOSET1 VENDOR-GROUP This index is used to access and AM115 AM117
VENDOR validate location codes for a specific AM15.1 AM15.2
LOCATION-CODE vendor. AM15.3 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 AP13.2
AP135 AP14.1
AP14.3 AP150
AP151 AP155
...
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 UK47.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. PR05.1 PR05.3
VENDOR KeyChange PR226 PR247
LOCATION-CODE PR26.1 PR47.1
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
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
"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
Apcontacts APCONTACT Delete Cascades
VLO-VENDOR-GROUP -> VCT-VENDOR-GROUP
VLO-VENDOR -> VCT-VENDOR
VLO-LOCATION-CODE -> VCT-LOCATION-CODE
VCT-RESP-CODE
VCT-CONTACT-LVL
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
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
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
Apvencert APVENCERT
VLO-VENDOR-GROUP -> AVT-VENDOR-GROUP
VLO-VENDOR -> AVT-VENDOR
VLO-LOCATION-CODE -> AVT-LOCATION-CODE
AVT-CERTIF-CODE
AVT-CERTIF-EFF-DT
|