Navigation:  Inspection >

Receiving data

 Previous  Top  Next

Overview

This command will list the data displayed in the receiving screen.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

IPRECEIVING

Receiving record

CDRECEIVING

IPCONFIGURATION

IPWORKFLOW

IPCONFIGURATION

Receiving form record

CDCONFIGURATION

IPRECEIVING

IPCONFIGTYPE

IPCONFIGTYPE

Inspection form type

CDCONFIGTYPE

IPCONFIGURATION

IPWORKFLOW

Receiving flow record

CDWORKFLOW

IPRECEIVING

 

Oracle/Postgres/SQL Server

SELECT
    IPREC.IDRECEIVING,
    IPWF.IDWORKFLOW,
       IPWF.NMWORKFLOW,
       IPCONFIG.IDCONFIGURATION,
       IPCONFTYPE.FGTYPE,
      IPREC.DTRECVEST,
      IPREC.DTRECVACT,
      IPREC.VLQTYEST,
      IPREC.VLQTYACT,
      IPREC.VLCOSTEST,
      IPREC.VLCOSTACT,
      IPREC.DSCOMMENT
FROM
   IPRECEIVING IPREC
   INNER JOIN IPCONFIGURATION IPCONFIG ON (IPCONFIG.CDCONFIGURATION = IPREC.CDCONFIGURATION)
   INNER JOIN IPCONFIGTYPE IPCONFTYPE ON (IPCONFTYPE.CDCONFIGTYPE = IPCONFIG.CDCONFIGTYPE)
   LEFT JOIN IPWORKFLOW IPWF ON (IPWF.CDWORKFLOW = IPREC.CDWORKFLOW)
WHERE
   IPREC.IDRECEIVING = 'RECEIVING ID' /*NOTE 1*/

 

Notes

▪1: Receiving ID #.

 

Fields used on the view screen

 

inspection-02

 

#

Field ID

Type

Description

1

IDRECEIVING

VARCHAR(50)

Receiving ID #

2

IDWORKFLOW

VARCHAR(50)

Inspection flow ID #

2

NMWORKFLOW

VARCHAR(255)

Inspection flow name

3

IDCONFIGURATION

VARCHAR(50)

Inspection form ID #

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

DTRECVEST

DATETIME

Estimated date

6

DTRECVACT

DATETIME

Actual date

7

VLQTYEST

NUMERIC(28,12)

Expected quantity

8

VLQTYACT

NUMERIC(28,12)

Actual quantity

9

VLCOSTEST

NUMERIC(28,12)

Estimated cost

10

VLCOSTACT

NUMERIC(28,12)

Actual cost

11

DSCOMMENT

TEXT

Notes