Unit Price contract-specific API V1

API Name: CoreconAPI_ContractUnitPrice

This API is specific to projects with unit price contracts only.

API fields

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

JobCostCode_RevenueBudget_Revised_UnitPrice
Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) divided by the job cost code quantity (JobCostCodeQuantity).
JobCostCode_CostBudget_Revised_UnitPrice
Is equal to the revised cost budget (CostBudget_Revised) divided by the job cost code quantity (JobCostCodeQuantity).

OwnerCostCode
OwnerCostCodeDescription

CostBudget_Prime_M
CostBudget_Prime_L
CostBudget_Prime_E
CostBudget_Prime_S
CostBudget_Prime_O
CostBudget_Prime
CostBudget_Prime_UnitPrice
Is equal to the prime cost budget (CostBudget_Prime) divided by the prime revenue budget estimated quantity (RevenueBudget_Prime_EstQuantity).

CostBudget_ApprovedCOs_M
CostBudget_ApprovedCOs_L
CostBudget_ApprovedCOs_E
CostBudget_ApprovedCOs_S
CostBudget_ApprovedCOs_O
CostBudget_ApprovedCOs
CostBudget_ApprovedCOs_UnitPrice
Is equal to the approved change order cost budget (CostBudget_ApprovedCOs) divided by the approved change order revenue budget estimated quantity (RevenueBudget_ApprovedCOs_EstQuantity).

CostBudget_Revised_M
CostBudget_Revised_L
CostBudget_Revised_E
CostBudget_Revised_S
CostBudget_Revised_O
CostBudget_Revised
CostBudget_Revised_UnitPrice
Is equal to the revised cost budget (CostBudget_Revised) divided by the revised revenue budget estimated quantity (RevenueBudget_Revised_EstQuantity).

CommittedCost_Approved_Subtotal_M
CommittedCost_Approved_Subtotal_L
CommittedCost_Approved_Subtotal_E
CommittedCost_Approved_Subtotal_S
CommittedCost_Approved_Subtotal_O
CommittedCost_Approved_Subtotal

CommittedCost_Pending_Subtotal_M
CommittedCost_Pending_Subtotal_L
CommittedCost_Pending_Subtotal_E
CommittedCost_Pending_Subtotal_S
CommittedCost_Pending_Subtotal_O
CommittedCost_Pending_Subtotal

CommittedCost_ApprovedPending_Subtotal_M
CommittedCost_ApprovedPending_Subtotal_L
CommittedCost_ApprovedPending_Subtotal_E
CommittedCost_ApprovedPending_Subtotal_S
CommittedCost_ApprovedPending_Subtotal_O
CommittedCost_ApprovedPending_Subtotal

CostToDate_Approved_GrossTotal_M
CostToDate_Approved_GrossTotal_L
CostToDate_Approved_GrossTotal_E
CostToDate_Approved_GrossTotal_S
CostToDate_Approved_GrossTotal_O
CostToDate_Approved_GrossTotal

CostToDate_Pending_GrossTotal_M
CostToDate_Pending_GrossTotal_L
CostToDate_Pending_GrossTotal_E
CostToDate_Pending_GrossTotal_S
CostToDate_Pending_GrossTotal_O
CostToDate_Pending_GrossTotal

CostToDate_ApprovedPending_GrossTotal_M
CostToDate_ApprovedPending_GrossTotal_L
CostToDate_ApprovedPending_GrossTotal_E
CostToDate_ApprovedPending_GrossTotal_S
CostToDate_ApprovedPending_GrossTotal_O
CostToDate_ApprovedPending_GrossTotal

CostToDate_Approved_DailyLog_Activity_Quantity_GrossUnitPrice
CostToDate_Approved_PrimeInvoice_Quantity_GrossUnitPrice
CostToDate_Approved_EstimatedFieldPercentComplete_GrossUnitPrice

CostToDate_ApprovedPending_DailyLog_Activity_Quantity_GrossUnitPrice
CostToDate_ApprovedPending_PrimeInvoice_Quantity_GrossUnitPrice
CostToDate_ApprovedPending_EstimatedFieldPercentComplete_GrossUnitPrice

RevenueBudget_Prime_EstQuantity
Is equal to the sum of the original contract item quantities that reference the same job cost code.
RevenueBudget_Prime_UnitPrice
RevenueBudget_Prime_Subtotal

RevenueBudget_ApprovedCOs_EstQuantity
Is equal to the sum of the approved change order item quantities that reference the same job cost code.
RevenueBudget_ApprovedCOs_UnitPrice
RevenueBudget_ApprovedCOs_Subtotal

RevenueBudget_Revised_EstQuantity
Is equal to the sum of the prime revenue budget estimated quantity (RevenueBudget_Prime_EstQuantity) and the approved change order revenue budget estimated quantity (RevenueBudget_ApprovedCOs_EstQuantity).
RevenueBudget_Revised_UnitPrice
Is equal to the sum of the prime revenue budget subtotal (RevenueBudget_Prime_Subtotal) and the approved change order revenue budget subtotal (RevenueBudget_ApprovedCOs_Subtotal) divided by the revised revenue budget estimated quantity (RevenueBudget_Revised_EstQuantity).
RevenueBudget_Revised_Subtotal

