PW_RULE_TREEHDR(SQL Table) |
Index Back |
|---|---|
Price Rule Tree Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 2 | COLLAPSED_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 3 | COLLAPSED_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 4 | EXPANDED_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 5 | EXPANDED_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 6 | PAGE_FIELD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Page Field Name |
| 7 | PAGE_SIZE | Number(3,0) | SMALLINT NOT NULL | Page Size |
| 8 | DISPLAY_LEVELS | Number(2,0) | SMALLINT NOT NULL | Display Levels |
| 9 | COLLAPSED_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Collapsed Image Name |
| 10 | EXPANDED_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Expanded Image Name |
| 11 | END_NODE_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | End Node Image Name |
| 12 | LEAF_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 13 | IMAGE_WIDTH | Number(2,0) | SMALLINT NOT NULL | Image Width |
| 14 | IMAGE_HEIGHT | Number(2,0) | SMALLINT NOT NULL | Image Height |
| 15 | INDENT_PIXELS | Number(2,0) | SMALLINT NOT NULL | Indent Pixels |
| 16 | TREECTL_VERSION | Number(4,0) | SMALLINT NOT NULL | HTML Tree Version |
| 17 | TOP_NODE_NUM | Number(7,0) | INTEGER NOT NULL | Top Node Num |
| 18 | LEFT_LEVEL_NUM | Number(2,0) | SMALLINT NOT NULL | Left Level Num |
| 19 | DEFERPROC | Number(1,0) | SMALLINT NOT NULL | Deferred Processing mode |
| 20 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |