Data Lookup Definitions are used to create a simple lookup table where internal data values can be mapped to external data values. You may also specify the value to use if the internal data value is an empty string (or null) or if the internal value is missing from the mapping table.
Integration ID |
Choose the integration ID associated with this data lookup definition. Integration IDs are user-defined and may be entered using the Integration Definition page. |
Lookup Name |
Choose the lookup name associated with the data lookup definition. Lookup names are user-defined and may be entered using the Lookup Names page. |
Value if Null | Enter the text of the value to return if the internal value to be processed is an empty string (or null). |
Value if Not Found | Enter the text of the value to return if the internal value to be processed is not found in the mapping table. |
Internal Value |
Enter the text of the internal value. All values entered are case-sensitive. |
External Value |
Enter the text of the external value. All values entered are case-sensitive. |