PROC_GRP_IDPROD_IDEO_CVRD_PRD_VW(SQL View) |
Index Back |
|---|
| SELECT PR.PROC_GRP_ID ,PR.PROD_ID ,INS.DESCRSHORT ,INS.DESCR FROM PS_EO_PS_PRODUCT INS ,PS_EO_PROCGRP_PROD PR WHERE INS.PROD_ID = PR.PROD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Uniquely identifies a Currency Conversion Process Group |
| 2 | PROD_ID |
Character(2) | VARCHAR2(2) NOT NULL | This is an XLAT field listing all PeopleSoft 7.5 Product codes. |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |