D Appendix: Retail Insights Setup Table Column Descriptions

This appendix lists the columns description of the Retail Insights Setup tables.

Table D-1 Setup Table Column Descriptions

Physical Table	Physical Column	Column Description
W_LANGUAGES_G	LANGUAGE_CODE	Supported Language code for the Product
W_LANGUAGES_G	SRC_LANGUAGE_CODE	The SRC_LANGUAGE_CODE column defines the primary language for the product.
W_GLOBAL_CURR_G	DATASOURCE_NUM_ID	This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define. separate unique source IDs for each of your different source instances.
W_GLOBAL_CURR_G	TENANT_ID	This column is the unique identifier for a Tenant in a multitenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service
W_GLOBAL_CURR_G	GLOBAL1_CURR_CODE	Currency Code for Global 1 Currency. Retail Insights provides three global currencies, which are the common currencies used by the Retail Insights. For example, if your organization is a multinational enterprise that has its headquarters in the United States, you probably want to choose US dollars (USD) as one of the three global currencies.
W_GLOBAL_CURR_G	GLOBAL2_CURR_CODE	Currency Code for Global 2 Currency. Retail Insights provides three global currencies, which are the common currencies used by the Retail Insights. For example, if your organization is a multinational enterprise that has its headquarters in the United States, you probably want to choose US dollars (USD) as one of the three global currencies.
W_GLOBAL_CURR_G	GLOBAL3_CURR_CODE	Currency Code for Global 3 Currency. Retail Insights provides three global currencies, which are the common currencies used by the Retail Insights. For example, if your organization is a multinational enterprise that has its headquarters in the United States, you probably want to choose US dollars (USD) as one of the three global currencies.
W_GLOBAL_CURR_G	GLOBAL1_RATE_TYPE	When Retail Insights converts your transaction records' amount from document currency to global currencies, it also requires the exchange rate types to use to perform the conversion. For each of the global currencies, This columns should be used to specify the exchange rate type to use to perform the conversion for Global 1 Currency.
W_GLOBAL_CURR_G	GLOBAL2_RATE_TYPE	When Retail Insights converts your transaction records' amount from document currency to global currencies, it also requires the exchange rate types to use to perform the conversion. For each of the global currencies, This columns should be used to specify the exchange rate type to use to perform the conversion for Global 2 Currency.
W_GLOBAL_CURR_G	GLOBAL3_RATE_TYPE	When Retail Insights converts your transaction records' amount from document currency to global currencies, it also requires the exchange rate types to use to perform the conversion. For each of the global currencies, This columns should be used to specify the exchange rate type to use to perform the conversion for Global 3 Currency.
W_GLOBAL_CURR_G	DEFAULT_LOC_RATE_TYPE	The conversion rate type for document currency to local currency conversion
W_MCAL_CONFIG_G	CALENDAR_ID	Indentifies the calendar that is being configured
W_MCAL_CONFIG_G	CALENDAR_NAME	Name of the calendar that is being configured
W_MCAL_CONFIG_G	CALENDAR_CLASS	Identifies the category of calendar. Valid values are 'Generated', 'File Sourced', 'OLTP Sourced'.
W_MCAL_CONFIG_G	PERIOD_TYPE	Type of the calendar period that is being configured e.g '4-4-5'
W_MCAL_CONFIG_G	CAL_ST_DT	This is the date from which the calendar generation begins
W_MCAL_CONFIG_G	CAL_END_DT	This is the date to which the calendar generation ends
W_MCAL_CONFIG_G	CAL_OFFSET	This is the offset which identifies the start date of the calendar. The Valid values are: Week Start Day Offset Value Monday 0 Tuesday 1 Wednesday 2 Thursday 3 Friday -3 Saturday -2 Sunday -1
W_MCAL_CONFIG_G	WEEK_ALLOCATION_RULE	This parameter determines how weeks are allocated
W_XACT_TYPE_D	ROW_WID	Surrogate key to uniquely identify a record.
W_XACT_TYPE_D	XACT_CODE	Identifies the code for classification and grouping of the transaction.
W_XACT_TYPE_D	XACT_CAT_CODE	Identifies the code of the transaction category. It is a grouping of transactions with similar characteristics.
W_XACT_TYPE_D	XACT_CAT_NAME	Identifies the name of the transaction category.
W_XACT_TYPE_D	XACT_TYPE_CODE	Identifies the transaction type code as defined in the source system. Transaction type is a specification of the source of the transaction.
W_XACT_TYPE_D	XACT_TYPE_NAME	Identifies the transaction type name as defined in the source system.