MTM_FNDEFN_TBL

(SQL Table)
 Index Back

MTM Ext. Function Header

Mark to market sub-function definition table. Defines the header for a sub-function

  • Related Language Record: MTM_FNDEFN_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_VEND_FNC_VW

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

    Prompt Table: MTM_VENDFUNC_VW

    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 MTM_FNEXEC_TXT Character(254) VARCHAR2(254) NOT NULL An internal field that contains specialized PeopleCode dedicated to converting a user de
    5 MTM_FNCALL_TXT Character(254) VARCHAR2(254) NOT NULL Represents the user definition of a analytics function call.
    6 MTM_MACRO_TXT Character(254) VARCHAR2(254) NOT NULL Represents the literal Microsoft Excel text content required to invoke a macro function associated with a c
    7 MTM_FN_CELL_LOC Character(30) VARCHAR2(30) NOT NULL The user defined Microsoft Excel spreadsheet excel location where a compatible third party analytic funct
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 MTM_CREATE_OBJ_Y_N Character(1) VARCHAR2(1) NOT NULL An internal work field utilized to manage COM object creation in regards to Treasury product i

    Y/N Table Edit

    10 MTM_FN_OBJECT_NM Character(64) VARCHAR2(64) NOT NULL COM Object name. Used for creating and instantiating a COM enabled dll of analytic functions
    11 MTM_COM_METHOD_TYP Character(2) VARCHAR2(2) NOT NULL Signifies whether a particular COM function is pre/post/core function call.
    CA=COM Function
    PO=COM Post Processing
    PR=COM Pre Processing
    12 MTM_FNC_OR_PROP Character(1) VARCHAR2(1) NOT NULL Indicates if a COM sub-"function" is a Method (function call) or a Property (can be Get or Set property)
    G=Get Property
    M=Method
    S=Set Property

    Default Value: M

    13 MTM_PROPERTY_NM Character(30) VARCHAR2(30) NOT NULL Property Name
    14 MTM_ERROR_RET_VAL Character(2) VARCHAR2(2) NOT NULL Allows an Analytic function return value to be checked for error conditions
    !0=Not Zero
    <0=Less than Zero
    =0=Null
    >0=Greater than Zero