Overview

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

Related tables

TABLE	Description	Primary key (PK)	Connection tables
ADCOMPANY	Company table	CDCOMPANY	GNCUSTOMER ADCOMPANYTYPE
GNCUSTOMER	Customer table	CDCUSTOMER	ADCOMPANY CTCUSTOMERTYPE
CTCUSTOMERTYPE	Customer category	CDSUPPLIERTYPE	GNCUSTOMER GNGENTYPE
ADCOMPANYTYPE	Company type	CDCOMPANYTYPE	ADCOMPANY
GNGENTYPE	Generic type	CDGENTYPE	CTCUSTOMERTYPE

Oracle/Postgres/SQL Server

SELECT
   ADCOM.IDCOMMERCIAL,
   ADCOM.NMCOMPANY,
   ADCOMPTYPE.IDCOMPANYTYPE,
   ADCOMPTYPE.NMCOMPANYTYPE,
   GNTYPE.IDGENTYPE,
   GNTYPE.NMGENTYPE,
   ADCOM.DSADDRESS,
   ADCOM.NMCITY,
   ADCOM.IDSTATE,
   ADCOM.NMCOUNTRY,
   ADCOM.IDZIPCODE,
   ADCOM.IDPHONE,
   ADCOM.IDFAX,
   ADCOM.IDCOMPANY,
   ADCOM.NMHOMEPAGE,
   ADCOM.DSCOMPANY
FROM
   ADCOMPANY ADCOM
   INNER JOIN GNCUSTOMER GNCUST ON (GNCUST.CDCUSTOMER = ADCOM.CDCOMPANY)
   INNER JOIN CTCUSTOMERTYPE CTTYPE ON (CTTYPE.CDCUSTOMERTYPE = GNCUST.CDCUSTOMERTYPE)
   INNER JOIN ADCOMPANYTYPE ADCOMPTYPE ON (ADCOMPTYPE.CDCOMPANYTYPE = ADCOM.CDCOMPANYTYPE)
   INNER JOIN GNGENTYPE GNTYPE ON (GNTYPE.CDGENTYPE = CTTYPE.CDCUSTOMERTYPE)
WHERE
   ADCOM.IDCOMMERCIAL = 'CUSTOMER ID' /* NOTE1 */

Notes

▪1: Customer ID #.

Fields used on the view screen

custumer-01

#	Field ID	Type	Description
1	IDCOMMERCIAL	VARCHAR(50)	Customer ID #
2	NMCOMPANY	VARCHAR(255)	Customer name
3	IDCOMPANYTYPE	VARCHAR(50)	Company type ID #
3	NMCOMPANYTYPE	VARCHAR(255)	Company type name
4	IDGENTYPE	VARCHAR(50)	Customer category ID #
4	NMGENTYPE	VARCHAR(255)	Customer category name
5	DSADDRESS	TEXT	Address
6	NMCITY	VARCHAR(255)	City
7	IDSTATE	VARCHAR(50)	State
8	NMCOUNTRY	VARCHAR(255)	Country
9	IDZIPCODE	VARCHAR(50)	ZIP (postal) code
10	IDPHONE	VARCHAR(50)	Phone #
11	IDFAX	VARCHAR(50)	Fax #
12	IDCOMPANY	VARCHAR(50)	Code
13	NMHOMEPAGE	VARCHAR(255)	Home page
14	DSCOMPANY	TEXT	Description

Customer data

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen