Navigation:  Storeroom >

Storeroom data

 Previous  Top  Next

Overview

This command will list the storeroom data.

 

Related tables

Table

Description

Primary key (PK)

Connection tables

GNSTOREROOM

Storeroom record

CDSTOREROOM

ADDEPARTMENT

GNCUSTOMER

GNFAVORITE

GNREPOSITORYTYPE

GNSTORAGETYPE

GNSTOREROOMTYPE

GNSUPPLIER

GNTRANSSETTING

GNSTOREROOMTYPE

Storeroom type

CDSTOREROOMTYPE

GNGENTYPE

GNGENTYPE

Generic type

CDGENTYPE

ADCHECKLIST

GNACTIVITYTIMECFG

GNASSOC

GNELETRONICFILECFG

GNEVAL

GNFAVORITE

GNMASK

GNREVCONFIG

GNSECURITY

GNTRANSLATION

GNTYPEROLE

ADTEAM

Teams

CDTEAM

ADAUTHLDAPCONFIG

GNMAPPING

GNPERMISSION

ADDEPARTMENT

Department record

CDDEPARTMENT

ADALLUSERS

ADDEPARTMENT

ADTEAM

COWORKSPACE

GNASSOC

GNFAVORITE

GNMAPPING

ADCOMPANY

Company record

CDCOMPANY

ADCOMPANYTYPE

GNTRANSCONF

Event configuration

CDTRANSCONF

ADAPPROVALROUTE

GNMASK

 

Oracle/Postgres/SQL Server

SELECT
   STM.IDSTOREROOM,
   STM.NMSTOREROOM,
   GNT.IDGENTYPE + ' - ' + GNT.NMGENTYPE AS NMGENTYPE,
   STM.CDPRODOBJECT,
   ADT.IDTEAM + ' - ' + ADT.NMTEAM AS NMTEAMRESP,
   STM2.IDSTOREROOM + ' - ' + STM2.NMSTOREROOM AS NMSTOREROOMOWNER,
   GNT2.IDCONF + ' - ' + GNT2.NMCONF AS NMCONF,
   STM.FGSTOREROOMOWNER,
   AD.IDDEPARTMENT + ' - ' + AD.NMDEPARTMENT AS NMDEPARTMENT,
   GNC.IDCOMMERCIAL + ' - ' + GNC.NMCOMPANY AS NMCUSTOMER,
   GNS.IDCOMMERCIAL + ' - ' + GNS.NMCOMPANY AS NMSUPPLIER,
   STM.DSSTOREROOM
FROM GNSTOREROOM STM
   LEFT JOIN GNSTOREROOMTYPE STMT ON ( STMT.CDSTOREROOMTYPE = STM.CDSTOREROOMTYPE )
   LEFT JOIN GNGENTYPE GNT ON ( GNT.CDGENTYPE = STMT.CDSTOREROOMTYPE )
   LEFT JOIN ADTEAM ADT ON ( ADT.CDTEAM = STM.CDTEAMRESP )
   LEFT JOIN ADDEPARTMENT AD ON ( AD.CDDEPARTMENT = STM.CDDEPARTMENT )
   LEFT JOIN ADCOMPANY GNC ON ( GNC.CDCOMPANY = STM.CDCUSTOMER )
   LEFT JOIN ADCOMPANY GNS ON ( GNS.CDCOMPANY = STM.CDSUPPLIER )
   LEFT JOIN GNTRANSCONF GNT2 ON ( GNT2.CDTRANSCONF = STM.CDTRANSCONF )
   LEFT JOIN GNSTOREROOM STM2 ON ( STM2.CDSTOREROOM = STM.CDSTOREROOMOWNER )
WHERE STM.IDSTOREROOM = 'STOREROOM_ID' /*NOTE 1*/

 

Notes

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

 

Fields used on the view screen

storeroom-04

 

#

Field ID

Type

Description

1

IDSTOREROOM

VARCHAR(50)

Storeroom ID #

2

NMSTOREROOM

VARCHAR(255)

Storeroom name

3

NMGENTYPE

VARCHAR(255)

Storeroom type

4

CDPRODOBJETCT

NUMERIC(10)

Object type 17-Waste; 149-Supply; 107-Item

5

NMTEAMRESP

VARCHAR(255)

Responsible team

6

NMSTOREROOMOWNER

VARCHAR(255)

Upper level storeroom

7

NMCONF

VARCHAR(255)

Event configuration

8

FGSTOREROOMOWNER

NUMERIC(2)

Storeroom owner:

1- Internal

2- Customer

3- Supplier

9

NMDEPARTMENT

VARCHAR(255)

Department

10

DSSTOREROOM

TEXT

Notes