APVENLOC

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 AP10.9 AP109 AP111 AP12.1
AP135 AP14.1 AP14.2 AP14.3 AP14.4 AP14.5
AP151 AP155 AP156 AP16.1 AP16.2 AP161
AP170 AP180 AP181 AP190 AP191 AP193
AP28.1 AP28.2 AP290 AP32.1 AP520 AP55.1
AP55.2 AP56.1 AP56.2 AP590 AP80.1 AP810
AP96.4 AP98.1 AP98.2 APBD.2 ZA161 CB00.1
CB06.2 CB10.1 CB150 CB700 EE135 EE20.1
EE20.2 EE20.4 EE35.1 EE35.2 EE520 IC258
IC266 IC524 IC58.1 IC58.2 IC58.3 IC81.1
MA64.6 MA64.9 MAED.1 PD263 PO135 PO197
PO216 PO227 PO231 RQIC.1 RQID.1 RQIG.1
AP92.3 AP92.4 AP93.3 AP93.4


UPDATED BY
AP100 AP110 AP160 AP300 AP510 API3.1
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 PO100 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 TX140
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP115 AP125 AP126 AP13.2 AP131
AP150 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 AP271 AP30.2 AP30.4
AP305 AP90.1 AP91.1 API1.1 API2.1 API4.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC66.1 IC83.1 IC840 MX123 MX500 MA126
MA180 MA278 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO192 PO195 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO233 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO253
PO254 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO278 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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 PO529
PO536 PO54.1 PO54.2 PO54.3 PO54.4 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830

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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-VENDOR
Element: 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
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-LOCATION-CODE
Element: Location Code
Alpha 4
A 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
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-VENDOR-VNAME
Element: Name
Alpha 30 (Lower Case)
The name of the alternate vendor location.
AP100 AP135
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-VENDOR-CONTCT
Element: Contact
Alpha 30
The name of the main contact for the alternate vendor location.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The country code for the alternate vendor location telephone number.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-PHONE-NUM
Element: Phone
Alpha 15
The telephone number for the alternate vendor location.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-PHONE-EXT
Element: Phone Ext
Alpha 5
The telephone extension number for the alternate vendor location.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The country code for the fax machine telephone number.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-FAX-NUM
Element: Phone
Alpha 15
The fax machine telephone number.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-FAX-EXT
Element: Phone Ext
Alpha 5
The fax machine telephone number extension.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-TELEX-NUM
Element: Telex
Alpha 15
The telex number for the alternate vendor location.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Code indicating the taxing status. E - Exempt, T - Taxable.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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.
AP100 AP110
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 TX140
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.
AP110 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP110
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
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 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-BANK-CURRENCY
Element: Currency Code
Alpha 5
This field contains the bank currency code.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP110
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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.
AP100 AP110
AP125 AP126
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
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 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-EDI-NBR
Element: EDI Number
Alpha 15
The 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
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP110
AP160 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-OPERATOR
Element: Operator
Alpha 10
The operator associated with maintaining the alternate vendor location record.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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).
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-SEP-CHK-FLAG
Element: Separate Payment
Alpha 1
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-ERS-CAPABLE
Element: ERS Capable
Alpha 1

Y = Yes
N = No
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-ERS-HANDLING
Element: ERS Handling
Alpha 4
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-EDI-AUTO-REL
EDI Invoice Auto
Release
Alpha 1
Indicates 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
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-WRITE-OFF-AMT
Element: Minimum Claim Amount
Signed 18.2
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-VEN-CLAIM-TYPE
Element: Vendor 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
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PO52.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-CLAIM-HOLD-CD
Vendor Claims
Chargeback Hold
Alpha 4
The hold code.
AP100 AP110
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-REPLACE-GOODS
Element: Replace Goods
Alpha 1

N = No
Y = Yes
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-SHIP-OR-HOLD
Element: Ship or Hold Goods
Alpha 1

