Project Financial Analytics - APIs - V1 - Contract Specific - Cost Plus
API Name: CoreconAPI_ContractCostPlus
Note: This API is specific to projects with cost plus 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
 
- OwnerCostCode
 - OwnerCostCodeDescription
 
- Bill_Approved_Subtotal
 - Bill_Approved_Subtotal_Billable
 - Bill_Approved_Subtotal_Billable_Invoiced
 - Bill_Approved_Subtotal_Billable_NotInvoiced
 - Bill_Approved_Subtotal_UnBillable
 - Bill_Approved_Subtotal_OnHold
 
- Bill_Pending_Subtotal
 - Bill_Pending_Subtotal_Billable
 - Bill_Pending_Subtotal_UnBillable
 - Bill_Pending_Subtotal_OnHold
 
- Bill_ApprovedPending_Subtotal = [Bill_Approved_Subtotal] + [Bill_Pending_Subtotal]
 
- SubInvoice_Approved_GrossTotal
 - SubInvoice_Approved_GrossTotal_Billable
 - SubInvoice_Approved_GrossTotal_Billable_Invoiced
 - SubInvoice_Approved_GrossTotal_Billable_NotInvoiced
 - SubInvoice_Approved_GrossTotal_UnBillable
 - SubInvoice_Approved_GrossTotal_OnHold
 
- SubInvoice_Pending_GrossTotal
 - SubInvoice_Pending_GrossTotal_Billable
 - SubInvoice_Pending_GrossTotal_UnBillable
 - SubInvoice_Pending_GrossTotal_OnHold
 
- SubInvoice_ApprovedPending_GrossTotal = [SubInvoice_Approved_GrossTotal] + [SubInvoice_Pending_GrossTotal]
 
- MiscExpense_Approved_Subtotal
 - MiscExpense_Approved_Subtotal_Billable
 - MiscExpense_Approved_Subtotal_Billable_Invoiced
 - MiscExpense_Approved_Subtotal_Billable_NotInvoiced
 - MiscExpense_Approved_Subtotal_UnBillable
 - MiscExpense_Approved_Subtotal_OnHold
 
- MiscExpense_Pending_Subtotal
 - MiscExpense_Pending_Subtotal_Billable
 - MiscExpense_Pending_Subtotal_UnBillable
 - MiscExpense_Pending_Subtotal_OnHold
 
- MiscExpense_ApprovedPending_Subtotal = [MiscExpense_Approved_Subtotal] + [MiscExpense_Pending_Subtotal]
 
- LbrTimecard_Approved_Cost
 - LbrTimecard_Approved_Billable
 - LbrTimecard_Approved_Billable_Invoiced
 - LbrTimecard_Approved_Billable_NotInvoiced
 - LbrTimecard_Approved_UnBillable
 - LbrTimecard_Approved_OnHold
 
- LbrTimecard_Pending_Cost
 - LbrTimecard_Pending_Billable
 - LbrTimecard_Pending_UnBillable
 - LbrTimecard_Pending_OnHold
 
- LbrTimecard_ApprovedPending_Billable = [LbrTimecard_Approved_Billable] + [LbrTimecard_Pending_Billable]
 - LbrTimecard_ApprovedPending_CostTotal = [LbrTimecard_Approved_Cost] + [LbrTimecard_Pending_Cost]
 
- EqpTimecard_Cost
 - EqpTimecard_Billable
 - EqpTimecard_Billable_Invoiced
 - EqpTimecard_Billable_NotInvoiced
 - EqpTimecard_UnBillable
 - EqpTimecard_OnHold
 
- WorkOrder_Approved_Subtotal_Cost
 - WorkOrder_Approved_Subtotal_Billable
 - WorkOrder_Approved_Subtotal_Billable_Invoiced
 - WorkOrder_Approved_Subtotal_Billable_NotInvoiced
 - WorkOrder_Approved_Subtotal_UnBillable
 - WorkOrder_Approved_Subtotal_OnHold
 
- WorkOrder_Pending_Subtotal_Cost
 - WorkOrder_Pending_Subtotal_Billable
 - WorkOrder_Pending_Subtotal_UnBillable
 - WorkOrder_Pending_Subtotal_OnHold
 
