APVENCERT

UPDATED BY
AP14.3 AP510 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
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 AP30.2 AP30.4 AP305
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
MX123 MX500 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO10.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1

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*
...
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
AP14.3 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AVTSET2 CERTIF-CODE
VENDOR-GROUP
VENDOR
LOCATION-CODE
CERTIF-EFF-DT*


APVENCERT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcertcode APCERTCODE Required
AVT-CERTIF-CODE->CER-CERTIF-CODE (CERSET1)
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: Wed Jun 08 20:47:34 2016

Home
Contact Us



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