Use of EAI Value Map in an integration field map source expression

EAI value map is when we need to convert a field value from it’s external representation into it’s internal representation and visa versa by referencing a EAI Value Map in a Data Map.

The source expression in an integration field map can use EAI value maps.

We can use the EAILookupSiebel function for inbound value mapping which uses the following syntax:

EAILookupSiebel(“”,[VALUE],[])

We can use the EAILookupExternal function for outbound value mapping which uses the following syntax:

EAILookupExternal(“”,[VALUE],[])

The following is an example integration field map source expression:

EAILookupExternal(“Country”, ifNULL(LookupName(‘COUNTRY’,[Bill To Country]), “UK”))

In this case, EAILookupExternal returns a value from the EAI data map table whereas LookupName returns a value from the LOV table.