Overview
This command will list the data displayed in the characteristic data screen.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
OBOBJECT
|
Item/Asset/Supply data based on revision
|
CDOBJECT, CDREVISION
|
OBINPUT
ITITEM
|
OBINPUT
|
Common data among items and supplies
|
CDINPUT
CDREVISION
|
OBOBJECT
OBINPUTCHARAC
|
ITITEM
|
Item record
|
CDITEM
CDREVISION
|
OBOBJECT
|
OBINPUTCHARAC
|
Association of item characteristics
|
CDCHARACTERISTIC
|
OBINPUTCHARACTTYPE
GNSYMBOL
ADMEASUNITY
|
OBINPUTCHARACTTYPE
|
Association of the item characteristic types/purposes
|
CDINPUTCHARACTTYPE
|
OBINPUTCHARAC
|
GNSYMBOL
|
Symbol record
|
CDSYMBOL
|
OBINPUTCHARAC
|
ADMEASUNITY
|
Measurement unit
|
CDMEASUNITY
|
OBINPUTCHARAC
|
Oracle/Postgres/SQL Server
SELECT
OBCHAR.NRORDER,
OBCHAR.IDCHARACTERISTIC,
OBCHAR.NMCHARACTERISTIC,
OBCHARTYPE.IDINPUTCHARACTTYPE,
OBCHARTYPE.NMINPUTCHARACTTYPE,
OBCHAR.FGSPECIALCHARACT,
GSYM.IDSYMBOL,
GSYM.NMSYMBOL,
OBCHAR.QTDECIMAL,
OBCHAR.FGLIMIT,
ADMEAS.IDMEASUNITY,
ADMEAS.NMMEASUNITY,
OBCHAR.VLNOMINAL,
OBCHAR.VLUPPER,
OBCHAR.VLLOWER,
OBCHAR.VLUSL,
OBCHAR.VLLSL
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)
LEFT JOIN OBINPUTCHARAC OBCHAR ON (OBCHAR.CDINPUT = IPT.CDINPUT AND OBCHAR.CDREVISION = IPT.CDREVISION)
LEFT JOIN OBINPUTCHARACTTYPE OBCHARTYPE ON (OBCHAR.CDINPUTCHARACTTYPE = OBCHARTYPE.CDINPUTCHARACTTYPE)
LEFT JOIN GNSYMBOL GSYM ON (OBCHAR.CDSYMBOLSUPPLIER = GSYM.CDSYMBOL)
LEFT JOIN ADMEASUNITY ADMEAS ON (ADMEAS.CDMEASUNITY = OBCHAR.CDMEASUNITY)
WHERE
OBJ.FGCURRENT = 1 /* NOTE1 */
AND OBJ.IDOBJECT = 'ITEM ID' /* NOTE2 */
AND OBCHAR.IDCHARACTERISTIC = 'CHAR ID' /* NOTE3 */
|
Notes
▪1: Filter by the current item revision only; ▪2: Item ID # for the view; ▪3: Item characteristic ID #.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NRORDER
|
NUMERIC(10)
|
Order
|
2
|
IDCHARACTERISTIC
|
VARCHAR(50)
|
Characteristic ID #
|
3
|
NMCHARACTERISTIC
|
VARCHAR(255)
|
Characteristic name
|
4
|
IDINPUTCHARACTTYPE
|
VARCHAR(50)
|
Characteristic type ID #
|
4
|
NMINPUTCHARACTTYPE
|
VARCHAR(255)
|
Characteristic type name
|
5
|
FGSPECIALCHARACT
|
NUMERIC(2)
|
Special characteristic:
1 - Yes
2 - No
|
6
|
IDSYMBOL
|
VARCHAR(50)
|
Symbol ID #
|
6
|
NMSYMBOL
|
VARCHAR(255)
|
Symbol name
|
7
|
QTDECIMAL
|
NUMERIC(10)
|
Number of decimal places
|
8
|
FGLIMIT
|
NUMERIC(2)
|
Limits:
0 - Bilateral
1 - Unilateral up
2 - Unilateral down
3 - Reference dimension
|
9
|
IDMEASUNITY
|
VARCHAR(50)
|
Measurement unit ID #
|
9
|
NMMEASUNITY
|
VARCHAR(255)
|
Measurement unit name
|
10
|
VLNOMINAL
|
NUMERIC(28, 12)
|
Nominal value
|
11
|
VLUPPER
|
NUMERIC(28, 12)
|
Upper tol.
|
12
|
VLLOWER
|
NUMERIC(28, 12)
|
Lower tol.
|
13
|
VLUSL
|
NUMERIC(28, 12)
|
USL
|
14
|
VLLSL
|
NUMERIC(28, 12)
|
LSL
|
|