TREE_NODE_CD001=Account
002=Customer
003=Department
004=Employee
005=Installed Product and Children
006=Site
007=Contact
001=Asset
002=Product
003=Service
004=Agreement
005=Commitment
Y/N Table Edit
Y/N Table Edit
A=Active
I=Inactive
I=Image
T=Text
RF_IPRDVH_IPNDE(SQL Table) |
Index Back |
|---|---|
Inst Prod Tree NodesThis table is used as the primary node record for the Installed Product Tree. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NODE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
This field is used by the Installed Product Viewable Hierarchy setup component to designate the type of node to display on the tree. The possible node types are Customer, Site, Account, Department, Employee and Installed Product and Children.
001=Account 002=Customer 003=Department 004=Employee 005=Installed Product and Children 006=Site 007=Contact |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 4 | INST_PROD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset 002=Product 003=Service 004=Agreement 005=Commitment |
| 5 | INST_PROD_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Status of an installed product. |
| 6 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 7 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 8 | PRODUCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |
| 9 | SERVICE | Character(1) | VARCHAR2(1) NOT NULL |
Service Flag
Y/N Table Edit |
| 10 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Product Kit Flag
Y/N Table Edit |
| 11 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 12 | ASSETTAG | Character(40) | VARCHAR2(40) NOT NULL | Asset Tag |
| 13 | PARENT_INST_PRODID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to store the installed product ID of the parent installed product |
| 14 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
| 15 | RBTACCTNAME | Character(30) | VARCHAR2(30) NOT NULL | Account Name |
| 16 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 17 | ADDRESS80 | Character(80) | VARCHAR2(80) NOT NULL | Address |
| 18 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 19 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 20 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 21 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 22 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 23 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 24 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 25 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 26 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 27 | SETID_SITE | Character(5) | VARCHAR2(5) NOT NULL | SetID of Site |
| 28 | SITE_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 29 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 30 | LEAF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Leaf Flag |
| 31 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 32 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 33 | RANGE_FROM | Character(30) | VARCHAR2(30) NOT NULL | Lower boundary for detail value that contains a range of values |
| 34 | RANGE_TO | Character(30) | VARCHAR2(30) NOT NULL | Upper boundary for detail value that contains a range of values |
| 35 | DYNAMIC_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Dynamic Flag |
| 36 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| 37 | DISPLAY_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
UAD Display Options
I=Image T=Text |
| 38 | STYLECLASSNAME | Character(30) | VARCHAR2(30) NOT NULL | Style Class Name |
| 39 | PARENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Parent Flag |
| 40 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 41 | LEVEL_OFFSET | Number(3,0) | SMALLINT NOT NULL | Level Offset |
| 42 | DESCR_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Description Image Name |
| 43 | EXPANDED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Expanded Flag |
| 44 | DISPLAYED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Displayed Flag |
| 45 | DESCR_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 46 | DESCR_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 47 | IMAGE_WIDTH | Number(2,0) | SMALLINT NOT NULL | Image Width |
| 48 | IMAGE_HEIGHT | Number(2,0) | SMALLINT NOT NULL | Image Height |
| 49 | COLLAPSED_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Collapsed Image Name |
| 50 | COLLAPSED_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 51 | COLLAPSED_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 52 | EXPANDED_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Expanded Image Name |
| 53 | EXPANDED_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 54 | EXPANDED_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 55 | END_NODE_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | End Node Image Name |
| 56 | END_NODE_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 57 | END_NODE_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 58 | LEAF_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 59 | LEAF_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 60 | LEAF_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 61 | HTMLAREA | Long Character | CLOB | HTML Area |
| 62 | SORT_ORDER_NUM | Number(3,0) | SMALLINT NOT NULL | Field to capture the sort order number. |
| 63 | HIDDEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Hidden Flag field |
| 64 | NODE_VALUE | Character(60) | VARCHAR2(60) NOT NULL | Field used for storing node value information |
| 65 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 66 | LINE_NBR_REL | Number(5,0) | INTEGER NOT NULL | Related Line |
| 67 | LINE_NBR_REL_1 | Number(5,0) | INTEGER NOT NULL | Field used for storing related order line (line number) information |
| 68 | LINE_NBR_REL_2 | Number(5,0) | INTEGER NOT NULL | Field used for storing related order line (line number) information |
| 69 | ROWSTYLECLASSNAME | Character(30) | VARCHAR2(30) NOT NULL | Fiels used by TREECTL_NDE_SBR to store name of style assigned to node of tree on line-details page |
| 70 | REL_INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | Field used for storing releated installed product information |
| 71 | CAPTURE_ID_REL | Character(20) | VARCHAR2(20) NOT NULL | This field stores relative capture IDs. |
| 72 | RO_SELECT | Character(1) | VARCHAR2(1) NOT NULL | Field Used in Customer Selection for Bulk Orders |