POS_LMT_TBL

#	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: PRCSRECUR
12	NOTIFY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Notification Method 1=Notification Framework 2=Workflow Default Value: 1