Navigation:  Inspection >

Inspection form data

 Previous  Top  Next

Overview

This command will list the data displayed in the inspection form screen.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

IPCONFIGURATION

Receiving form record

CDCONFIGURATION

IPCONFIGTYPE

IPEVALCONFGRUP

IPQUALITYINDEX

IPWORKFLOW

IPCONFIGTYPE

Inspection form type

CDCONFIGTYPE

IPCONFIGURATION

GNGENTYPE

GNGENTYPE

Generic type

CDGENTYPE

IPCONFIGTYPE

IPEVALCONFGRUP

Evaluation group record

CDEVALCONFGRUP

IPCONFIGURATION

IPQUALITYINDEX

Quality index record

CDQUALITYINDEX

IPCONFIGURATION

IPWORKFLOW

Receiving flow record

CDWORKFLOW

IPCONFIGURATION

 

Oracle/Postgres/SQL Server

SELECT
   IPCONFIG.IDCONFIGURATION,
   IPCONFIG.FGBLOCK,
   GNGNTYPE.IDGENTYPE,
   GNGNTYPE.NMGENTYPE,
   IPCONFTYPE.FGTYPE,
   CONFGRP.NMEVALCONFGRUP,
   QLTYIDX.IDQUALITYINDEX,
       QLTYIDX.NMQUALITYINDEX,
       IPWF.IDWORKFLOW,
       IPWF.NMWORKFLOW,
       IPCONFIG.FGALLOWEDITWF
FROM
   IPCONFIGURATION IPCONFIG
   INNER JOIN IPCONFIGTYPE IPCONFTYPE ON (IPCONFTYPE.CDCONFIGTYPE = IPCONFIG.CDCONFIGTYPE)
      INNER JOIN GNGENTYPE GNGNTYPE ON (GNGNTYPE.CDGENTYPE = IPCONFTYPE.CDCONFIGTYPE)
      LEFT JOIN IPEVALCONFGRUP CONFGRP ON (CONFGRP.CDEVALCONFGRUP = IPCONFIG.CDEVALCONFGRUP)
      LEFT JOIN IPQUALITYINDEX QLTYIDX ON (QLTYIDX.CDQUALITYINDEX = IPCONFIG.CDQUALITYINDEX)
       LEFT JOIN IPWORKFLOW IPWF ON (IPWF.CDWORKFLOW = IPCONFIG.CDWORKFLOW)
WHERE
   IPCONFIG.IDCONFIGURATION = 'FORM ID' /*NOTE 1*/

 

Notes

▪1: Inspection form ID #.

 

Fields used on the view screen

 

inspection-01

 

#

Field ID

Type

Description

1

IDCONFIGURATION

VARCHAR(50)

Inspection form ID #

2

FGBLOCK

NUMERIC(2)

Block inspection form

1- Yes

2- No

3

IDGENTYPE

VARCHAR(50)

Inspection form type ID #

3

NMGENTYPE

VARCHAR(255)

Inspection form type name

4

FGTYPE

NUMERIC(2)

Inspection type:

1- Raw material inspection form (Supply);

2- Product in progress inspection form;

3- Finished internal product inspection form;

6- Finished external product inspection form;

4- Work inspection form;

5- Process inspection form (With workflow);

7- Process activity inspection form (With workflow);

8- Process inspection form (Without workflow);

9- Process activity inspection form (Without workflow);

5

NMEVALCONFGRUP

VARCHAR(255)

Evaluation group

6

IDQUALITYINDEX

VARCHAR(50)

Quality index ID #

6

NMQUALITYINDEX

VARCHAR(255)

Quality index name

7

IDWORKFLOW

VARCHAR(50)

Receiving flow ID #

7

NMWORKFLOW

VARCHAR(255)

Receiving flow name

8

FGALLOWEDITWF

NUMERIC(2)

Allow editing the flow during the receiving

1– Yes