Project Financial Analytics - APIs - V2 - Contract Specific - Unit Price

API Name: API_V2_UnitPrice


Note: This API is specific to projects with unit price contracts only.


  • ProjectNumber
  • ProjectTitle
  • ProjectPMContactName
  • ProjectBidContactName
  • ProjectSalesContactName

  • PrimeContractId
  • PrimeContractNumber
  • PrimeContractSubject
  • PrimeContractIssueDateUtc
  • PrimeContractIssueDateOrgLocal
  • PrimeContractStatus
  • PrimeContractStatusDateUtc
  • PrimeContractStatusDateOrgLocal
  • PrimeContractBillingType
  • PrimeContractBillingTypeValue
  • OwnerCompanyName
  • OwnerContactName
  • ContractorCompanyName
  • ContractorContactName
  • PrimeContractEstStartDateUtc
  • PrimeContractEstFinishDateUtc
  • PrimeContractEstFinishDateInclCODaysUtc
  • PrimeContractEstStartDateOrgLocal
  • PrimeContractEstFinishDateOrgLocal
  • PrimeContractEstFinishDateInclCODaysOrgLocal

  • JobCostCodeId
  • JobCostCodeOrderNumber
  • JobCostCode
  • JobCostCodeDescription
  • JobCostCodeQuantity
  • JobCostCodeUnit
  • JobCostCodeInternalDivision
  • JobCostCodeInternalDivisionDesc
  • JobCostCodeInternalMajor
  • JobCostCodeInternalMajorDesc
  • JobCostCodeInternalMinor
  • JobCostCodeInternalMinorDesc
  • JobCostCodeInternalSubMinor
  • JobCostCodeInternalSubMinorDesc

  • OwnerCostCode
  • OwnerCostCodeDescription

  • Percent_Field_EstimatedCompletion

  • Quantity_RevenueBudget_Prime_Item
  • Quantity_RevenueBudget_ApprovedCOs_Item
  • Quantity_RevenueBudget_Revised_Item
  • Quantity_RevenueBudget_PendingCOs_Item
  • Quantity_RevenueBudget_ApprovedAndPendingCOs_Item

  • Quantity_PrimeInvoice_Approved_Item_NoCORef
  • Quantity_PrimeInvoice_Approved_Item_WithCORef
  • Quantity_PrimeInvoice_Approved_Item
  • Quantity_PrimeInvoice_ApprovedAndPending_Item_NoCORef
  • Quantity_PrimeInvoice_ApprovedAndPending_Item_WithCORef
  • Quantity_PrimeInvoice_ApprovedAndPending_Item

  • Quantity_DailyLog_Activity_Item_NoCORef
  • Quantity_DailyLog_Activity_Item_WithCORef
  • Quantity_DailyLog_Activity_Item

  • Variance_RevenueBudgetPrimeInvoice_Approved_ItemQty
  • Variance_RevenueBudgetPrimeInvoice_ApprovedAndPending_ItemQty
  • Variance_RevenueBudgetDailyLogActivity_ItemQty

  • Variance_DailyLogActivityPrimeInvoice_ItemQty_NoCORef
  • Variance_DailyLogActivityPrimeInvoice_ItemQty_WithCORef
  • Variance_DailyLogActivityPrimeInvoice_ItemQty

  • Percent_PrimeInvoiceRevenueBudget_Approved_ItemQty
  • Percent_PrimeInvoiceRevenueBudget_ApprovedAndPending_ItemQty

  • Percent_DailyLogActivityRevenueBudget_ItemQty

  • CostBudget_Prime_M
  • CostBudget_Prime_L
  • CostBudget_Prime_E
  • CostBudget_Prime_S
  • CostBudget_Prime_O
  • CostBudget_Prime
  • CostBudget_Prime_ItemQty_UnitPrice

  • CostBudget_ApprovedCOs_M
  • CostBudget_ApprovedCOs_L
  • CostBudget_ApprovedCOs_E
  • CostBudget_ApprovedCOs_S
  • CostBudget_ApprovedCOs_O
  • CostBudget_ApprovedCOs
  • CostBudget_ApprovedCOs_ItemQty_UnitPrice

  • CostBudget_Revised_M
  • CostBudget_Revised_L
  • CostBudget_Revised_E
  • CostBudget_Revised_S
  • CostBudget_Revised_O
  • CostBudget_Revised
  • CostBudget_Revised_ItemQty_UnitPrice
  • CostBudget_Revised_JCCQty_UnitPrice

  • CostBudget_PendingCOs_M
  • CostBudget_PendingCOs_L
  • CostBudget_PendingCOs_E
  • CostBudget_PendingCOs_S
  • CostBudget_PendingCOs_O
  • CostBudget_PendingCOs
  • CostBudget_PendingCOs_ItemQty_UnitPrice

  • CostBudget_ApprovedAndPendingCOs
  • CostBudget_ApprovedAndPendingCOs_ItemQty_UnitPrice

  • CostBudget_ApprovedCPRs
  • CostBudget_PendingCPRs
  • CostBudget_ApprovedAndPendingCPRs

  • CommittedCost_Approved_Subtotal_M
  • CommittedCost_Approved_Subtotal_L
  • CommittedCost_Approved_Subtotal_E
  • CommittedCost_Approved_Subtotal_S
  • CommittedCost_Approved_Subtotal_O
  • CommittedCost_Approved_Subtotal

  • CommittedCost_Pending_Subtotal_M
  • CommittedCost_Pending_Subtotal_L
  • CommittedCost_Pending_Subtotal_E
  • CommittedCost_Pending_Subtotal_S
  • CommittedCost_Pending_Subtotal_O
  • CommittedCost_Pending_Subtotal

  • CommittedCost_ApprovedAndPending_Subtotal_M
  • CommittedCost_ApprovedAndPending_Subtotal_L
  • CommittedCost_ApprovedAndPending_Subtotal_E
  • CommittedCost_ApprovedAndPending_Subtotal_S
  • CommittedCost_ApprovedAndPending_Subtotal_O
  • CommittedCost_ApprovedAndPending_Subtotal

  • CostToDate_Approved_GrossTotal_M
  • CostToDate_Approved_GrossTotal_L
  • CostToDate_Approved_GrossTotal_E
  • CostToDate_Approved_GrossTotal_S
  • CostToDate_Approved_GrossTotal_O
  • CostToDate_Approved_GrossTotal

  • CostToDate_Pending_GrossTotal_M
  • CostToDate_Pending_GrossTotal_L
  • CostToDate_Pending_GrossTotal_E
  • CostToDate_Pending_GrossTotal_S
  • CostToDate_Pending_GrossTotal_O
  • CostToDate_Pending_GrossTotal

  • CostToDate_ApprovedAndPending_GrossTotal_M
  • CostToDate_ApprovedAndPending_GrossTotal_L
  • CostToDate_ApprovedAndPending_GrossTotal_E
  • CostToDate_ApprovedAndPending_GrossTotal_S
  • CostToDate_ApprovedAndPending_GrossTotal_O
  • CostToDate_ApprovedAndPending_GrossTotal

  • CostToDate_Approved_GrossTotal_DailyLog_Activity_ItemQty_UnitPrice
  • CostToDate_ApprovedAndPending_GrossTotal_DailyLog_Activity_ItemQty_UnitPrice

  • CostToDate_Approved_GrossTotal_PrimeInvoice_ItemQty_UnitPrice
  • CostToDate_ApprovedAndPending_GrossTotal_PrimeInvoice_ItemQty_UnitPrice

  • CostToDate_Approved_GrossTotal_Field_EstimatedCompletion_UnitPrice
  • CostToDate_ApprovedAndPending_GrossTotal_Field_EstimatedCompletion_UnitPrice

  • Percent_CostToDateCostBudget_Gross

  • RevenueBudget_Prime_Subtotal
  • RevenueBudget_Prime_ItemQty_UnitPrice

  • RevenueBudget_ApprovedCOs_Subtotal
  • RevenueBudget_ApprovedCOs_ItemQty_UnitPrice

  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_ItemQty_UnitPrice
  • RevenueBudget_Revised_JCCQty_UnitPrice

  • RevenueBudget_PendingCOs_Subtotal
  • RevenueBudget_PendingCOs_ItemQty_UnitPrice

  • PrimeInvoice_Approved_GrossTotal_NoCORef
  • PrimeInvoice_Approved_GrossTotal_WithCORef
  • PrimeInvoice_Approved_GrossTotal

  • PrimeInvoice_ApprovedAndPending_GrossTotal_NoCORef
  • PrimeInvoice_ApprovedAndPending_GrossTotal_WithCORef
  • PrimeInvoice_ApprovedAndPending_GrossTotal

  • Variance_PrimeInvoiceCostToDate_Approved_GrossTotal
  • Variance_PrimeInvoiceCostToDate_ApprovedAndPending_GrossTotal

  • ProjectedCost_DailyLog_Activity_ItemQty

  • ProjectedCost_Invoiced_Approved_ItemQty
  • ProjectedCost_Invoiced_ApprovedAndPending_ItemQty

  • EarnedRevenue_CostToDateCostBudget_Approved_GrossTotal
  • Billing_Over_CostToDateCostBudget_Approved_GrossTotal
  • Billing_Under_CostToDateCostBudget_Approved_GrossTotal

  • EarnedRevenue_DailyLogActivityRevenueBudget_ItemQty
  • Billing_Over_DailyLogActivityRevenueBudget_ItemQty
  • Billing_Under_DailyLogActivityRevenueBudget_ItemQty

  • EarnedRevenue_Field_EstimatedCompletion
  • Billing_Over_Field_EstimatedCompletion
  • Billing_Under_Field_EstimatedCompletion

  • HourBudget_Prime_L
  • HourBudget_ApprovedCOs_L
  • HourBudget_Revised_L

  • LbrTimecard_Approved_Hours_NoCORef
  • LbrTimecard_Approved_Hours_WithCORef
  • LbrTimecard_Approved_Hours

  • LbrTimecard_Pending_Hours_NoCORef
  • LbrTimecard_Pending_Hours_WithCORef
  • LbrTimecard_Pending_Hours

  • LbrTimecard_ApprovedAndPending_Hours_NoCORef
  • LbrTimecard_ApprovedAndPending_Hours_WithCORef
  • LbrTimecard_ApprovedAndPending_Hours

  • Variance_HourBudgetTimecard_L
  • Percent_TimecardHourBudget_L

  • LbrTimecard_Approved_CostTotal
  • LbrTimecard_Approved_Billable
  • LbrTimecard_Approved_Unbillable
  • LbrTimecard_Approved_OnHold

  • LbrTimecard_ApprovedAndPending_CostTotal
  • LbrTimecard_ApprovedAndPending_Billable
  • LbrTimecard_ApprovedAndPending_Unbillable
  • LbrTimecard_ApprovedAndPending_OnHold

  • Projected_Hours_L
  • Projected_Cost_Total_L

  • DailyLog_Manpower_JobCostCode_Hours

  • HourBudget_Prime_E
  • HourBudget_ApprovedCOs_E
  • HourBudget_Revised_E

  • EqpTimecard_Hours_NoCORef
  • EqpTimecard_Hours_WithCORef
  • EqpTimecard_Hours

  • Variance_HourBudgetTimecard_E
  • Percent_TimecardHourBudget_E

  • EqpTimecard_CostTotal
  • EqpTimecard_Billable
  • EqpTimecard_Unbillable
  • EqpTimecard_OnHold

  • Projected_Hours_E
  • Projected_Cost_Total_E

  • DailyLog_MajorEqp_JobCostCode_Hours