RBD_PGRP_VW (SQL View)	Index Back
Dashboard Product Group This is the record for the Dashboard Product Group view.

RBD_PGRP_VW

(SQL View)

Dashboard Product Group

This is the record for the Dashboard Product Group view.

SELECT A.SETID , A.PROD_GRP_TYPE , A.PRODUCT_GROUP , A.DESCR , A.DESCRSHORT FROM %Table(PROD_GROUP_TBL) A WHERE %EffdtCheck(PROD_GROUP_TBL B, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 PROD_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Product Group Type
ACCT=Accounting
CTLG=Product Catalogs
CUST=Customer Target
CZ=Configurator
FCST=Forecast
FRT=Freight
GEN=General
LIT=Literature
ORG=Organization
PLIN=Product Line
PRC=Pricing
REPE=Reporting Externally
REPI=Reporting Internally
RPT=Reporting
SCON=Buying Agreement
SSP=Self-Service Products
TAX=Tax
TRPT=Transportations
VAT=VAT
WEB=WEB Order Entry

3 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	PROD_GRP_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Product Group Type ACCT=Accounting CTLG=Product Catalogs CUST=Customer Target CZ=Configurator FCST=Forecast FRT=Freight GEN=General LIT=Literature ORG=Organization PLIN=Product Line PRC=Pricing REPE=Reporting Externally REPI=Reporting Internally RPT=Reporting SCON=Buying Agreement SSP=Self-Service Products TAX=Tax TRPT=Transportations VAT=VAT WEB=WEB Order Entry
3	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description