LIC_PROD_CD_VW(SQL View) |
Index Back |
---|---|
Licensed Product CodesThis view brings in all the fields from INSTALLATION |
SELECT FIELDNAME , LBLTEXT FROM PSPNLFIELD WHERE PNLNAME = 'RB_INSTALLATION' AND FIELDTYPE = 7 AND FIELDNUM <= 54 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LIC_PROD_CD | Character(18) | VARCHAR2(18) NOT NULL | Licensed product code for the configurable component. |
2 | LONGNAME_02 | Character(60) | VARCHAR2(60) NOT NULL | Long Name |