Model: Cash Planning - Specifications for 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)
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 | | | |