APVENCERT

REFERENCED BY
PO240 AP13.3


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP110 AP115 AP125 AP126 AP131
AP14.3 AP150 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 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP590 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC140 IC142
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 IC840
MX123 MX500 MA180 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 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 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5
POCP.1 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 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AVT-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.3 AP510
AVT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP14.3 AP510
AVT-LOCATION-CODE
Element: Location Code
Alpha 4
A user-defined code that represents an alternate purchasing or remittance location for the vendor.
AP14.3 AP510
AVT-CERTIF-CODE
Element: Certif Code
Alpha 10
User defined code representing certifications.
AP14.3 AP510
AVT-CERTIF-DESC
Element: Certif Desc
Alpha 30
Description of the Certification Code.
AP14.3 AP510
AVT-CERTIF-EFF-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
AP14.3 AP510
AVT-CERTIF-EXP-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
AP14.3 AP510


APVENCERT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AVTSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-CODE
CERTIF-EFF-DT*
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP14.3 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AVTSET2 CERTIF-CODE
VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-EFF-DT*
AP13.3


APVENCERT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


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

Home
Contact Us



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