APVENADDR

AP Vendor Address

The Vendor Address file contains vendor address information.

REFERENCED BY
AP145 AP146 AP155 AP160 AP161 AP202
AP265 AP284 AP290


UPDATED BY
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 AP10.3
AP10.9 AP10.1 AP10.2 AP100 AP109 AP110
AP115 AP125 AP126 AP131 AP14.2 AP14.1
AP150 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP20.6 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP300 AP305 AP510 AP520 AP90.1 AP90.6
AP90.7 AP91.1 API1.1 API2.1 API3.1 API4.1
MX123 MX500 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO10.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
AP102 CB186 CB187 CB286 AP130 AC210
AM18.1 AP02.3 AP156 AP282 MA05.2 PR198

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDR-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-LOCATION-CODE
Element: Location Code
Alpha 4
A user-defined code for a vendors' additional address. A blank location identifies a vendor master address record. A location code identifies an address for this specific location code.
...
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 AP10.9
AP100 AP110
AP115 AP125
AP126 AP131
AP14.2 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
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
VDR-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
AP150 AP160
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 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
VDR-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
VDR-CUR-ADDR
Element: Current Address
Alpha 1
Indicates if this is the current vendor address.
...
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 AP10.3
AP10.9 AP100
AP109 AP110
AP115 AP125
AP126 AP131
AP14.2 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
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
VDR-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
VDR-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
...
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 AP10.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
VDR-RESP-CODE
Element: Resp Code
Alpha 5
User defined field for label assignment to contacts.
AP14.2 AP510
VDR-CONTACT-LVL
Element: Contact Lvl
Numeric 3
System generated assignment that can be over-ridden at input. To distinguish and prioritize contacts.
AP14.2 AP510


APVENADDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDRSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
EFFECTIVE-DATE
...
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 AP10.1
AP10.2 AP10.9
AP102 AP109
AP110 AP115
AP125 AP126
AP131 AP14.1
AP14.2 AP150
VDRSET2 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
CUR-ADDR
KeyChange, Subset
WhereCUR-ADDR ="Y"
...
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 AP10.9
AP109 AP110
AP115 AP125
AP126 AP130
AP131 AP14.2
AP150 AP20.1
AP20.2 AP20.3
VDRSET4 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
EFFECTIVE-DATE*
KeyChange
...
AC210 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP02.3 AP03.3
AP10.1 AP10.2
AP10.3 AP10.9
AP100 AP109
AP110 AP115
AP125 AP126


File created: Wed Jun 08 20:47:34 2016

Home
Contact Us



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