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 |