MTM_FNPAR_VW (SQL View)	Index Back
MTM Ext Funct. Detail View To create a level 1 scroll on the instr-mtm-parm_pnl

MTM_FNPAR_VW

(SQL View)

MTM Ext Funct. Detail View

To create a level 1 scroll on the instr-mtm-parm_pnl

SELECT a.mtm_vendor_nm , a.mtm_func_nm , a.mtm_func_seq , a.seq_num , a.mtm_param_nm , a.required_sw FROM PS_MTM_FNPARM_TBL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MTM_VENDOR_NM Character(20) VARCHAR2(20) NOT NULL 3rd party analytics vendor used for valuation and analytics.

2 MTM_FUNC_NM Character(30) VARCHAR2(30) NOT NULL The user defined name for a given analytics function.

3 MTM_FUNC_SEQ Number(2,0) SMALLINT NOT NULL A sequential value utilized in order to determine the calling or submission sequence of a series of a

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 MTM_PARAM_NM Character(20) VARCHAR2(20) NOT NULL The user defined data parameter name assigned to a specific datum associated with Treasury product deal
Prompt Table: MTM_PARMNM_VW

6 REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Book is Required

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MTM_VENDOR_NM	Character(20)	VARCHAR2(20) NOT NULL	3rd party analytics vendor used for valuation and analytics.
2	MTM_FUNC_NM	Character(30)	VARCHAR2(30) NOT NULL	The user defined name for a given analytics function.
3	MTM_FUNC_SEQ	Number(2,0)	SMALLINT NOT NULL	A sequential value utilized in order to determine the calling or submission sequence of a series of a
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	MTM_PARAM_NM	Character(20)	VARCHAR2(20) NOT NULL	The user defined data parameter name assigned to a specific datum associated with Treasury product deal Prompt Table: MTM_PARMNM_VW
6	REQUIRED_SW	Character(1)	VARCHAR2(1) NOT NULL	Book is Required