Unifier - Cost Sheet / Primavera - Cost Sheet
Description: Use this subject area to analyze cost sheets. You can map your data source to a predefined list of cost sheet columns. Twenty generic columns are included to support mapping of additional data sources from the cost sheet.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Fact - Primavera - Cost Sheet | Costs | Costs | |||
| Fact - Primavera - Cost Sheet | Costs | Actuals Received | Fact | Actuals Received |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Actuals Received (Base)", "P6Core"."Fact - Cost Sheet"."Actuals Received (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Budget Revisions | Fact | Approved Budget Revisions |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Budget Revisions (Base)", "P6Core"."Fact - Cost Sheet"."Approved Budget Revisions (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Change Orders | Fact | Approved Change Orders |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Change Orders (Base)", "P6Core"."Fact - Cost Sheet"."Approved Change Orders (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Commitment Changes | Fact | Approved Commitment Changes |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Commitment Changes (Base)", "P6Core"."Fact - Cost Sheet"."Approved Commitment Changes (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Invoices | Fact | Approved Invoices |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Invoices (Base)", "P6Core"."Fact - Cost Sheet"."Approved Invoices (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved PO Amendments | Fact | Approved PO Amendments |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved PO Amendments (Base)", "P6Core"."Fact - Cost Sheet"."Approved PO Amendments (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Payment Applications | Fact | Approved Payment Applications |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Payment Applications (Base)", "P6Core"."Fact - Cost Sheet"."Approved Payment Applications (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Approved Spends | Fact | Approved Spends |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Approved Spends (Base)", "P6Core"."Fact - Cost Sheet"."Approved Spends (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Budget Percent | Fact | Budget Percent |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Budget Percent (Base)", "P6Core"."Fact - Cost Sheet"."Budget Percent (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Budget Variance | Fact | Budget Variance |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Budget Variance (Base)", "P6Core"."Fact - Cost Sheet"."Budget Variance (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Commitment Percent | Fact | Commitment Percent |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Commitment Percent (Base)", "P6Core"."Fact - Cost Sheet"."Commitment Percent (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Contracts | Fact | Contracts |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Contracts (Base)", "P6Core"."Fact - Cost Sheet"."Contracts (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Estimate | Fact | Estimate |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Estimate (Base)", "P6Core"."Fact - Cost Sheet"."Estimate (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Forecast | Fact | Forecast |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Forecast (Base)", "P6Core"."Fact - Cost Sheet"."Forecast (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Forecast Adjustments | Fact | Forecast Adjustments |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Forecast Adjustments (Base)", "P6Core"."Fact - Cost Sheet"."Forecast Adjustments (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Journal Entries | Fact | Journal Entries |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Journal Entries (Base)", "P6Core"."Fact - Cost Sheet"."Journal Entries (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Original Budget | Fact | Original Budget |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Original Budget (Base)", "P6Core"."Fact - Cost Sheet"."Original Budget (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Original Commitments | Fact | Original Commitments |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Original Commitments (Base)", "P6Core"."Fact - Cost Sheet"."Original Commitments (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Budget Revisions | Fact | Pending Budget Revisions |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Budget Revisions (Base)", "P6Core"."Fact - Cost Sheet"."Pending Budget Revisions (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Change Orders | Fact | Pending Change Orders |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Change Orders (Base)", "P6Core"."Fact - Cost Sheet"."Pending Change Orders (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Commitment Changes | Fact | Pending Commitment Changes |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Commitment Changes (Base)", "P6Core"."Fact - Cost Sheet"."Pending Commitment Changes (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Invoices | Fact | Pending Invoices |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Invoices (Base)", "P6Core"."Fact - Cost Sheet"."Pending Invoices (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending PO Amendments | Fact | Pending PO Amendments |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending PO Amendments (Base)", "P6Core"."Fact - Cost Sheet"."Pending PO Amendments (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Payment Applications | Fact | Pending Payment Applications |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Payment Applications (Base)", "P6Core"."Fact - Cost Sheet"."Pending Payment Applications (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Pending Spends | Fact | Pending Spends |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Pending Spends (Base)", "P6Core"."Fact - Cost Sheet"."Pending Spends (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Purchase Orders | Fact | Purchase Orders |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Purchase Orders (Base)", "P6Core"."Fact - Cost Sheet"."Purchase Orders (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Remaining Budget | Fact | Remaining Budget |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Remaining Budget (Base)", "P6Core"."Fact - Cost Sheet"."Remaining Budget (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Revised Budget | Fact | Revised Budget |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Revised Budget (Base)", "P6Core"."Fact - Cost Sheet"."Revised Budget (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Revised Commitments | Fact | Revised Commitments |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Revised Commitments (Base)", "P6Core"."Fact - Cost Sheet"."Revised Commitments (Project)")
|
| Fact - Primavera - Cost Sheet | Costs | Risks and Issues | Fact | Risks and Issues |
INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet"."Risks and Issues (Base)", "P6Core"."Fact - Cost Sheet"."Risks and Issues (Project)")
|