Project Financial Analytics - APIs - V1 - Cost By Resource Type
API Name: CoreconAPI_CostResource
Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-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 (Uses Labor Timecard Bill Rate instead of Cost Rate)
- CommittedCost_Approved_Subtotal_E
- CommittedCost_Approved_Subtotal_E_OnBillRates (Uses Equipment Timecard Bill Rate instead of Cost Rate)
- CommittedCost_Approved_Subtotal_S
- CommittedCost_Approved_Subtotal_O
- CommittedCost_Approved_Subtotal
- CommittedCost_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of 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 (Uses Labor Timecard Bill Rate instead of Cost Rate)
- CommittedCost_Approved_Total_E
- CommittedCost_Approved_Total_E_OnBillRates (Uses Equipment Timecard Bill Rate instead of Cost Rate)
- CommittedCost_Approved_Total_S
- CommittedCost_Approved_Total_O
- CommittedCost_Approved_Total
- CommittedCost_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of 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 (CommittedCost_Approved_M listed above includes AnticipatedCost_M)
- AnticipatedCost_L (CommittedCost_Approved_L listed above includes AnticipatedCost_L)
- AnticipatedCost_E (CommittedCost_Approved_E listed above includes AnticipatedCost_E)
- AnticipatedCost_S (CommittedCost_Approved_S listed above includes AnticipatedCost_S)
- AnticipatedCost_O (CommittedCost_Approved_O listed above includes AnticipatedCost_O)
- AnticipatedCost_Total (CommittedCost_Approved listed above includes AnticipatedCost)
- CostToDate_Approved_GrossTotal
- CostToDate_Approved_GrossTotal_OnBillRates (Uses Labor Timecard Bill Rate instead of Cost Rate)
- CostToDate_Pending_GrossTotal
- CostToDate_Approved_Subtotal_M
- CostToDate_Approved_Subtotal_L
- CostToDate_Approved_Subtotal_L_OnBillRates (Uses Labor Timecard Bill Rate instead of Cost Rate)
- CostToDate_Approved_Subtotal_E
- CostToDate_Approved_Subtotal_E_OnBillRates (Uses Equipment Timecard Bill Rate instead of Cost Rate)
- CostToDate_Approved_Subtotal_S
- CostToDate_Approved_Subtotal_O
- CostToDate_Approved_Subtotal
- CostToDate_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of 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 (Uses Labor Timecard Bill Rate instead of Cost Rate)
- CostToDate_Approved_Total_E
- CostToDate_Approved_Total_E_OnBillRates (Uses Equipment Timecard Bill Rate instead of Cost Rate)
- CostToDate_Approved_Total_S
- CostToDate_Approved_Total_O
- CostToDate_Approved_Total
- CostToDate_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of 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 (Latest cost information in ERP system such as Sage Intacct. Data must be populated using AccountingLink utility.)
- CostBudget_Revised_Less_CommittedCost_Approved_Subtotal = [CostBudget_Revised] - [CommittedCost_Approved_Subtotal]
- CostBudget_Revised_Less_CommittedCost_Approved_Total = [CostBudget_Revised] - [CommittedCost_Approved_Total]
- CostBudget_Revised_Less_CostToDate_Approved_GrossTotal = [CostBudget_Revised] - [CostToDate_Approved_GrossTotal]
- CostBudget_Revised_Less_CostToDate_Approved_Subtotal = [CostBudget_Revised] - [CostToDate_Approved_Subtotal]
- CostBudget_Revised_Less_CostToDate_Approved_Total = [CostBudget_Revised] - [CostToDate_Approved_Total]
- CommittedCost_Approved_Subtotal_Less_CostToDate_Approved_GrossTotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_GrossTotal]
- CommittedCost_Approved_Subtotal_Less_CostToDate_Approved_Subtotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_Subtotal]
- CommittedCost_Approved_Total_Less_CostToDate_Approved_Total = [CommittedCost_Approved_Total] - [CostToDate_Approved_Total]
- CommittedCost_Approved_Subtotal_VS_CostBudget_Revised = Sum([CommittedCost_Approved_Subtotal]) / Sum([CostBudget_Revised])
- CommittedCost_Approved_Total_VS_CostBudget_Revised = Sum([CommittedCost_Approved_Total]) / Sum([CostBudget_Revised])
- CostToDate_Approved_GrossTotal_VS_CostBudget_Revised = Sum([CostToDate_Approved_GrossTotal]) / Sum([CostBudget_Revised])
- CostToDate_Approved_Subtotal_VS_CostBudget_Revised = Sum([CostToDate_Approved_Subtotal]) / Sum([CostBudget_Revised])
- CostToDate_Approved_Total_VS_CostBudget_Revised = Sum([CostToDate_Approved_Total]) / Sum([CostBudget_Revised])
- EstimatedFieldPercentComplete