Data Lookup Definition (kourier_transformation_def.aspx)


Purpose

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.

File/Key Field

KT_INTEGRATION_XREF/Integration ID * Lookup Name

Fields

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.

Line Item Fields

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.


User Guide - Table of Contents