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) |
| 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 |
| Due Date | Represents the date when the cash flow occur, the date is not adjusted with estimation of payment delay days |
| Calender Date | Represents the date when the cash flow occur |
| Acc Currency Amount With Tax | Represents the cash flow amount in accounting currency including tax |
| Trans Currency Amount | Represents the cash flow amount in transaction currency excluding tax |
| Rep Currency 1 Amount With Tax | Represents the cash flow amount in reporting currency 1 including tax |
| Rep Currency 3 Amount With Tax | Represents the cash flow amount in reporting currency 3 including tax |
| Acc Currency Amount | Represents the cash flow amount in accounting currency excluding tax |
| Rep Currency 2 Amount | Represents the cash flow amount in reporting currency 2 excluding tax |
| Row ID | Represent the row ID |
| Rep Currency 3 Amount | Represents the cash flow amount in reporting currency 3 excluding tax |
| Customer Payment Delay Days | Estimated number of days for customer payment to be delayed |
| Rep Currency 2 Amount With Tax | Represents the cash flow amount in reporting currency 2 including tax |
| Rep Currency 1 Amount | Represents the cash flow amount in reporting currency 1 excluding tax |
| Trans Currency Amount With Tax | Represents the cash flow amount in transaction currency including tax |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| CASH PLAN DETAILS | FACT_CASH_PLAN_DETAIL_BI | FACT_CASH_PLAN_DETAIL | On Line |