PAGE_NAMESJ_JRNL_TAB_VW(SQL View) |
Index Back |
|---|---|
Simp Jrnl Entry - TabsTis table stores the Journal tabs. |
| SELECT C.PNLNAME , C.SUBITEMNUM , C.ITEMLABEL , C.ITEMLABEL FROM PSPNLGROUP C , PSPNLDEFN P WHERE C.PNLGRPNAME = 'SJ_JRNL_ENTRY_FL' AND C.PNLNAME = P.PNLNAME AND P.PNLTYPE = 0 AND C.HIDDEN = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAGE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 2 | SUBITEMNUM | Number(4,0) | SMALLINT NOT NULL | Sub Item Number |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |