MTM_PRODNM_TBL

(SQL Table)
Index Back

MTM Supplier info table

Analytics/Filexport supplier/Product information table

  • Related Language Record: MTM_PRODNM_LNG
  • # 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_VENDORNM_VW

    2 MTM_SRC_TYPE Character(3) VARCHAR2(3) NOT NULL Represents the type of interface method (Excel/COM/FSI/File Format)
    COM=Component Object Model
    FLE=File Format
    FSI=Peoplesoft Financial Services
    XLA=Excel Add-In
    3 TR_STAGE_TBL_RECNM Character(15) VARCHAR2(15) NOT NULL An internal work field that contains the EDI staging table name.

    Prompt Table: MTM_STG_TBL_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 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
    6 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

    Y/N Table Edit

    Default Value: N

    7 MTM_CONTACT Character(20) VARCHAR2(20) NOT NULL Vendor contact representative name for treasury-selected third party analytics application.
    8 MTM_CNTCT_TITLE Character(20) VARCHAR2(20) NOT NULL Vendor contact representative title for treasury-selected third party analytics application.
    9 MTM_CNTCT_PHONE Character(20) VARCHAR2(20) NOT NULL Vendor contact representative phone number for treasury-selected third party analytics application
    10 MTM_CNTCT_LOC Character(20) VARCHAR2(20) NOT NULL Vendor contact representative address for treasury-selected third party analytics application.
    11 MTM_INTERFACE_TYPE Character(1) VARCHAR2(1) NOT NULL mtm interface type
    C=COM Interface
    F=FSI interface
    L=File Export Interface
    X=Excel interface
    12 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
    13 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path