Overview

This command will list the nonconformity data.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
IPRECVNC	Nonconformities additional information record	CDRNC	GNRNC OBINPUTCHARAC
GNRNC	Nonconformity record	CDRNC	IPRECVNC GNRNCTYPE
GNRNCTYPE	Nonconformity type	CDRNCTYPE	GNRNC
OBINPUTCHARAC	Association of item/supply characteristics	CDCHARACTERISTIC	IPRECVNC

Oracle/Postgres/SQL Server

SELECT
   GENNC.IDRNC,
   GENNC.NMRNC,
   RECNC.FGNCTYPE,
   RECNC.FGNCWHEN,
   GENNC.DTRNC,
   OBCHAR.IDCHARACTERISTIC,
   OBCHAR.NMCHARACTERISTIC,
   GENNCTYPE.IDRNCTYPE,
   GENNCTYPE.VLCRITICALFACTOR,
   RECNC.QTDEFECT
FROM
   IPRECVNC RECNC
     INNER JOIN GNRNC GENNC ON (GENNC.CDRNC = RECNC.CDRNC)
     INNER JOIN GNRNCTYPE GENNCTYPE ON (GENNCTYPE.CDRNCTYPE = GENNC.CDRNCTYPE)
   LEFT JOIN OBINPUTCHARAC OBCHAR ON (RECNC.CDCHARACTERISTIC = OBCHAR.CDCHARACTERISTIC)
WHERE
   GENNC.IDRNC = 'NC ID' /*NOTE 1*/

Notes

▪1: Nonconformity data ID #.

Fields used on the view screen

inspection-03

#	Field ID	Type	Description
1	IDRNC	VARCHAR(50)	Nonconformity ID #
2	NMRNC	VARCHAR(255)	Nonconformity name
3	FGNCTYPE	NUMERIC(2)	Nonconformity type 1 - Ad-hoc 2 - Action 3 - Workflow 4 - Action plan
4	FGNCWHEN	NUMERIC(2)	When was it identified? 1 - During receiving 2 - After receiving 3 - At customer
5	DTRNC	DATETIME	Date
6	IDCHARACTERISTIC	VARCHAR(50)	Characteristic ID #
6	NMCHARACTERISTIC	VARCHAR(255)	Characteristic name
7	IDRNCTYPE	VARCHAR(50)	Classification
8	VLCRITICALFACTOR	NUMERIC(28,12)	Severity
9	QTDEFECT	NUMERIC(10)	# of defective items