MTM_VEND_FNC_VW (SQL View)	Index Back
Prompt for Analytics suppliers Specific prompt for Analytic suppliers only

MTM_VEND_FNC_VW

(SQL View)

Prompt for Analytics suppliers

Specific prompt for Analytic suppliers only

SELECT MTM_VENDOR_NM , DESCR FROM PS_MTM_PRODNM_TBL WHERE MTM_MAP_TYPE <> 'FE'

Related Language Record: MTM_VND_FNC_V_L

# 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.
Prompt Table: MTM_PRODNM_TBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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. Prompt Table: MTM_PRODNM_TBL
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description