APCVENCERT FILE
UPDATED BY
AP51.8 AP51.1 AP510
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVN-VENDOR-GROUP Alpha 4 AP51.8
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
CVN-VENDOR Alpha 9 (Right Justified) AP51.8
Element: Vendor The vendor's identification code.
CVN-LOCATION-CODE Alpha 4 AP51.8
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
CVN-CERTIF-CODE Alpha 10 AP51.8
Element: Certif Code User defined code representing
certifications.
CVN-CERTIF-DESC Alpha 30 AP51.8
Element: Certif Desc Description of the Certification Code.
CVN-CERTIF-EFF-DT Numeric 8 (yyyymmdd) AP51.8
Element: Effective Dt The effective date is the date the
record is first valid.
CVN-CERTIF-EXP-DT Numeric 8 (yyyymmdd) AP51.8
Element: Effective Dt The effective date is the date the
record is first valid.
APCVENCERT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVNSET1 VENDOR-GROUP AP51.1 AP51.8
VENDOR AP510
LOCATION-CODE
CERTIF-CODE
CERTIF-EFF-DT*
APCVENCERT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcertcode APCERTCODE Required
CVN-CERTIF-CODE -> CER-CERTIF-CODE
|
