APVENADDR

AP Vendor Address

The Vendor Address file contains vendor address information.

REFERENCED BY
AP145 AP146 AP155 AP160 AP161 AP265
AP284 AP290 ZA161 AM18.1 AP202 MA05.2


UPDATED BY
AC160 AC210 AC297 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 AP02.3 AP03.3 AP10.1 AP10.2
AP10.3 AP10.9 AP100 AP102 AP109 AP110
AP111 AP115 AP125 AP126 AP130 AP131
AP14.1 AP14.2 AP14.5 AP150 AP156 AP16.1
AP170 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP271 AP282
AP30.2 AP30.4 AP300 AP305 AP510 AP520
AP590 AP90.1 AP90.6 AP90.7 AP91.1 API1.1
API2.1 API3.1 API4.1 ZA585 ZA586 CB186
CB187 CB286 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
EE135 EE20.1 EE20.2 EE35.1 EE35.2 EE520
DR100 IC140 IC142 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 EX14.1 EX14.2 MX123
MX500 MA180 MA279 MA310 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
MA530 MA531 MA60.2 MA60.3 MA60.4 MA60.5
MA61.1 MA63.1 MA64.6 MA64.9 MA65.1 MA66.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.4 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAED.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO28.2 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 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR198 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIC.1 RQIF.1 RQIG.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 ZW130

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.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification 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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.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.
...
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.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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
VDR-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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.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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
VDR-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal 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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.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.
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
VDR-CUR-ADDR
Element: Current Address
Alpha 1
Indicates if this is the current vendor address.
...
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.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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
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)
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
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).
...
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.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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
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
...
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
AP102 AP109
AP110 AP115
AP125 AP126
AP131 AP14.1
VDRSET2 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
CUR-ADDR
KeyChange, Subset
WhereCUR-ADDR ="Y"
...
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
AP109 AP110
AP111 AP115
AP125 AP126
AP130 AP131
VDRSET4 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
EFFECTIVE-DATE*
KeyChange
...
AC160 AC210
AC297 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM22.1 AM500
AM51.1 AM551
AM97.1 AP02.3
AP03.3 AP10.1
AP10.2 AP10.3
AP10.9 AP100
AP109 AP110


File created: Thu Jun 09 11:07:43 2016

Home
Contact Us



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