Project Financial Analytics - APIs - V1 - Cost

API Name: CoreconAPI_Cost


Note: Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-projects are selected.


  • ProjectId
  • ProjectNumber
  • ProjectTitle
  • ProjectBidContactName
  • ProjectSalesContactName
  • ProjectPMContactName
  • ProjectEstStartDateUtc
  • ProjectEstStartDateOrgLocal
  • ProjectEstFinishDateUtc
  • ProjectEstFinishDateOrgLocal

  • PrimeContractId
  • PrimeContractNumber
  • PrimeContractSubject
  • PrimeContractIssueDateUtc
  • PrimeContractIssueDateOrgLocal
  • PrimeContractStatus
  • PrimeContractApprovalDateUtc
  • PrimeContractApprovalDateOrgLocal
  • PrimeContractBillingType
  • PrimeContractBillingTypeValue
  • OwnerCompanyName
  • OwnerContactName
  • ContractorCompanyName
  • ContractorContactName
  • PrimeContractEstStartDateUtc
  • PrimeContractEstFinishDateUtc
  • PrimeContractEstStartDateOrgLocal
  • PrimeContractEstFinishDateOrgLocal

  • JobCostCodeId
  • JobCostCodeOrderNumber
  • JobCostCode
  • JobCostCodeDescription
  • JobCostCodeQuantity
  • JobCostCodeUnit

  • JobCostCodeInternalDivision
  • JobCostCodeInternalDivisionDesc
  • JobCostCodeInternalMajor
  • JobCostCodeInternalMajorDesc
  • JobCostCodeInternalMinor
  • JobCostCodeInternalMinorDesc
  • JobCostCodeInternalSubMinor
  • JobCostCodeInternalSubMinorDesc

  • OwnerCostCode
  • OwnerCostCodeDescription

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

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

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

  • CostBudget_ApprovedAndPendingCOs_M
  • CostBudget_ApprovedAndPendingCOs_L
  • CostBudget_ApprovedAndPendingCOs_E
  • CostBudget_ApprovedAndPendingCOs_S
  • CostBudget_ApprovedAndPendingCOs_O
  • CostBudget_ApprovedAndPendingCOs

  • CostBudget_Revised_M = [CostBudget_Prime_M] + [CostBudget_ApprovedCOs_M]
  • CostBudget_Revised_L = [CostBudget_Prime_L] + [CostBudget_ApprovedCOs_L]
  • CostBudget_Revised_E = [CostBudget_Prime_E] + [CostBudget_ApprovedCOs_E]
  • CostBudget_Revised_S = [CostBudget_Prime_S] + [CostBudget_ApprovedCOs_S]
  • CostBudget_Revised_O = [CostBudget_Prime_O] + [CostBudget_ApprovedCOs_O]
  • CostBudget_Revised = [CostBudget_Prime] + [CostBudget_ApprovedCOs]

  • CostBudget_ApprovedCPRs_M
  • CostBudget_ApprovedCPRs_L
  • CostBudget_ApprovedCPRs_E
  • CostBudget_ApprovedCPRs_S
  • CostBudget_ApprovedCPRs_O
  • CostBudget_ApprovedCPRs

  • CostBudget_PendingCPRs_M
  • CostBudget_PendingCPRs_L
  • CostBudget_PendingCPRs_E
  • CostBudget_PendingCPRs_S
  • CostBudget_PendingCPRs_O
  • CostBudget_PendingCPRs

  • AnticipatedCost_Subtotal
  • AnticipatedCost_Tax
  • AnticipatedCost_Total

  • PO_Approved_Subtotal
  • PO_Approved_Tax
  • PO_Approved_Total

  • PO_Approved_Open_Subtotal
  • PO_Approved_Open_Total

  • PO_Pending_Subtotal
  • PO_Pending_Tax
  • PO_Pending_Total

  • PO_ApprovedAndPending_Subtotal
  • PO_ApprovedAndPending_Tax
  • PO_ApprovedAndPending_Total

  • Bill_Approved_Subtotal
  • Bill_Approved_Tax
  • Bill_Approved_Total

  • Bill_Pending_Subtotal
  • Bill_Pending_Tax
  • Bill_Pending_Total

  • Bill_ApprovedAndPending_Subtotal
  • Bill_ApprovedAndPending_Tax
  • Bill_ApprovedAndPending_Total

  • Bill_NoPO_Approved_Subtotal
  • Bill_NoPO_Approved_Tax
  • Bill_NoPO_Approved_Total

  • Bill_NoPO_Pending_Subtotal
  • Bill_NoPO_Pending_Tax
  • Bill_NoPO_Pending_Total

  • Bill_NoPO_ApprovedAndPending_Subtotal
  • Bill_NoPO_ApprovedAndPending_Tax
  • Bill_NoPO_ApprovedAndPending_Total

  • Subcontract_Approved_Subtotal
  • Subcontract_Approved_Tax
  • Subcontract_Approved_Total

  • Subcontract_Pending_Subtotal
  • Subcontract_Pending_Tax
  • Subcontract_Pending_Total

  • Subcontract_ApprovedAndPending_Subtotal
  • Subcontract_ApprovedAndPending_Tax
  • Subcontract_ApprovedAndPending_Total

  • SCO_Approved_Subtotal
  • SCO_Approved_Tax
  • SCO_Approved_Total

  • SCO_Pending_Subtotal
  • SCO_Pending_Tax
  • SCO_Pending_Total

  • SCO_ApprovedAndPending_Subtotal
  • SCO_ApprovedAndPending_Tax
  • SCO_ApprovedAndPending_Total

  • RevisedSubcontract_Approved_Subtotal
  • RevisedSubcontract_Approved_Tax
  • RevisedSubcontract_Approved_Total

  • RevisedSubcontract_Approved_Open_Subtotal
  • RevisedSubcontract_Approved_Open_Total
  • RevisedSubcontract_Approved_Open_GrossTotal

  • PORevisedSubcontract_Approved_Open_Subtotal = [PO_Approved_Open_Subtotal] + [RevisedSubcontract_Approved_Open_Subtotal]
  • PORevisedSubcontract_Approved_Open_Total = [PO_Approved_Open_Total] + [RevisedSubcontract_Approved_Open_Total]

  • SubInvoice_Approved_GrossTotal

  • SubInvoice_Approved_Retainage
  • SubInvoice_Approved_RetainageBilled
  • SubInvoice_Approved_NetRetainage

  • SubInvoice_Approved_Subtotal
  • SubInvoice_Approved_Tax
  • SubInvoice_Approved_Total

  • SubInvoice_Pending_GrossTotal

  • SubInvoice_Pending_Retainage
  • SubInvoice_Pending_RetainageBilled
  • SubInvoice_Pending_NetRetainage

  • SubInvoice_Pending_Subtotal
  • SubInvoice_Pending_Tax
  • SubInvoice_Pending_Total

  • SubInvoice_ApprovedAndPending_GrossTotal
  • SubInvoice_ApprovedAndPending_Retainage
  • SubInvoice_ApprovedAndPending_RetainageBilled
  • SubInvoice_ApprovedAndPending_NetRetainage
  • SubInvoice_ApprovedAndPending_Subtotal
  • SubInvoice_ApprovedAndPending_Tax
  • SubInvoice_ApprovedAndPending_Total

  • MiscExpense_Approved_Subtotal
  • MiscExpense_Approved_Tax
  • MiscExpense_Approved_Total

  • MiscExpense_Pending_Subtotal
  • MiscExpense_Pending_Tax
  • MiscExpense_Pending_Total

  • MiscExpense_ApprovedAndPending_Subtotal
  • MiscExpense_ApprovedAndPending_Tax
  • MiscExpense_ApprovedAndPending_Total

  • LbrTimecard_Approved_Total
  • LbrTimecard_Approved_Total_OnBillRates (Uses Bill Rate instead of Cost Rate)
  • LbrTimecard_Pending_Total
  • LbrTimecard_ApprovedAndPending_Total = [LbrTimecard_Approved_Total] + [LbrTimecard_Pending_Total]
  • LbrTimecard_Projected_Total = [LbrTimecard_Approved_Total] / [EstimatedFieldPercentComplete]
  • LbrTimecard_Remaining_Total = [LbrTimecard_Projected_Total] - [LbrTimecard_Approved_Total]

  • EqpTimecard_Total
  • EqpTimecard_Total_OnBillRates (Uses Bill Rate instead of Cost Rate)
  • EqpTimecard_Projected_Total = [EqpTimecard_Total] / [EstimatedFieldPercentComplete]

  • AnticipatedCostRemainingLbrEqp_Total = [AnticipatedCost_Total] + [LbrTimecard_Remaining_Total] + [EqpTimecard_Remaining_Total]

  • CommittedCost_Approved_Subtotal
  • CommittedCost_Approved_Tax
  • CommittedCost_Approved_Total

  • CommittedCost_Pending_Subtotal
  • CommittedCost_Pending_Tax
  • CommittedCost_Pending_Total

  • CommittedCost_ApprovedAndPending_Subtotal = [CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]
  • CommittedCost_ApprovedAndPending_Total = [CommittedCost_Approved_Total] + [CommittedCost_Pending_Total]

  • CommittedCost_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
  • CommittedCost_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)

  • CostToDate_Approved_GrossTotal
  • CostToDate_Pending_GrossTotal

  • CostToDate_Approved_Subtotal
  • CostToDate_Approved_Tax
  • CostToDate_Approved_Total

  • CostToDate_Pending_Subtotal
  • CostToDate_Pending_Tax
  • CostToDate_Pending_Total

  • CostToDate_ApprovedAndPending_GrossTotal = [CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal]
  • CostToDate_ApprovedAndPending_Subtotal = [CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal]
  • CostToDate_ApprovedAndPending_Total = [CostToDate_Approved_Total] + [CostToDate_Pending_Total]

  • CostToDate_Approved_GrossTotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
  • CostToDate_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
  • CostToDate_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)

  • ProjectedCostAtCompletion_Total = [CostToDate_Approved_Total] + ([PORevisedSubcontract_Approved_Open_Total]) + ([AnticipatedCostRemainingLbrEqp_Total])

  • ProjectedCostToComplete_Total = [PORevisedSubcontract_Approved_Open_Total] + [AnticipatedCostRemainingLbrEqp_Total]

  • ERP_JobToDate_Cost (Latest cost information in ERP system such as Sage Intacct. Data must be populated using AccountingLink utility.)

  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_Tax
  • RevenueBudget_Revised_Total

  • RevisedCostBudget_Less_CommittedCostApprovedSubtotal = [CostBudget_Revised] - [CommittedCost_Approved_Subtotal]
  • RevisedCostBudget_Less_CommittedCostApprovedTotal = [CostBudget_Revised] - [CommittedCost_Approved_Total]

  • RevisedCostBudget_Less_CommittedCostApprovedPendingSubtotal = [CostBudget_Revised] - ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal])
  • RevisedCostBudget_Less_CommittedCostApprovedPendingTotal = [CostBudget_Revised] - ([CommittedCost_Approved_Total] + [CommittedCost_Pending_Total])

  • RevisedCostBudget_Less_CostToDateApprovedGrossTotal = [CostBudget_Revised] - [CostToDate_Approved_GrossTotal]
  • RevisedCostBudget_Less_CostToDateApprovedSubtotal = [CostBudget_Revised] - [CostToDate_Approved_Subtotal]
  • RevisedCostBudget_Less_CostToDateApprovedTotal = [CostBudget_Revised] - [CostToDate_Approved_Total]

  • RevisedCostBudget_Less_CostToDateApprovedPendingGrossTotal = [CostBudget_Revised] - ([CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal])
  • RevisedCostBudget_Less_CostToDateApprovedPendingSubtotal = [CostBudget_Revised] - ([CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal])
  • RevisedCostBudget_Less_CostToDateApprovedPendingTotal = [CostBudget_Revised] - ([CostToDate_Approved_Total] + [CostToDate_Pending_Total])

  • RevisedCostBudget_Less_ProjectedCostAtCompletion_Total = [CostBudget_Revised] - [ProjectedCostAtCompletion_Total]

  • CommittedCostApprovedSubtotal_Less_CostToDateApprovedGrossTotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_GrossTotal]
  • CommittedCostApprovedSubtotal_Less_CostToDateApprovedSubtotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_Subtotal]

  • CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingGrossTotal = ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]) - ([CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal])
  • CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingSubtotal = ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]) - ([CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal])

  • CommittedCostApprovedTotal_Less_CostToDateApprovedTotal = [CommittedCost_Approved_Total] - [CostToDate_Approved_Total]
  • CommittedCostApprovedAndPendingTotal_Less_CostToDateApprovedAndPendingTotal = ([CommittedCost_Approved_Total] + [CommittedCost_Pending_Total]) - ([CostToDate_Approved_Total] + [CostToDate_Pending_Total])

  • RevisedRevenueBudget_Less_CommittedCost_Approved_Total = [RevenueBudget_Revised_Total] - [CommittedCost_Approved_Total]
  • RevisedRevenueBudget_Less_CommittedCost_ApprovedPending_Total = [RevenueBudget_Revised_Total] - [CommittedCost_ApprovedAndPending_Total]

  • RevisedRevenueBudget_Less_CostToDate_Approved_GrossTotal = [RevenueBudget_Revised_Total] - [CostToDate_Approved_GrossTotal]
  • RevisedRevenueBudget_Less_CostToDate_Approved_Total = [RevenueBudget_Revised_Total] - [CostToDate_Approved_Total]

  • RevisedRevenueBudget_Less_CostToDate_ApprovedPending_GrossTotal = [RevenueBudget_Revised_Total] - [CostToDate_ApprovedAndPending_GrossTotal]
  • RevisedRevenueBudget_Less_CostToDate_ApprovedPending_Total = [RevenueBudget_Revised_Total] - [CostToDate_ApprovedAndPending_Total]

  • RevisedRevenueBudget_Less_ProjectedCostAtCompletion_Total = [RevenueBudget_Revised_Total] - [ProjectedCostAtCompletion_Total]

  • Percent_CommittedCostBudget_Subtotal = ([CommittedCost_Approved_Subtotal] / [CostBudget_Revised]) * 100

  • Percent_CostToDateCostBudget_Gross = ([CostToDate_Approved_GrossTotal] / [CostBudget_Revised]) * 100
  • Percent_CostToDateCostBudget_Subtotal = ([CostToDate_Approved_Subtotal] / [CostBudget_Revised]) * 100

  • Percent_CostToDateCommittedCost_Gross = ([CostToDate_Approved_GrossTotal] / [CommittedCost_Approved_Subtotal]) * 100
  • Percent_CostToDateCommittedCost_Subtotal = ([CostToDate_Approved_Subtotal] / [CommittedCost_Approved_Subtotal]) * 100

  • EstimatedFieldPercentComplete

On this page

Posted November 03, 2025 © 2025 The Sage Group plc or its affiliates ("Sage") or its licensors. All trademarks mentioned are the property of their respective owners. Use of non-Sage trademarks is not an endorsement of any person or product.