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
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VLO-VENDOR-GROUP Element: Vendor Group | Alpha 4 The vendor group to which the vendor and location belong. Must be a valid record in the Vendor Group file. |
|
||||||||||||||||||||||||
VLO-VENDOR Element: Vendor | Alpha 9 (Right Justified) The identification number assigned to the vendor. Must be a valid record in the Vendor file. |
|
||||||||||||||||||||||||
VLO-LOCATION-CODE Element: Location Code | Alpha 4 A user-defined code representing an alternate remittance or purchasing location for the vendor. |
|
||||||||||||||||||||||||
VLO-LOC-TYPE Element: Location Type | Alpha 1 Indicates the type of alternate vendor 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 Element: Name | Alpha 30 (Lower Case) The name of the alternate vendor location. |
|
||||||||||||||||||||||||
VLO-VENDOR-CONTCT Element: Contact | Alpha 30 The name of the main contact for the alternate vendor location. |
|
||||||||||||||||||||||||
VLO-NORM-REMIT Element: Normal Remit To | Alpha 1 If 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. |
|
||||||||||||||||||||||||
VLO-NORM-PURCH Element: Normal Purchase From | Alpha 1 If 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. |
|
||||||||||||||||||||||||
VLO-REMIT-TO-CODE Element: Remit Payment To | Alpha 4 If the Normal Purchase From Location 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 Element: Phone Prefix | Alpha 6 The country code for the alternate vendor location telephone number. |
|
||||||||||||||||||||||||
VLO-PHONE-NUM Element: Phone | Alpha 15 The telephone number for the alternate vendor location. |
|
||||||||||||||||||||||||
VLO-PHONE-EXT Element: Phone Ext | Alpha 5 The telephone extension number for the alternate vendor location. |
|
||||||||||||||||||||||||
VLO-FAX-PREFIX Element: Phone Prefix | Alpha 6 The country code for the fax machine telephone number. |
|
||||||||||||||||||||||||
VLO-FAX-NUM Element: Phone | Alpha 15 The fax machine telephone number. |
|
||||||||||||||||||||||||
VLO-FAX-EXT Element: Phone Ext | Alpha 5 The fax machine telephone number extension. |
|
||||||||||||||||||||||||
VLO-TELEX-NUM Element: Telex | Alpha 15 The telex number for the alternate vendor location. |
|
||||||||||||||||||||||||
VLO-TAX-EXEMPT-CD Element: Tax Exempt Cd | Alpha 1 Code indicating the taxing status. E - Exempt, T - Taxable. |
|
||||||||||||||||||||||||
VLO-TAX-CODE Element: Tax Code | Alpha 10 The 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. |
|
||||||||||||||||||||||||
VLO-TERM-CODE Element: Payment Terms | Alpha 5 The 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. |
|
||||||||||||||||||||||||
VLO-INV-CURRENCY Element: Invoice Currency | Alpha 5 The 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. |
|||||||||||||||||||||||||
VLO-BANK-CURRENCY Element: Currency Code | Alpha 5 This field contains the bank currency code. |
|
||||||||||||||||||||||||
VLO-CURR-RECALC Currency Recalculation | Alpha 1 Indicates 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. |
|
||||||||||||||||||||||||
VLO-BANK-INST-CODE Element: Payment Code | Alpha 3 The 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. |
|
||||||||||||||||||||||||
VLO-CASH-CODE Element: Cash Code | Alpha 4 The 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. |
|||||||||||||||||||||||||
VLO-BANK-ENTITY Element: Bank | Alpha 15 The 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. |
|
||||||||||||||||||||||||
VLO-VBANK-ACCT-NO Element: Bank Account | Alpha 35 The 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. |
|
||||||||||||||||||||||||
VLO-VBANK-ACCT-TP Element: Bank Account Type | Alpha 1 Indicates 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: C = Current/Checking Account. S = Savings Account. Blank = Electronic payment type was not selected. |
|
||||||||||||||||||||||||
VLO-VBANK-IDENT Element: Vbank Ident | Alpha 1 This field indicates if the account number is and IBAN number that requires an account validation check. Y = Yes N = No |
|
||||||||||||||||||||||||
VLO-EDI-NBR Element: EDI Number | Alpha 15 The electronic data interchange (EDI) number for the alternate vendor location. Used for reference. |
|
||||||||||||||||||||||||
VLO-ACH-PRENOT Prenotification Status | Alpha 1 Required only for ACH payment types. Indicates the status of electronic payment processing between the alternate vendor location and the processing bank. Valid values are: N = Notified. Payment Tape Creation (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. 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 Element: Operator | Alpha 10 The operator associated with maintaining the alternate vendor location record. |
|
||||||||||||||||||||||||
VLO-USER-NAME-01 Element: Vendor User Field 1 | Alpha 20 The value of the information being tracked by the first user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-USER-NAME-02 Element: Vendor User Field 2 | Alpha 20 The value of the information being tracked by the second user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-USER-NAME-03 Element: Vendor User Field 3 | Alpha 20 The value of the information being tracked by the third user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-USER-NAME-04 Element: Vendor User Field 4 | Alpha 20 The value of the information being tracked by the fourth user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-USER-NAME-05 Element: Vendor User Field 5 | Alpha 20 The value of the information being tracked by the fifth user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-USER-NAME-06 Element: Vendor User Field 6 | Alpha 20 The value of the information being tracked by the sixth user-defined vendor group field. |
|
||||||||||||||||||||||||
VLO-INVOICE-GROUP Element: Invoice Group | Alpha 4 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 Element: Separate Payment | Alpha 1 |
|
||||||||||||||||||||||||
VLO-ACTIVE-STATUS Element: Status | Alpha 1 The status of the account. If Inactive, no posting can be done to the account. A = Active I = Inactive D = Inactive for PO additions |
|
||||||||||||||||||||||||
VLO-ERS-CAPABLE Element: ERS Capable | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||||
VLO-ERS-HANDLING Element: ERS Handling | Alpha 4 |
|
||||||||||||||||||||||||
VLO-INVC-REF-TYPE ERS Invoice Reference | Alpha 2 Indicates 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 |
|
||||||||||||||||||||||||
VLO-EDI-AUTO-REL EDI Invoice Auto Release | Alpha 1 Indicates whether the company automatically releases EDI invoices. Y = Yes N = No |
|
||||||||||||||||||||||||
VLO-WRITE-OFF-AMT Element: Minimum Claim Amount | Signed 18.2 |
|
||||||||||||||||||||||||
VLO-VEN-CLAIM-TYPE Element: Vendor Claim Type | Alpha 2 CB = Chargeback CM = Credit Memo N = None |
|
||||||||||||||||||||||||
VLO-CLAIM-HOLD-CD Vendor Claims Chargeback Hold | Alpha 4 The hold code. |
|
||||||||||||||||||||||||
VLO-REPLACE-GOODS Element: Replace Goods | Alpha 1 N = No Y = Yes |
|
||||||||||||||||||||||||
VLO-SHIP-OR-HOLD Element: Ship or Hold Goods | Alpha 1 S = Ship H = Hold |
|
||||||||||||||||||||||||
VLO-E-MAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) e-mail address. |
|
||||||||||||||||||||||||
VLO-VEND-ACCT Element: Vend Acct | Alpha 30 The customer number the vendor has assigned to you. |
|
||||||||||||||||||||||||
VLO-TAX-USAGE-CD Element: Tax Usage Cd | Alpha 10 The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. |
|
||||||||||||||||||||||||
VLO-VAT-REG-CTRY Element: Vat Reg Ctry | Alpha 2 The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction. |
|
||||||||||||||||||||||||
VLO-VAT-REG-NBR Element: Vat Reg Nbr | Alpha 12 The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number. |
|
||||||||||||||||||||||||
VLO-VDR-ADDR1 Element: Vdr Addr1 | Derived Vendor location address line 1. |
|
||||||||||||||||||||||||
VLO-VDR-ADDR2 Element: Vdr Addr2 | Derived Vendor location address line 2. |
|
||||||||||||||||||||||||
VLO-VDR-ADDR3 Element: Vdr Addr3 | Derived Vendor location address line 3. |
|
||||||||||||||||||||||||
VLO-VDR-ADDR4 Element: Vdr Addr4 | Derived Vendor location address line 4. |
|
||||||||||||||||||||||||
VLO-VDR-CITY-ADDR5 Element: Vdr City Addr5 | Derived Vendor city or address line 5. |
|
||||||||||||||||||||||||
VLO-VDR-STATE Element: Vdr State | Derived Vendor state or province. |
|
||||||||||||||||||||||||
VLO-VDR-POSTAL Element: Vdr Postal | Derived Vendor postal code. |
|
||||||||||||||||||||||||
VLO-VDR-COUNTRY Element: Vdr Country | Derived Vendor country. |
|
||||||||||||||||||||||||
VLO-VDR-COUNTY Element: Vdr County | Derived |
|
||||||||||||||||||||||||
VLO-VAT-NBR Element: Vat Nbr | Derived The concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID. |
|
||||||||||||||||||||||||
VLO-MBL-INT-PREFIX Element: Mbl Int Prefix | Alpha 6 This field contains the country code of the mobile phone number. |
|
||||||||||||||||||||||||
VLO-MOBILE-NUM Element: Mobile Num | Alpha 15 This field contains the mobile phone number. |
|
||||||||||||||||||||||||
VLO-MOBILE-EXT Element: Mobile Ext | Alpha 5 This field contains the mobile phone extension number. |
|
||||||||||||||||||||||||
VLO-PAY-IMM-FLAG Element: All Flag | Alpha 1 |
|
||||||||||||||||||||||||
VLO-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||||||||||||||||||||||||
VLO-INTM-BANK-ENT Element: Bank Entity | Alpha 15 Type the intermediary bank identification used to deposit electronic payments for the vendor. |
|
||||||||||||||||||||||||
VLO-INTM-BANK-ACCT Element: Bank Acct Nbr | Alpha 35 Type the intermediary bank account number used to deposit electronic payments for the vendor. |
|
||||||||||||||||||||||||
VLO-INTM-BANK-IDNT Element: Intm Bank Idnt | Alpha 1 This field indicates if the account umber is an IBAN number that requires an account validation check. Y = Yes N = No |
|
||||||||||||||||||||||||
VLO-INTM-BANK-CURR Element: Currency Code | Alpha 5 This field contains the intermediary bank currency code. |
|
||||||||||||||||||||||||
VLO-INTM-PRENOT Element: All Flag | Alpha 1 If 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 |
|
||||||||||||||||||||||||
VLO-INTM-SWIFT-ID Element: Patient Id | Alpha 12 Use SWIFT Payment Options (AP10.8) to define SWIFT payment options if you create Intermediary SWIFT payments for the vendor. |
|
||||||||||||||||||||||||
VLO-INTM-PMT-CAT Element: Pmt Cat Code | Alpha 6 Select the Intermediary SWIFT Payment Category. |
|
||||||||||||||||||||||||
VLO-INTM-NORM-EXP Element: Charge Code | Alpha 1 Indicates whether the SWIFT payment is a normal or express payment. N = Normal E = Express " " = Not defined for the vendor |
|
||||||||||||||||||||||||
VLO-INTM-PMT-FORM Element: Pmt Form | Alpha 2 Indicates how the Intermediary SWIFT payment is made. |
|
||||||||||||||||||||||||
VLO-INTM-CHRG-CD Element: Charge Code | Alpha 1 Indicates who pays service charges or fees associated with a Intermediary SWIFT payment. |
|
||||||||||||||||||||||||
VLO-INTM-CRS-IDENT Element: Intm Crs Ident | Alpha 1 This field is used to distriguish between SWIFT ID numers and Routing numbers. S = SWIFT R = Routing Number |
|
||||||||||||||||||||||||
VLO-CHARGE-CODE Element: Charge Code | Alpha 1 |
|
||||||||||||||||||||||||
VLO-PMT-CAT-CODE Element: Pmt Cat Code | Alpha 6 |
|
||||||||||||||||||||||||
VLO-NORM-EXP-CODE Element: Charge Code | Alpha 1 |
|
||||||||||||||||||||||||
VLO-PMT-FORM Element: Pmt Form | Alpha 2 |
|
||||||||||||||||||||||||
VLO-SWIFT-ID Element: Swift Id | Alpha 12 |
|
||||||||||||||||||||||||
VLO-BUILD-SOC-REF Element: Build Soc Ref | Alpha 18 This field holds an individual account number reference for the Building Society |
|
||||||||||||||||||||||||
VLO-BUILD-ACCT-NM Element: Account Name | Alpha 18 |
|
||||||||||||||||||||||||
VLO-DISCOUNT-CODE Element: Discount Code | Alpha 10 A user-defined code that represents a general ledger discount account. |
|
||||||||||||||||||||||||
VLO-CROSS-IDENT Element: Cross Ident | Alpha 1 This field is used to distinguish between SWIFT ID numbers and Routing numbers. S = Swift R = Routing Number |
|
||||||||||||||||||||||||
VLO-GIRO-NUMBER Element: Giro Number | Alpha 15 This field is the Bankgiro or Postgiro account number |
|
||||||||||||||||||||||||
VLO-CR-CARD-NUMBER Element: Cr Card Number | Alpha 16 This field contains the credit card number. |
|
||||||||||||||||||||||||
VLO-BANK-INSTRUCT1 Element: Bank Instruct1 | Alpha 35 This field contains bank instructions. |
|
||||||||||||||||||||||||
VLO-BANK-INSTRUCT2 Element: Bank Instruct2 | Alpha 35 This field contains bank instructions. |
|
||||||||||||||||||||||||
VLO-BANK-INSTRUCT3 Element: Bank Instruct3 | Alpha 35 This field contains bank instructions. |
|
||||||||||||||||||||||||
VLO-BANK-INSTRUCT4 Element: Bank Instruct4 | Alpha 35 This field contains bank instructions. |
|
||||||||||||||||||||||||
VLO-P-CARD-FLAG Element: Flag Num | Numeric 1 |
|
||||||||||||||||||||||||
VLO-PCARD-NBR Element: Pcard Nbr | Alpha 16 |
|
||||||||||||||||||||||||
VLO-GLN-NBR Element: Gln Nbr | Alpha 13 |
|
||||||||||||||||||||||||
VLO-CREATED-BY Element: Operator | Alpha 10 |
|
||||||||||||||||||||||||
VLO-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||
VLO-LAST-UPDT-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||||
VLO-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|
||||||||||||||||||||||||
VLO-VALID-CERT-DT Element: Flag | Alpha 1 |
|
||||||||||||||||||||||||
VLO-SOCIAL-ID1 Element: Social Id1 | Alpha 80 (Lower Case) |
|
||||||||||||||||||||||||
VLO-SOCIAL-ID2 Element: Social Id2 | Alpha 80 (Lower Case) |
|
||||||||||||||||||||||||
VLO-SOCIAL-ID3 Element: Social Id3 | Alpha 80 (Lower Case) |
|
||||||||||||||||||||||||
VLO-SOCIAL-ID4 Element: Social Id4 | Alpha 80 (Lower Case) |
|
||||||||||||||||||||||||
VLO-SOCIAL-ID5 Element: Social Id5 | Alpha 80 (Lower Case) |
|
||||||||||||||||||||||||
VLO-BANK-CODE Element: Bank Code 2 | Alpha 2 |
|
||||||||||||||||||||||||
VLO-BANK-ID Element: Category | Alpha 9 |
|
||||||||||||||||||||||||
VLO-ASSIGNMENT-NBR Element: Assign Nbr | Alpha 14 |
|
||||||||||||||||||||||||
VLO-DEBITING-SIGN Element: Debiting Sign | Alpha 1 |
|
||||||||||||||||||||||||
VLO-INTM-BANK-CODE Element: Bank Code 2 | Alpha 2 |
|
||||||||||||||||||||||||
VLO-INTM-BANK-ID Element: Category | Alpha 9 |
|
||||||||||||||||||||||||
VLO-INTM-ASSIGN-NO Element: Assign Nbr | Alpha 14 |
|
||||||||||||||||||||||||
VLO-INTM-DEBITING Element: Debiting Sign | Alpha 1 |
|
||||||||||||||||||||||||
VLO-SEPA-FLAG Element: Flag | Alpha 1 |
|
||||||||||||||||||||||||
VLO-INTM-SEPA-FLAG Element: Flag | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VLOSET1 |
VENDOR-GROUP VENDOR LOCATION-CODE |
|
|||||||||||||||||||||||||||||||||||||||||
VLOSET2 |
VENDOR-GROUP VENDOR LOCATION-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||
VLOSET3 |
VENDOR-GROUP VENDOR LOCATION-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||
VLOSET4 |
VENDOR-GROUP VENDOR LOCATION-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||
VLOSET5 |
VENDOR-GROUP EDI-NBR VENDOR LOCATION-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Address1 | APVENADDR |
Required
| |||||||||||||||||||||
Apvengroup | APVENGROUP |
Not Required
| |||||||||||||||||||||
Apvenlcbod | APVENLCBOD |
Not Required, Delete Cascades
| |||||||||||||||||||||
Apvenmast | APVENMAST |
Required
| |||||||||||||||||||||
Glnloc | GLNLOC |
Not Required
| |||||||||||||||||||||
Glnlocdtl | GLNLOCDTL |
Not Required
| |||||||||||||||||||||
Procuregrp | PROCUREGRP |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcomments | APCOMMENTS |
Delete Cascades
| ||||||||||||||||||
Apcontacts | APCONTACT |
Delete Cascades
| ||||||||||||||||||
Apcpyvnd | APCPYVND |
| ||||||||||||||||||
Aplocbal | APVENBAL |
Delete Cascades
| ||||||||||||||||||
Apvenaddr | APVENADDR |
| ||||||||||||||||||
Apvenbal | APVENBAL |
Delete Cascades
| ||||||||||||||||||
Apvencert | APVENCERT |
| ||||||||||||||||||
Apvendiv | APVENDIV |
|
All trademarks and registered trademarks are the property of their
respective owners.