RBD_PRODGRP_VW(SQL View) |
Index Back |
|---|---|
Product Group ViewThe View returns all the Product Group Definitions. It is used to construct the message for the Dashboard Product Group Dimension. |
| SELECT SETID , PROD_GRP_TYPE ,PRODUCT_GROUP ,DESCR ,ROW_ADDED_DTTM FROM PS_PROD_GROUP_TBL |
| # | 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 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |