RBF_PROD_DEF_VW(SQL View) |
Index Back |
|---|---|
Product Definition ViewProduct Definition View |
| SELECT A.SETID , A.PROD_GRP_TYPE , A.PRODUCT_GROUP , C.EFFDT , A.PRODUCT_ID , B.DESCR , B.EFF_STATUS , B.PRODUCT_KIT_FLAG FROM PS_PROD_PGRP_LNK A , PS_PROD_ITEM B , PS_PROD_GROUP_TBL C WHERE A.SETID=B.SETID AND A.PRODUCT_ID=B.PRODUCT_ID AND A.SETID = C.SETID AND A.PROD_GRP_TYPE = C.PROD_GRP_TYPE AND A.PRODUCT_GROUP = C.PRODUCT_GROUP |
| # | 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.
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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 8 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Product Kit Flag |