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

Currency lookups are required because your business may have transactions involving multiple currencies. To create a meaningful report, you have to use a common currency. The Siebel Customer-Centric Enterprise Warehouse provides a means for converting a variety of currencies, as well as prepackaging the following three currency types for each amount stored in the Siebel Customer-Centric Enterprise Warehouse:

• Document currency. The currency of the transaction. For example, if you purchase a chair from a supplier in Mexico, the document currency is probably the Mexican peso.
• Local currency. The currency in which the financial books, including the transaction, are closed. For example, if your business organization is located in France and orders a part from a supplier in Britain, it may pay in British pounds, but it closes its books in French francs. In this case the local currency for the transaction is French francs and the document currency for the transaction is British pounds. The local currency is useful when each business unit of the enterprise creates its own internal reports. For example, your Japanese site may produce internal reports using Japanese yen, while your United States site may produce internal reports using United States dollars.
• Group currency. The standard currency used by your entire enterprise. For example, if a multinational enterprise has its headquarters in the United States, its group currency is probably U.S. dollars. The group currency is useful when creating enterprise-wide reports.

For every monetary amount extracted from the source, the ADI loads the document, local and group currency amounts into the target table. The method that the ADI uses to load the three different currency values depends on what the source provides.

There are three possible situations that can occur:

• Source System Provides Three Currency Amounts

  In this situation, the source system provides all three currency amounts. All three amounts are extracted and loaded into the corresponding Siebel Customer-Centric Enterprise Warehouse table; the system does not need to do any currency conversions.

• Source System Provides Document Amount, Codes, and Exchange Rates for Local and Group Currencies

  In this situation, the source system provides the document currency amount and the exchange rates for finding the local and group currency amounts.

• Source System Provides the Document Currency Amount

  In this situation, the source system provides the document currency amount, but it does not provide the local and group currency amounts or exchange rates used for currency conversion.

The Siebel Customer-Centric Enterprise Warehouse has a predefined logic for loading the document, local, and group currency values into an IA table. The logic is shown in Figure 29.

Figure 29. Currency Conversion Logic