Overview detailed API V1

API Name: CoreconAPI_OverviewDetails

Similar to the Overview API, with added resource and pending transaction totals.

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
  • 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
  • RevenueBudget_PendingCOs_Subtotal
  • RevenueBudget_PendingCOs_Tax
  • RevenueBudget_PendingCOs_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
  • PrimeInvoice_ApprovedAndPending_GrossTotal_NoCORef
  • PrimeInvoice_ApprovedAndPending_GrossTotal_WithCORef
  • PrimeInvoice_ApprovedAndPending_GrossTotal
  • PrimeInvoice_ApprovedAndPending_Retainage
  • PrimeInvoice_ApprovedAndPending_RetainageBilled
  • PrimeInvoice_ApprovedAndPending_NetRetainage
  • PrimeInvoice_ApprovedAndPending_Subtotal
  • PrimeInvoice_ApprovedAndPending_Tax
  • PrimeInvoice_ApprovedAndPending_Total
  • 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_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 othe 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_PendingCOs
  • CostBudget_ApprovedCPRs
  • CostBudget_PendingCPRs
  • CommittedCost_Approved_Subtotal_M
  • CommittedCost_Approved_Subtotal_L
  • CommittedCost_Approved_Subtotal_E
  • CommittedCost_Approved_Subtotal_S
  • CommittedCost_Approved_Subtotal_O
  • CommittedCost_Approved_Subtotal_NoCORef
  • CommittedCost_Approved_Subtotal_WithCORef
  • CommittedCost_Approved_Subtotal
  • CommittedCost_Approved_Tax_NoCORef
  • CommittedCost_Approved_Tax_WithCORef
  • CommittedCost_Approved_Tax
  • CommittedCost_Approved_Total_M
  • CommittedCost_Approved_Total_L
  • CommittedCost_Approved_Total_E
  • CommittedCost_Approved_Total_S
  • CommittedCost_Approved_Total_O
  • CommittedCost_Approved_Total_NoCORef
  • CommittedCost_Approved_Total_WithCORef
  • CommittedCost_Approved_Total
  • CommittedCost_Pending_Subtotal_M
  • CommittedCost_Pending_Subtotal_L
  • CommittedCost_Pending_Subtotal_E
  • CommittedCost_Pending_Subtotal_S
  • CommittedCost_Pending_Subtotal_O
  • CommittedCost_Pending_Subtotal
  • CommittedCost_Pending_Total_M
  • CommittedCost_Pending_Total_L
  • CommittedCost_Pending_Total_E
  • CommittedCost_Pending_Total_S
  • CommittedCost_Pending_Total_O
  • CommittedCost_Pending_Total
  • CommittedCost_ApprovedAndPending_Subtotal_M
  • CommittedCost_ApprovedAndPending_Subtotal_L
  • CommittedCost_ApprovedAndPending_Subtotal_E
  • CommittedCost_ApprovedAndPending_Subtotal_S
  • CommittedCost_ApprovedAndPending_Subtotal_O
  • CommittedCost_ApprovedAndPending_Subtotal
  • CommittedCost_ApprovedAndPending_Total_M
  • CommittedCost_ApprovedAndPending_Total_L
  • CommittedCost_ApprovedAndPending_Total_E
  • CommittedCost_ApprovedAndPending_Total_S
  • CommittedCost_ApprovedAndPending_Total_O
  • CommittedCost_ApprovedAndPending_Total
  • CostToDate_Approved_Subtotal_M
  • CostToDate_Approved_Subtotal_L
  • CostToDate_Approved_Subtotal_E
  • CostToDate_Approved_Subtotal_S
  • CostToDate_Approved_Subtotal_O
  • CostToDate_Approved_Subtotal_NoCORef
  • CostToDate_Approved_Subtotal_WithCORef
  • CostToDate_Approved_Subtotal
  • CostToDate_Approved_Tax_NoCORef
  • CostToDate_Approved_Tax_WithCORef
  • CostToDate_Approved_Tax
  • CostToDate_Approved_Total_M
  • CostToDate_Approved_Total_L
  • CostToDate_Approved_Total_E
  • CostToDate_Approved_Total_S
  • CostToDate_Approved_Total_O
  • CostToDate_Approved_Total_NoCORef
  • CostToDate_Approved_Total_WithCORef
  • CostToDate_Approved_Total
  • CostToDate_Approved_GrossTotal_NoCORef
  • CostToDate_Approved_GrossTotal_WithCORef
  • CostToDate_Approved_GrossTotal
  • 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_Pending_Total
  • CostToDate_Pending_GrossTotal_NoCORef
  • CostToDate_Pending_GrossTotal_WithCORef
  • CostToDate_Pending_GrossTotal
  • CostToDate_ApprovedAndPending_Subtotal_M
  • CostToDate_ApprovedAndPending_Subtotal_L
  • CostToDate_ApprovedAndPending_Subtotal_E
  • CostToDate_ApprovedAndPending_Subtotal_S
  • CostToDate_ApprovedAndPending_Subtotal_O
  • CostToDate_ApprovedAndPending_Subtotal
  • CostToDate_ApprovedAndPending_Total_M
  • CostToDate_ApprovedAndPending_Total_L
  • CostToDate_ApprovedAndPending_Total_E
  • CostToDate_ApprovedAndPending_Total_S
  • CostToDate_ApprovedAndPending_Total_O
  • CostToDate_ApprovedAndPending_Total
  • ERP_JobToDate_Cost

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

  • CostBudgetCommittedVariance_Revised_Subtotal_M

    Is equal to the revised material cost budget (CostBudget_Revised_M) minus the approved material committed cost subtotal (CommittedCost_Approved_Subtotal_M).

  • CostBudgetCommittedVariance_Revised_Subtotal_L

    Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the approved labor committed cost subtotal (CommittedCost_Approved_Subtotal_L).

  • CostBudgetCommittedVariance_Revised_Subtotal_E

    Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the approved equipment committed cost subtotal (CommittedCost_Approved_Subtotal_E).

  • CostBudgetCommittedVariance_Revised_Subtotal_S

    Is equal to the revised subcontract cost budget (CostBudget_Revised_S) minus the approved subcontract committed cost subtotal (CommittedCost_Approved_Subtotal_S).

  • CostBudgetCommittedVariance_Revised_Subtotal_O

    Is equal to the revised other cost budget (CostBudget_Revised_O) minus the approved other committed cost subtotal (CommittedCost_Approved_Subtotal_O).

  • CostBudgetCommittedVariance_Revised_Subtotal

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

  • CostBudgetCommittedVariance_Revised_Total_M

    Is equal to the revised material cost budget (CostBudget_Revised_M) minus the total approved material committed costs (CommittedCost_Approved_Total_M).

  • CostBudgetCommittedVariance_Revised_Total_L

    Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the total approved labor committed costs (CommittedCost_Approved_Total_L).

  • CostBudgetCommittedVariance_Revised_Total_E

    Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the total approved equipment committed costs (CommittedCost_Approved_Total_E).

  • CostBudgetCommittedVariance_Revised_Total_S

    Is equal to the revised subcontract cost budget (CostBudget_Revised_S) minus the total approved subcontract committed costs (CommittedCost_Approved_Total_S).

  • CostBudgetCommittedVariance_Revised_Total_O

    Is equal to the revised other cost budget (CostBudget_Revised_O) minus the total approved other committed costs (CommittedCost_Approved_Total_O).

  • CostBudgetCommittedVariance_Revised_Total

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

  • CostBudgetCostToDateVariance_Revised_Subtotal_M

    Is equal to the revised material cost budget (CostBudget_Revised_M) minus the approved cost-to-date material subtotal (CostToDate_Approved_Subtotal_M).

  • CostBudgetCostToDateVariance_Revised_Subtotal_L

    Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the approved cost-to-date labor subtotal (CostToDate_Approved_Subtotal_L).

  • CostBudgetCostToDateVariance_Revised_Subtotal_E

    Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the approved cost-to-date equipment subtotal (CostToDate_Approved_Subtotal_E).

  • CostBudgetCostToDateVariance_Revised_Subtotal_S

    Is equal to the revised subcontract cost budget (CostBudget_Revised_S) minus the approved cost-to-date subcontract subtotal (CostToDate_Approved_Subtotal_S).

  • CostBudgetCostToDateVariance_Revised_Subtotal_O

    Is equal to the revised other cost budget (CostBudget_Revised_O) minus the approved cost-to-date other subtotal (CostToDate_Approved_Subtotal_O).

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

    Is equal to the revised material cost budget (CostBudget_Revised_M) minus the approved cost-to-date material total (CostToDate_Approved_Total_M).

  • CostBudgetCostToDateVariance_Revised_Total_L

    Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the approved cost-to-date labor total (CostToDate_Approved_Total_L).

  • CostBudgetCostToDateVariance_Revised_Total_E

    Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the approved cost-to-date equipment total (CostToDate_Approved_Total_E).

  • CostBudgetCostToDateVariance_Revised_Total_S

    Is equal to the revised subcontract cost budget (CostBudget_Revised_S) minus the approved cost-to-date subcontract total (CostToDate_Approved_Total_S).

  • CostBudgetCostToDateVariance_Revised_Total_O

    Is equal to the revised other cost budget (CostBudget_Revised_O) minus the approved cost-to-date other total (CostToDate_Approved_Total_O).

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

    Is equal to the approved material committed cost subtotal (CommittedCost_Approved_Subtotal_M) minus the approved cost-to-date material subtotal (CostToDate_Approved_Subtotal_M).

  • CommittedCostToDateVariance_Approved_Subtotal_L

    Is equal to the approved labor committed cost subtotal (CommittedCost_Approved_Subtotal_L) minus the approved cost-to-date labor subtotal (CostToDate_Approved_Subtotal_L).

  • CommittedCostToDateVariance_Approved_Subtotal_E

    Is equal to the approved equipment committed cost subtotal (CommittedCost_Approved_Subtotal_E) minus the approved cost-to-date equipment subtotal (CostToDate_Approved_Subtotal_E).

  • CommittedCostToDateVariance_Approved_Subtotal_S

    Is equal to the approved subcontract committed cost subtotal (CommittedCost_Approved_Subtotal_S) minus the approved cost-to-date subcontract subtotal (CostToDate_Approved_Subtotal_S).

  • CommittedCostToDateVariance_Approved_Subtotal_O

    Is equal to the approved other committed cost subtotal (CommittedCost_Approved_Subtotal_O) minus the approved cost-to-date other subtotal (CostToDate_Approved_Subtotal_O).

  • CommittedCostToDateVariance_Approved_Subtotal

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

  • CommittedCostToDateVariance_Approved_Total_M

    Is equal to the approved material committed cost total (CommittedCost_Approved_Total_M) minus the approved cost-to-date material total (CostToDate_Approved_Total_M).

  • CommittedCostToDateVariance_Approved_Total_L

    Is equal to the approved labor committed cost total (CommittedCost_Approved_Total_L) minus the approved cost-to-date labor total (CostToDate_Approved_Total_L).

  • CommittedCostToDateVariance_Approved_Total_E

    Is equal to the approved equipment committed cost total (CommittedCost_Approved_Total_E) minus the approved cost-to-date equipment total (CostToDate_Approved_Total_E).

  • CommittedCostToDateVariance_Approved_Total_S

    Is equal to the approved subcontract committed cost total (CommittedCost_Approved_Total_S) minus the approved cost-to-date subcontract total (CostToDate_Approved_Total_S).

  • CommittedCostToDateVariance_Approved_Total_O

    Is equal to the approved other committed cost total (CommittedCost_Approved_Total_O) minus the approved cost-to-date other total (CostToDate_Approved_Total_O).

  • CommittedCostToDateVariance_Approved_Total

    Is equal to the approved committed cost total (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 total prime revenue budget (RevenueBudget_Prime_Total).

  • CostBudgetContractVariance_ApprovedCO_Total

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

  • CostBudgetContractVariance_Revised_Total

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

  • RevenueCostBudgetVariance_Prime_Subtotal

    Is equal to the prime revenue budget subtotal (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 prime revenue budget total (RevenueBudget_Prime_Total) minus the prime cost budget (CostBudget_Prime).

  • RevenueCostBudgetVariance_ApprovedCO_Total

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

  • RevenueCostBudgetVariance_Revised_Total

    Is equal to the revised revenue budget total (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_Subtotal_OnBillRates

    Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) minus the approved committed cost subtotal on bill rates (CommittedCost_Approved_Subtotal_OnBillRates).

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

  • RevenueCommittedCostVariance_Approved_Total_OnBillRates

    Is equal to the revised revenue budget total (RevenueBudget_Revised_Total) minus the approved committed cost total on bill rates(CommittedCost_Approved_Total_OnBillRates).

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

  • 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_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 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_ApprovedAndPending_Hours_NoCORef
  • LbrTimecard_ApprovedAndPending_Hours_WIthCORef
  • LbrTimecard_ApprovedAndPending_Hours
  • LbrTimecard_Projected_Total
  • 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
  • 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.