Overview

This command will list the suppliers of a supply.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
OBINPUTSUPPLIER	Association of suppliers with a supply	CDINPUT CDREVISION CDCOMPANY	GNSUPPLIER OBINPUT
OBINPUT	Supply data record	CDINPUT CDREVISION	ADMEASUNITY OBCLASSIFICATION OBOBJECT WMCOLOR WMDANGEROUSNESS WMODOR
OBOBJECT	Item/Asset/Supply data based on revision	CDOBJECT CDREVISION	ADTEAM GNASSOC GNREVISION OBOBJECTGROUP OBSUBREASON
GNSUPPLIER	Supplier record	CDSUPPLIER	ADCOMPANY GNASSOC GNCOMPFILECONTCOPY SUSUPPLIERTYPE
ADCOMPANY	Company record	CDCOMPANY	ADCOMPANYTYPE

Oracle/Postgres/SQL Server

SELECT
   MA.FGDEFAULT,
   AD.IDCOMMERCIAL,
   AD.NMCOMPANY,
   MA.IDINPUTSUPP,
   MA.DSINPUTSUPP,
   MA.VLCOST
FROM OBINPUTSUPPLIER MA
   INNER JOIN OBINPUT OBPT ON (OBPT.CDINPUT = MA.CDINPUT AND OBPT.CDREVISION = MA.CDREVISION)
   INNER JOIN OBOBJECT OBJ ON (OBJ.CDOBJECT = OBPT.CDINPUT AND OBJ.CDREVISION = OBPT.CDREVISION)
   INNER JOIN GNSUPPLIER OC ON (MA.CDCOMPANY = OC.CDSUPPLIER)
   INNER JOIN ADCOMPANY AD ON (OC.CDSUPPLIER = AD.CDCOMPANY)
WHERE OBJ.IDOBJECT = 'SUPPLY_ID' /*NOTE 1*/

Notes

▪1: ID # of the supply to be filtered.

Fields used on the view screen

supply-04

#	Field ID	Type	Description
1	FGDEFAULT	NUMERIC(2)	Default supplier: 1– Yes 2– No
2	IDCOMMERCIAL	VARCHAR(50)	Supplier ID #
3	NMCOMPANY	VARCHAR(255)	Supplier name
4	IDINPUTSUPP	VARCHAR(50)	Reference
5	DSINPUTSUPP	TEXT	Description
6	VLCOST	NUMERIC(28,12)	Cost

Association of a supply with a supplier

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen