SETIDTREE_NAMETREE_NODEDefault Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL
01=Recursive
02=Non-recursive
TR_HDR_TBL_TMP(SQL Table) |
Index Back |
|---|---|
Treasury Bin Header Table TREE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 |