APVENCERT FILE
REFERENCED BY
PO240 AP13.3
UPDATED BY
AP14.3 AP510 AC160 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP03.3 AP110 AP115 AP125 AP126
AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MX123 MX500 MA180 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.1 PO54.2
PO54.3 PO54.4 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AVT-VENDOR-GROUP Alpha 4 AP14.3 AP510
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
AVT-VENDOR Alpha 9 (Right Justified) AP14.3 AP510
Element: Vendor The vendor's identification code.
AVT-LOCATION-CODE Alpha 4 AP14.3 AP510
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
AVT-CERTIF-CODE Alpha 10 AP14.3 AP510
Element: Certif Code User defined code representing
certifications.
AVT-CERTIF-DESC Alpha 30 AP14.3 AP510
Element: Certif Desc Description of the Certification Code.
AVT-CERTIF-EFF-DT Numeric 8 (yyyymmdd) AP14.3 AP510
Element: Effective Dt The effective date is the date the
record is first valid.
AVT-CERTIF-EXP-DT Numeric 8 (yyyymmdd) AP14.3 AP510
Element: Effective Dt The effective date is the date the
record is first valid.
APVENCERT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AVTSET1 VENDOR-GROUP AC160 AM115
VENDOR AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
CERTIF-CODE AM15.4 AM19.1
CERTIF-EFF-DT* AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP14.3
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
AVTSET2 CERTIF-CODE AP13.3
VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-EFF-DT*
APVENCERT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcertcode APCERTCODE Required
AVT-CERTIF-CODE -> CER-CERTIF-CODE
Apvenloc APVENLOC Not Required
AVT-VENDOR-GROUP -> VLO-VENDOR-GROUP
AVT-VENDOR -> VLO-VENDOR
AVT-LOCATION-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
AVT-VENDOR-GROUP -> VEN-VENDOR-GROUP
AVT-VENDOR -> VEN-VENDOR
|