S = Ship
H = Hold
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PO52.1
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-VEND-ACCT
Element: Vend Acct
Alpha 30
The customer number the vendor has assigned to you.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-MOBILE-NUM
Element: Mobile Num
Alpha 15
This field contains the mobile phone number.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-MOBILE-EXT
Element: Mobile Ext
Alpha 5
This field contains the mobile phone extension number.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-PAY-IMM-FLAG
Element: All Flag
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-DIVERSE-CODE
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
AP110 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-INTM-BANK-ENT
Element: Bank Entity
Alpha 15
Type 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
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-BANK-ACCT
Element: Bank Acct Nbr
Alpha 35
Type 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
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-BANK-CURR
Element: Currency Code
Alpha 5
This field contains the intermediary bank currency code.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-PMT-CAT
Element: Pmt Cat Code
Alpha 6
Select the Intermediary SWIFT Payment Category.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-PMT-FORM
Element: Pmt Form
Alpha 2
Indicates how the Intermediary SWIFT payment is made.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-CHRG-CD
Element: Charge Code
Alpha 1
Indicates 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
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-CHARGE-CODE
Element: Charge Code
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-PMT-CAT-CODE
Element: Pmt Cat Code
Alpha 6
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-NORM-EXP-CODE
Element: Charge Code
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-PMT-FORM
Element: Pmt Form
Alpha 2
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SWIFT-ID
Element: Swift Id
Alpha 12
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BUILD-SOC-REF
Element: Build Soc Ref
Alpha 18
This field holds an individual account number reference for the Building Society
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BUILD-ACCT-NM
Element: Account Name
Alpha 18
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-DISCOUNT-CODE
Element: Discount Code
Alpha 10
A user-defined code that represents a general ledger discount account.
AP110 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-GIRO-NUMBER
Element: Giro Number
Alpha 15
This field is the Bankgiro or Postgiro account number
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-CR-CARD-NUMBER
Element: Cr Card Number
Alpha 16
This field contains the credit card number.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-INSTRUCT1
Element: Bank Instruct1
Alpha 35
This field contains bank instructions.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-INSTRUCT2
Element: Bank Instruct2
Alpha 35
This field contains bank instructions.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-INSTRUCT3
Element: Bank Instruct3
Alpha 35
This field contains bank instructions.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-INSTRUCT4
Element: Bank Instruct4
Alpha 35
This field contains bank instructions.
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-P-CARD-FLAG
Element: Flag Num
Numeric 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-PCARD-NBR
Element: Pcard Nbr
Alpha 16
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-CREATED-BY
Element: Operator
Alpha 10
AP100 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
VLO-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
AP100 AP110
AP160 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
TX140
VLO-LAST-UPDT-TIME
Element: Time
Numeric 8
AP100 AP110
AP160 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
TX140
VLO-LAST-UPDATE-BY
Element: Operator
Alpha 10
AP100 AP110
AP160 AP510
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
TX140
VLO-VALID-CERT-DT
Element: Flag
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SOCIAL-ID1
Element: Social Id1
Alpha 80 (Lower Case)
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SOCIAL-ID2
Element: Social Id2
Alpha 80 (Lower Case)
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SOCIAL-ID3
Element: Social Id3
Alpha 80 (Lower Case)
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SOCIAL-ID4
Element: Social Id4
Alpha 80 (Lower Case)
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SOCIAL-ID5
Element: Social Id5
Alpha 80 (Lower Case)
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-CODE
Element: Bank Code 2
Alpha 2
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-BANK-ID
Element: Category
Alpha 9
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-ASSIGNMENT-NBR
Element: Assign Nbr
Alpha 14
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-DEBITING-SIGN
Element: Debiting Sign
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-BANK-CODE
Element: Bank Code 2
Alpha 2
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-BANK-ID
Element: Category
Alpha 9
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-ASSIGN-NO
Element: Assign Nbr
Alpha 14
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-INTM-DEBITING
Element: Debiting Sign
Alpha 1
AP510 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLO-SEPA-FLAG
Element: Flag
Alpha 1
VLO-INTM-SEPA-FLAG
Element: Flag
Alpha 1


APVENLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLOSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP10.2 AP10.9
AP100 AP109
AP110 AP111
AP115 AP12.1
AP125 AP126
VLOSET2 VENDOR-GROUP
VENDOR
LOCATION-CODE
KeyChange, Subset
WhereLOC-TYPE !="P"
AP10.2 AP30.1
AP30.3 AP32.1
AP510 AP92.3
AP92.4 AP93.3
AP93.4 API3.1
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 PO100
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514
VLOSET3 VENDOR-GROUP
VENDOR
LOCATION-CODE
KeyChange, Subset
WhereLOC-TYPE !="R"
AP20.6 AP32.1
AP92.3 AP92.4
AP93.3 AP93.4
VLOSET4 VENDOR-GROUP
VENDOR
LOCATION-CODE
Subset
WhereACH-PRENOT ="N"
OrACH-PRENOT ="P"
AP160
VLOSET5 VENDOR-GROUP
EDI-NBR
VENDOR
LOCATION-CODE
KeyChange
AP510 AP520
API3.1 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO100 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514


APVENLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Apvengroup APVENGROUP Not Required
VEN-VENDOR-GROUP->VGP-VENDOR-GROUP
Apvenlcbod APVENLCBOD Not Required, Delete Cascades
VLO-VENDOR-GROUP->YBB-VENDOR-GROUP
VLO-VENDOR->YBB-VENDOR
VLO-LOCATION-CODE->YBB-LOCATION-CODE
Apvenmast APVENMAST Required
VLO-VENDOR-GROUP->VEN-VENDOR-GROUP
VLO-VENDOR->VEN-VENDOR
Glnloc GLNLOC Not Required
Valid When VLO-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLO-ITEM-GROUP
VLO-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When VLO-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLX-ITEM-GROUP
8->GLX-GLN-TYPE
VLO-VENDOR->GLX-VENDOR
VLO-LOCATION-CODE->GLX-LOCATION-CODE
VLO-GLN-NBR->GLX-GLN-NBR
Procuregrp PROCUREGRP Not Required
VEN-PROC-GRP->PCG-PROCURE-GROUP


APVENLOC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:07:33 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.