TR_LMT_TBL_TMP(SQL Table) |
Index Back |
|---|---|
Position Limt Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: POS_POS_TREE_VW |
| 3 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: POS_TREENODE_VW |
| 4 | POSN_LONG_SHORT |
Character(2) | VARCHAR2(2) NOT NULL |
"Represents whether a given position tree node reflects a short
01=Long Limit Only 02=Short Limit Only 03=Short and Long Limit |
| 5 | INTERNAL_EXTERNAL |
Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given defined bank account is utilized for internal or ext
E=External I=Internal |
| 6 | LIMIT_MAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the maximum amount of exposure established by the treasury for a given tree node (position or cash wo |
| 7 | LIMIT_MIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the minimum amount of exposure established by the treasury for a given tree node (position or cash wo |
| 8 | CURR_LIMIT | Character(3) | VARCHAR2(3) NOT NULL |
The currency in which a given position limit is defined in the Position tools.
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 9 | LIMIT_CHK_DEAL_ENT | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that deal transactions are enabled to be processed for limit
Y/N Table Edit Default Value: N |
| 10 | LIMIT_CHK_PRE_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that the limit checking process is enabled to run in the bac
Y/N Table Edit Default Value: N |
| 11 | RECURNAME | Character(30) | VARCHAR2(30) NOT NULL |
Recurrence Name
Prompt Table: PSRECURDEL |