SETIDCATALOG_ID_NUMPRODUCT_IDLANGUAGE_CDRO_CATPRD_LVW(SQL View) |
Index Back |
|---|---|
Catalog viewLanguage View - View of Catalog Products used by Partner. |
| SELECT DISTINCT a.SETID , a.CATALOG_ID_NUM , a.PRODUCT_ID , c.LANGUAGE_CD , c.DESCR FROM PS_RO_CATPRD_CACHE a , PS_PROD_ITEM b , PS_PROD_ITEM_LNG c WHERE a.PRODUCT_ID = b.PRODUCT_ID AND a.SETID=b.SETID AND b.SETID=c.SETID AND b.PRODUCT_ID = c.PRODUCT_ID |
| # | 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 | CATALOG_ID_NUM |
Number(5,0) | INTEGER NOT NULL | Catalog ID |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |