APVENLOC – Vendor Location

System
Accounts Payable (AP)
Prefix
VLO
Primary key
VENDOR-GROUP, VENDOR, LOCATION-CODE
Fields
118
Updated by
293 programs
Referenced by
76 programs

APVENLOC is the Vendor Location table in Lawson Accounts Payable (prefix VLO). It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE (VLOSET1); alternate indexes: VLOSET2, VLOSET3, VLOSET4 and VLOSET5. It is related 1:1 to APVENADDR, APVENGROUP, APVENLCBOD, APVENMAST, GLNLOC, GLNLOCDTL and PROCUREGRP and 1:M to APCOMMENTS, APCONTACT, APCPYVND, APVENBAL, APVENADDR, APVENCERT and APVENDIV. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 285 more and referenced by AP10.1, AP10.2, AP10.9, AP109, AP111, AP12.1, AP135, AP14.1 and 68 more. The table has 118 fields, 5 indexes and 15 documented relations.

About APVENLOC

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.

Fields (118)

Column = COBOL field name without the VLO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
VLO-VENDOR-GROUP PK
VENDOR_GROUP
Alpha 4The vendor group to which the vendor and location belong. Must be a valid record in the Vendor Group file.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VENDOR PK
VENDOR
Alpha 9 (Right Justified)The identification number assigned to the vendor. Must be a valid record in the Vendor file.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-LOCATION-CODE PK
LOCATION_CODE
Alpha 4A user-defined code representing an alternate remittance or purchasing location for the vendor.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-LOC-TYPE
LOC_TYPE
Alpha 1Indicates the type of alternate vendor location. Valid values are: both a purchasing and a remittance location for the vendor. represents an alternate purchasing location for the vendor. represents an alternate remittance location for the vendor.
  • B Both. The location code represents
  • P Purchase-From. The location code
  • R Remit-To. The location code
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VENDOR-VNAME
VENDOR_VNAME
Alpha 30 (Lower Case)The name of the alternate vendor location.AP100, AP135, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4 +13 more
VLO-VENDOR-CONTCT
VENDOR_CONTCT
Alpha 30The name of the main contact for the alternate vendor location.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-NORM-REMIT
NORM_REMIT
Alpha 1If the Location Type = R or B, this 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.
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-NORM-PURCH
NORM_PURCH
Alpha 1If the Location Type = P or B, this 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.
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-REMIT-TO-CODE
REMIT_TO_CODE
Alpha 4If the Normal Purchase From Location 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.
  • field Yes, this field indicates which
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-PHONE-PREFIX
PHONE_PREFIX
Alpha 6The country code for the alternate vendor location telephone number.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-PHONE-NUM
PHONE_NUM
Alpha 15The telephone number for the alternate vendor location.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-PHONE-EXT
PHONE_EXT
Alpha 5The telephone extension number for the alternate vendor location.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-FAX-PREFIX
FAX_PREFIX
Alpha 6The country code for the fax machine telephone number.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-FAX-NUM
FAX_NUM
Alpha 15The fax machine telephone number.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-FAX-EXT
FAX_EXT
Alpha 5The fax machine telephone number extension.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-TELEX-NUM
TELEX_NUM
Alpha 15The telex number for the alternate vendor location.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-TAX-EXEMPT-CD
TAX_EXEMPT_CD
Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-TAX-CODE
TAX_CODE
Alpha 10The tax code assigned to the alternate vendor location. Used to automatically 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.AP100, AP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4 +14 more
VLO-TERM-CODE
TERM_CODE
Alpha 5The payment terms code assigned to the 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.AP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-INV-CURRENCY
INV_CURRENCY
Alpha 5The currency used to add invoices for the alternate vendor location. The currency code defaults on the location's invoices during invoice entry. Must be a valid record in the Currency Code file. If left blank, the location uses the invoice currency assigned to the vendor.AP100, AP110, AP125, AP126, AP151, AP156, AP180, AP20.1 +46 more
VLO-BANK-CURRENCY
BANK_CURRENCY
Alpha 5This field contains the bank currency code.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-CURR-RECALC
CURR_RECALC
Alpha 1Indicates whether invoices for this 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.
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-BANK-INST-CODE
BANK_INST_CODE
Alpha 3The payment code assigned to the 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.AP100, AP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4 +13 more
VLO-CASH-CODE
CASH_CODE
Alpha 4The cash code assigned to the alternate vendor location. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the vendor, if assigned, defaults. Valid only if the location type is remit to or both.AP100, AP110, AP125, AP126, AP151, AP156, AP180, AP20.1 +46 more
VLO-BANK-ENTITY
BANK_ENTITY
Alpha 15The bank identification used to deposit 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.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VBANK-ACCT-NO
VBANK_ACCT_NO
Alpha 35The bank account number used to deposit 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.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VBANK-ACCT-TP
VBANK_ACCT_TP
Alpha 1Indicates the type of bank account used to deposit electronic payments for the alternate vendor location. Valid only if the location type is remit to or both. Valid values are: selected.
  • C Current/Checking Account.
  • S Savings Account.
  • Blank Electronic payment type was not
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VBANK-IDENT
VBANK_IDENT
Alpha 1This field indicates if the account number is and IBAN number that requires an account validation check.
  • Y Yes
  • N No
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-EDI-NBR
EDI_NBR
Alpha 15The electronic data interchange (EDI) number for the alternate vendor location. Used for reference.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-ACH-PRENOT
ACH_PRENOT
Alpha 1Required only for ACH payment types. Indicates the status of electronic payment processing between the alternate vendor location and the processing bank. Valid values are: (AP160) 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. when first entering ACH information to prenotify the processing bank. Accepted once the processing bank accepts the electronic payment tape.
  • N Notified. Payment Tape Creation
  • P Prenotified. Select this status
  • A Accepted. Change the status to
  • Blank ACH payment type not selected.
AP100, AP110, AP160, AP510, API3.1, IC64.1, IC64.2, IC64.3 +14 more
VLO-OPERATOR
OPERATOR
Alpha 10The operator associated with maintaining the alternate vendor location record.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-01
USER_NAME_01
Alpha 20The value of the information being tracked by the first user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-02
USER_NAME_02
Alpha 20The value of the information being tracked by the second user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-03
USER_NAME_03
Alpha 20The value of the information being tracked by the third user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-04
USER_NAME_04
Alpha 20The value of the information being tracked by the fourth user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-05
USER_NAME_05
Alpha 20The value of the information being tracked by the fifth user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-USER-NAME-06
USER_NAME_06
Alpha 20The value of the information being tracked by the sixth user-defined vendor group field.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-INVOICE-GROUP
INVOICE_GROUP
Alpha 4A 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).AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-SEP-CHK-FLAG
SEP_CHK_FLAG
Alpha 1AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
  • D Inactive for PO additions
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-ERS-CAPABLE
ERS_CAPABLE
Alpha 1
  • Y Yes
  • N No
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-ERS-HANDLING
ERS_HANDLING
Alpha 4AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-INVC-REF-TYPE
INVC_REF_TYPE
Alpha 2Indicates the type of number the vendor 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
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-EDI-AUTO-REL
EDI_AUTO_REL
Alpha 1Indicates whether the company automatically releases EDI invoices.
  • Y Yes
  • N No
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-WRITE-OFF-AMT
WRITE_OFF_AMT
Signed 18.2AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VEN-CLAIM-TYPE
VEN_CLAIM_TYPE
Alpha 2
  • CB Chargeback
  • CM Credit Memo
  • N None
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +13 more
VLO-CLAIM-HOLD-CD
CLAIM_HOLD_CD
Alpha 4The hold code.AP100, AP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4 +13 more
VLO-REPLACE-GOODS
REPLACE_GOODS
Alpha 1
  • N No
  • Y Yes
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-SHIP-OR-HOLD
SHIP_OR_HOLD
Alpha 1
  • S Ship
  • H Hold
AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +13 more
VLO-E-MAIL-ADDRESS
E_MAIL_ADDRESS
Alpha 60 (Lower Case)e-mail address.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VEND-ACCT
VEND_ACCT
Alpha 30The customer number the vendor has assigned to you.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VAT-REG-CTRY
VAT_REG_CTRY
Alpha 2The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VAT-REG-NBR
VAT_REG_NBR
Alpha 12The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-VDR-ADDR1
VDR_ADDR1
DerivedVendor location address line 1.
VLO-VDR-ADDR2
VDR_ADDR2
DerivedVendor location address line 2.
VLO-VDR-ADDR3
VDR_ADDR3
DerivedVendor location address line 3.
VLO-VDR-ADDR4
VDR_ADDR4
DerivedVendor location address line 4.
VLO-VDR-CITY-ADDR5
VDR_CITY_ADDR5
DerivedVendor city or address line 5.
VLO-VDR-STATE
VDR_STATE
DerivedVendor state or province.
VLO-VDR-POSTAL
VDR_POSTAL
DerivedVendor postal code.
VLO-VDR-COUNTRY
VDR_COUNTRY
DerivedVendor country.
VLO-VDR-COUNTY
VDR_COUNTY
Derived
VLO-VAT-NBR
VAT_NBR
DerivedThe concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID.
VLO-MBL-INT-PREFIX
MBL_INT_PREFIX
Alpha 6This field contains the country code of the mobile phone number.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-MOBILE-NUM
MOBILE_NUM
Alpha 15This field contains the mobile phone number.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-MOBILE-EXT
MOBILE_EXT
Alpha 5This field contains the mobile phone extension number.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-PAY-IMM-FLAG
PAY_IMM_FLAG
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-DIVERSE-CODE
DIVERSE_CODE
Alpha 5Diversity Code for Account Payable VendorsAP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-INTM-BANK-ENT
INTM_BANK_ENT
Alpha 15Type the intermediary bank identification used to deposit electronic payments for the vendor.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-BANK-ACCT
INTM_BANK_ACCT
Alpha 35Type the intermediary bank account number used to deposit electronic payments for the vendor.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-BANK-IDNT
INTM_BANK_IDNT
Alpha 1This field indicates if the account umber is an IBAN number that requires an account validation check.
  • Y Yes
  • N No
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-BANK-CURR
INTM_BANK_CURR
Alpha 5This field contains the intermediary bank currency code.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-PRENOT
INTM_PRENOT
Alpha 1If you create Intermediary ACH payments for the vendor, select the prenotification status. Indicates the status of the electronic payment between the vendor and the processing bank.
  • A Accepted
  • N Not Prenotified
  • P Prenotified
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-SWIFT-ID
INTM_SWIFT_ID
Alpha 12Use SWIFT Payment Options (AP10.8) to define SWIFT payment options if you create Intermediary SWIFT payments for the vendor.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-PMT-CAT
INTM_PMT_CAT
Alpha 6Select the Intermediary SWIFT Payment Category.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-NORM-EXP
INTM_NORM_EXP
Alpha 1Indicates whether the SWIFT payment is a normal or express payment. " " = Not defined for the vendor
  • N Normal
  • E Express
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-PMT-FORM
INTM_PMT_FORM
Alpha 2Indicates how the Intermediary SWIFT payment is made.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-CHRG-CD
INTM_CHRG_CD
Alpha 1Indicates who pays service charges or fees associated with a Intermediary SWIFT payment.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-CRS-IDENT
INTM_CRS_IDENT
Alpha 1This field is used to distriguish between SWIFT ID numers and Routing numbers.
  • S SWIFT
  • R Routing Number
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-CHARGE-CODE
CHARGE_CODE
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-PMT-CAT-CODE
PMT_CAT_CODE
Alpha 6AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-NORM-EXP-CODE
NORM_EXP_CODE
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-PMT-FORM
PMT_FORM
Alpha 2AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SWIFT-ID
SWIFT_ID
Alpha 12AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BUILD-SOC-REF
BUILD_SOC_REF
Alpha 18This field holds an individual account number reference for the Building SocietyAP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BUILD-ACCT-NM
BUILD_ACCT_NM
Alpha 18AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-DISCOUNT-CODE
DISCOUNT_CODE
Alpha 10A user-defined code that represents a general ledger discount account.AP110, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-CROSS-IDENT
CROSS_IDENT
Alpha 1This field is used to distinguish between SWIFT ID numbers and Routing numbers.
  • S Swift
  • R Routing Number
AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-GIRO-NUMBER
GIRO_NUMBER
Alpha 15This field is the Bankgiro or Postgiro account numberAP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-CR-CARD-NUMBER
CR_CARD_NUMBER
Alpha 16This field contains the credit card number.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-INSTRUCT1
BANK_INSTRUCT1
Alpha 35This field contains bank instructions.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-INSTRUCT2
BANK_INSTRUCT2
Alpha 35This field contains bank instructions.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-INSTRUCT3
BANK_INSTRUCT3
Alpha 35This field contains bank instructions.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-INSTRUCT4
BANK_INSTRUCT4
Alpha 35This field contains bank instructions.AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-P-CARD-FLAG
P_CARD_FLAG
Numeric 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-PCARD-NBR
PCARD_NBR
Alpha 16AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-GLN-NBR
GLN_NBR
Alpha 13AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-CREATED-BY
CREATED_BY
Alpha 10AP100, AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more
VLO-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)AP100, AP110, AP160, AP510, API3.1, IC64.1, IC64.2, IC64.3 +15 more
VLO-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8AP100, AP110, AP160, AP510, API3.1, IC64.1, IC64.2, IC64.3 +15 more
VLO-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AP100, AP110, AP160, AP510, API3.1, IC64.1, IC64.2, IC64.3 +15 more
VLO-VALID-CERT-DT
VALID_CERT_DT
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SOCIAL-ID1
SOCIAL_ID1
Alpha 80 (Lower Case)AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SOCIAL-ID2
SOCIAL_ID2
Alpha 80 (Lower Case)AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SOCIAL-ID3
SOCIAL_ID3
Alpha 80 (Lower Case)AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SOCIAL-ID4
SOCIAL_ID4
Alpha 80 (Lower Case)AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SOCIAL-ID5
SOCIAL_ID5
Alpha 80 (Lower Case)AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-CODE
BANK_CODE
Alpha 2AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-BANK-ID
BANK_ID
Alpha 9AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-ASSIGNMENT-NBR
ASSIGNMENT_NBR
Alpha 14AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-DEBITING-SIGN
DEBITING_SIGN
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-BANK-CODE
INTM_BANK_CODE
Alpha 2AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-BANK-ID
INTM_BANK_ID
Alpha 9AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-ASSIGN-NO
INTM_ASSIGN_NO
Alpha 14AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-INTM-DEBITING
INTM_DEBITING
Alpha 1AP510, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6 +11 more
VLO-SEPA-FLAG
SEPA_FLAG
Alpha 1
VLO-INTM-SEPA-FLAG
INTM_SEPA_FLAG
Alpha 1

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VLOSET1VENDOR-GROUP, VENDOR, LOCATION-CODEPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
VLOSET2VENDOR-GROUP, VENDOR, LOCATION-CODEKeyChange, SubsetWhere LOC-TYPE != "P"AP10.2, AP30.1, AP30.3, AP32.1, AP510, AP92.3, AP92.4, AP93.3 +19 more
VLOSET3VENDOR-GROUP, VENDOR, LOCATION-CODEKeyChange, SubsetWhere LOC-TYPE != "R"AP20.6, AP32.1, AP92.3, AP92.4, AP93.3, AP93.4
VLOSET4VENDOR-GROUP, VENDOR, LOCATION-CODESubsetWhere ACH-PRENOT = "N" Or ACH-PRENOT = "P"AP160
VLOSET5VENDOR-GROUP, EDI-NBR, VENDOR, LOCATION-CODEKeyChangeAP510, AP520, API3.1, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +12 more

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
Address1APVENADDRRequiredVLO-VENDOR-GROUPVDR-VENDOR-GROUP, VLO-VENDORVDR-VENDOR, VLO-LOCATION-CODEVDR-LOCATION-CODE, SpacesVDR-RESP-CODE, ZeroesVDR-CONTACT-LVL, "Y"VDR-CUR-ADDR
ApvengroupAPVENGROUPNot RequiredVEN-VENDOR-GROUPVGP-VENDOR-GROUP
ApvenlcbodAPVENLCBODNot Required, Delete CascadesVLO-VENDOR-GROUPYBB-VENDOR-GROUP, VLO-VENDORYBB-VENDOR, VLO-LOCATION-CODEYBB-LOCATION-CODE
ApvenmastAPVENMASTRequiredVLO-VENDOR-GROUPVEN-VENDOR-GROUP, VLO-VENDORVEN-VENDOR
GlnlocGLNLOCNot RequiredValid When VLO-GLN-NBR != SpacesPCG-ITEM-GROUPGLO-ITEM-GROUP, VLO-GLN-NBRGLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When VLO-GLN-NBR != SpacesPCG-ITEM-GROUPGLX-ITEM-GROUP, 8GLX-GLN-TYPE, VLO-VENDORGLX-VENDOR, VLO-LOCATION-CODEGLX-LOCATION-CODE, VLO-GLN-NBRGLX-GLN-NBR
ProcuregrpPROCUREGRPNot RequiredVEN-PROC-GRPPCG-PROCURE-GROUP

One to many (8) — child tables

RelationTableRulesConditionField map
ApcommentsAPCOMMENTSDelete Cascades"V"APC-REC-TYPE, VLO-VENDOR-GROUPAPC-VENDOR-GROUP, VLO-VENDORAPC-VENDOR, VLO-LOCATION-CODEAPC-LOCATION-CODE, APC-COMPANY, APC-SEQ-NBR
ApcontactsAPCONTACTDelete CascadesVLO-VENDOR-GROUPVCT-VENDOR-GROUP, VLO-VENDORVCT-VENDOR, VLO-LOCATION-CODEVCT-LOCATION-CODE, VCT-RESP-CODE, VCT-CONTACT-LVL
ApcpyvndAPCPYVNDVLO-VENDOR-GROUPAPX-VENDOR-GROUP, VLO-VENDORAPX-VENDOR, VLO-LOCATION-CODEAPX-LOCATION-CODE, APX-COMPANY
AplocbalAPVENBALDelete CascadesVLO-VENDOR-GROUPVBA-VENDOR-GROUP, VLO-VENDORVBA-VENDOR, VLO-LOCATION-CODEVBA-LOCATION-CODE, VBA-COMPANY
ApvenaddrAPVENADDRVLO-VENDOR-GROUPVDR-VENDOR-GROUP, VLO-VENDORVDR-VENDOR, VLO-LOCATION-CODEVDR-LOCATION-CODE, SpacesVDR-RESP-CODE, ZeroesVDR-CONTACT-LVL, VDR-EFFECTIVE-DATE
ApvenbalAPVENBALDelete CascadesVLO-VENDOR-GROUPVBA-VENDOR-GROUP, VLO-VENDORVBA-VENDOR, VEN-BAL-CURRENCYVBA-BAL-CURRENCY, VLO-LOCATION-CODEVBA-LOCATION-CODE, VBA-COMPANY
ApvencertAPVENCERTVLO-VENDOR-GROUPAVT-VENDOR-GROUP, VLO-VENDORAVT-VENDOR, VLO-LOCATION-CODEAVT-LOCATION-CODE, AVT-CERTIF-CODE, AVT-CERTIF-EFF-DT
ApvendivAPVENDIVVLO-VENDOR-GROUPVDC-VENDOR-GROUP, VLO-VENDORVDC-VENDOR, VLO-LOCATION-CODEVDC-LOCATION-CODE, VDC-DIVERSE-CODE, VDC-DCERT-DATE

Programs

Updated by (293)

Referenced by (76)