APCCONTACT – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
CVH
Primary key
VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL
Fields
16
Updated by
2 programs
Referenced by
0 programs

APCCONTACT is a Lawson Accounts Payable table (prefix CVH); no description in the lawson data dictionary. It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL (CVHSET1); alternate indexes: CVHSET4. It is updated by AP51.6 and AP510. The table has 16 fields, 2 indexes and 0 documented relations.

About APCCONTACT

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the CVH- 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
#CVH-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP51.6
#CVH-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP51.6
#CVH-LOCATION-CODE PK
LOCATION_CODE		Alpha 4A user-defined code that represents an alternate purchasing or remittance location for the vendor.AP51.6
#CVH-RESP-CODE PK
RESP_CODE		Alpha 5User defined field for label assignment to contacts.AP51.6
#CVH-CONTACT-LVL PK
CONTACT_LVL		Numeric 3System generated assignment that can be over-ridden at input. To distinguish and prioritize contacts.AP51.6
#CVH-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.AP51.6
#CVH-INT-PREFIX
INT_PREFIX		Alpha 6The telephone number country code.AP51.6
#CVH-PHONE-NMBR
PHONE_NMBR		Alpha 15Phone number.AP51.6
#CVH-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.AP51.6
#CVH-MBL-INT-PREFIX
MBL_INT_PREFIX		Alpha 6This field contains the country code of the mobile phone number.AP51.6
#CVH-MOBILE-NUM
MOBILE_NUM		Alpha 15This field contains the mobile phone number.AP51.6
#CVH-MOBILE-EXT
MOBILE_EXT		Alpha 5This field contains the mobile phone extension number.AP51.6
#CVH-FAX-PREFIX
FAX_PREFIX		Alpha 6The telephone number country code.AP51.6
#CVH-FAX-NMBR
FAX_NMBR		Alpha 15Phone number.AP51.6
#CVH-FAX-EXT
FAX_EXT		Alpha 5This field contains the telephone extension number.AP51.6
#CVH-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.AP51.6

Indexes (2)

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
CVHSET1
  1. VENDOR-GROUP
  2. VENDOR
  3. LOCATION-CODE
  4. RESP-CODE
  5. CONTACT-LVL
PrimaryAP51.6, AP510
CVHSET4
  1. VENDOR-GROUP
  2. VENDOR
  3. LOCATION-CODE
  4. RESP-CODE
  5. CONTACT-LVL ↓
AP51.6

Programs

Updated by (2)