Unifier - Cash Flow / Primavera - Cash Flow

Description: Use this subject area to analyze WBS shell-level cash flows and commitment-level cash flows. You can map columns to predefined WBS shell-level cash flow curves and commitment level cash flow curves respectively. Ten generic columns are included to support cash flow curves.

Folder	Subfolder	Field Name	Dimension/ Fact / Lookup	Description	Values Derived From / Calculated By
Commitment	Base Commit BP		Dimension	Base Commit BP
Commitment	Base Commit BP	Base Commit BP Name	Dimension	Base Commit BP Name	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_NAME
Commitment	Base Commit BP	Base Commit BP Record Name	Dimension	Base Commit BP Record Name	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_REC_NAME
Commitment	Base Commit BP	Base Commit BP Record Number	Dimension	Base Commit BP Record Number	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_BASE_COMM_BP_REC_NO
Commitment	Change Commit BP			Change Commit BP
Commitment	Change Commit BP	Business Process Name	Dimension	Change Commit BP Name	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_BP_NAME
Commitment	Change Commit BP	Record Id	Dimension	Change Commit BP Record Id	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORDID
Commitment	Change Commit BP	Record Name	Dimension	Change Commit BP Record Name	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORD_NAME
Commitment	Change Commit BP	Record Number	Dimension	Change Commit BP Record Number	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_RECORDNO
Commitment	Change Commit BP	Status	Dimension	Change Commit BP Status	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_CC_BP_STATUS
Commitment	Change Commit BP Line	Line Description	Dimension	Change Commit BP Line Description	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LI_SHORT_DESC
Commitment	Change Commit BP Line	Line Id	Dimension	Change Commit BP Line Id	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LIID
Commitment	Change Commit BP Line	Line Number	Dimension	Change Commit BP Line Number	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.CMM_SRC_LINUM
Commitment	Dates - (Commitment)			Dates - (Commitment)
Commitment	Dates - (Commitment)	From Date	Dimension	From Date	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.FROM_DATE
Commitment	Dates - (Commitment)	To Date	Dimension	To Date	Value Derived From : Dim_W_CMM_COMM_BP_D_Cash_Flow_Commitment_BP.TO_DATE

Cash Flow Folder
Cash Flow				Cash Flow
Cash Flow		Cash Flow Name	Dimension	The name of the cash flow in project	Dim_W_CASH_FLOW_D_Cash_Flow.FAMILY_NAME
Cash Flow		Unique Cash Flow ID	Dimension	The unique ID of the cash flow	Dim_W_CASH_FLOW_D_Cash_Flow.CF_OBJECT_ID

Fact - Primavera - Cash Flow Folder
Fact - Primavera - Cash Flow	Costs (Summary)		Fact	Costs (Summary)
Fact - Primavera - Cash Flow	Costs (Summary)	Total	Fact	Total	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Total (Base)", "P6Core"."Fact - Cash Flow"."Total (Project)")
Fact - Primavera - Cash Flow	Costs (Summary)	Unassigned Amount	Fact	Unassigned Amount	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Unassigned Amount (Base)", "P6Core"."Fact - Cash Flow"."Unassigned Amount (Project)")
Fact - Primavera - Cash Flow	Costs	Actuals	Fact	Actuals cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Actuals (Base)", "P6Core"."Fact - Cash Flow"."Actuals (Project)")
Fact - Primavera - Cash Flow	Cash Flow	Cash Flow Detail Level	Dimension	Cash Flow Detail Level	case Dim_W_CASH_FLOW_D_Cash_Flow.DETAIL_LEVEL when 1 then 'CBS' when 2 then 'Summary CBS' when 3 then 'Commitment' else NULL end
Fact - Primavera - Cash Flow	Costs	Current Baseline	Fact	Current baseline cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Current Baseline (Base)", "P6Core"."Fact - Cash Flow"."Current Baseline (Project)")
Fact - Primavera - Cash Flow	Costs	Forecast	Fact	Forecasted cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Forecast (Base)", "P6Core"."Fact - Cash Flow"."Forecast (Project)")
Fact - Primavera - Cash Flow	Costs	Initial Baseline	Fact	Initial baseline cost	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cash Flow"."Initial Baseline (Base)", "P6Core"."Fact - Cash Flow"."Initial Baseline (Project)")

Related Topics