Labor and equipment hours API V1
API Name: CoreconAPI_Hours
- 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
- HourBudget_Prime_L
- HourBudget_ApprovedCOs_L
- HourBudget_Revised_L
- HourBudget_PendingCOs_L
- HourBudget_ApprovedCPRs_L
- HourBudget_PendingCPRs_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
Is equal to the sum of approved labor timecard hours (LbrTimecard_Approved_Hours) and pending labor timecard hours (LbrTimecard_Pending_Hours).
- Projected_Hours_L
Is equal to the approved labor timecard hours (LbrTimecard_Approved_Hours) divided by the estimated field percent complete (EstimatedFieldPercentComplete).
- RevisedLbrHourBudget_Less_ApprLbrHours
Is equal to the revised labor hour budget (HourBudget_Revised_L) minus the approved labor timecard hours (LbrTimecard_Approved_Hours).
- RevisedLbrHourBudget_Less_ApprAndPendLbrHours
Is equal to the revised labor hour budget (HourBudget_Revised_L) minus the sum of approved labor timecard hours (LbrTimecard_Approved_Hours) and pending labor timecard hours (LbrTimecard_Pending_Hours).
- RevisedLbrHourBudget_Less_ProjectedLbrHours
Is equal to the revised labor hour budget (HourBudget_Revised_L) minus the projected labor hours (LbrTimecard_Approved_Hours).
- ProjectedLbrHours_Less_RevisedLbrHourBudget = [Projected_Hours_L] - [HourBudget_Revised_L]
Is equal to the projected labor hours (LbrTimecard_Approved_Hours) minus the revised labor hour budget (HourBudget_Revised_L).
- CostBudget_Prime_L
- CostBudget_ApprovedCOs_L
- CostBudget_Revised_L
- CostBudget_PendingCOs_L
- CostBudget_ApprovedCPRs_L
- CostBudget_PendingCPRs_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
Is equal to the approved labor timecard cost total (LbrTimecard_Approved_CostTotal) divided by the approved labor timecard hours (LbrTimecard_Approved_Hours), multiplied by the projected labor hours (Projected_Hours_L).
- RevisedLbrCostBudget_Less_ApprLbrCost
Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the approved labor timecard cost total (LbrTimecard_Approved_CostTotal).
- RevisedLbrCostBudget_Less_ApprAndPendLbrCost
Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the sum of the approved labor timecard cost total (LbrTimecard_Approved_CostTotal) and the pending labor timecard cost total (LbrTimecard_Pending_CostTotal).
- RevisedLbrCostBudget_Less_ProjectedLbrCost
Is equal to the revised labor cost budget (CostBudget_Revised_L) minus the projected labor timecard total (LbrTimecard_Projected_Total).
- Cost Budget_Per_JCCQty_Rate
Is equal to 0 when the job cost code quantity (JobCostCodeQuantity) is null or equal to 0; otherwise, it's equal to the revised labor cost budget (CostBudget_Revised_L) divided by the JobCostCodeQuantity.
- ActualCost_Per_DailyLogQty_Rate
Is equal to 0 when the daily log activity job cost code quantity (DailyLog_Activity_JobCostCodeQuantity) is null or equal to 0; otherwise, it's equal to the approved labor timecard cost total (LbrTimecard_Approved_CostTotal) divided by the DailyLog_Activity_JobCostCodeQuantity.
- ProjectedCost_Per_JCCQty_Rate
Is equal to 0 when the job cost code quantity (JobCostCodeQuantity) is null or equal to 0; otherwise, it's equal to the projected labor timecard total (LbrTimecard_Projected_Total) divided by the JobCostCodeQuantity.
- HourBudget_Prime_E
- HourBudget_ApprovedCOs_E
- HourBudget_Revised_E
- HourBudget_PendingCOs_E
- HourBudget_ApprovedCPRs_E
- HourBudget_PendingCPRs_E
- EqpTimecard_Hours_NoCORef
- EqpTimecard_Hours_WithCORef
- EqpTimecard_Hours
- Projected_Hours_E
Is equal to the equipment timecard hours (EqpTimecard_Hours) divided by the estimated field percent complete (EstimatedFieldPercentComplete).
- RevisedEqpHourBudget_Less_EqpHours
Is equal to the revised equipment hour budget (HourBudget_Revised_E) minus the equipment timecard hours (EqpTimecard_Hours).
- RevisedEqpHourBudget_Less_ProjectedEqpHours
Is equal to the revised equipment hour budget (HourBudget_Revised_E) minus the projected equipment hours (Projected_Hours_E).
- ProjectedEqpHours_Less_RevisedEqpHourBudget
Is equal to the projected equipment hours (Projected_Hours_E) minus the revised equipment hour budget (HourBudget_Revised_E).
- CostBudget_Prime_E
- CostBudget_ApprovedCOs_E
- CostBudget_Revised_E
- CostBudget_PendingCOs_E
- CostBudget_ApprovedCPRs_E
- CostBudget_PendingCPRs_E
- EqpTimecard_CostTotal
- EqpTimecard_Billable
- EqpTimecard_Unbillable
- EqpTimecard_OnHold
- EqpTimecard_Projected_Total
Is equal to the equipment timecard cost total (EqpTimecard_CostTotal) divided by the equipment timecard hours (EqpTimecard_Hours), multiplied by the projected equipment hours (Projected_Hours_E).
- RevisedEqpCostBudget_Less_EqpCost
Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the equipment timecard cost total (EqpTimecard_CostTotal).
- RevisedEqpCostBudget_Less_ProjectedEqpCost
Is equal to the revised equipment cost budget (CostBudget_Revised_E) minus the projected equipment timecard total (EqpTimecard_Projected_Total).
- EstimatedFieldPercentComplete
- DailyLog_Activity_JobCostCodeQuantity
- DailyLog_Manpower_JobCostCodeManpowerHours
The job cost code is added to the add, edit, and import forms.
- DailyLog_MajorEqp_JobCostCodeEquipmentHours
The job cost code is added to the add, edit, and import forms.
- PrimeInvoice_UnitPrice_JobCostCodeQuantity