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