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

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

Attributes

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

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 DETAILS	FACT_CASH_PLAN_DETAIL_TM	FACT_CASH_PLAN_DETAIL_BI	FACT_CASH_PLAN_DETAIL	Data Mart