Project Financial Analytics - APIs - V1 - Change Order

API Name: CoreconAPI_ChangeOrder


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

  • ChangeOrderId
  • ChangeOrderNumber
  • ChangeOrderSubject
  • ChangeOrderIssueDateUtc
  • ChangeOrderIssueDateOrgLocal
  • ChangeOrderStatusDateUtc
  • ChangeOrderStatusDateOrgLocal

  • RevenueBudget_Subtotal
  • RevenueBudget_Tax
  • RevenueBudget_Total

  • PrimeInvoice_Approved_GrossTotal
  • PrimeInvoice_Approved_Subtotal
  • PrimeInvoice_Approved_Tax
  • PrimeInvoice_Approved_Total

  • PrimeInvoice_Pending_GrossTotal
  • PrimeInvoice_Pending_Subtotal
  • PrimeInvoice_Pending_Tax
  • PrimeInvoice_Pending_Total

  • CostBudget
  • CostBudget_M
  • CostBudget_L
  • CostBudget_E
  • CostBudget_S
  • CostBudget_O

  • CommittedCost_Approved_Subtotal
  • CommittedCost_Approved_Tax
  • CommittedCost_Approved_Total

  • CommittedCost_Approved_Subtotal_M
  • CommittedCost_Approved_Subtotal_L
  • CommittedCost_Approved_Subtotal_E
  • CommittedCost_Approved_Subtotal_S
  • CommittedCost_Approved_Subtotal_O

  • CommittedCost_Approved_Total_M
  • CommittedCost_Approved_Total_L
  • CommittedCost_Approved_Total_E
  • CommittedCost_Approved_Total_S
  • CommittedCost_Approved_Total_O

  • CommittedCost_Pending_Subtotal
  • CommittedCost_Pending_Tax
  • CommittedCost_Pending_Total

  • CommittedCost_Pending_Subtotal_M
  • CommittedCost_Pending_Subtotal_L
  • CommittedCost_Pending_Subtotal_E
  • CommittedCost_Pending_Subtotal_S
  • CommittedCost_Pending_Subtotal_O

  • CommittedCost_Pending_Total_M
  • CommittedCost_Pending_Total_L
  • CommittedCost_Pending_Total_E
  • CommittedCost_Pending_Total_S
  • CommittedCost_Pending_Total_O

  • CommittedCost_ApprovedPending_Subtotal = [CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]
  • CommittedCost_ApprovedPending_Tax = [CommittedCost_Approved_Tax] + [CommittedCost_Pending_Tax]
  • CommittedCost_ApprovedPending_Total = [CommittedCost_Approved_Total] + [CommittedCost_Pending_Total]

  • CostToDate_Approved_GrossTotal
  • CostToDate_Approved_Subtotal
  • CostToDate_Approved_Tax
  • CostToDate_Approved_Total

  • CostToDate_Approved_Subtotal_M
  • CostToDate_Approved_Subtotal_L
  • CostToDate_Approved_Subtotal_E
  • CostToDate_Approved_Subtotal_S
  • CostToDate_Approved_Subtotal_O

  • CostToDate_Approved_Total_M
  • CostToDate_Approved_Total_L
  • CostToDate_Approved_Total_E
  • CostToDate_Approved_Total_S
  • CostToDate_Approved_Total_O

  • CostToDate_Pending_GrossTotal
  • CostToDate_Pending_Subtotal
  • CostToDate_Pending_Tax
  • CostToDate_Pending_Total

  • CostToDate_Pending_Subtotal_M
  • CostToDate_Pending_Subtotal_L
  • CostToDate_Pending_Subtotal_E
  • CostToDate_Pending_Subtotal_S
  • CostToDate_Pending_Subtotal_O

  • CostToDate_Pending_Total_M
  • CostToDate_Pending_Total_L
  • CostToDate_Pending_Total_E
  • CostToDate_Pending_Total_S
  • CostToDate_Pending_Total_O

  • CostToDate_ApprovedPending_GrossTotal = [CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal]
  • CostToDate_ApprovedPending_Subtotal = [CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal]
  • CostToDate_ApprovedPending_Tax = [CostToDate_Approved_Tax] + [CostToDate_Pending_Tax]
  • CostToDate_ApprovedPending_Total = [CostToDate_Approved_Total] + [CostToDate_Pending_Total]

  • CashFlow_Approved_Gross = [PrimeInvoice_Approved_GrossTotal] - [CostToDate_Approved_GrossTotal]
  • CashFlow_Approved_Total = [PrimeInvoice_Approved_Total] - [CostToDate_Approved_Total]

  • Percent_Invoiced_Gross = ([PrimeInvoice_Approved_GrossTotal] / [RevenueBudget_Subtotal]) * 100
  • Percent_Invoiced_Subtotal = ([PrimeInvoice_Approved_Subtotal] / [RevenueBudget_Subtotal]) * 100

  • Percent_Profit_Margin_Total = ([CashFlow_Approved_Total] / [RevenueBudget_Total]) * 100

  • HourBudget_L
  • LbrTimecard_Approved_Hours
  • LbrTimecard_Pending_Hours

  • Percent_HourBudget_L = ([LbrTimecard_Approved_Hours] / [HourBudget_L]) * 100

  • HourBudget_E
  • EqpTimecard_Hours

  • Percent_HourBudget_E = ([EqpTimecard_Hours] / [HourBudget_E]) * 100

In this topic

Posted March 27, 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.