Project Financial Analytics - APIs - V1 - Labor and Equipment Hours Historical

API Name: CoreconAPI_HoursHistorical


  • MonthYearUTC
  • MonthYearOrgLocal
  • MonthYearUTCString
  • MonthYearOrgLocalString

  • 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

  • HourBudget_Prime_L
  • HourBudget_ApprovedCOs_L
  • HourBudget_Revised_L

  • Projected_Hours_L

  • LbrTimecard_Approved_Hours_NoCORef
  • LbrTimecard_Approved_Hours_WithCORef
  • LbrTimecard_Approved_Hours

  • LbrTimecard_Pending_Hours_NoCORef
  • LbrTimecard_Pending_Hours_WIthCORef
  • LbrTimecard_Pending_Hours

  • CostBudget_Prime_L
  • CostBudget_ApprovedCOs_L
  • CostBudget_Revised_L

  • LbrTimecard_Approved_CostTotal
  • LbrTimecard_Approved_Billable
  • LbrTimecard_Approved_Unbillable
  • LbrTimecard_Approved_OnHold

  • LbrTimecard_Pending_CostTotal
  • LbrTimecard_Pending_Billable
  • LbrTimecard_Pending_Unbillable
  • LbrTimecard_Pending_OnHold

  • LbrTimecard_Projected_Total

  • HourBudget_Prime_E
  • HourBudget_ApprovedCOs_E
  • HourBudget_Revised_E

  • Projected_Hours_E

  • EqpTimecard_Hours_NoCORef
  • EqpTimecard_Hours_WithCORef
  • EqpTimecard_Hours

  • CostBudget_Prime_E
  • CostBudget_ApprovedCOs_E
  • CostBudget_Revised_E

  • EqpTimecard_CostTotal
  • EqpTimecard_Billable
  • EqpTimecard_Unbillable
  • EqpTimecard_OnHold

  • EqpTimecard_Projected_Total

  • EstimatedFieldPercentComplete

  • DailyLog_Activity_JobCostCodeQuantity
  • DailyLog_Manpower_JobCostCodeManpowerHours (Job Cost Code has to be added on the add, edit and import forms.)
  • DailyLog_MajorEqp_JobCostCodeEquipmentHours (Job Cost Code has to be added on the add, edit and import forms.)
  • PrimeInvoice_UnitPrice_JobCostCodeQuantity