Navigation: Supplier >

Evaluations for a supplier

Overview

This command will display the list of evaluations for a supplier.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
SUEVALRESULTPENDING	Supplier quality level data	CDEVALRESULTPENDING	SUEVALPENDING
SUEVALPENDING	Evaluation execution table	CDEVALPENDING	SUEVALRESULTPENDING GNSUPPLIER
GNSUPPLIER	Suppliers	CDSUPPLIER	SUEVALPENDING GNGENTYPE ADCOMPANY
GNGENTYPE	Generic type	CDGENTYPE	GNSUPPLIER
ADCOMPANY	Company	CDCOMPANY	GNSUPPLIER ADCOMPANYTYPE
ADCOMPANYTYPE	Company type	CDCOMPANYTYPE	ADCOMPANY

Oracle/Postgres/SQL Server

SELECT
   GNT.IDGENTYPE,
   ADCOMPTYPE.IDCOMPANYTYPE,
   ADC.IDCOMMERCIAL,
   ADC.NMCOMPANY,
   SUEVALPEND.DTSTARTPENDING,
   SUEVALPEND.DTFINISH,
   SUEVALRESULT.VLNOTE
FROM
   SUEVALRESULTPENDING SUEVALRESULT
   INNER JOIN SUEVALPENDING SUEVALPEND ON (SUEVALRESULT.CDEVALRESULTPENDING = SUEVALPEND.CDEVALPENDING)
   INNER JOIN GNSUPPLIER GNS ON (GNS.CDSUPPLIER = SUEVALPEND.CDCOMPANY)
   INNER JOIN GNGENTYPE GNT ON (GNT.CDGENTYPE = GNS.CDSUPPLIERTYPE)
   INNER JOIN ADCOMPANY ADC ON (ADC.CDCOMPANY = GNS.CDSUPPLIER)
   INNER JOIN ADCOMPANYTYPE ADCOMPTYPE ON (ADCOMPTYPE.CDCOMPANYTYPE = ADC.CDCOMPANYTYPE)
WHERE
   ADC.IDCOMMERCIAL = 'SUPPLIER ID' /*NOTE 1*/
ORDER BY
   SUEVALPEND.DTFINISH DESC

Notes

▪1: Supplier ID #.

Fields used on the view screen

supplier-03

#	Field ID	Type	Description
1	IDGENTYPE	VARCHAR(50)	Company type
2	IDCOMPANYTYPE	VARCHAR(50)	Supplier category
3	IDCOMMERCIAL	VARCHAR(50)	Supplier ID #
4	NMCOMPANY	VARCHAR(255)	Supplier name
5	DTSTARTPENDING	DATETIME	Evaluation start date
6	DTFINISH	DATETIME	Evaluation end date
7	VLNOTE	NUMERIC(28,12)	Score