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.

Field / columnTypeDescription & valuesUpdated by
CON-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR11.1
CON-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.AR11.1
CON-RESP-CODE PK
RESP_CODE		Alpha 5This 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-NAME
NAME		Alpha 30 (Lower Case)The name of the contact person.AR11.1
CON-INT-PREFIX
INT_PREFIX		Alpha 6The contact's international telephone number prefix.AR11.1
CON-PHONE-NMBR
PHONE_NMBR		Alpha 15The telephone number of the contact person.AR11.1
CON-PHONE-EXT
PHONE_EXT		Alpha 5Telephone extension number.AR11.1
CON-FAX-NMBR
FAX_NMBR		Alpha 15Fax number of the contact person.AR11.1
CON-FAX-EXT
FAX_EXT		Alpha 5Fax extension number.AR11.1
CON-DESC
DESC		Alpha 30 (Lower Case)Description or notes for this contact.AR11.1
CON-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)The contact's Email address.AR11.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CONSET1COMPANY, CUSTOMER, RESP-CODEPrimaryAC56.1, AC560, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2 +18 more

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredCON-COMPANY → ACO-COMPANY
ConbodCONBODNot Required, Delete CascadesCON-COMPANY → YCN-COMPANY, CON-CUSTOMER → YCN-CUSTOMER, CON-RESP-CODE → YCN-RESP-CODE
CustcontactARCUSTOMERRequiredCON-COMPANY → ACM-COMPANY, CON-CUSTOMER → ACM-CUSTOMER
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, CON-CUSTOMER → CUD-CUSTOMER

Programs

Updated by (3)

Referenced by (23)