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)")
|
Related Topics
Primavera Unifier Subject Areas
Unifier - Business Process / Primavera - Business Process
Unifier - Business Process History / Primavera - Business Process History
Unifier - Cash Flow / Primavera - Cash Flow
Unifier - Cash Flow History / Primavera - Cash Flow History
Unifier - Cost Sheet History / Primavera - Cost Sheet History
Unifier - Earned Value Management (Unifier) / Primavera - Earned Value Management (Unifier)
Unifier - Generic Cost Sheet / Primavera - Generic Cost Sheet
Unifier - Resource Cost Summary / Primavera - Resource Cost Summary
Unifier - Space Management / Primavera - Space Management
Unifier - Space Management History / Primavera - Space Management History
Unifier - Workflow / Primavera - Workflow
Last Published Friday, December 8, 2023