Cost by resource type API V1

API Name: CoreconAPI_CostResource

The job cost code, internal grouping, and owner code fields will be blank when multiple projects are selected.

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

CostBudget_Prime_M
CostBudget_Prime_L
CostBudget_Prime_E
CostBudget_Prime_S
CostBudget_Prime_O
CostBudget_Prime

CostBudget_ApprovedCOs_M
CostBudget_ApprovedCOs_L
CostBudget_ApprovedCOs_E
CostBudget_ApprovedCOs_S
CostBudget_ApprovedCOs_O
CostBudget_ApprovedCOs

CostBudget_PendingCOs_M
CostBudget_PendingCOs_L
CostBudget_PendingCOs_E
CostBudget_PendingCOs_S
CostBudget_PendingCOs_O
CostBudget_PendingCOs

CostBudget_Revised_M
CostBudget_Revised_L
CostBudget_Revised_E
CostBudget_Revised_S
CostBudget_Revised_O
CostBudget_Revised

CommittedCost_Approved_Subtotal_M
CommittedCost_Approved_Subtotal_L
CommittedCost_Approved_Subtotal_L_OnBillRates
The labor timecard bill rate is used instead of the cost rate.
CommittedCost_Approved_Subtotal_E
CommittedCost_Approved_Subtotal_E_OnBillRates
The equipment timecard bill rate is used instead of the cost rate.
CommittedCost_Approved_Subtotal_S
CommittedCost_Approved_Subtotal_O
CommittedCost_Approved_Subtotal
CommittedCost_Approved_Subtotal_OnBillRates
The labor and equipment timecard bill rate is used instead of the cost rate.

CommittedCost_Approved_Tax_M
CommittedCost_Approved_Tax_L
CommittedCost_Approved_Tax_E
CommittedCost_Approved_Tax_S
CommittedCost_Approved_Tax_O
CommittedCost_Approved_Tax

CommittedCost_Approved_Total_M
CommittedCost_Approved_Total_L
CommittedCost_Approved_Total_L_OnBillRates
The labor timecard bill rate is used instead of the cost rate.
CommittedCost_Approved_Total_E
CommittedCost_Approved_Total_E_OnBillRates
The equipment timecard bill rate is used instead of the cost rate.
CommittedCost_Approved_Total_S
CommittedCost_Approved_Total_O
CommittedCost_Approved_Total
CommittedCost_Approved_Total_OnBillRates
The labor and equipment timecard bill rate is used instead of the cost rate.

CommittedCost_Pending_Subtotal_M
CommittedCost_Pending_Subtotal_L
CommittedCost_Pending_Subtotal_E
CommittedCost_Pending_Subtotal_S
CommittedCost_Pending_Subtotal_O
CommittedCost_Pending_Subtotal

CommittedCost_Pending_Tax_M
CommittedCost_Pending_Tax_L
CommittedCost_Pending_Tax_E
CommittedCost_Pending_Tax_S
CommittedCost_Pending_Tax_O
CommittedCost_Pending_Tax

CommittedCost_Pending_Total_M
CommittedCost_Pending_Total_L
CommittedCost_Pending_Total_E
CommittedCost_Pending_Total_S
CommittedCost_Pending_Total_O
CommittedCost_Pending_Total

AnticipatedCost_M
This is included in the CommittedCost_Approved_M.
AnticipatedCost_L
This is included in the CommittedCost_Approved_L.
AnticipatedCost_E
This is included in the CommittedCost_Approved_E.
AnticipatedCost_S
This is included in the CommittedCost_Approved_S.
AnticipatedCost_O
This is included in the CommittedCost_Approved_O.
AnticipatedCost_Total
This is included in the CommittedCost_Approved.

CostToDate_Approved_GrossTotal
CostToDate_Approved_GrossTotal_OnBillRates
The labor timecard bill rate is used instead of the cost rate.
CostToDate_Pending_GrossTotal

CostToDate_Approved_Subtotal_M
CostToDate_Approved_Subtotal_L
CostToDate_Approved_Subtotal_L_OnBillRates
The labor timecard bill rate is used instead of the cost rate.
CostToDate_Approved_Subtotal_E
CostToDate_Approved_Subtotal_E_OnBillRates
The equipment timecard bill rate is used instead of the cost rate.
CostToDate_Approved_Subtotal_S
CostToDate_Approved_Subtotal_O
CostToDate_Approved_Subtotal
CostToDate_Approved_Subtotal_OnBillRates
The labor and equipment timecard bill rate is used instead of the cost rate.

