On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: CASH PLAN DETAILS.
Represents the cash plan specific analysis source.
Measures derived from the base amounts will be available in CASH PLAN MEASURES.
| Attribute | Description (where applicable) |
| Acc Currency Amount | Represents the cash flow amount in accounting currency excluding tax |
| Acc Currency Amount With Tax | Represents the cash flow amount in accounting currency including tax |
| Calender Date | Represents the date when the cash flow occur |
| Comments | Represents optional comments made on manual cash flows/cash plan adjustments |
| Customer Payment Delay Days | Estimated number of days for customer payment to be delayed |
| Due Date | Represents the date when the cash flow occur, the date is not adjusted with estimation of payment delay days |
| ID | Transaction ID |
| MVT_CREATED_DT | Time stamp from data load |
| Reference Text | Represents reference information from the cash plan source |
| Rep Currency 1 Amount | Represents the cash flow amount in reporting currency 1 excluding tax |
| Rep Currency 1 Amount With Tax | Represents the cash flow amount in reporting currency 1 including tax |
| Rep Currency 2 Amount | Represents the cash flow amount in reporting currency 2 excluding tax |
| Rep Currency 2 Amount With Tax | Represents the cash flow amount in reporting currency 2 including tax |
| Rep Currency 3 Amount | Represents the cash flow amount in reporting currency 3 excluding tax |
| Rep Currency 3 Amount With Tax | Represents the cash flow amount in reporting currency 3 including tax |
| Row ID | Represent the row ID |
| Tag 1 | Represents optional tags on manual cash flows/cash plan adjustments |
| Tag 2 | Represents optional tags on manual cash flows/cash plan adjustments |
| Tag 3 | Represents optional tags on manual cash flows/cash plan adjustments |
| Trans Currency Amount | Represents the cash flow amount in transaction currency excluding tax |
| Trans Currency Amount With Tax | Represents the cash flow amount in transaction currency including tax |
| Model Name |
| Cash Planning |
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 DETAILS | FACT_CASH_PLAN_DETAIL_TM | FACT_CASH_PLAN_DETAIL_BI | FACT_CASH_PLAN_DETAIL | Data Mart |