|
|
APVENADDR FILE
AP Vendor Address
The Vendor Address file contains vendor address information.
REFERENCED BY
AP102 CB186 CB187 CB286 POCP.1 AP130
ET700 AC210 AM18.1 AP02.3 AP145 AP146
AP150 AP155 AP156 AP160 AP161 AP202
AP265 AP282 AP284 AP290 MA05.2 PR198
RQIC.1 RQIG.1
UPDATED BY
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
AP10.3 AP10.9 AP100 AP109 AP110 AP115
AP125 AP126 AP131 AP14.2 AP14.1 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 AP300 AP305 AP510
AP520 AP90.1 AP91.1 API1.1 API2.1 API3.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
PO100 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 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ10.1 RQ10.2 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDR-VENDOR-GROUP Alpha 4 AC160 AM115
Element: Vendor Group A vendor group represents a group of AM117 AM15.1
vendors that can be shared by one or AM15.2 AM15.3
more companies. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor The vendor's identification code. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-LOCATION-CODE Alpha 4 AC160 AM115
Element: Location Code A user-defined code for a vendors' AM117 AM15.1
additional address. AM15.2 AM15.3
A blank location identifies a vendor AM15.4 AM19.1
master address record. A location code AM19.2 AM20.1
identifies an address for this specific AM20.3 AM21.1
location code. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.9 AP100
AP110 AP115
AP125 AP126
AP131 AP14.2
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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
VDR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Effective DateThe date a vendor's prices will be in AM117 AM15.1
effect. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-ADDR1 Alpha 30 (Lower Case) AC160 AM115
Element: Addr1 This field contains the first line of AM117 AM15.1
address information. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-ADDR2 Alpha 30 (Lower Case) AC160 AM115
Element: Addr1 This field contains the first line of AM117 AM15.1
address information. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-ADDR3 Alpha 30 (Lower Case) AC160 AM115
Element: Addr1 This field contains the first line of AM117 AM15.1
address information. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-ADDR4 Alpha 30 (Lower Case) AC160 AM115
Element: Addr1 This field contains the first line of AM117 AM15.1
address information. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-CITY-ADDR5 Alpha 18 (Lower Case) AC160 AM115
Element: City This field contains the city of the AM117 AM15.1
address. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-STATE-PROV Alpha 2 AC160 AM115
Element: State Prov The state or province. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-POSTAL-CODE Alpha 10 (Lower Case) AC160 AM115
Element: Postal Code This field contains the postal code. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-COUNTY Alpha 25 (Lower Case) AC160 AM115
Element: County The county for the company address. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-COUNTRY Alpha 30 (Lower Case) AC160 AM115
Element: Country This field contains the country of the AM117 AM15.1
address, or it can be used for AM15.2 AM15.3
additional information such as an AM15.4 AM19.1
attention name. 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 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
VDR-CUR-ADDR Alpha 1 AC160 AM115
Element: Current AddresIndicates if this is the current vendor AM117 AM15.1
address. 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
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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
VDR-REGION Alpha 2 AC160 AM115
Element: Region The region code, if applicable for the AM117 AM15.1
country. Used by Intrastat. Must be AM15.2 AM15.3
defined in IN02.1 (Region Maintenance) 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 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
VDR-COUNTRY-CODE Alpha 2 AC160 AM115
Element: Country Code The country code. Required for VAT and AM117 AM15.1
intrastat reporting. Must be defined in AM15.2 AM15.3
IN01.1 (Country Maintenance). 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 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
VDR-RESP-CODE Alpha 5 AP14.2 AP510
Element: Resp Code User defined field for label assignment
to contacts.
VDR-CONTACT-LVL Numeric 3 AP14.2 AP510
Element: Contact Lvl System generated assignment that can be
over-ridden at input. To distinguish
and prioritize contacts.
APVENADDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDRSET1 VENDOR-GROUP AC160 AM115
VENDOR AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
RESP-CODE AM15.4 AM19.1
CONTACT-LVL AM19.2 AM20.1
EFFECTIVE-DATE 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
...
VDRSET2 VENDOR-GROUP KeyChange, Subset AC160 AM115
VENDOR Where CUR-ADDR = "Y" AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
RESP-CODE AM15.4 AM19.1
CONTACT-LVL AM19.2 AM20.1
CUR-ADDR 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 AP20.1
AP20.2 AP20.3
...
VDRSET4 VENDOR-GROUP KeyChange AC160 AC210
VENDOR AM115 AM117
LOCATION-CODE AM15.1 AM15.2
RESP-CODE AM15.3 AM15.4
CONTACT-LVL AM18.1 AM19.1
EFFECTIVE-DATE* 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
...
|