- CostToDate_Approved_Cost_Subtotal = [Bill_Approved_Subtotal] + [SubInvoice_Approved_GrossTotal] + [MiscExpense_Approved_Subtotal] + [LbrTimecard_Approved_Cost] + [EqpTimecard_Cost]
 - CostToDate_Pending_Cost_Subtotal = [Bill_Pending_Subtotal] + [SubInvoice_Pending_GrossTotal] + [MiscExpense_Pending_Subtotal] + [LbrTimecard_Pending_Cost]
 - CostToDate_ApprovedPending_Cost_Subtotal = [CostToDate_Approved_Cost_Subtotal] + [CostToDate_Pending_Cost_Subtotal]
 
- CostToDate_Approved_Billable_Subtotal = [Bill_Approved_Subtotal_Billable] + [SubInvoice_Approved_GrossTotal_Billable] + [MiscExpense_Approved_Subtotal_Billable] + [LbrTimecard_Approved_Billable] + [EqpTimecard_Billable]
 - CostToDate_Pending_Billable_Subtotal = [Bill_Pending_Subtotal_Billable] + [SubInvoice_Pending_GrossTotal_Billable] + [MiscExpense_Pending_Subtotal_Billable] + [LbrTimecard_Pending_Billable]
 - CostToDate_ApprovedPending_Billable_Subtotal = [CostToDate_Approved_Billable_Subtotal] + [CostToDate_Pending_Billable_Subtotal]
 
- CostToDate_Approved_Billable_Subtotal_Invoiced = [Bill_Approved_Subtotal_Billable_Invoiced] + [SubInvoice_Approved_GrossTotal_Billable_Invoiced] + [MiscExpense_Approved_Subtotal_Billable_Invoiced] + [LbrTimecard_Approved_Billable_Invoiced] + [EqpTimecard_Billable_Invoiced]
 - CostToDate_Approved_Billable_Subtotal_NotInvoiced = [Bill_Approved_Subtotal_Billable_NotInvoiced] + [SubInvoice_Approved_GrossTotal_Billable_NotInvoiced] + [MiscExpense_Approved_Subtotal_Billable_NotInvoiced] + [LbrTimecard_Approved_Billable_NotInvoiced] + [EqpTimecard_Billable_NotInvoiced]
 - CostToDate_Approved_UnBillable = [Bill_Approved_Subtotal_UnBillable] + [SubInvoice_Approved_GrossTotal_UnBillable] + [MiscExpense_Approved_Subtotal_UnBillable] + [LbrTimecard_Approved_UnBillable] + [EqpTimecard_UnBillable]
 
- RevenueBudget_Prime_Subtotal
 - RevenueBudget_Prime_Tax
 - RevenueBudget_Prime_Total
 
- RevenueBudget_ApprovedCOs_Subtotal
 - RevenueBudget_ApprovedCOs_Tax
 - RevenueBudget_ApprovedCOs_Total
 
- RevenueBudget_PendingCOs_Subtotal
 - RevenueBudget_PendingCOs_Tax
 - RevenueBudget_PendingCOs_Total
 
- RevenueBudget_Revised_Subtotal
 - RevenueBudget_Revised_Tax
 - RevenueBudget_Revised_Total
 
- RevenueBudget_ApprovedCPRs_Subtotal
 - RevenueBudget_ApprovedCPRs_Tax
 - RevenueBudget_ApprovedCPRs_Total
 
- RevenueBudget_PendingCPRs_Subtotal
 - RevenueBudget_PendingCPRs_Tax
 - RevenueBudget_PendingCPRs_Total
 
- PrimeInvoice_Approved_GrossTotal_NoCORef
 - PrimeInvoice_Approved_GrossTotal_WithCORef
 - PrimeInvoice_Approved_GrossTotal
 
- PrimeInvoice_Approved_Retainage
 - PrimeInvoice_Approved_RetainageBilled
 - PrimeInvoice_Approved_NetRetainage
 
- PrimeInvoice_Approved_Subtotal
 - PrimeInvoice_Approved_Tax
 - PrimeInvoice_Approved_Total
 
- PrimeInvoice_Pending_GrossTotal_NoCORef
 - PrimeInvoice_Pending_GrossTotal_WithCORef
 - PrimeInvoice_Pending_GrossTotal
 
- PrimeInvoice_Pending_Retainage
 - PrimeInvoice_Pending_RetainageBilled
 - PrimeInvoice_Pending_NetRetainage
 
- PrimeInvoice_Pending_Subtotal
 - PrimeInvoice_Pending_Tax
 - PrimeInvoice_Pending_Total