POS_LMT_TB_TEO3

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for POS_LMT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: POS_POS_TREE_VW

4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: POS_TREENODE_VW

5 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
6 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
7 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
8 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
9 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

10 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

11 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

12 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

Prompt Table: PRCSRECUR

13 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code