Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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     AP12.1    AP13.2    AP135
AP14.1    AP14.3    AP14.4    AP150     AP151     AP155
AP156     AP16.2    AP161     AP170     AP180     AP191
AP193     AP28.1    AP28.2    AP290     AP32.1    AP520
AP55.1    AP56.1    AP56.2    AP80.1    AP810     AP96.4
CB06.2    EE135     EE20.1    EE20.2    EE20.4    EE35.1
EE35.2    EE520     PO150     PO204     PO216     PO227
PO231     RQ11.1    RQ13.2    RQ35.1    RQ500     RQIB.1
RQIC.1    RQID.1    RQIF.1    RQIG.1    RQIJ.1    AP92.3
AP92.4    AP93.3    AP93.4

UPDATED BY

AP100     AP110     AP160     AP300     AP510     API3.1
PO100     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    PR514     UK47.1    TX140     AC160     AM115
AM117     AM15.1    AM15.2    AM15.3    AM15.4    AM19.1
AM19.2    AM20.1    AM20.3    AM21.1    AM21.3    AM500
AM51.1    AM551     AM97.1    AP03.3    AP115     AP125
AP126     AP131     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP21.1    AP210     AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     AP90.1    AP91.1    API1.1    API2.1    API4.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MX123     MX500     MA180     MA279     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PD235     PO10.1    PO101
PO120     PO122     PO131     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO223
PO23.1    PO233     PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO253     PO254     PO27.2    PO278     PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO32.4    PO33.1    PO34.1    PO35.1    PO36.1
PO36.2    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     PO536     PO54.1    PO54.2    PO54.3
PO54.4    POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7

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  PO100
                       and location belong. Must be a valid      PR05.1  PR05.3
                       record in the Vendor Group file.          PR226   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  PO100
                       the vendor. Must be a valid record in     PR05.1  PR05.3
                       the Vendor file.                          PR226   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  PO100
                       alternate remittance or purchasing        PR05.1  PR05.3
                       location for the vendor.                  PR226   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  PO100
                       location. Valid values are:               PR05.1  PR05.3
                                                                 PR226   PR247
                       B = Both. The location code represents    PR26.1  PR47.1
                       both a purchasing and a remittance        PR514   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.                                 PO100   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  PO100
                       alternate vendor location.                PR05.1  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  PO100
                       field indicates whether the location is   PR05.1  PR05.3
                       the normal remit-to location for the      PR226   PR247
                       vendor. If Yes is selected in this        PR26.1  PR47.1
                       field, the location address               PR514   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  PO100
                       field indicates whether the location is   PR05.1  PR05.3
                       the normal purchase-from location for     PR226   PR247
                       the vendor. If Yes is selected in this    PR26.1  PR47.1
                       field, the location address               PR514   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  PO100
                       field = Yes, this field indicates which   PR05.1  PR05.3
                       alternate remit-to location will be used  PR226   PR247
                       when the purchase-from location code is   PR26.1  PR47.1
                       used. Must be a valid remit-to location   PR514   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
Element: Phone Prefix  The country code for the alternate        API3.1  PO100
                       vendor location telephone number.         PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-PHONE-NUM          Alpha 15                                  AP100   AP510
Element: Phone         The telephone number for the alternate    API3.1  PO100
                       vendor location.                          PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-PHONE-EXT          Alpha 5                                   AP100   AP510
Element: Phone Ext     The telephone extension number for the    API3.1  PO100
                       alternate vendor location.                PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-FAX-PREFIX         Alpha 6                                   AP100   AP510
Element: Phone Prefix  The country code for the fax machine      API3.1  PO100
                       telephone number.                         PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-FAX-NUM            Alpha 15                                  AP100   AP510
Element: Phone         The fax machine telephone number.         API3.1  PO100
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-FAX-EXT            Alpha 5                                   AP100   AP510
Element: Phone Ext     The fax machine telephone number          API3.1  PO100
                       extension.                                PR05.1  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  PO100
                       vendor location.                          PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-TAX-EXEMPT-CD      Alpha 1                                   API3.1  PO100
Element: Tax Exempt Cd Code indicating the taxing status. E -    PR05.1  PR05.3
                       Exempt, T - Taxable.                      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    PO100   PR05.1
                       calculate invoice tax information. Must   PR05.3  PR226
                       be a valid record in the Tax Code file.   PR247   PR26.1
                       If left blank, the tax code assigned to   PR47.1  PR514
                       the vendor, if assigned, defaults. Valid  TX140   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  PO100
                       alternate vendor location. Used to        PR05.1  PR05.3
                       automatically calculate invoice due date  PR226   PR247
                       and discount information for the          PR26.1  PR47.1
                       location's invoices. Must be a valid      PR514   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.  AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP510   AP56.1
                                                                 AP56.2  AP80.1
                                                                 API3.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BANK-CURRENCY      Alpha 5                                   AP510   API3.1
