W_GLOBAL_CURR_G

The W_GLOBAL_CURR_G table is used by Retail Insights to support up to three additional currencies in reporting and aggregation (other fields above 3 are not used at this time). RI pre-populates global currency fields in all aggregation tables based on the specified currency codes. The desired codes are added to one row in this table and must align with the Exchange Rates data provided separately. This table is available from the Control & Tactical Center and is not a required configuration for any project unless you wish to report on additional currencies in Retail Insights.

Example data to be inserted to this table:

DATASOURCE_NUM_ID	TENANT_ID	GLOBAL1_CURR_CODE	GLOBAL2_CURR_CODE	GLOBAL3_CURR_CODE	GLOBAL1_RATE_TYPE	GLOBAL2_RATE_TYPE	GLOBAL3_RATE_TYPE	DEFAULT_LOC_RATE_TYPE
1	DEFAULT	INR	AED	PEN	Corporate	Corporate	Corporate	Corporate