Navigation: Supplier >

Supplier contacts

Overview

This command will display the supplier contact list.

Related tables

TABLE

Description

Primary key (PK)

Connection tables

ADCONTACT

Contacts

CDCOMPANY

CDCONTACT

ADCOMPANY

Company

CDCOMPANY

ADCONTACT

Oracle/Postgres/SQL Server

SELECT
   ADCT.FGDEFAULT,
   ADCT.NMRESPONSIBLE,
   ADCT.NMDEPARTMENT,
   ADCT.NMPOSITION,
   ADCT.NMEMAIL,
   ADCT.IDPHONE
FROM
   ADCONTACT ADCT
   INNER JOIN ADCOMPANY ADCOM ON (ADCOM.CDCOMPANY = ADCT.CDCOMPANY)
WHERE
   ADCOM.IDCOMMERCIAL = 'SUPPLIER ID' /*NOTE 1*/

Notes

▪1: Supplier ID #.

Fields used on the view screen

supplier-02

#	Field ID	Type	Description
1	FGDEFAULT	NUMERIC(2)	Default contact: 1– Yes 2- No
2	NMRESPONSIBLE	VARCHAR(255)	Contact
3	NMDEPARTMENT	VARCHAR(255)	Department
4	NMPOSITION	VARCHAR(255)	Position
5	NMEMAIL	VARCHAR(255)	E-mail
6	IDPHONE	VARCHAR(50)	Phone #