 |
Lawson Insight Technical Documentation |
|
APVENADDR FILE
AP Vendor Address
The Vendor Address file contains vendor address information.
REFERENCED BY
AP102 AP130 AM18.1 AP02.3 AP145 AP146
AP150 AP155 AP156 AP160 AP161 AP202
AP210 AP220 AP265 AP282 AP284 AP90.6
AP90.7 IC530 IC840 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
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
VDR-VENDOR Alpha 9 (Right Justified) AP10.3 AP10.9
Vendor ID The vendor's identification code. AP100 AP510
AP520 API3.1
API4.1
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
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
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
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
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
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
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
VDR-STATE-PROV Alpha 2 AP10.3 AP10.9
State or Province The state or province. AP100 AP510
AP520 API3.1
API4.1
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
VDR-COUNTY Alpha 25 (Lower Case) AP10.3 AP10.9
County The county for the company address. AP100 AP510
AP520 API3.1
API4.1
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
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
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)
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).
APVENADDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDRSET1 VENDOR-GROUP AP10.1 AP10.2
VENDOR AP10.9 AP102
LOCATION-CODE AP300 AP510
EFFECTIVE-DATE API3.1 API4.1
VDRSET2 VENDOR-GROUP KeyChange, Subset AP10.9 AP130
VENDOR Where CUR-ADDR = "Y" AP510
LOCATION-CODE
CUR-ADDR
VDRSET4 VENDOR-GROUP KeyChange AM18.1 AP02.3
VENDOR AP10.1 AP10.2
LOCATION-CODE AP10.3 AP10.9
EFFECTIVE-DATE* AP100 AP145
AP146 AP150
AP155 AP156
AP160 AP161
AP202 AP210
AP220 AP265
AP282 AP284
AP510 AP90.6
AP90.7 API3.1
API4.1 IC530
IC840 MA05.2
MA63.1 PR05.1
...
|