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 | MA42.2 | MA43.2 | MA44.1 | MA44.2 |
MA540 |
AP14.4 | AP300 |
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. |
|
||
VDC-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||
VDC-LOCATION-CODE Element: Location Code | Alpha 4 A user-defined code that represents an alternate purchasing or remittance location for the vendor. |
|
||
VDC-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||
VDC-CERT-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date the vendor was certified for the diversity code |
|
||
VDC-DCERT-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date the expiration date for the diversity code of the vendor |
|
||
VDC-REVIEW-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date the diversity code should be reviewed for certification |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
VDCSET1 |
VENDOR-GROUP VENDOR LOCATION-CODE DIVERSE-CODE DCERT-DATE |
|
| ||||||||||||||||||||||||||||
VDCSET2 |
DIVERSE-CODE VENDOR-GROUP VENDOR LOCATION-CODE DCERT-DATE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Apdivcode | APDIVCODE |
Required
| |||||||||
Apvenloc | APVENLOC |
Required
| |||||||||
Apvenmast | APVENMAST |
Required
| |||||||||
Procuregrp | PROCUREGRP |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apinvoice | APINVOICE |
| ||||||||||||||||||
Apvenbal | APVENBAL |
| ||||||||||||||||||
Povagrmthd | POVAGRMTHD |
|
All trademarks and registered trademarks are the property of their
respective owners.