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