IBDOCLAYOUTNAMEIB_DOCPAGE_INDEXIBTRANSACTIONIDDOCLOLBL_VW(SQL View) |
Index Back |
|---|
| SELECT IBDOCLAYOUTNAME ,IB_DOCPAGE_INDEX ,IBTRANSACTIONID ,IB_LBLTEXT ,IB_GRP_LBLTEXT ,IB_ACCESSTXT ,DESCRLONG FROM PSDOCLOLBLTRANS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IBDOCLAYOUTNAME |
Character(20) | VARCHAR2(20) NOT NULL | Layout Name (see PSDOCLODEFN). |
| 2 | IB_DOCPAGE_INDEX |
Number(3,0) | SMALLINT NOT NULL | Page Index |
| 3 | IBTRANSACTIONID |
Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
| 4 | IB_LBLTEXT | Character(100) | VARCHAR2(100) NOT NULL | Label Text |
| 5 | IB_GRP_LBLTEXT | Character(100) | VARCHAR2(100) NOT NULL | Group Label Text |
| 6 | IB_ACCESSTXT | Character(100) | VARCHAR2(100) NOT NULL | Accessibility |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |