BO_REQ_TRE_DTL

(SQL Table)
Index Back

FSR Tree

Financial Structure Request Tree

  • Parent record: BO_REQUEST_DTL
  • # 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