Lawson Insight Technical Documentation |
|
APVENADDR
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 AP30.4 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 IC28.1 MA180 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 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 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 POCP.1 POI3.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7 AP03.3
AP130 AC210 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
UPDATED BY
AM115 AM117 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
AP14.2 AP14.1 AP300 AP510 AP520 API3.1
API4.1 IC840 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDR-VENDOR-GROUP Alpha 4 AM115 AM117
Element: Vendor Group A vendor group represents a group of AM15.1 AM15.2
vendors that can be shared by one or AM15.3 AM15.4
more companies. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor ID The vendor's identification code. 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 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-LOCATION-CODE Alpha 4 AM115 AM117
Element: Location Code A user-defined code for a vendors' AM15.1 AM15.2
additional address. AM15.3 AM15.4
A blank location identifies a vendor AM20.1 AM20.3
master address record. A location code AM21.1 AM21.3
identifies an address for this specific AM500 AM51.1
location code. AM551 AM97.1
AP10.9 AP100
AP14.2 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VDR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Effective DateThe date a vendor's prices will be in AM15.1 AM15.2
effect. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-ADDR1 Alpha 30 (Lower Case) AM115 AM117
Element: Address 1 This field contains the first line of AM15.1 AM15.2
address information. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-ADDR2 Alpha 30 (Lower Case) AM115 AM117
Element: Address 1 This field contains the second line of AM15.1 AM15.2
address information. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-ADDR3 Alpha 30 (Lower Case) AM115 AM117
Element: Address 1 This field contains the third line of AM15.1 AM15.2
address information. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-ADDR4 Alpha 30 (Lower Case) AM115 AM117
Element: Address 1 This field contains the fourth line of AM15.1 AM15.2
address information. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-CITY-ADDR5 Alpha 30 (Lower Case) AM115 AM117
Element: Address 1 The city or address line five. 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 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-STATE-PROV Alpha 2 AM115 AM117
Element: State or ProviThe state or province. 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 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-POSTAL-CODE Alpha 10 (Lower Case) AM115 AM117
Element: Postal Code This field contains the postal code. 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 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-COUNTY Alpha 25 (Lower Case) AM115 AM117
Element: County The county for the company address. 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 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-COUNTRY Alpha 30 (Lower Case) AM115 AM117
Element: Country or OthThis field contains the country of the AM15.1 AM15.2
address, or it can be used for AM15.3 AM15.4
additional information such as an AM20.1 AM20.3
attention name. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 AP520
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
VDR-CUR-ADDR Alpha 1 AM115 AM117
Element: Current AddresIndicates if this is the current vendor AM15.1 AM15.2
address. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP109
AP14.2 AP510
AP520 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VDR-REGION Alpha 2 AM115 AM117
Element: Region Code The region code, if applicable for the AM15.1 AM15.2
country. Used by Intrastat. Must be AM15.3 AM15.4
defined in IN02.1 (Region Maintenance) AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VDR-COUNTRY-CODE Alpha 2 AM115 AM117
Element: Country Code The country code. Required for VAT and AM15.1 AM15.2
intrastat reporting. Must be defined in AM15.3 AM15.4
IN01.1 (Country Maintenance). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.3 AP10.9
AP100 AP14.2
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
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 AM115 AM117
VENDOR AM15.1 AM15.2
LOCATION-CODE AM15.3 AM15.4
RESP-CODE AM20.1 AM20.3
CONTACT-LVL AM21.1 AM21.3
EFFECTIVE-DATE AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.2
AP10.9 AP102
AP109 AP125
AP126 AP131
AP14.1 AP14.2
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP300
...
VDRSET2 VENDOR-GROUP KeyChange, Subset AM115 AM117
VENDOR Where CUR-ADDR = "Y" AM15.1 AM15.2
LOCATION-CODE AM15.3 AM15.4
RESP-CODE AM20.1 AM20.3
CONTACT-LVL AM21.1 AM21.3
CUR-ADDR AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.9
AP109 AP130
AP131 AP14.2
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
...
VDRSET4 VENDOR-GROUP KeyChange AC210 AM115
VENDOR AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
RESP-CODE AM15.4 AM18.1
CONTACT-LVL AM20.1 AM20.3
EFFECTIVE-DATE* AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP02.3 AP10.1
AP10.2 AP10.3
AP10.9 AP100
AP109 AP131
AP14.2 AP145
AP146 AP150
AP155 AP156
...
|