Data Warehouse Parameters (tcgen0100m100)
Field Information
- Effective Date
-
The date and time on which the parameters are valid.
- Description
-
The description or name of the code.
- Data Warehouse Setup in Company
-
The company in which the data warehouse parameters are set up.
The setup can be created in a specific company and reused by other companies by referencing that setup company. For example, if the setup is defined in company 300, companies 301 and 302 can reference and use the setup in 300.
It is recommended to use a Data Warehouse Setup Company to ensure consistent settings across all companies.
- Use Data Warehouse Currency
-
Determines whether calculated fields for amounts in the data warehouse currency are calculated or filled with a zero value.
It is recommended to select this check box to enable aggregation of amounts across companies in the same currency.
- Data Warehouse Currency
-
The currency in which data warehousing transactions are processed.
- Description
-
The description or name of the code.
- Exchange Rate Type
-
If this check box is selected, amounts in the data warehouse currency are calculated using the exchange rate type specified in the Exchange Rate Type field.
If this check box is cleared, the exchange rate type from the transaction is used.
It is recommended not to select this check box.
- Exchange Rate Type
-
The exchange rate type to which you link the transactions.
- Description
-
The description or name of the code.
- Use Reference Currency
-
Determines whether calculated fields for amounts in the reference currency are calculated or filled with a zero value.
- Use Local Currency
-
Determines whether calculated fields for amounts in the local currency are calculated or filled with a zero value.
- Use Reporting Currency 1
-
Determines whether calculated fields for amounts in the reporting currency 1 are calculated or filled with a zero value.
- Use Reporting Currency 2
-
Determines whether calculated fields for amounts in the reporting currency 2 are calculated or filled with a zero value.
- Use Transaction Currency
-
Determines whether calculated fields for amounts in the transaction currency are calculated or filled with a zero value.