ACCONTACTS – Contract Customer Contacts
- System
- AC Billing Revenue (BR)
- Prefix
CTS- Primary key
ACTIVITY-GRP,CONTRACT,RESP-CODE- Fields
- 21
- Updated by
- 5 programs
- Referenced by
- 2 programs
ACCONTACTS is the Contract Customer Contacts table in Lawson AC Billing Revenue (prefix CTS). It is indexed by ACTIVITY-GRP, CONTRACT, RESP-CODE (CTSSET1). It is related 1:1 to ACCNTSBOD. It is updated by AC120, AC300, BR10.1, BR10.9 and BR14.1 and referenced by BR210 and BRBD.2. The table has 21 fields, 1 index and 1 documented relation.
About ACCONTACTS
The ACCONTACTS file maintains contract customer contacts. Contract customer contacts are established and maintained via BR14.1 (Customer Contacts). Information stored includes a contact code, name, e-mail address, telephone number, fax, notes and address information.
Fields (21)
Column = COBOL field name without the CTS- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#CTS-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | The activity group is the overall project. | AC120, BR14.1 |
#CTS-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BR14.1 |
#CTS-RESP-CODE PKRESP_CODE | Alpha 5 | — | BR14.1 |
#CTS-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | BR14.1 |
#CTS-INT-PREFIXINT_PREFIX | Alpha 6 | The telephone number country code. | BR14.1 |
#CTS-PHONE-NMBRPHONE_NMBR | Alpha 15 | Phone number. | BR14.1 |
#CTS-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | BR14.1 |
#CTS-FAX-NMBRFAX_NMBR | Alpha 15 | Phone number. | BR14.1 |
#CTS-FAX-EXTFAX_EXT | Alpha 5 | This field contains the telephone extension number. | BR14.1 |
#CTS-LONG-DESCLONG_DESC | Alpha 60 (Lower Case) | Long description. | BR14.1 |
#CTS-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | BR14.1 |
#CTS-ADDR1ADDR1 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR14.1 |
#CTS-ADDR2ADDR2 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR14.1 |
#CTS-ADDR3ADDR3 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR14.1 |
#CTS-ADDR4ADDR4 | Alpha 30 (Lower Case) | This field contains the first line of address information. | BR14.1 |
#CTS-CITYCITY | Alpha 18 (Lower Case) | This field contains the city of the address. | BR14.1 |
#CTS-STATESTATE | Alpha 2 | This field contains the two-character state code of the address. | BR14.1 |
#CTS-ZIPZIP | Alpha 10 | This field contains the postal code of the address. | BR14.1 |
#CTS-COUNTYCOUNTY | Alpha 25 (Lower Case) | The county for the company address. | BR14.1 |
#CTS-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | BR14.1 |
#CTS-REGIONREGION | Alpha 2 | The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance) | BR14.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CTSSET1 |
| Primary | AC120, AC300, BR10.1, BR10.9, BR14.1, BR210, BRBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accntsbod | ACCNTSBOD | Not Required, Delete Cascades | Valid When YAJ- = CTS- |
|
Programs
Updated by (5)
- AC120 Level Reorganization
- AC300 Activity Group Purge
- BR10.1 Contract Parameters
- BR10.9 Product Contract Parameters
- BR14.1 Customer Contacts