CostToDate_Approved_Tax_M
CostToDate_Approved_Tax_L
CostToDate_Approved_Tax_E
CostToDate_Approved_Tax_S
CostToDate_Approved_Tax_O
CostToDate_Approved_Tax

CostToDate_Approved_Total_M
CostToDate_Approved_Total_L
CostToDate_Approved_Total_L_OnBillRates
The labor timecard bill rate is used instead of the cost rate.
CostToDate_Approved_Total_E
CostToDate_Approved_Total_E_OnBillRates
The equipment timecard bill rate is used instead of the cost rate.
CostToDate_Approved_Total_S
CostToDate_Approved_Total_O
CostToDate_Approved_Total
CostToDate_Approved_Total_OnBillRates
The labor and equipment timecard bill rate is used instead of the cost rate.

CostToDate_Pending_Subtotal_M
CostToDate_Pending_Subtotal_L
CostToDate_Pending_Subtotal_E
CostToDate_Pending_Subtotal_S
CostToDate_Pending_Subtotal_O
CostToDate_Pending_Subtotal

CostToDate_Pending_Tax_M
CostToDate_Pending_Tax_L
CostToDate_Pending_Tax_E
CostToDate_Pending_Tax_S
CostToDate_Pending_Tax_O
CostToDate_Pending_Tax

CostToDate_Pending_Total_M
CostToDate_Pending_Total_L
CostToDate_Pending_Total_E
CostToDate_Pending_Total_S
CostToDate_Pending_Total_O
CostToDate_Pending_Total

ERP_JobToDate_Cost
Displays the most recent cost information from the ERP system, such as Sage Intacct, retrieved through the AccountingLink.

CostBudget_Revised_Less_CommittedCost_Approved_Subtotal
Is equal to the revised cost budget (CostBudget_Revised) minus the approved committed cost subtotal (CommittedCost_Approved_Subtotal).
CostBudget_Revised_Less_CommittedCost_Approved_Total
Is equal to the revised cost budget (CostBudget_Revised) minus the approved committed cost total (CommittedCost_Approved_Total).

CostBudget_Revised_Less_CostToDate_Approved_GrossTotal
Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost-to-date gross total (CostToDate_Approved_GrossTotal).
CostBudget_Revised_Less_CostToDate_Approved_Subtotal
Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost-to-date subtotal (CostToDate_Approved_Subtotal).
CostBudget_Revised_Less_CostToDate_Approved_Total
Is equal to the revised cost budget (CostBudget_Revised) minus the approved cost-to-date total (CostToDate_Approved_Total).

CommittedCost_Approved_Subtotal_Less_CostToDate_Approved_GrossTotal
Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) minus the approved cost-to-date gross total (CostToDate_Approved_GrossTotal).
CommittedCost_Approved_Subtotal_Less_CostToDate_Approved_Subtotal
Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) minus the approved cost-to-date subtotal (CostToDate_Approved_Subtotal).
CommittedCost_Approved_Total_Less_CostToDate_Approved_Total
Is equal to the approved committed cost subtotal (CommittedCost_Approved_Subtotal) minus the approved cost-to-date total (CostToDate_Approved_Total).

CommittedCost_Approved_Subtotal_VS_CostBudget_Revised
Is equal to the sum of the approved committed cost subtotal (CommittedCost_Approved_Subtotal) divided by the sum of the revised cost budget (CostBudget_Revised).
CommittedCost_Approved_Total_VS_CostBudget_Revised
Is equal to the sum of the approved committed cost total (CommittedCost_Approved_Total) divided by the sum of the revised cost budget (CostBudget_Revised).

CostToDate_Approved_GrossTotal_VS_CostBudget_Revised
Is equal to the sum of the approved cost-to-date gross total (CostToDate_Approved_GrossTotal) divided by the sum of the revised cost budget (CostBudget_Revised).
CostToDate_Approved_Subtotal_VS_CostBudget_Revised
Is equal to the sum of the approved cost-to-date subtotal (CostToDate_Approved_Subtotal) divided by the sum of the revised cost budget (CostBudget_Revised).
CostToDate_Approved_Total_VS_CostBudget_Revised
Is equal to the sum of the approved cost-to-date total (CostToDate_Approved_Total) divided by the sum of the revised cost budget (CostBudget_Revised).

EstimatedFieldPercentComplete