APVENDIV – The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST

System
Accounts Payable (AP)
Prefix
VDC
Primary key
VENDOR-GROUP, VENDOR, LOCATION-CODE, DIVERSE-CODE, DCERT-DATE
Fields
7
Updated by
2 programs
Referenced by
19 programs

APVENDIV is the The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST table in Lawson Accounts Payable (prefix VDC). It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE, DIVERSE-CODE, DCERT-DATE (VDCSET1); alternate indexes: VDCSET2. It is related 1:1 to APDIVCODE, APVENLOC, APVENMAST and PROCUREGRP and 1:M to APINVOICE, APVENBAL and POVAGRMTHD. It is updated by AP14.4 and AP300 and referenced by AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 and 11 more. The table has 7 fields, 2 indexes and 7 documented relations.

About APVENDIV

The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST

Fields (7)

Column = COBOL field name without the VDC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
VDC-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP14.4
VDC-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP14.4
VDC-LOCATION-CODE PK
LOCATION_CODE		Alpha 4A user-defined code that represents an alternate purchasing or remittance location for the vendor.AP14.4
VDC-DIVERSE-CODE PK
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP14.4
VDC-CERT-DATE
CERT_DATE		Numeric 8 (yyyymmdd)This is the date the vendor was certified for the diversity codeAP14.4
VDC-DCERT-DATE PK
DCERT_DATE		Numeric 8 (yyyymmdd)This is the date the expiration date for the diversity code of the vendorAP14.4
VDC-REVIEW-DATE
REVIEW_DATE		Numeric 8 (yyyymmdd)This is the date the diversity code should be reviewed for certificationAP14.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
VDCSET1VENDOR-GROUP, VENDOR, LOCATION-CODE, DIVERSE-CODE, DCERT-DATEPrimaryAP14.4, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 +13 more
VDCSET2DIVERSE-CODE, VENDOR-GROUP, VENDOR, LOCATION-CODE, DCERT-DATE—

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApdivcodeAPDIVCODERequiredVDC-DIVERSE-CODE → AVC-DIVERSE-CODE (AVCSET1)
ApvenlocAPVENLOCRequiredVDC-VENDOR-GROUP → VLO-VENDOR-GROUP, VDC-VENDOR → VLO-VENDOR, VDC-LOCATION-CODE → VLO-LOCATION-CODE
ApvenmastAPVENMASTRequiredVDC-VENDOR-GROUP → VEN-VENDOR-GROUP, VDC-VENDOR → VEN-VENDOR
ProcuregrpPROCUREGRPRequiredVDC-VENDOR-GROUP → PCG-VENDOR-GROUP

One to many (3) — child tables

RelationTableRulesConditionField map
ApinvoiceAPINVOICEVDC-VENDOR-GROUP → API-VENDOR-GROUP, VDC-VENDOR → API-VENDOR, → API-INVOICE, → API-SUFFIX, → API-CANCEL-SEQ, → API-COMPANY
ApvenbalAPVENBALVDC-VENDOR-GROUP → VBA-VENDOR-GROUP, VDC-VENDOR → VBA-VENDOR, VDC-LOCATION-CODE → VBA-LOCATION-CODE, → VBA-COMPANY
PovagrmthdPOVAGRMTHDPCG-PROCURE-GROUP → PVH-PROCURE-GROUP, VDC-VENDOR → PVH-VENDOR, VDC-LOCATION-CODE → PVH-PURCH-FR-LOC, → PVH-VEN-AGRMT-REF

Programs

Updated by (2)

Referenced by (19)