PrimeInvoice_Approved_GrossTotal_NoCORef
PrimeInvoice_Approved_GrossTotal_WithCORef
PrimeInvoice_Approved_GrossTotal

PrimeInvoice_Approved_Quantity_NoCORef
PrimeInvoice_Approved_Quantity_WithCORef
PrimeInvoice_Approved_Quantity
PrimeInvoice_Approved_Quantity_Remaining
Is equal to the revised revenue budget estimated quantity (RevenueBudget_Revised_EstQuantity) minus the approved prime invoice quantity (PrimeInvoice_Approved_Quantity).

Percent_PrimeInvoice_Approved_Quantity_NoCORef
Percent_PrimeInvoice_Approved_Quantity_WithCORef
Percent_PrimeInvoice_Approved_Quantity

PrimeInvoice_ApprovedPending_GrossTotal_NoCORef
PrimeInvoice_ApprovedPending_GrossTotal_WithCORef
PrimeInvoice_ApprovedPending_GrossTotal

PrimeInvoice_ApprovedPending_Quantity_NoCORef
PrimeInvoice_ApprovedPending_Quantity_WithCORef
PrimeInvoice_ApprovedPending_Quantity
PrimeInvoice_ApprovedPending_Quantity_Remaining
Is equal to the revised revenue budget estimated quantity (RevenueBudget_Revised_EstQuantity) minus the approved and pending prime invoice quantity (PrimeInvoice_ApprovedPending_Quantity).

Percent_PrimeInvoice_ApprovedPending_Quantity_NoCORef
Percent_PrimeInvoice_ApprovedPending_Quantity_WithCORef
Percent_PrimeInvoice_ApprovedPending_Quantity

CashFlow_Approved_GrossTotal
CashFlow_ApprovedPending_GrossTotal

DailyLog_Activity_Quantity_NoCORef
DailyLog_Activity_Quantity_WithCORef
DailyLog_Activity_Quantity

Percent_DailyLog_Activity_Quantity_NoCORef
Percent_DailyLog_Activity_Quantity_WithCORef
Percent_DailyLog_Activity_Quantity

EstimatedFieldPercentComplete

Percent_CostToDateCostBudget_Gross

Projected_Cost_DailyLog_Activity_Quantity
Projected_Cost_Invoiced_Approved_Quantity
Projected_Cost_Invoiced_ApprovedPending_Quantity

EarnedRevenue_EstQuantity_DailyLogQuantity_Gross
Billing_Over_EstQuantity_DailyLogQuantity
Billing_Under_EstQuantity_DailyLogQuantity

EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity
Is equal to the revised revenue budget subtotal (RevenueBudget_Revised_Subtotal) multiplied by the estimated field percent complete (EstimatedFieldPercentComplete) and divided by 100 when the estimated field percent complete (EstimatedFieldPercentComplete) is less than 100; otherwise, it's equal to the RevenueBudget_Revised_Subtotal.
Billing_Over_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity
Is equal to the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) minus the earned revenue based on estimated quantity and estimated field percent complete (EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity) when the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) is greater than the EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity; otherwise, it's equal to 0.
Billing_Under_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity
Is equal to the earned revenue based on estimated quantity and estimated field percent complete (EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity) minus the approved prime invoice gross total (PrimeInvoice_Approved_GrossTotal) when the PrimeInvoice_Approved_GrossTotal is less than the EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity; otherwise, it's equal to 0.

EarnedRevenue_CostBudget_Gross
Billing_Over_CostToDate_CostBudget
Billing_Under_CostToDate_CostBudget

Labor budget hours and timecard information fields

HourBudget_Prime_L
HourBudget_ApprovedCOs_L
HourBudget_Revised_L

LbrTimecard_Approved_Hours_NoCORef
LbrTimecard_Approved_Hours_WithCORef
LbrTimecard_Approved_Hours

LbrTimecard_ApprovedPending_Hours_NoCORef
LbrTimecard_ApprovedPending_Hours_WIthCORef
LbrTimecard_ApprovedPending_Hours

LbrTimecard_Approved_CostTotal
LbrTimecard_Approved_Billable
LbrTimecard_Approved_Unbillable
LbrTimecard_Approved_OnHold

LbrTimecard_ApprovedPending_CostTotal
LbrTimecard_ApprovedPending_Billable
LbrTimecard_ApprovedPending_Unbillable
LbrTimecard_ApprovedPending_OnHold

Projected_Hours_L
LbrTimecard_Projected_Total

Equipment budget hours and timecard information fields

HourBudget_Prime_E
HourBudget_ApprovedCOs_E
HourBudget_Revised_E

EqpTimecard_Hours_NoCORef
EqpTimecard_Hours_WithCORef
EqpTimecard_Hours

EqpTimecard_CostTotal
EqpTimecard_Billable
EqpTimecard_Unbillable
EqpTimecard_OnHold

Additional daily log information fields

DailyLog_Manpower_JobCostCode_ManpowerHours
DailyLog_MajorEqp_JobCostCode_EquipmentHours