Project Financial Analytics - APIs - V1 - Contract Specific - Unit Price

API Name: CoreconAPI_ContractUnitPrice

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

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 = ([RevenueBudget_Revised_Subtotal] / [JobCostCodeQuantity])
JobCostCode_CostBudget_Revised_UnitPrice = ([CostBudget_Revised] / [JobCostCodeQuantity])

OwnerCostCode
OwnerCostCodeDescription

CostBudget_Prime_M
CostBudget_Prime_L
CostBudget_Prime_E
CostBudget_Prime_S
CostBudget_Prime_O
CostBudget_Prime
CostBudget_Prime_UnitPrice = [CostBudget_Prime] / [RevenueBudget_Prime_EstQuantity]

CostBudget_ApprovedCOs_M
CostBudget_ApprovedCOs_L
CostBudget_ApprovedCOs_E
CostBudget_ApprovedCOs_S
CostBudget_ApprovedCOs_O
CostBudget_ApprovedCOs
CostBudget_ApprovedCOs_UnitPrice = [CostBudget_ApprovedCOs] / [RevenueBudget_ApprovedCOs_EstQuantity]

CostBudget_Revised_M
CostBudget_Revised_L
CostBudget_Revised_E
CostBudget_Revised_S
CostBudget_Revised_O
CostBudget_Revised
CostBudget_Revised_UnitPrice = [CostBudget_Revised] / [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 = (Sum of Original Contract Item Quantities that reference same Job Cost Code)
RevenueBudget_Prime_UnitPrice
RevenueBudget_Prime_Subtotal

RevenueBudget_ApprovedCOs_EstQuantity = (Sum of Approved CO Item Quantities that reference same Job Cost Code)
RevenueBudget_ApprovedCOs_UnitPrice
RevenueBudget_ApprovedCOs_Subtotal

RevenueBudget_Revised_EstQuantity = [RevenueBudget_Prime_EstQuantity] + [RevenueBudget_ApprovedCOs_EstQuantity]
RevenueBudget_Revised_UnitPrice = ([RevenueBudget_Prime_Subtotal] + [RevenueBudget_ApprovedCOs_Subtotal]) / [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 = [RevenueBudget_Revised_EstQuantity] - [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 = [RevenueBudget_Revised_EstQuantity] - [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 = IF EstimatedFieldPercentComplete < 100 Then ((EstimatedFieldPercentComplete * RevenueBudget_Revised_Subtotal) / 100)) Else (RevenueBudget_Revised_Subtotal)
Billing_Over_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity = IF PrimeInvoice_Approved_GrossTotal > EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity Then (PrimeInvoice_Approved_GrossTotal - EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity) Else (0)
Billing_Under_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity = PrimeInvoice_Approved_GrossTotal < EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity Then (EarnedRevenue_EstQuantity_EstimatedFieldPercentComplete_JobCostCodeQuantity - PrimeInvoice_Approved_GrossTotal) Else (0)

EarnedRevenue_CostBudget_Gross
Billing_Over_CostToDate_CostBudget
Billing_Under_CostToDate_CostBudget

Labor Budget Hours and Timecard Information

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

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

DailyLog_Manpower_JobCostCode_ManpowerHours
DailyLog_MajorEqp_JobCostCode_EquipmentHours