Element: Currency Code This field contains the bank currency     PO100   PR05.1
                       code.                                     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  PO100
Recalculation          alternate vendor location will be         PR05.1  PR05.3
                       automatically revalued to account for     PR226   PR247
                       currency rate fluctuations when they are  PR26.1  PR47.1
                       scheduled for payment. This revaluation   PR514   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   PO100   PR05.1
                       type of cash payment, such as a check or  PR05.3  PR226
                       payment tape, or a bill of exchange       PR247   PR26.1
                       payment. Must be a valid cash or bill of  PR47.1  PR514
                       exchange payment transaction code record  UK47.1
                       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.        AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP510   AP56.1
                                                                 AP56.2  AP80.1
                                                                 API3.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PO100   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  PO100
                       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.        PR514   UK47.1


VLO-VBANK-ACCT-NO      Alpha 35                                  AP100   AP510
Element: Bank Account  The bank account number used to deposit   API3.1  PO100
                       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  PR514   UK47.1
                       both.

VLO-VBANK-ACCT-TP      Alpha 1                                   AP100   AP510
Element: Bank Account TIndicates the type of bank account used   API3.1  PO100
                       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:                         PR514   UK47.1

                       C = Current/Checking Account.
                       S = Savings Account.
                       Blank = Electronic payment type was not
                       selected.



VLO-VBANK-IDENT        Alpha 1                                   AP510   API3.1
Element: Vbank Ident   This field indicates if the account       PO100   PR05.1
                       number is and IBAN number that requires   PR05.3  PR226
                       an account validation check.              PR247   PR26.1
                                                                 PR47.1  PR514
                       Y = Yes                                   UK47.1
                       N = No

VLO-EDI-NBR            Alpha 15                                  AP100   AP510
Element: EDI Number    The electronic data interchange (EDI)     API3.1  PO100
                       number for the alternate vendor           PR05.1  PR05.3
                       location. Used for reference.             PR226   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  PO100
                       payment processing between the alternate  PR05.1  PR05.3
                       vendor location and the processing bank.  PR226   PR247
                       Valid values are:                         PR26.1  PR47.1
                                                                 PR514   UK47.1
                       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           Alpha 10                                  AP100   AP510
Element: Operator      The operator associated with              API3.1  PO100
                       maintaining the alternate vendor          PR05.1  PR05.3
                       location record.                          PR226   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  PO100
                       tracked by the first user-defined vendor  PR05.1  PR05.3
                       group field.                              PR226   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  PO100
                       tracked by the second user-defined        PR05.1  PR05.3
                       vendor group field.                       PR226   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  PO100
                       tracked by the third user-defined vendor  PR05.1  PR05.3
                       group field.                              PR226   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  PO100
                       tracked by the fourth user-defined        PR05.1  PR05.3
                       vendor group field.                       PR226   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  PO100
                       tracked by the fifth user-defined vendor  PR05.1  PR05.3
                       group field.                              PR226   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  PO100
                       tracked by the sixth user-defined vendor  PR05.1  PR05.3
                       group field.                              PR226   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  PO100
                       to the location. This value defaults on   PR05.1  PR05.3
                       invoices entered for the location. Can    PR226   PR247
                       be used to select invoices for payment    PR26.1  PR47.1
                       in AP150 (Cash Requirements).             PR514   UK47.1

VLO-SEP-CHK-FLAG       Alpha 1                                   AP100   AP510
Element: Separate Payment                                        API3.1  PO100
                                                                 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  PO100
                       no posting can be done to the account.    PR05.1  PR05.3
                                                                 PR226   PR247
                       A = Active                                PR26.1  PR47.1
                       I = Inactive                              PR514   UK47.1
                       D = Inactive for PO additions

VLO-ERS-CAPABLE        Alpha 1                                   AP100   AP510
Element: ERS Capable   Y = Yes                                   API3.1  PO100
                       N = No                                    PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-ERS-HANDLING       Alpha 4                                   AP100   AP510
Element: ERS Handling                                            API3.1  PO100
                                                                 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  PO100
Reference              is providing to reference the invoice.    PR05.1  PR05.3
                                                                 PR226   PR247
                       BM = Bill of Lading                       PR26.1  PR47.1
                       IN = Invoice                              PR514   UK47.1
                       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       Alpha 1                                   AP100   AP510
EDI Invoice Auto       Indicates whether the company             API3.1  PO100
Release                automatically releases EDI invoices.      PR05.1  PR05.3
                                                                 PR226   PR247
                       Y = Yes                                   PR26.1  PR47.1
                       N = No                                    PR514   UK47.1

