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