MTM_PG_VNDR_V (SQL View)	Index Back
MTM PROGRAM SUPPLIER INFO VIEW VIWE TO SELECT PROGRAM SUPPLIER INFO

MTM_PG_VNDR_V

(SQL View)

MTM PROGRAM SUPPLIER INFO VIEW

VIWE TO SELECT PROGRAM SUPPLIER INFO

SELECT a.mtm_vendor_nm , a.mtm_program_nm , b.mtm_fn_or_mcro_flg , b.mtm_wrkbook_flag , b.tr_stage_tbl_recnm FROM ps_mtm_prog_defn a , PS_MTM_PRODNM_TBL b WHERE b.mtm_vendor_nm = a.mtm_vendor_nm

# 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_PROGRAM_NM Character(30) VARCHAR2(30) NOT NULL MTM Valuation/Analytic processing program

3 MTM_FN_OR_MCRO_FLG Character(1) VARCHAR2(1) NOT NULL Allows the user to designate whether a Microsoft Excel-based third party analytics solution
F=Function
M=Macro

4 MTM_WRKBOOK_FLAG Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a Microsoft Excel workbook object is required in order to execut

5 TR_STAGE_TBL_RECNM Character(15) VARCHAR2(15) NOT NULL An internal work field that contains the EDI staging table name.

#	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_PROGRAM_NM	Character(30)	VARCHAR2(30) NOT NULL	MTM Valuation/Analytic processing program
3	MTM_FN_OR_MCRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to designate whether a Microsoft Excel-based third party analytics solution F=Function M=Macro
4	MTM_WRKBOOK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a Microsoft Excel workbook object is required in order to execut
5	TR_STAGE_TBL_RECNM	Character(15)	VARCHAR2(15) NOT NULL	An internal work field that contains the EDI staging table name.