Cost API V1

API Name: CoreconAPI_Cost

The job cost code, internal grouping, and owner code fields will be blank when multiple 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

    Is equal to the prime material cost budget (CostBudget_Prime_M) plus the approved change order material cost budget (CostBudget_ApprovedCOs_M).

  • CostBudget_Revised_L

    Is equal to the prime labor cost budget (CostBudget_Prime_L) plus the approved change order labor cost budget (CostBudget_ApprovedCOs_L).

  • CostBudget_Revised_E

    Is equal to the prime equipment cost budget (CostBudget_Prime_E) plus the approved change order equipment cost budget (CostBudget_ApprovedCOs_E).

  • CostBudget_Revised_S

    Is equal to the prime subcontract cost budget (CostBudget_Prime_S) plus the approved change order subcontract cost budget (CostBudget_ApprovedCOs_S).

  • CostBudget_Revised_O

    Is equal to the prime other cost budget (CostBudget_Prime_O) plus the approved change order other cost budget (CostBudget_ApprovedCOs_O).

  • CostBudget_Revised

    Is equal to the prime cost budget (CostBudget_Prime) plus the approved change order cost budget (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

    Is equal to the approved open purchase order subtotal (PO_Approved_Open_Subtotal) plus the revised approved open subcontract subtotal (RevisedSubcontract_Approved_Open_Subtotal).

  • PORevisedSubcontract_Approved_Open_Total

    Is equal to the approved open purchase order total (PO_Approved_Open_Total) plus the revised approved open subcontract 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

    The bill rate is used instead of the cost rate.

  • LbrTimecard_Pending_Total
  • LbrTimecard_ApprovedAndPending_Total

    Is equal to the total approved labor timecard amount (LbrTimecard_Approved_Total) plus the pending labor timecard amount (LbrTimecard_Pending_Total).

  • LbrTimecard_Projected_Total

    Is equal to the approved labor timecard total (LbrTimecard_Approved_Total) divided by the estimated field percent complete (EstimatedFieldPercentComplete).

  • LbrTimecard_Remaining_Total

    Is equal to the projected labor timecard total (LbrTimecard_Projected_Total) minus the approved labor timecard total (LbrTimecard_Approved_Total).

  • EqpTimecard_Total
  • EqpTimecard_Total_OnBillRates

    The bill rate is used instead of the cost rate.

  • EqpTimecard_Projected_Total

    Is equal to the total equipment timecard amount (EqpTimecard_Total) divided by the estimated field percent complete (EstimatedFieldPercentComplete).

  • AnticipatedCostRemainingLbrEqp_Total

    Is equal to the total anticipated cost (AnticipatedCost_Total) plus remaining labor timecard total (LbrTimecard_Remaining_Total) and remaining equipment timecard 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

    Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) plus the pending committed cost subtotal (CommittedCost_Pending_Subtotal).

  • CommittedCost_ApprovedAndPending_Total

    Is equal to the approved committed cost total (CommittedCost_Approved_Total) plus the pending committed cost total (CommittedCost_Pending_Total).

  • CommittedCost_Approved_Subtotal_OnBillRates

    The labor and equipment timecard bill rate is used instead of the cost rate.

  • CommittedCost_Approved_Total_OnBillRates

    The labor and equipment timecard bill rate is used instead of the 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

    Is equal to the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) plus the pending cost-to-date gross total (CostToDate_Pending_GrossTotal).

  • CostToDate_ApprovedAndPending_Subtotal

    Is equal to the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) plus the pending cost-to-date subtotal (CostToDate_Pending_Subtotal).

  • CostToDate_ApprovedAndPending_Total

    Is equal to the approved cost-to-date total (CostToDate_Approved_Total) plus the pending cost-to-date total (CostToDate_Pending_Total).

  • CostToDate_Approved_GrossTotal_OnBillRates

    The labor and equipment timecard bill rate is used instead of the cost rate.

  • CostToDate_Approved_Subtotal_OnBillRates

    The labor and equipment timecard bill rate is used instead of the cost rate.

  • CostToDate_Approved_Total_OnBillRates

    The labor and equipment timecard bill rate is used instead of the cost rate.

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

    Displays the most recent cost information from the ERP system, such as Sage Intacct, retrieved through the AccountingLink.

  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_Tax
  • RevenueBudget_Revised_Total
  • RevisedCostBudget_Less_CommittedCostApprovedSubtotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the approved committed cost subtotal (CommittedCost_Approved_Subtotal).

  • RevisedCostBudget_Less_CommittedCostApprovedTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the approved committed cost total (CommittedCost_Approved_Total).

  • RevisedCostBudget_Less_CommittedCostApprovedPendingSubtotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the sum of the approved committed cost subtotal (CommittedCost_Approved_Subtotal) and the pending committed cost subtotal (CommittedCost_Pending_Subtotal).

  • RevisedCostBudget_Less_CommittedCostApprovedPendingTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the sum of the approved committed cost total (CommittedCost_Approved_Total) and the pending committed cost total (CommittedCost_Pending_Total).

  • RevisedCostBudget_Less_CostToDateApprovedGrossTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost to date gross total (CostToDate_Approved_GrossTotal).

  • RevisedCostBudget_Less_CostToDateApprovedSubtotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost to date subtotal (CostToDate_Approved_Subtotal).

  • RevisedCostBudget_Less_CostToDateApprovedTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost to date total (CostToDate_Approved_Total).

  • RevisedCostBudget_Less_CostToDateApprovedPendingGrossTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the sum of the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) and the pending cost-to-date gross total (CostToDate_Pending_GrossTotal).

  • RevisedCostBudget_Less_CostToDateApprovedPendingSubtotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the sum of the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) and the pending cost-to-date subtotal (CostToDate_Pending_Subtotal).

  • RevisedCostBudget_Less_CostToDateApprovedPendingTotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the sum of the approved cost-to-date total (CostToDate_Approved_Total) and the pending cost-to-date total (CostToDate_Pending_Total).

  • RevisedCostBudget_Less_ProjectedCostAtCompletion_Total

    Is equal to the revised cost budget (CostBudget_Revised) minus the total projected cost at completion (ProjectedCostAtCompletion_Total).

  • CommittedCostApprovedSubtotal_Less_CostToDateApprovedGrossTotal

    Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) minus the approved cost-to-date gross total (CostToDate_Approved_GrossTotal).

  • CommittedCostApprovedSubtotal_Less_CostToDateApprovedSubtotal

    Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) minus the approved cost-to-date subtotal (CostToDate_Approved_Subtotal).

  • CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingGrossTotal

    Is equal to the sum of the approved committed cost subtotal (CommittedCost_Approved_Subtotal) and the pending committed cost subtotal (CommittedCost_Pending_Subtotal) minus the sum of the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) and the pending cost-to-date gross total (CostToDate_Pending_GrossTotal).

  • CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingSubtotal

    Is equal to the sum of the approved committed cost subtotal (CommittedCost_Approved_Subtotal) and the pending committed cost subtotal (CommittedCost_Pending_Subtotal) minus the sum of the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) and the pending cost-to-date subtotal (CostToDate_Pending_Subtotal).

  • CommittedCostApprovedTotal_Less_CostToDateApprovedTotal

    Is equal to the approved committed cost total (CommittedCost_Approved_Total) minus the approved cost-to-date total (CostToDate_Approved_Total).

  • CommittedCostApprovedAndPendingTotal_Less_CostToDateApprovedAndPendingTotal

    Is equal to the sum of the approved committed cost total (CommittedCost_Approved_Total) and the pending committed cost total (CommittedCost_Pending_Total) minus the sum of the approved cost-to-date total (CostToDate_Approved_Total) and the pending cost-to-date total (CostToDate_Pending_Total).

  • RevisedRevenueBudget_Less_CommittedCost_Approved_Total

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved committed cost total (CommittedCost_Approved_Total).

  • RevisedRevenueBudget_Less_CommittedCost_ApprovedPending_Total

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved and pending committed cost total (CommittedCost_ApprovedAndPending_Total).

  • RevisedRevenueBudget_Less_CostToDate_Approved_GrossTotal

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved cost-to-date gross total (CostToDate_Approved_GrossTotal).

  • RevisedRevenueBudget_Less_CostToDate_Approved_Total = [RevenueBudget_Revised_Total] - []

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved cost-to-date total (CostToDate_Approved_Total).

  • RevisedRevenueBudget_Less_CostToDate_ApprovedPending_GrossTotal

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved and pending cost-to-date gross total (CostToDate_ApprovedAndPending_GrossTotal).

  • RevisedRevenueBudget_Less_CostToDate_ApprovedPending_Total

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the approved and pending cost-to-date total (CostToDate_ApprovedAndPending_Total).

  • RevisedRevenueBudget_Less_ProjectedCostAtCompletion_Total

    Is equal to the revised total revenue budget (RevenueBudget_Revised_Total) minus the projected cost at completion total (ProjectedCostAtCompletion_Total).

  • Percent_CommittedCostBudget_Subtotal

    Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) divided by the revised cost budget (CostBudget_Revised), multiplied by 100.

  • Percent_CostToDateCostBudget_Gross

    Is equal to the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) divided by the revised cost budget (CostBudget_Revised), multiplied by 100.

  • Percent_CostToDateCostBudget_Subtotal

    Is equal to the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) divided by the revised cost budget (CostBudget_Revised), multiplied by 100.

  • Percent_CostToDateCommittedCost_Gross

    Is equal to the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) divided by the approved committed cost subtotal (CommittedCost_Approved_Subtotal), multiplied by 100.

  • Percent_CostToDateCommittedCost_Subtotal

    Is equal to the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) divided by the approved committed cost subtotal (CommittedCost_Approved_Subtotal), multiplied by 100.

  • EstimatedFieldPercentComplete

On this page

Posted March 17, 2026 © 2026 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.