ARCONTACTS – AR Customer Contacts
- System
- Accounts Receivable (AR)
- Prefix
CON- Primary key
COMPANY,CUSTOMER,RESP-CODE- Fields
- 11
- Updated by
- 3 programs
- Referenced by
- 23 programs
ARCONTACTS is the AR Customer Contacts table in Lawson Accounts Receivable (prefix CON). It is indexed by COMPANY, CUSTOMER, RESP-CODE (CONSET1). It is related 1:1 to ARCOMP, CONBOD, ARCUSTOMER and CUSTDESC. It is updated by AR10.1, AR11.1 and AR301 and referenced by AC56.1, AC560, AR09.1, AR09.4, AR12.1, AR12.2, AR13.1, AR13.2 and 15 more. The table has 11 fields, 1 index and 4 documented relations.
About ARCONTACTS
The AR Customer Contacts file contains additional contact names for a customer. (Each customer has a contact at the group customer level and one contact at the company customer level.)
Fields (11)
Column = COBOL field name without the CON- 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 |
|---|---|---|---|
#CON-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR11.1 |
#CON-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | Customer number. | AR11.1 |
#CON-RESP-CODE PKRESP_CODE | Alpha 5 | This field's primary purpose is to maintain uniqueness among the contacts. It also represents the responsibility of the contact in a short form. For example, "AP" for accounts payable manager. The responsibility code is user defined. | AR11.1 |
#CON-NAMENAME | Alpha 30 (Lower Case) | The name of the contact person. | AR11.1 |
#CON-INT-PREFIXINT_PREFIX | Alpha 6 | The contact's international telephone number prefix. | AR11.1 |
#CON-PHONE-NMBRPHONE_NMBR | Alpha 15 | The telephone number of the contact person. | AR11.1 |
#CON-PHONE-EXTPHONE_EXT | Alpha 5 | Telephone extension number. | AR11.1 |
#CON-FAX-NMBRFAX_NMBR | Alpha 15 | Fax number of the contact person. | AR11.1 |
#CON-FAX-EXTFAX_EXT | Alpha 5 | Fax extension number. | AR11.1 |
#CON-DESCDESC | Alpha 30 (Lower Case) | Description or notes for this contact. | AR11.1 |
#CON-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | The contact's Email address. | AR11.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 |
|---|---|---|---|---|
CONSET1 |
| Primary | AC56.1, AC560, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2 +18 more |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP | Required |
| ||||||||||
| Conbod | CONBOD | Not Required, Delete Cascades |
| ||||||||||
| Custcontact | ARCUSTOMER | Required |
| ||||||||||
| Custdesc | CUSTDESC | Required |
|
Programs
Updated by (3)
Referenced by (23)
- AC56.1 Setup Interface Adjustment
- AC560 Setup Interface
- AR09.1 Customer Group Address
- AR09.4 Bill To
- AR12.1 National Account
- AR12.2 National Account Speed Entry
- AR13.1 MICR Customer
- AR13.2 Customer MICR
- AR210 Customer Listing
- AR211 Customer Optional Fields Listing
- AR501 Customer Conversion
- AR550 Customer Interface
- ARLL.1 AR Transaction Interface
- BR11.1 Customer
- BR20.7 Invoice Header
- BR21.1 Invoice Cancellation
- BR211 Activity Customer Listing
- BR252 Maintenance Schedule Listing
- BR55.1 Maintenance Invoice Cancellation
- BRIP.1 Invoice Print Program
- CB06.2 Bank Statement Detail Entry
- CB191 Bank Statement Close
- TX140 Vertex Geocode Update