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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CVH-VENDOR-GROUP PKVENDOR_GROUP | Alpha 4 | A vendor group represents a group of vendors that can be shared by one or more companies. | AP51.6 |
CVH-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AP51.6 |
CVH-LOCATION-CODE PKLOCATION_CODE | Alpha 4 | A user-defined code that represents an alternate purchasing or remittance location for the vendor. | AP51.6 |
CVH-RESP-CODE PKRESP_CODE | Alpha 5 | User defined field for label assignment to contacts. | AP51.6 |
CVH-CONTACT-LVL PKCONTACT_LVL | Numeric 3 | System generated assignment that can be over-ridden at input. To distinguish and prioritize contacts. | AP51.6 |
CVH-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | AP51.6 |
CVH-INT-PREFIXINT_PREFIX | Alpha 6 | The telephone number country code. | AP51.6 |
CVH-PHONE-NMBRPHONE_NMBR | Alpha 15 | Phone number. | AP51.6 |
CVH-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | AP51.6 |
CVH-MBL-INT-PREFIXMBL_INT_PREFIX | Alpha 6 | This field contains the country code of the mobile phone number. | AP51.6 |
CVH-MOBILE-NUMMOBILE_NUM | Alpha 15 | This field contains the mobile phone number. | AP51.6 |
CVH-MOBILE-EXTMOBILE_EXT | Alpha 5 | This field contains the mobile phone extension number. | AP51.6 |
CVH-FAX-PREFIXFAX_PREFIX | Alpha 6 | The telephone number country code. | AP51.6 |
CVH-FAX-NMBRFAX_NMBR | Alpha 15 | Phone number. | AP51.6 |
CVH-FAX-EXTFAX_EXT | Alpha 5 | This field contains the telephone extension number. | AP51.6 |
CVH-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | AP51.6 |
Indexes (2)
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 |
|---|---|---|---|---|
CVHSET1 | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL | Primary | AP51.6, AP510 | |
CVHSET4 | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL* | AP51.6 |