POS_HDR_TBL

(SQL Table)
 Index Back

Treasury Bin Header Table TREE

  • Related Language Record: POS_HDR_LNG

  • Parent Record Of POS_CREATE_WHER POS_CREATE_WHR POS_CREATE_WHR2 POS_HDR_LNG POS_NODE_SRC_VW POS_NOD_SRC_VW2 POS_SOURCE_SET POS_TREE_SRC_VW POS_TREE_TBL POS_WHERE_TBL TR_NOD_SRC_TMP TR_SOURCSET_TMP TR_TREE_SRC_TMP TR_TREE_TBL_TMP TR_WHERE_HD_TMP TR_WHERE_TB_TMP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    4 CURR_POSITION Character(3) VARCHAR2(3) NOT NULL The currency in which a given exposure or position is defined in the Position tools.

    Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 NOTES_254 Character(254) VARCHAR2(254) NOT NULL Represents a field that allows free form text on the position tree setup panels.
    7 NODE_MODE_CODE Character(2) VARCHAR2(2) NOT NULL An internal work field that holds a specific code which determines if a given position tree node is su
    01=Recursive
    02=Non-recursive