Project Financial Analytics - APIs - V1 - Revenue

API Name: CoreconAPI_Revenue


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

  • RevenueBudget_Prime_Subtotal
  • RevenueBudget_Prime_Tax
  • RevenueBudget_Prime_Total

  • RevenueBudget_ApprovedCOs_Subtotal
  • RevenueBudget_ApprovedCOs_Tax
  • RevenueBudget_ApprovedCOs_Total

  • RevenueBudget_PendingCOs_Subtotal
  • RevenueBudget_PendingCOs_Tax
  • RevenueBudget_PendingCOs_Total

  • RevenueBudget_Revised_Subtotal
  • RevenueBudget_Revised_Tax
  • RevenueBudget_Revised_Total

  • RevenueBudget_ApprovedCPRs_Subtotal
  • RevenueBudget_ApprovedCPRs_Tax
  • RevenueBudget_ApprovedCPRs_Total

  • RevenueBudget_PendingCPRs_Subtotal
  • RevenueBudget_PendingCPRs_Tax
  • RevenueBudget_PendingCPRs_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

  • RevenueBudgetPrimeInvoiceVariance_Approved_Gross = [RevenueBudget_Revised_Subtotal] - [PrimeInvoice_Approved_GrossTotal]
  • RevenueBudgetPrimeInvoiceVariance_Approved_Total = [RevenueBudget_Revised_Total] - [PrimeInvoice_Approved_Total]

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

  • EstimatedFieldPercentComplete