Navigation: Customer >

Evaluations for a customer

Overview

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

Related tables

TABLE	Description	Primary key (PK)	Connection tables
SUEVALRESULTPENDING	Customer quality level data	CDEVALRESULTPENDING	SUEVALPENDING
SUEVALPENDING	Evaluation execution table	CDEVALPENDING	SUEVALRESULTPENDING GNCUSTOMER
GNCUSTOMER	Customers	CDCUSTOMER	SUEVALPENDING GNGENTYPE ADCOMPANY
GNGENTYPE	Generic type	CDGENTYPE	GNCUSTOMER
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 GNCUSTOMER GNCUST ON (GNCUST.CDCUSTOMER = SUEVALPEND.CDCOMPANY)
   INNER JOIN GNGENTYPE GNT ON (GNT.CDGENTYPE = GNCUST.CDCUSTOMERTYPE)
   INNER JOIN ADCOMPANY ADC ON (ADC.CDCOMPANY = GNCUST.CDCUSTOMER)
   INNER JOIN ADCOMPANYTYPE ADCOMPTYPE ON (ADCOMPTYPE.CDCOMPANYTYPE = ADC.CDCOMPANYTYPE)
WHERE
   ADC.IDCOMMERCIAL = 'CUSTOMER ID' /*NOTE 1*/
ORDER BY
   SUEVALPEND.DTFINISH DESC

Notes

▪1: Customer ID #.

Fields used on the view screen

custumer-03

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