MTM_VENDOR_NMPrompt Table: MTM_VEND_COM_VW
MTM_FUNC_NMPrompt Table: MTM_V_FN_COM_VW
CO=COM Functions
FE=File Export
FN=Function
FS=FSI Functions
Default Value: FN
MTM_COM_SRCH_VW(SQL View) |
Index Back |
|---|---|
Analytic functions for COMView over analytic functions that are used in COM |
| SELECT mtm_vendor_nm , mtm_func_nm , mtm_map_type , descr FROM PS_MTM_FUNC_HDR WHERE mtm_map_type = 'CO' |
| # | 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_VEND_COM_VW |
| 2 | MTM_FUNC_NM |
Character(30) | VARCHAR2(30) NOT NULL |
The user defined name for a given analytics function.
Prompt Table: MTM_V_FN_COM_VW |
| 3 | MTM_MAP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
The technical interface method utilized by the Treasury product to submit and receive third party analytic
CO=COM Functions FE=File Export FN=Function FS=FSI Functions Default Value: FN |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |