Navigation:  Supplier >

Supplier data

 Previous  Top  Next

Overview

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

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

ADCOMPANY

Company table

CDCOMPANY

GNSUPPLIER

ADCOMPANYTYPE

GNSUPPLIER

Supplier table

CDSUPPLIER

ADCOMPANY

SUSUPPLIERTYPE

SUSUPPLIERTYPE

Supplier category

CDSUPPLIERTYPE

GNSUPPLIER

GNGENTYPE

ADCOMPANYTYPE

Company type

CDCOMPANYTYPE

ADCOMPANY

GNGENTYPE

Generic type

CDGENTYPE

SUSUPPLIERTYPE

 

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 GNSUPPLIER GNSUP ON (GNSUP.CDSUPPLIER = ADCOM.CDCOMPANY)
   INNER JOIN SUSUPPLIERTYPE SUTYPE ON (SUTYPE.CDSUPPLIERTYPE = GNSUP.CDSUPPLIERTYPE)
   INNER JOIN ADCOMPANYTYPE ADCOMPTYPE ON (ADCOMPTYPE.CDCOMPANYTYPE = ADCOM.CDCOMPANYTYPE)
   INNER JOIN GNGENTYPE GNTYPE ON (GNTYPE.CDGENTYPE = SUTYPE.CDSUPPLIERTYPE)
WHERE
   ADCOM.IDCOMMERCIAL = 'SUPPLIER ID' /* NOTE1 */

 

Notes

▪1: Supplier ID #.

 

Fields used on the view screen

 

supplier-01

 

#

Field ID

Type

Description

1

IDCOMMERCIAL

VARCHAR(50)

Supplier ID #

2

NMCOMPANY

VARCHAR(255)

Supplier name

3

IDCOMPANYTYPE

VARCHAR(50)

Company type ID #

3

NMCOMPANYTYPE

VARCHAR(255)

Company type name

4

IDGENTYPE

VARCHAR(50)

Supplier category ID #

4

NMGENTYPE

VARCHAR(255)

Supplier 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