Overview

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

Related tables

TABLE	Description	Primary key (PK)	Connection tables
OBOBJECT	Item/Asset/Supply data based on revision	CDOBJECT CDREVISION	OBINPUT ITITEM ADTEAM GNREVISION OBOBJECTGROUP
OBINPUT	Common data among items and supplies	CDINPUT CDREVISION	OBOBJECT ADMEASUNITY
ITITEM	Item record	CDITEM CDREVISION	OBOBJECT
ADTEAM	Team data	CDTEAM	OBOBJECT
GNREVISION	Revision data	CDREVISION	OBOBJECT
OBOBJECTGROUP	Item/Asset/Supply	CDOBJECTGROUP	OBOBJECT
OBOBJECTTYPE	Item/Asset/Supply type	CDOBJECTTYPE	OBOBJECTGROUP
ADMEASUNITY	Measurement unit	CDMEASUNITY	OBINPUT

Oracle/Postgres/SQL Server

SELECT
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNREV.IDREVISION,
   GNREV.DTREVISION,
   OBJTYPE.IDOBJECTTYPE,
   OBJTYPE.NMOBJECTTYPE,
   TEAM.IDTEAM,
   TEAM.NMTEAM,
   IPT.VLCOST,
   ADMEAS.IDMEASUNITY,
   ADMEAS.NMMEASUNITY,
   IPT.FGLOTSERIAL,
   IT.IDDRAWINGNR,
   IT.FGINTERNAL,
   OBJ.DSOBSERVATION
FROM
   OBOBJECT OBJ
     INNER JOIN OBINPUT IPT ON (OBJ.CDOBJECT = IPT.CDINPUT AND OBJ.CDREVISION = IPT.CDREVISION)
     INNER JOIN ITITEM IT ON (OBJ.CDOBJECT = IT.CDITEM AND OBJ.CDREVISION = IT.CDREVISION)
     INNER JOIN ADTEAM TEAM ON (OBJ.CDTEAMRESPONSABLE = TEAM.CDTEAM)
   INNER JOIN GNREVISION GNREV ON (OBJ.CDREVISION = GNREV.CDREVISION)
   INNER JOIN OBOBJECTGROUP OBJGRP ON (OBJ.CDOBJECT = OBJGRP.CDOBJECTGROUP)
   INNER JOIN OBOBJECTTYPE OBJTYPE ON (OBJTYPE.CDOBJECTTYPE = OBJGRP.CDOBJECTTYPE)
   LEFT JOIN ADMEASUNITY ADMEAS ON (ADMEAS.CDMEASUNITY = IPT.CDMEASUNITY)
WHERE
   OBJ.FGCURRENT = 1 /* NOTE1 */
   AND OBJ.IDOBJECT = 'ITEM ID' /* NOTE2 */

Notes

▪1: Current revision only;

▪2: Item ID # for the view.

Fields used on the view screen

pdm-01