PROD_GROUP_SRCH (SQL View)	Index Back
Product Group Table This record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more.

PROD_GROUP_SRCH

(SQL View)

Product Group Table

This record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more.

SELECT a.SETID , a.PROD_GRP_TYPE , a.PRODUCT_GROUP , a.DESCR , a.GLOBAL_FLAG FROM %Table(PROD_GROUP_TBL) a WHERE (%EffdtCheck(PROD_GROUP_TBL b, a, %CurrentdateIn) OR a.EFFDT > %CurrentDateIn) AND MARKET = 'GBL'

# 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.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global Case flag for relationship
Y/N Table Edit

#	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. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
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	GLOBAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Global Case flag for relationship Y/N Table Edit