Defining the Custom Function in the application#
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 usercalc as V_<variable name>
- example: a Variable identified as Current Month FTE will be identified as V_CURRENT_MONTH_FTE in the SQL code
3. Invoke the custom function in your usercalc using an Operand Type of CF (Custom Function)
