Cost Plus contract-specific API V1

API Name: CoreconAPI_ContractCostPlus

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
Is equal to the sum of the approved bill subtotal (Bill_Approved_Subtotal) and the pending bill 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
Is equal to the sum of the approved subcontractor invoice gross total (SubInvoice_Approved_GrossTotal) and the pending subcontractor invoice gross total (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
Is equal to the sum of the approved miscellaneous expense subtotal (MiscExpense_Approved_Subtotal) and the pending miscellaneous expense 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]
Is equal to the sum of the approved billable labor timecard amount (LbrTimecard_Approved_Billable) and the pending billable labor timecard amount (LbrTimecard_Pending_Billable).
LbrTimecard_ApprovedPending_CostTotal
Is equal to the sum of the approved labor timecard cost (LbrTimecard_Approved_Cost) and the pending labor timecard 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
Is equal to the sum of the approved bill subtotal (Bill_Approved_Subtotal), the approved subcontractor invoice gross total (SubInvoice_Approved_GrossTotal), the approved miscellaneous expense subtotal (MiscExpense_Approved_Subtotal), the approved labor timecard cost (LbrTimecard_Approved_Cost), and the equipment timecard cost (EqpTimecard_Cost).
CostToDate_Pending_Cost_Subtotal
Is equal to the sum of the pending bill subtotal (Bill_Pending_Subtotal), the pending subcontractor invoice gross total (SubInvoice_Pending_GrossTotal), the pending miscellaneous expense subtotal (MiscExpense_Pending_Subtotal), and the pending labor timecard cost (LbrTimecard_Pending_Cost).
CostToDate_ApprovedPending_Cost_Subtotal
Is equal to the sum of the approved cost‑to‑date cost subtotal (CostToDate_Approved_Cost_Subtotal) and the pending cost‑to‑date cost subtotal (CostToDate_Pending_Cost_Subtotal).

CostToDate_Approved_Billable_Subtotal
Is equal to the sum of the approved billable bill subtotal (Bill_Approved_Subtotal_Billable), the approved billable subcontractor invoice gross total (SubInvoice_Approved_GrossTotal_Billable), the approved billable miscellaneous expense subtotal (MiscExpense_Approved_Subtotal_Billable), the approved billable labor timecard amount (LbrTimecard_Approved_Billable), and the billable equipment timecard amount (EqpTimecard_Billable).
CostToDate_Pending_Billable_Subtotal
Is equal to the sum of the pending billable bill subtotal (Bill_Pending_Subtotal_Billable), the pending billable subcontractor invoice gross total (SubInvoice_Pending_GrossTotal_Billable), the pending billable miscellaneous expense subtotal (MiscExpense_Pending_Subtotal_Billable), and the pending billable labor timecard amount (LbrTimecard_Pending_Billable).
CostToDate_ApprovedPending_Billable_Subtotal
Is equal to the sum of the approved cost-to-date billable subtotal (CostToDate_Approved_Billable_Subtotal) and the pending cost-to-date billable subtotal (CostToDate_Pending_Billable_Subtotal).

CostToDate_Approved_Billable_Subtotal_Invoiced
Is equal to the sum of the approved invoiced billable bill subtotal (Bill_Approved_Subtotal_Billable_Invoiced), the approved invoiced billable subcontractor invoice gross total (SubInvoice_Approved_GrossTotal_Billable_Invoiced), the approved invoiced billable miscellaneous expense subtotal (MiscExpense_Approved_Subtotal_Billable_Invoiced), the approved invoiced billable labor timecard amount (LbrTimecard_Approved_Billable_Invoiced), and the invoiced billable equipment timecard amount (EqpTimecard_Billable_Invoiced).
CostToDate_Approved_Billable_Subtotal_NotInvoiced
Is equal to the sum of the approved non-invoiced billable bill subtotal (Bill_Approved_Subtotal_Billable_NotInvoiced), the approved non-invoiced billable subcontractor invoice gross total (SubInvoice_Approved_GrossTotal_Billable_NotInvoiced), the approved non-invoiced billable miscellaneous expense subtotal (MiscExpense_Approved_Subtotal_Billable_NotInvoiced), the approved non-invoiced billable labor timecard amount (LbrTimecard_Approved_Billable_NotInvoiced), and the non-invoiced billable equipment timecard amount (EqpTimecard_Billable_NotInvoiced).
CostToDate_Approved_UnBillable = [] + [] + [] + [] + []
Is equal to the sum of the approved non-billable bill subtotal (Bill_Approved_Subtotal_UnBillable), the approved non-billable subcontractor invoice gross total (SubInvoice_Approved_GrossTotal_UnBillable), the approved non-billable miscellaneous expense subtotal (MiscExpense_Approved_Subtotal_UnBillable), the approved non-billable labor timecard amount (LbrTimecard_Approved_UnBillable), and the non-billable equipment timecard amount (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