APCVENCERT

UPDATED BY
AP51.8 AP51.1 AP510

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVN-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP51.8
CVN-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP51.8
CVN-LOCATION-CODE
Element: Location Code
Alpha 4
A user-defined code that represents an alternate purchasing or remittance location for the vendor.
AP51.8
CVN-CERTIF-CODE
Element: Certif Code
Alpha 10
User defined code representing certifications.
AP51.8
CVN-CERTIF-DESC
Element: Certif Desc
Alpha 30
Description of the Certification Code.
AP51.8
CVN-CERTIF-EFF-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
AP51.8
CVN-CERTIF-EXP-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
AP51.8
CVN-VALIDATE-FL
Element: Flag
Alpha 1
AP51.8


APCVENCERT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVNSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-CODE
CERTIF-EFF-DT*
AP51.1 AP51.8
AP510


APCVENCERT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcertcode APCERTCODE Required
CVN-CERTIF-CODE->CER-CERTIF-CODE


File created: Thu Jun 09 02:06:58 2016

Home
Contact Us



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