VLO-WRITE-OFF-AMT      Signed 18.2                               AP100   AP510
Element: Minimum Claim Amount                                    API3.1  PO100
                                                                 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  PO100
                       CM = Credit Memo                          PO52.1  PR05.1
                       N = None                                  PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-CLAIM-HOLD-CD      Alpha 4                                   AP100   AP510
Vendor Claims          The hold code.                            API3.1  PO100
Chargeback Hold                                                  PR05.1  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  PO100
                       Y = Yes                                   PR05.1  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  PO100
                       H = Hold                                  PO52.1  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 e-mail address.                           API3.1  PO100
                                                                 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  PO100
                       assigned to you.                          PR05.1  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  PO100
                       filed is required if the AP Company       PR05.1  PR05.3
                       inidcates that VAT reporting required.    PR226   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  PO100
                       Registration Number. This field,          PR05.1  PR05.3
                       together with the Registration Number     PR226   PR247
                       for the company on the tax transaction.   PR26.1  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  PO100
                       Registration Number. This field together  PR05.1  PR05.3
                       with the Registration Country field make  PR226   PR247
                       up the VAT Registration Number.           PR26.1  PR47.1
                                                                 PR514   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   PO100   PR05.1
                       the mobile phone number.                  PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-MOBILE-NUM         Alpha 15                                  AP510   API3.1
Element: Mobile Num    This field contains the mobile phone      PO100   PR05.1
                       number.                                   PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-MOBILE-EXT         Alpha 5                                   AP510   API3.1
Element: Mobile Ext    This field contains the mobile phone      PO100   PR05.1
                       extension number.                         PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-PAY-IMM-FLAG       Alpha 1                                   AP510   API3.1
Element: All Flag                                                PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-DIVERSE-CODE       Alpha 5                                   AP110   AP510
Element: Diverse Code  Diversity Code for Account Payable        API3.1  PO100
                       Vendors                                   PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-INTM-BANK-ENT      Alpha 15                                  AP510   API3.1
Element: Bank Entity   Type the intermediary bank                PO100   PR05.1
                       identification used to deposit            PR05.3  PR226
                       electronic payments for the vendor.       PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-BANK-ACCT     Alpha 35                                  AP510   API3.1
Element: Bank Acct Nbr Type the intermediary bank account        PO100   PR05.1
                       number used to deposit electronic         PR05.3  PR226
                       payments for the vendor.                  PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-BANK-IDNT     Alpha 1                                   AP510   API3.1
Element: Intm Bank IdntThis field indicates if the account       PO100   PR05.1
                       umber is an IBAN number that requires an  PR05.3  PR226
                       account validation check.                 PR247   PR26.1
                                                                 PR47.1  PR514
                       Y = Yes                                   UK47.1
                       N = No

VLO-INTM-BANK-CURR     Alpha 5                                   AP510   API3.1
Element: Currency Code This field contains the intermediary      PO100   PR05.1
                       bank currency code.                       PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-PRENOT        Alpha 1                                   AP510   API3.1
Element: All Flag      If you create Intermediary ACH payments   PO100   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  PR514
                       the vendor and the processing bank.       UK47.1
                       A = Accepted
                       N = Not Prenotified
                       P = Prenotified

VLO-INTM-SWIFT-ID      Alpha 12                                  AP510   API3.1
Element: Patient Id    Use SWIFT Payment Options (AP10.8) to     PO100   PR05.1
                       define SWIFT payment options if you       PR05.3  PR226
                       create Intermediary SWIFT payments for    PR247   PR26.1
                       the vendor.                               PR47.1  PR514
                                                                 UK47.1

VLO-INTM-PMT-CAT       Alpha 6                                   AP510   API3.1
Element: Pmt Cat Code  Select the Intermediary SWIFT Payment     PO100   PR05.1
                       Category.                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-NORM-EXP      Alpha 1                                   AP510   API3.1
Element: Charge Code   Indicates whether the SWIFT payment is a  PO100   PR05.1
                       normal or express payment.                PR05.3  PR226
                       N = Normal                                PR247   PR26.1
                       E = Express                               PR47.1  PR514
                       " " = Not defined for the vendor          UK47.1

VLO-INTM-PMT-FORM      Alpha 2                                   AP510   API3.1
Element: Pmt Form      Indicates how the Intermediary SWIFT      PO100   PR05.1
                       payment is made.                          PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-CHRG-CD       Alpha 1                                   AP510   API3.1
Element: Charge Code   Indicates who pays service charges or     PO100   PR05.1
                       fees associated with a Intermediary       PR05.3  PR226
                       SWIFT payment.                            PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-INTM-CRS-IDENT     Alpha 1                                   AP510   API3.1
