APVENDIV FILE
The APVENDIV file stores the diversity codes and their certification dates for
the related vendor in APVENMAST
REFERENCED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP520 API1.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.2 MA540
UPDATED BY
AP14.4 AP300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDC-VENDOR-GROUP Alpha 4 AP14.4
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
VDC-VENDOR Alpha 9 (Right Justified) AP14.4
Element: Vendor The vendor's identification code.
VDC-LOCATION-CODE Alpha 4 AP14.4
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
VDC-DIVERSE-CODE Alpha 5 AP14.4
Element: Diverse Code Diversity Code for Account Payable
Vendors
VDC-CERT-DATE Numeric 8 (yyyymmdd) AP14.4
Element: Date This is the date the vendor was
certified for the diversity code
VDC-DCERT-DATE Numeric 8 (yyyymmdd) AP14.4
Element: Date This is the date the expiration date for
the diversity code of the vendor
VDC-REVIEW-DATE Numeric 8 (yyyymmdd) AP14.4
Element: Date This is the date the diversity code
should be reviewed for certification
APVENDIV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDCSET1 VENDOR-GROUP AP14.4 AP20.1
VENDOR AP20.2 AP20.3
LOCATION-CODE AP20.4 AP20.5
DIVERSE-CODE AP20.7 AP21.1
DCERT-DATE AP23.1 AP300
AP520 API1.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA540
VDCSET2 DIVERSE-CODE
VENDOR-GROUP
VENDOR
LOCATION-CODE
DCERT-DATE
APVENDIV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvenloc APVENLOC Required
VDC-VENDOR-GROUP -> VLO-VENDOR-GROUP (VLOSET1)
VDC-VENDOR -> VLO-VENDOR
VDC-LOCATION-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
VDC-VENDOR-GROUP -> VEN-VENDOR-GROUP
VDC-VENDOR -> VEN-VENDOR
Procuregrp PROCUREGRP Required
VDC-VENDOR-GROUP -> PCG-VENDOR-GROUP
APVENDIV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE
VDC-VENDOR-GROUP -> API-VENDOR-GROUP
VDC-VENDOR -> API-VENDOR
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
API-COMPANY
Apvenbal APVENBAL
VDC-VENDOR-GROUP -> VBA-VENDOR-GROUP
VDC-VENDOR -> VBA-VENDOR
VDC-LOCATION-CODE -> VBA-LOCATION-CODE
VBA-COMPANY
Povagrmthd POVAGRMTHD
PCG-PROCURE-GROUP -> PVH-PROCURE-GROUP
VDC-VENDOR -> PVH-VENDOR
VDC-LOCATION-CODE -> PVH-PURCH-FR-LOC
PVH-VEN-AGRMT-REF
|