BO_REQ_TRE_DTL(SQL Table) |
Index Back |
|---|---|
FSR TreeFinancial Structure Request Tree |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Financial Structure Request ID |
| 2 | BO_REQ_DTL_NO |
Number(3,0) | SMALLINT NOT NULL | Financial Structure Request Detail ID |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: FLD_REQ_TREE_VW |
| 4 | TREE_EFFDT |
Date(10) | DATE NOT NULL | Effective date of the Tree |
| 5 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: FLD_REQ_NODE_VW |
| 6 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | EFFDT_TREE | Date(10) | DATE | Tree Effective Date |
| 8 | GL_NODE_LEAF_FLAG | Character(4) | VARCHAR2(4) NOT NULL |
As Node or Leaf
LEAF=Leaf NODE=Node |
| 9 | GL_NEW_NODE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
New Tree Node
Y/N Table Edit Default Value: N |
| 10 | GL_NEW_NODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | New Node Description |
| 11 | TREE_NODE_TO | Character(20) | VARCHAR2(20) NOT NULL |
Move/Add Node to Parent Node
Prompt Table: FLD_REQ_NODE_VW |
| 12 | FLD_REQ_TRE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field Request Tree Update Status
D=Saved as Draft F=Failed N=None S=Success Default Value: N |