PSDOCLOURLELMNT(SQL Table) |
Index Back |
---|---|
Document Layout URL Element |
# | 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_CONTAINER_TYPE | Number(3,0) | SMALLINT NOT NULL | Content Type |
5 | IB_SEQUENCE_NBR | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
6 | IB_CONSTANT | Number(3,0) | SMALLINT NOT NULL | Constant |
7 | IB_PACKAGEID | Character(100) | VARCHAR2(100) NOT NULL | Referenced Package |
8 | IB_SCHEMANAME | Character(100) | VARCHAR2(100) NOT NULL | Document Name |
9 | IB_VARIANTNAME | Character(30) | VARCHAR2(30) NOT NULL | Version Name |
10 | IB_DOC_ELEMENT | Character(30) | VARCHAR2(30) NOT NULL | Element Name |
11 | IB_MAP_DOC_ELEMENT | Character(30) | VARCHAR2(30) NOT NULL | Element Name |
12 | IB_DOC_CONST_ELMT | Character(30) | VARCHAR2(30) NOT NULL | Document Constant Element |
13 | IB_DOC_CONST_VALUE | Character(100) | VARCHAR2(100) NOT NULL | Document Constant Value |
14 | IB_DOC_LBL_ID | Character(35) | VARCHAR2(35) NOT NULL | Field Layout Type |
15 | IB_DOC_LBL_ALT_ID | Character(35) | VARCHAR2(35) NOT NULL | Alt ID |
16 | IB_DOCLOMTAG | Character(1) | VARCHAR2(1) NOT NULL | When moving lines in a document layout, it becomes necessary to tag certain lines to avoid a double change. This field is used for that purpose. |
17 | IB_CUST_DOCUMENT | Number(3,0) | SMALLINT NOT NULL | Use Custom Document |