RPC_PROD_LNG_VW(SQL View) |
Index Back |
|---|---|
Product languagesRecord to store product language related information |
| SELECT a.SETID , a.PRODUCT_ID , a.LANGUAGE_CD , a.DESCR , b.XLATSHORTNAME , c.RB_HLEV_DESCR FROM PS_PROD_ITEM_LNG a , PSXLATITEMLANG b , PS_RB_HLEV_DFN_LNG c , PS_RPC_PRODUCT d , PS_RB_MLPB_STRUCT e WHERE a.SETID = d.SETID AND a.PRODUCT_ID = d.PRODUCT_ID AND b.fieldname = 'PROD_TYPE' AND d.PROD_TYPE = b.FIELDVALUE AND d.SETID = e.SETID AND e.STRUCTURE_ID = c.STRUCTURE_ID AND d.RB_HLEV_ID = c.RB_HLEV_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 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PROD_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Multileve product type description |
| 6 | COMP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Multileve component type description |