Element: Intm Crs IdentThis field is used to distriguish         PO100   PR05.1
                       between SWIFT ID numers and Routing       PR05.3  PR226
                       numbers.                                  PR247   PR26.1
                       S = SWIFT                                 PR47.1  PR514
                       R = Routing Number                        UK47.1

VLO-CHARGE-CODE        Alpha 1                                   AP510   API3.1
Element: Charge Code                                             PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-PMT-CAT-CODE       Alpha 6                                   AP510   API3.1
Element: Pmt Cat Code                                            PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-NORM-EXP-CODE      Alpha 1                                   AP510   API3.1
Element: Charge Code                                             PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-PMT-FORM           Alpha 2                                   AP510   API3.1
Element: Pmt Form                                                PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-SWIFT-ID           Alpha 12                                  AP510   API3.1
Element: Swift Id                                                PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BUILD-SOC-REF      Alpha 18                                  AP510   API3.1
Element: Build Soc Ref This field holds an individual account    PO100   PR05.1
                       number reference for the Building         PR05.3  PR226
                       Society                                   PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BUILD-ACCT-NM      Alpha 18                                  AP510   API3.1
Element: Account Name                                            PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-DISCOUNT-CODE      Alpha 10                                  API3.1  PO100
Element: Discount Code A user-defined code that represents a     PR05.1  PR05.3
                       general ledger discount account.          PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLO-CROSS-IDENT        Alpha 1                                   AP510   API3.1
Element: Cross Ident   This field is used to distinguish         PO100   PR05.1
                       between SWIFT ID numbers and Routing      PR05.3  PR226
                       numbers.                                  PR247   PR26.1
                       S = Swift                                 PR47.1  PR514
                       R = Routing Number                        UK47.1

VLO-GIRO-NUMBER        Alpha 15                                  AP510   API3.1
Element: Giro Number   This field is the Bankgiro or Postgiro    PO100   PR05.1
                       account number                            PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-CR-CARD-NUMBER     Alpha 16                                  AP510   API3.1
Element: Cr Card NumberThis field contains the credit card       PO100   PR05.1
                       number.                                   PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BANK-INSTRUCT1     Alpha 35                                  AP510   API3.1
Element: Bank Instruct1This field contains bank instructions.    PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BANK-INSTRUCT2     Alpha 35                                  AP510   API3.1
Element: Bank Instruct2This field contains bank instructions.    PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BANK-INSTRUCT3     Alpha 35                                  AP510   API3.1
Element: Bank Instruct3This field contains bank instructions.    PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-BANK-INSTRUCT4     Alpha 35                                  AP510   API3.1
Element: Bank Instruct4This field contains bank instructions.    PO100   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514
                                                                 UK47.1

VLO-P-CARD-FLAG        Numeric 1
Element: Flag Num

VLO-PCARD-NBR          Alpha 16
Element: Pcard Nbr

                         APVENLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VLOSET1   VENDOR-GROUP                                           AC160   AM115
          VENDOR                                                 AM117   AM15.1
          LOCATION-CODE                                          AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP10.1  AP10.2
                                                                 AP100   AP109
                                                                 AP110   AP115
                                                                 AP12.1  AP125
                                                                 AP126   AP13.2
                                                                 AP131   AP135
                                                                 ...

VLOSET2   VENDOR-GROUP  KeyChange, Subset                        AP10.2  AP30.1
          VENDOR        Where LOC-TYPE != "P"                    AP30.3  AP32.1
          LOCATION-CODE                                          AP92.3  AP92.4
                                                                 AP93.3  AP93.4
                                                                 API3.1  PO100
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

VLOSET3   VENDOR-GROUP  KeyChange, Subset                        AP20.6  AP32.1
          VENDOR        Where LOC-TYPE != "R"                    AP92.3  AP92.4
          LOCATION-CODE                                          AP93.3  AP93.4

VLOSET4   VENDOR-GROUP  Subset                                   AP160
          VENDOR        Where ACH-PRENOT = "N"
          LOCATION-CODE Or    ACH-PRENOT = "P"

VLOSET5   VENDOR-GROUP  KeyChange                                AP520   API3.1
          EDI-NBR                                                PO100   PR05.1
          VENDOR                                                 PR05.3  PR226
          LOCATION-CODE                                          PR247   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
                            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

Apvendiv       APVENDIV

                            VLO-VENDOR-GROUP     -> VDC-VENDOR-GROUP
                            VLO-VENDOR           -> VDC-VENDOR
                            VLO-LOCATION-CODE    -> VDC-LOCATION-CODE
                                                    VDC-DIVERSE-CODE
                                                    VDC-DCERT-DATE