ACADDRESS – Activity Address
- System
- Activity Management (AC)
- Prefix
ADD- Primary key
ADDRESS-CODE- Fields
- 16
- Updated by
- 1 program
- Referenced by
- 3 programs
ACADDRESS is the Activity Address table in Lawson Activity Management (prefix ADD). It is indexed by ADDRESS-CODE (ADDSET1). It is related 1:1 to ACADDRBOD. It is updated by AC10.4 and referenced by AC50.1, AC500 and ACBD.2. The table has 16 fields, 1 index and 1 documented relation.
About ACADDRESS
This file contains address information from AC10.5 (Location). It includes the actual address, an address code for the address, a contact for the address, and telephone and E-mail information for the contact. You can assign address codes to activities and activity groups in AC10.2 (Location Assignment).
Fields (16)
Column = COBOL field name without the ADD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ADD-ADDRESS-CODE PKADDRESS_CODE | Alpha 9 | Required key. This field contains the address code. The address code is defined in AC10.4 (Location). | AC10.4 |
ADD-ADDR1ADDR1 | Alpha 30 (Lower Case) | This is the first line of address information. | AC10.4 |
ADD-ADDR2ADDR2 | Alpha 30 (Lower Case) | This is the second line of address information. | AC10.4 |
ADD-ADDR3ADDR3 | Alpha 30 (Lower Case) | This is the third line of address information. | AC10.4 |
ADD-ADDR4ADDR4 | Alpha 30 (Lower Case) | This is the fourth line of address information. | AC10.4 |
ADD-ADDR5ADDR5 | Alpha 18 (Lower Case) | This is the fifth line of address information. In the United States, define the city. | AC10.4 |
ADD-STATE-PROVSTATE_PROV | Alpha 2 | This is the state or province. | AC10.4 |
ADD-POSTAL-CODEPOSTAL_CODE | Alpha 10 (Lower Case) | This is the postal code or zip code. | AC10.4 |
ADD-COUNTYCOUNTY | Alpha 25 (Lower Case) | This is the county for the address. | AC10.4 |
ADD-COUNTRYCOUNTRY | Alpha 30 (Lower Case) | This is the country of the address or a place to record additional information such as an attention name. | AC10.4 |
ADD-ADDR-CONTACTADDR_CONTACT | Alpha 30 (Lower Case) | This is the name of the main contact. | AC10.4 |
ADD-PHONE-COUNTRYPHONE_COUNTRY | Alpha 6 | This is the prefix of the telephone number for the main contact. For example, the country or city telephone code. | AC10.4 |
ADD-PHONEPHONE | Alpha 15 | This is the telephone number. | AC10.4 |
ADD-PHONE-EXTPHONE_EXT | Alpha 5 | This is the telephone extension for the main contact. | AC10.4 |
ADD-TELEX-NUMBERTELEX_NUMBER | Alpha 15 | This is the telex number for the main contact. | AC10.4 |
ADD-E-MAIL-ADDRE_MAIL_ADDR | Alpha 60 | This is the E-mail address for the main contact. | AC10.4 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADDSET1 | ADDRESS-CODE | Primary | AC10.2, AC10.4, AC50.1, AC500, ACBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acaddrbod | ACADDRBOD | Not Required, Delete Cascades | Valid When YAC- = ADD- | ADD-ADDRESS-CODE → YAC-ADDRESS-CODE |
Programs
Updated by (1)
- AC10.4 Location