Lawson Insight Technical Documentation |
|
APVENADDR
APVENADDR FILE
AP Vendor Address
The Vendor Address file contains vendor address information.
REFERENCED BY
AP102 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP20.6 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1
IC28.1 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 PO100 PO101
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQIE.1 WH20.2 WH20.7 AP130 AC210 AC297
AM18.1 AP02.3 AP145 AP146 AP150 AP155
AP156 AP160 AP161 AP202 AP210 AP220
AP265 AP282 AP284 AP290 AP90.6 AP90.7
IC530 MA05.2 MA63.1 PR198 RQIC.1 RQIG.1
UPDATED BY
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP10.3 AP10.9 AP100 AP109 AP300
AP510 AP520 API3.1 API4.1 IC840 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDR-VENDOR-GROUP Alpha 4 AM115 AM15.1
Element: Vendor Group A vendor group represents a group of AM15.2 AM15.3
vendors that can be shared by one or AM15.4 AM20.1
more companies. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Element: Vendor ID The vendor's identification code. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-LOCATION-CODE Alpha 4 AM115 AM15.1
Purchase From A user-defined code for a vendors' AM15.2 AM15.3
Location Code additional address. AM15.4 AM20.1
A blank location identifies a vendor AM20.3 AM21.1
master address record. A location code AM21.3 AM500
identifies an address for this specific AM51.1 AM551
location code. AM97.1 AP10.9
AP100 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VDR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Element: Date AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-ADDR1 Alpha 30 (Lower Case) AM115 AM15.1
Element: Address 1 This field contains the first line of AM15.2 AM15.3
address information. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-ADDR2 Alpha 30 (Lower Case) AM115 AM15.1
Element: Address 1 AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-ADDR3 Alpha 30 (Lower Case) AM115 AM15.1
Element: Address 1 AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-ADDR4 Alpha 30 (Lower Case) AM115 AM15.1
Element: Address 1 AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-CITY-ADDR5 Alpha 18 (Lower Case) AM115 AM15.1
Element: City AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-STATE-PROV Alpha 2 AM115 AM15.1
Element: State or ProviThe state or province. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-POSTAL-CODE Alpha 10 (Lower Case) AM115 AM15.1
Element: Postal Code This field contains the postal code. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-COUNTY Alpha 25 (Lower Case) AM115 AM15.1
Element: County The county for the company address. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-COUNTRY Alpha 30 (Lower Case) AM115 AM15.1
Element: Country or OthThis field contains the country of the AM15.2 AM15.3
address, or it can be used for AM15.4 AM20.1
additional information such as an AM20.3 AM21.1
attention name. AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VDR-CUR-ADDR Alpha 1 AM115 AM15.1
Element: Current AddresIndicates if this is the current vendor AM15.2 AM15.3
address. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP109 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VDR-REGION Alpha 2 AM115 AM15.1
Element: Region Code The region code, if applicable for the AM15.2 AM15.3
country. Used by Intrastat. Must be AM15.4 AM20.1
defined in IN02.1 (Region Maintenance) AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
VDR-COUNTRY-CODE Alpha 2 AM115 AM15.1
Element: Country Code The country code. Required for VAT and AM15.2 AM15.3
intrastat reporting. Must be defined in AM15.4 AM20.1
IN01.1 (Country Maintenance). AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.3
AP10.9 AP100
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
PR514 UK47.1
APVENADDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDRSET1 VENDOR-GROUP AM115 AM15.1
VENDOR AM15.2 AM15.3
LOCATION-CODE AM15.4 AM20.1
EFFECTIVE-DATE AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.1
AP10.2 AP10.9
AP102 AP109
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
...
VDRSET2 VENDOR-GROUP KeyChange, Subset AP109 AP130
VENDOR Where CUR-ADDR = "Y" AP131 AP20.1
LOCATION-CODE AP20.2 AP20.3
CUR-ADDR AP20.4 AP20.5
AP20.7 AP23.1
AP510 MA41.2
MA43.2
VDRSET4 VENDOR-GROUP KeyChange AC210 AC297
VENDOR AM115 AM15.1
LOCATION-CODE AM15.2 AM15.3
EFFECTIVE-DATE* AM15.4 AM18.1
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP02.3 AP10.1
AP10.2 AP10.3
AP10.9 AP100
AP109 AP131
AP145 AP146
AP150 AP155
AP156 AP160
...
|