Fetch Lookup

These function can be used to get the lookup values.

FIELD_NAME is mandatory input while the other remaining input parameters are optional for this function.

Function:

FETCH(LOOKUP[COLUMN_NAME,FIELD_NAME,FIELD_VALUE,DESCR,LANGUAGE_CD])

Expected list of input field/column values:

Input Parameter	Description	Table Description
COLUMN_NAME	Column name to be mapped from the returned RESULTSET. i.e. OUTPUT field name
FIELD_NAME	Lookup Field Name	Lookup Field Value Language
FIELD_VALUE	Lookup Field Value	Lookup Field Value Language
DESCR	Description	Lookup Field Value Language
LANGUAGE_CD	Language Code	Lookup Field Value Language

List of output field/column values: