Navigation: Customer >
This command will display the customer contact list.
TABLE
Description
Primary key (PK)
Connection tables
ADCONTACT
Contacts
CDCOMPANY
CDCONTACT
ADCOMPANY
Company
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 = 'CUSTOMER ID' /*NOTE 1*/
▪1: Customer ID #.
#
Field ID
Type
1
FGDEFAULT
NUMERIC(2)
Default contact:
1– Yes
2- No
2
NMRESPONSIBLE
VARCHAR(255)
Contact
3
NMDEPARTMENT
Department
4
NMPOSITION
Position
5
NMEMAIL
E-mail
6
IDPHONE
VARCHAR(50)
Phone #