APVENDIV

The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST
UPDATED BY
AP14.4 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP23.1 AP300 AP520 API1.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA540

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VDC-VENDOR-GROUP
Element: Vendor Group		Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP14.4
VDC-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP14.4
VDC-LOCATION-CODE
Element: Location Code		Alpha 4
A user-defined code that represents an alternate purchasing or remittance location for the vendor.
AP14.4
VDC-DIVERSE-CODE
Element: Diverse Code		Alpha 5
Diversity Code for Account Payable Vendors
AP14.4
VDC-CERT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This is the date the vendor was certified for the diversity code
AP14.4
VDC-DCERT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This is the date the expiration date for the diversity code of the vendor
AP14.4
VDC-REVIEW-DATE
Element: Date		Numeric 8 (yyyymmdd)
This is the date the diversity code should be reviewed for certification
AP14.4


APVENDIV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VDCSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
DIVERSE-CODE
DCERT-DATE
AP14.4 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP300
AP520 API1.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA540
VDCSET2 DIVERSE-CODE
VENDOR-GROUP
VENDOR
LOCATION-CODE
DCERT-DATE


APVENDIV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdivcode APDIVCODE Required
VDC-DIVERSE-CODE->AVC-DIVERSE-CODE (AVCSET1)
Apvenloc APVENLOC Required
VDC-VENDOR-GROUP->VLO-VENDOR-GROUP
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
NAME		 RELATED 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

File created: Thu Jun 09 11:07:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.