Overview detailed simple API V1

API Name: CoreconAPI_OverviewDetailsSimple

Similar to the Overview detailed API, without pending transaction totals or tax.

The job cost code, internal grouping, and owner code fields will be blank when multiple projects are selected.
  • ProjectNumber
  • ProjectTitle
  • ProjectPMContactName
  • ProjectBidContactName
  • ProjectSalesContactName
  • PrimeContractNumber
  • PrimeContractSubject
  • OwnerCompanyName
  • OwnerContactName
  • ContractorCompanyName
  • ContractorContactName
  • PrimeContractIssueDateUtc
  • PrimeContractIssueDateOrgLocal
  • PrimeContractApprovalDateUtc
  • PrimeContractApprovalDateOrgLocal
  • PrimeContractEstStartDateUtc
  • PrimeContractEstStartDateOrgLocal
  • PrimeContractEstFinishDateUtc
  • PrimeContractEstFinishDateOrgLocal
  • PrimeContractBillingType
  • PrimeContractBillingTypeValue
  • PrimeContractStatus
  • JobCostCodeId
  • JobCostCodeOrderNumber
  • JobCostCode
  • JobCostCodeDescription
  • JobCostCodeQuantity
  • JobCostCodeUnit
  • JobCostCodeInternalDivision
  • JobCostCodeInternalDivisionDesc
  • JobCostCodeInternalMajor
  • JobCostCodeInternalMajorDesc
  • JobCostCodeInternalMinor
  • JobCostCodeInternalMinorDesc
  • JobCostCodeInternalSubMinor
  • JobCostCodeInternalSubMinorDesc
  • OwnerCostCode
  • OwnerCostCodeDescription
  • CostBudget_Prime
  • CostBudget_ApprovedCOs
  • CostBudget_Revised
  • CostBudget_PendingCOs
  • CostBudget_ApprovedAndPendingCOs
  • CostBudget_ApprovedCPRs
  • CostBudget_PendingCPRs
  • PO_Approved_Subtotal
  • PO_Approved_Total
  • PO_Pending_Subtotal
  • PO_Pending_Total
  • PO_ApprovedAndPending_Subtotal
  • PO_ApprovedAndPending_Total
  • Bill_Approved_Subtotal
  • Bill_Approved_Total
  • Bill_Pending_Subtotal
  • Bill_Pending_Total
  • Bill_ApprovedAndPending_Subtotal
  • Bill_ApprovedAndPending_Total
  • Bill_NoPO_Approved_Subtotal
  • Bill_NoPO_Approved_Total
  • Bill_NoPO_Pending_Subtotal
  • Bill_NoPO_Pending_Total
  • Bill_NoPO_ApprovedAndPending_Subtotal
  • Bill_NoPO_ApprovedAndPending_Total
  • PO_Approved_Open_Subtotal
  • PO_Approved_Open_Total
  • Subcontract_Approved_Subtotal
  • Subcontract_Approved_Total
  • Subcontract_Pending_Subtotal
  • Subcontract_Pending_Total
  • Subcontract_ApprovedAndPending_Subtotal
  • Subcontract_ApprovedAndPending_Total
  • SCO_Approved_Subtotal
  • SCO_Approved_Total
  • SCO_Pending_Subtotal
  • SCO_Pending_Total
  • SCO_ApprovedAndPending_Subtotal
  • SCO_ApprovedAndPending_Total
  • RevisedSubcontract_Approved_Subtotal
  • RevisedSubcontract_Approved_Total
  • SubInvoice_Approved_GrossTotal
  • SubInvoice_Approved_Subtotal
  • SubInvoice_Approved_Total
  • SubInvoice_Approved_NetRetainage
  • SubInvoice_Pending_GrossTotal
  • SubInvoice_Pending_Subtotal
  • SubInvoice_Pending_Total
  • SubInvoice_Pending_NetRetainage
  • SubInvoice_ApprovedAndPending_GrossTotal
  • SubInvoice_ApprovedAndPending_Subtotal
  • SubInvoice_ApprovedAndPending_Total
  • SubInvoice_ApprovedAndPending_NetRetainage
  • RevisedSubcontract_Approved_Open_GrossTotal
  • RevisedSubcontract_Approved_Open_Subtotal
  • RevisedSubcontract_Approved_Open_Total
  • MiscExpense_Approved_Subtotal
  • MiscExpense_Approved_Total
  • MiscExpense_Pending_Subtotal
  • MiscExpense_Pending_Total
  • MiscExpense_ApprovedAndPending_Subtotal
  • MiscExpense_ApprovedAndPending_Total
  • LbrTimecard_Approved_Total
  • LbrTimecard_Approved_Total_OnBillRates
  • LbrTimecard_Pending_Total
  • LbrTimecard_ApprovedAndPending_Total
  • EqpTimecard_Total
  • EqpTimecard_Total_OnBillRates
  • AnticipatedCost_Total
  • CommittedCost_Approved_Subtotal
  • CommittedCost_Approved_Subtotal_OnBillRates
  • CommittedCost_Approved_Total
  • CommittedCost_Approved_Total_OnBillRates
  • CommittedCost_Pending_Subtotal
  • CommittedCost_Pending_Total
  • CommittedCost_ApprovedAndPending_Subtotal
  • CommittedCost_ApprovedAndPending_Total
  • CostToDate_Approved_GrossTotal
  • CostToDate_Approved_GrossTotal_OnBillRates
  • CostToDate_Approved_Subtotal
  • CostToDate_Approved_Subtotal_OnBillRates
  • CostToDate_Approved_Total
  • CostToDate_Approved_Total_OnBillRates
  • CostToDate_Pending_GrossTotal
  • CostToDate_Pending_Subtotal
  • CostToDate_Pending_Total
  • CostToDate_ApprovedAndPending_GrossTotal
  • CostToDate_ApprovedAndPending_Subtotal
  • CostToDate_ApprovedAndPending_Total
  • 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).

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

  • ERP_JobToDate_Cost

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

  • RevenueBudget_Prime_Subtotal
  • RevenueBudget_Prime_Total
  • RevenueBudget_ApprovedCOs_Subtotal
  • RevenueBudget_ApprovedCOs_Total
  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_Total
  • RevenueBudget_PendingCOs_Subtotal
  • RevenueBudget_PendingCOs_Total
  • RevenueBudget_ApprovedAndPendingCOs_Total
  • RevenueBudget_ApprovedCPRs_Subtotal
  • RevenueBudget_ApprovedCPRs_Total
  • RevenueBudget_PendingCPRs_Subtotal
  • RevenueBudget_PendingCPRs_Total
  • RevenueBudget_ApprovedAndPendingCPRs_Total
  • PrimeInvoice_Approved_GrossTotal
  • PrimeInvoice_Approved_Subtotal
  • PrimeInvoice_Approved_Total
  • PrimeInvoice_Approved_NetRetainage
  • PrimeInvoice_Pending_GrossTotal
  • PrimeInvoice_Pending_Subtotal
  • PrimeInvoice_Pending_Total
  • PrimeInvoice_Pending_NetRetainage
  • 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

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

  • 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

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

  • RevenueCostToDateVariance_Approved_Total

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

  • RevenueCostToDateVariance_Approved_Total_OnBillRates

    Is equal to the revised revenue budget total (RevenueBudget_Revised_Total) minus the approved cost-to-date total on bill rates (CostToDate_Approved_Total_OnBillRates).

  • 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_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_Subtotal

    Is equal to the approved prime invoice subtotal (PrimeInvoice_Approved_Subtotal) minus the approved cost-to-date subtotal (CostToDate_Approved_Subtotal).

  • CashFlow_Approved_Total

    Is equal to the approved prime invoice total (PrimeInvoice_Approved_Total) minus the approved cost-to-date total (CostToDate_Approved_Total).

  • 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
  • HourBudget_PendingCOs_L
  • HourBudget_ApprovedCPRs_L
  • HourBudget_PendingCPRs_L
  • LbrTimecard_Approved_Hours
  • LbrTimecard_Pending_Hours
  • LbrTimecard_ApprovedAndPending_Hours
  • Projected_Hours_L
  • LbrTimecard_Projected_Total
  • 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
  • HourBudget_PendingCOs_E
  • HourBudget_ApprovedCPRs_E
  • HourBudget_PendingCPRs_E
  • EqpTimecard_Hours
  • Projected_Hours_E
  • EqpTimecard_Projected_Total
  • 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.