Overview API V1

API Name: CoreconAPI_Overview

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
  • ProjectAndPrimeNumber

    Combines the ProjectNumber and PrimeContractNumber into a single formatted string, trimming extra whitespace. For example, Project # 123 | Prime # ABC.

  • 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
  • RevenueBudget_Prime_Subtotal
  • RevenueBudget_Prime_Tax
  • RevenueBudget_Prime_Total
  • RevenueBudget_ApprovedCOs_Subtotal
  • RevenueBudget_ApprovedCOs_Tax
  • RevenueBudget_ApprovedCOs_Total
  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_Tax
  • RevenueBudget_Revised_Total
  • PrimeInvoice_Approved_GrossTotal_NoCORef
  • PrimeInvoice_Approved_GrossTotal_WithCORef
  • PrimeInvoice_Approved_GrossTotal
  • PrimeInvoice_Approved_Retainage
  • PrimeInvoice_Approved_RetainageBilled
  • PrimeInvoice_Approved_NetRetainage
  • PrimeInvoice_Approved_Subtotal
  • PrimeInvoice_Approved_Tax
  • PrimeInvoice_Approved_Total
  • PrimeInvoice_Pending_GrossTotal_NoCORef
  • PrimeInvoice_Pending_GrossTotal_WithCORef
  • PrimeInvoice_Pending_GrossTotal
  • PrimeInvoice_Pending_Retainage
  • PrimeInvoice_Pending_RetainageBilled
  • PrimeInvoice_Pending_NetRetainage
  • PrimeInvoice_Pending_Subtotal
  • PrimeInvoice_Pending_Tax
  • PrimeInvoice_Pending_Total
  • CostBudget_Prime
  • CostBudget_ApprovedCOs
  • CostBudget_Revised
  • CommittedCost_Approved_Subtotal_NoCORef
  • CommittedCost_Approved_Tax_NoCORef
  • CommittedCost_Approved_Total_NoCORef
  • CommittedCost_Approved_Subtotal_WithCORef
  • CommittedCost_Approved_Tax_WithCORef
  • CommittedCost_Approved_Total_WithCORef
  • CommittedCost_Approved_Subtotal
  • CommittedCost_Approved_Tax
  • CommittedCost_Approved_Total
  • CommittedCost_Approved_Subtotal_OnBillRates
  • CommittedCost_Approved_Total_OnBillRates
  • CostToDate_Approved_GrossTotal_NoCORef
  • CostToDate_Approved_GrossTotal_WithCORef
  • CostToDate_Approved_GrossTotal
  • CostToDate_Approved_GrossTotal_OnBillRates
  • CostToDate_Approved_Subtotal_NoCORef
  • CostToDate_Approved_Tax_NoCORef
  • CostToDate_Approved_Total_NoCORef
  • CostToDate_Approved_Subtotal_WithCORef
  • CostToDate_Approved_Tax_WithCORef
  • CostToDate_Approved_Total_WithCORef
  • CostToDate_Approved_Subtotal
  • CostToDate_Approved_Tax
  • CostToDate_Approved_Total
  • CostToDate_Approved_Subtotal_OnBillRates
  • CostToDate_Approved_Total_OnBillRates
  • ERP_JobToDate_Cost

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

  • CostBudgetCommittedVariance_Revised_Subtotal

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

  • CostBudgetCommittedVariance_Revised_Total

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

  • CostBudgetCostToDateVariance_Revised_Subtotal

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

  • CostBudgetCostToDateVariance_Revised_Total

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

  • CommittedCostToDateVariance_Approved_Subtotal

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

  • CommittedCostToDateVariance_Approved_Total

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

  • CostBudgetContractVariance_Prime_Subtotal

    Is equal to the prime cost budget (CostBudget_Prime) minus the prime revenue budget subtotal (RevenueBudget_Prime_Subtotal).

  • CostBudgetContractVariance_ApprovedCO_Subtotal

    Is equal to the approved COs cost budget (CostBudget_ApprovedCOs) minus the approved COs revenue budget subtotal (RevenueBudget_ApprovedCOs_Subtotal).

  • CostBudgetContractVariance_Revised_Subtotal

    Is equal to the revised cost budget (CostBudget_Revised) minus the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal).

  • CostBudgetContractVariance_Prime_Total

    Is equal to the prime cost budget (CostBudget_Prime) minus the prime revenue budget total (RevenueBudget_Prime_Total).

  • CostBudgetContractVariance_ApprovedCO_Total

    Is equal to the approved COs cost budget (CostBudget_ApprovedCOs) minus the approved COs revenue budget total (RevenueBudget_ApprovedCOs_Total).

  • CostBudgetContractVariance_Revised_Total

    Is equal to the revised cost budget (CostBudget_Revised) minus the revised revenue budget total (RevenueBudget_Revised_Total).

  • RevenueCostBudgetVariance_Prime_Subtotal

    Is equal to the prime revenue budget (RevenueBudget_Prime_Subtotal) minus the prime cost budget (CostBudget_Prime).

  • RevenueCostBudgetVariance_ApprovedCO_Subtotal

    Is equal to the approved COs revenue budget subtotal (RevenueBudget_ApprovedCOs_Subtotal) minus the approved COs cost budget (CostBudget_ApprovedCOs).

  • RevenueCostBudgetVariance_Revised_Subtotal

    Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) minus the revised cost budget (CostBudget_Revised).

  • RevenueCostBudgetVariance_Prime_Total

    Is equal to the total prime revenue budget (RevenueBudget_Prime_Total) minus the prime cost budget (CostBudget_Prime).

  • RevenueCostBudgetVariance_ApprovedCO_Total

    Is equal to the total approved COs revenue budget (RevenueBudget_ApprovedCOs_Total) minus the approved COs cost budget (CostBudget_ApprovedCOs).

  • RevenueCostBudgetVariance_Revised_Total

    Is equal to the total revised revenue budget (RevenueBudget_Revised_Total) minus the revised cost budget (CostBudget_Revised).

  • RevenueCommittedCostVariance_Approved_Subtotal_NoCORef

    Is equal to the prime revenue budget subtotal (RevenueBudget_Prime_Subtotal) minus the approved committed costs without change order references (CommittedCost_Approved_Subtotal_NoCORef).

  • RevenueCommittedCostVariance_Approved_Subtotal_WithCORef

    Is equal to the approved COs revenue budget subtotal (RevenueBudget_ApprovedCOs_Subtotal) minus the approved committed costs with change order references (CommittedCost_Approved_Subtotal_WithCORef).

  • RevenueCommittedCostVariance_Approved_Subtotal

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

  • RevenueCommittedCostVariance_Approved_Total_NoCORef

    Is equal to the prime revenue budget total (RevenueBudget_Prime_Total) minus the approved committed costs without change order references (CommittedCost_Approved_Total_NoCORef).

  • RevenueCommittedCostVariance_Approved_Total_WithCORef

    Is equal to the approved COs revenue budget total (RevenueBudget_ApprovedCOs_Total) minus the approved committed costs with change order references (CommittedCost_Approved_Total_WithCORef).

  • RevenueCommittedCostVariance_Approved_Total

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

  • RevenueCostToDateVariance_Approved_Subtotal_NoCORef

    Is equal to the prime revenue budget subtotal (RevenueBudget_Prime_Subtotal) minus the approved cost-to-date without change order references (CostToDate_Approved_Subtotal_NoCORef).

  • RevenueCostToDateVariance_Approved_Subtotal_WithCORef

    Is equal to the approved COs revenue budget subtotal (RevenueBudget_ApprovedCOs_Subtotal) minus the approved cost-to-date with change order references (CostToDate_Approved_Subtotal_WithCORef).

  • RevenueCostToDateVariance_Approved_Subtotal

    Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) minus the approved cost-to-date subtotal (CostToDate_Approved_Subtotal).

  • RevenueCostToDateVariance_Approved_Total_NoCORef

    Is equal to the prime revenue budget total (RevenueBudget_Prime_Total) minus the approved cost-to-date without change order references (CostToDate_Approved_Total_NoCORef).

  • RevenueCostToDateVariance_Approved_Total_WithCORef

    Is equal to the approved COs revenue budget total (RevenueBudget_ApprovedCOs_Total) minus the approved cost-to-date with change order references (CostToDate_Approved_Total_WithCORef).

  • RevenueCostToDateVariance_Approved_Total

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

  • RevenueBudgetPrimeInvoiceVariance_Approved_Gross

    Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) minus the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal).

  • RevenueBudgetPrimeInvoiceVariance_Approved_Total

    Is equal to the revised revenue budget total (RevenueBudget_Revised_Total) minus the approved prime invoice total (PrimeInvoice_Approved_Total).

  • CashFlow_Gross_NoCORef_Total

    Is equal to the approved prime invoice gross total withour change order references (PrimeInvoice_Approved_GrossTotal_NoCORef) minus the approved cost-to-date gross total without change order references (CostToDate_Approved_GrossTotal_NoCORef).

  • CashFlow_Gross_WithCORef_Total

    Is equal to the approved prime invoice gross total with change order references (PrimeInvoice_Approved_GrossTotal_WithCORef) minus the approved cost-to-date gross total with change order references (CostToDate_Approved_GrossTotal_WithCORef).

  • CashFlow_Gross_Total

    Is equal to the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) minus the approved cost-to-date gross total (CostToDate_Approved_GrossTotal).

  • CashFlow_Approved_Total

    Is equal to the approved prime invoice gross total (PrimeInvoice_Approved_Total) minus the approved cost-to-date total (CostToDate_Approved_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 to calculate a percentage.

  • 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 to calculate a percentage.

  • 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 to calculate a percentage.

  • 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 to calculate a percentage.

  • 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 to calculate a percentage.

  • Percent_Invoiced_Gross

    Is equal to the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) divided by the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal), multiplied by 100 to calculate a percentage.

  • Percent_Invoiced_Subtotal

    Is equal to the approved prime invoice subtotal (PrimeInvoice_Approved_Subtotal) divided by the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal), multiplied by 100 to calculate a percentage.

  • Percent_Profit_Margin_Total

    Is equal to the approved total cash flow (CashFlow_Approved_Total) divided by the revised total revenue budget (RevenueBudget_Revised_Total), multiplied by 100 to calculate a percentage.

  • 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_Projected_Total
  • Projected_Hours_L
  • HourBudget_Remaining_Prime_L

    Is equal to the prime labor hour budget (HourBudget_Prime_L) minus the approved labor timecard hours without change order references (LbrTimecard_Approved_Hours_NoCORef).

  • HourBudget_Remaining_ApprovedCOs_L

    Is equal to the approved COs labor hour budget (HourBudget_ApprovedCOs_L) minus the approved labor timecard hours with change order references (LbrTimecard_Approved_Hours_WithCORef).

  • HourBudget_Remaining_L

    Is equal to the revised labor hour budget (HourBudget_Revised_L) minus the approved labor timecard hours (LbrTimecard_Approved_Hours).

  • Percent_HourBudget_L

    Is equal to the approved labor timecard hours (LbrTimecard_Approved_Hours) divided by the revised labor hour budget (HourBudget_Revised_L), multiplied by 100 to calculate a percentage.

  • HourBudget_Prime_E
  • HourBudget_ApprovedCOs_E
  • HourBudget_Revised_E
  • EqpTimecard_Hours_NoCORef
  • EqpTimecard_Hours_WithCORef
  • EqpTimecard_Hours
  • EqpTimecard_Projected_Total
  • Projected_Hours_E
  • HourBudget_Remaining_Prime_E

    Is equal to the prime equipment hour budget (HourBudget_Prime_E) minus the approved equipment timecard hours without change order references (EqpTimecard_Hours_NoCORef).

  • HourBudget_Remaining_ApprovedCOs_E

    Is equal to the approved COs equipment hour budget (HourBudget_ApprovedCOs_E) minus the approved equipment timecard hours with change order references (EqpTimecard_Hours_WithCORef).

  • HourBudget_Remaining_E

    Is equal to the revised equipment hour budget (HourBudget_Revised_E) minus the equipment timecard hours (EqpTimecard_Hours).

  • Percent_HourBudget_E

    Is equal to the equipment timecard hours (EqpTimecard_Hours) divided by the revised equipment hour budget (HourBudget_Revised_E), multiplied by 100 to calculate a percentage.

  • 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.