PROD_GROUP_ADD(SQL View) |
Index Back |
|---|---|
Product Group TableThis record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more. /* ICE 580165000 - removed 'GEN' as the default for PROD_GRP_TYPE */ |
| SELECT a.SETID , a.PRODUCT_GROUP , a.PROD_GRP_TYPE , a.DESCR FROM PS_PROD_GROUP_TBL a |
| # | 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 | PRODUCT_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 3 | 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 |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |