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.
tipWidgetTipSetup data lookups to provide standardized or consistent data values from inconsistent internal data values. For example you can setup a data lookup for Country codes and then define the external data value you want to use for each of your county code variations (e.g., U.S., U.S.A. can all map to USA).
KT_INTEGRATION_XREF/Integration ID * Lookup Name
|
Field Name |
Description - Usage - Notes |
|
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. |
|
Field Name |
Description - Usage - Notes |
|
Internal Value |
Enter the text of the internal data value. All values entered are case-sensitive. |
|
External Value |
Enter the text of the external data value. All values entered are case-sensitive. |