APCVENADDR – Vender Address Conversion

System
Accounts Payable (AP)
Prefix
AAD
Primary key
VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL, EFFECTIVE-DATE
Fields
17
Updated by
3 programs
Referenced by
0 programs

APCVENADDR is the Vender Address Conversion table in Lawson Accounts Payable (prefix AAD). It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL, EFFECTIVE-DATE (AADSET1). It is updated by AP51.3, AP51.7 and AP510. The table has 17 fields, 1 index and 0 documented relations.

About APCVENADDR

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the AAD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AAD-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP51.3, AP51.7
#AAD-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP51.3, AP51.7
#AAD-LOCATION-CODE PK
LOCATION_CODE		Alpha 4A user-defined code that represents an alternate purchasing or remittance location for the vendor.AP51.3, AP51.7
#AAD-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AP51.3, AP51.7
#AAD-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AP51.3, AP51.7
#AAD-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AP51.3, AP51.7
#AAD-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AP51.3, AP51.7
#AAD-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AP51.3, AP51.7
#AAD-CITY-ADDR5
CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.AP51.3, AP51.7
#AAD-STATE-PROV
STATE_PROV		Alpha 2The state or province.AP51.3, AP51.7
#AAD-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.AP51.3, AP51.7
#AAD-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AP51.3, AP51.7
#AAD-COUNTRY
COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AP51.3, AP51.7
#AAD-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP51.3, AP51.7
#AAD-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AP51.3, AP51.7
#AAD-RESP-CODE PK
RESP_CODE		Alpha 5User defined field for label assignment to contacts.AP51.7
#AAD-CONTACT-LVL PK
CONTACT_LVL		Numeric 3System generated assignment that can be over-ridden at input. To distinguish and prioritize contacts.AP51.7

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AADSET1
  1. VENDOR-GROUP
  2. VENDOR
  3. LOCATION-CODE
  4. RESP-CODE
  5. CONTACT-LVL
  6. EFFECTIVE-DATE
PrimaryAP51.3, AP51.7, AP510

Programs

Updated by (3)