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 |