APCVENCERT – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
CVN- Primary key
VENDOR-GROUP,VENDOR,LOCATION-CODE,CERTIF-CODE,CERTIF-EFF-DT- Fields
- 8
- Updated by
- 3 programs
- Referenced by
- 0 programs
APCVENCERT is a Lawson Accounts Payable table (prefix CVN); no description in the lawson data dictionary. It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE, CERTIF-CODE, CERTIF-EFF-DT (CVNSET1). It is related 1:1 to APCERTCODE. It is updated by AP51.1, AP51.8 and AP510. The table has 8 fields, 1 index and 1 documented relation.
About APCVENCERT
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the CVN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CVN-VENDOR-GROUP PKVENDOR_GROUP | Alpha 4 | A vendor group represents a group of vendors that can be shared by one or more companies. | AP51.8 |
CVN-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AP51.8 |
CVN-LOCATION-CODE PKLOCATION_CODE | Alpha 4 | A user-defined code that represents an alternate purchasing or remittance location for the vendor. | AP51.8 |
CVN-CERTIF-CODE PKCERTIF_CODE | Alpha 10 | User defined code representing certifications. | AP51.8 |
CVN-CERTIF-DESCCERTIF_DESC | Alpha 30 | Description of the Certification Code. | AP51.8 |
CVN-CERTIF-EFF-DT PKCERTIF_EFF_DT | Numeric 8 (yyyymmdd) | The effective date is the date the record is first valid. | AP51.8 |
CVN-CERTIF-EXP-DTCERTIF_EXP_DT | Numeric 8 (yyyymmdd) | The effective date is the date the record is first valid. | AP51.8 |
CVN-VALIDATE-FLVALIDATE_FL | Alpha 1 | — | AP51.8 |
Indexes (1)
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 |
|---|---|---|---|---|
CVNSET1 | VENDOR-GROUP, VENDOR, LOCATION-CODE, CERTIF-CODE, CERTIF-EFF-DT* | Primary | AP51.1, AP51.8, AP510 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apcertcode | APCERTCODE | Required | CVN-CERTIF-CODE → CER-CERTIF-CODE |