Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > About Document, Local, and Group Currencies >

Source System Provides the Document Currency Amount

This is the most common situation, and thus is the Siebel Customer-Centric Enterprise Warehouse's default for handling currency. If the source system provides only the document currency amount, the Source Adapter performs lookups to identify the local and group currency codes based on the source system. Based on the source system the appropriate currencies are assigned. After the lookups occur, the Source Adapter mapplet provides the ADI with the document currency amount and the document, local, and group currency codes.

Because the ADI does not have the local and group amounts, or document-to-group (DOC_TO_GRP) and local-to-group (LOC_TO_GRP) currency conversion rates to derive the amounts, it looks up the exchange rates. By default, the ADI looks up the exchange rates in the IA_XRATES table. However, if you have custom tables that maintain exchange rate values, you can reconfigure the system to do the extraction from that source system.

The ADI then populates the exchange rate values in the DOC_TO_GRP and LOC_TO_GRP variables. After this population is complete, the ADI uses the DOC_TO_GRP rate to convert the document currency amount to the group currency amount. The ADI then uses the ratio of DOC_TO_GRP and LOC_TO_GRP to convert the document currency amount to the local currency amount. Finally, the ADI passes the three currency amounts and currency codes to the corresponding IA table.

NOTE:  For currency code information to be resolved, you must verify that the currency codes extracted map to the currency codes in the IA_XRATES table.