Model: Cash Planning - Specifications for Dimension Table: CASH PLAN CURRENCY

On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: CASH PLAN CURRENCY.

Attributes

Attribute	Description (where applicable)
Attribute	Represent the 3 reporting currencies
Cash Plan ID	Represent the Cash plan ID, to connect to CASH PLAN table
Header Balance	Header text to be used as title when presenting Balances by transaction currency that also includes the currency code
Header Inflow Outflow	Header text to be used as title when presenting Inflow and Outflow by transaction currency that also includes the currency code
Header Top of graphs	Header text to be used as title when presenting values by transaction currency that also includes the currency code
Reporting Currency	Represent the code for the reporting currency
Switch Reporting Currency Row ID	ID to connect to the Switch Currency Type table

USED BY MODEL(S)

Model Name

Cash Planning

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
CASH PLAN CURRENCY	CAPL_CURRENCY_TM