IBDOCLAYOUTNAMEIB_DOCPAGE_INDEXIB_DOCLAYOUT_IDIB_SEQUENCE_NBRPSDOCLOMULT(SQL Table) |
Index Back |
|---|---|
Document Layout Multiple |
| # | 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 | IB_DOCLAYOUT_ID |
Number(4,0) | SMALLINT NOT NULL | Document Layout ID |
| 4 | IB_SEQUENCE_NBR |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | IB_TYPE | Number(3,0) | SMALLINT NOT NULL | Type |
| 6 | IB_MESSAGE_DATA | Character(60) | VARCHAR2(60) NOT NULL | Message Data |
| 7 | IB_CLASSNAME | Character(254) | VARCHAR2(254) NOT NULL | Content Class |
| 8 | IB_STYLE | Character(254) | VARCHAR2(254) NOT NULL | Content Style |
| 9 | IB_DOC_LBL_ID | Character(35) | VARCHAR2(35) NOT NULL | Field Layout Type |
| 10 | IB_DOC_LBL_ALT_ID | Character(35) | VARCHAR2(35) NOT NULL | Alt ID |
| 11 | IB_LBLTEXT | Character(100) | VARCHAR2(100) NOT NULL | Label Text |
| 12 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 13 | IB_HIDDEN | Number(1,0) | SMALLINT NOT NULL | Hidden |
| 14 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |