1. Go to IMLN and identify the custom function in the X_UC_FUNCTIONS lexicon

  • Saved Value is a unique 10 character code that is stored in the data base
  • Displayed Value is the Function Name as declared in the data base
  • Meaning is the product that the Function is intended to be used with

2. Create the function in the data base as a data base function returning VARCHAR or NUMBER

  • No parameters may be defined in this function
  • Variables can be passed, however, by setting their value prior to calling the custom function
    • Variables defined on the IMUC Variables tab are created in the User Calc as V_<variable name>
    • example: a Variable identified as Current Month FTE will be identified as V_CURRENT_MONTH_FTE in the SQL code