APVENCERT

REFERENCED BY
AP10.1 AP10.2 AP520 AP590 PO240


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 AM22.1 AM500 AM51.1
AM551 AM97.1 AP03.3 AP110 AP115 AP125
AP126 AP131 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 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 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 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
MA126 MA180 MA278 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
MA53.1 MA530 MA531 MA540 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO192
PO195 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.2
PO22.3 PO22.4 PO22.5 PO220 PO222 PO223
PO224 PO225 PO229 PO23.1 PO230 PO233
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO253 PO254 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO278 PO28.2 PO280 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 PO529 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.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 AP13.3

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
AVT-VALIDATE-FL
Element: Flag
Alpha 1

N = No
Y = Yes
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 AP10.1
AP10.2 AP110
AP115 AP125
AP126 AP131
AP14.3 AP150
AP20.1 AP20.2
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 02:07:28 2016

Home
Contact Us



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