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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
VDCSET1
  1. VENDOR-GROUP
  2. VENDOR
  3. LOCATION-CODE
  4. DIVERSE-CODE
  5. DCERT-DATE
PrimaryAP14.4, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 +13 more
VDCSET2
  1. DIVERSE-CODE
  2. VENDOR-GROUP
  3. VENDOR
  4. LOCATION-CODE
  5. DCERT-DATE
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APDIVCODEAPVENLOCAPVENMASTPROCUREGRPAPINVOICEAPVENBALPOVAGRMTHDAPVENDIV

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApdivcodeAPDIVCODERequired
VDC-DIVERSE-CODE→AVC-DIVERSE-CODE (AVCSET1)
ApvenlocAPVENLOCRequired
VDC-VENDOR-GROUP→VLO-VENDOR-GROUP
VDC-VENDOR→VLO-VENDOR
VDC-LOCATION-CODE→VLO-LOCATION-CODE
ApvenmastAPVENMASTRequired
VDC-VENDOR-GROUP→VEN-VENDOR-GROUP
VDC-VENDOR→VEN-VENDOR
ProcuregrpPROCUREGRPRequired
VDC-VENDOR-GROUP→PCG-VENDOR-GROUP

One to many (3) — child tables

RelationTableRulesConditionField map
ApinvoiceAPINVOICE
VDC-VENDOR-GROUP→API-VENDOR-GROUP
VDC-VENDOR→API-VENDOR
—→API-INVOICE
—→API-SUFFIX
—→API-CANCEL-SEQ
—→API-COMPANY
ApvenbalAPVENBAL
VDC-VENDOR-GROUP→VBA-VENDOR-GROUP
VDC-VENDOR→VBA-VENDOR
VDC-LOCATION-CODE→VBA-LOCATION-CODE
—→VBA-COMPANY
PovagrmthdPOVAGRMTHD
PCG-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)