Lawson Insight Technical Documentation |
|
APVENLOC
APVENLOC FILE
Vendor Location
The Vendor Location file contains all location code records for alternate
vendor locations defined for accounts payable vendors. An alternate vendor
location can be used as a purchasing location, a remittance location, or both.
A vendor can have more than one alternate vendor location record.
REFERENCED BY
AP10.1 AP10.2 AP109 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
|