Project Financial Analytics - APIs - V2 - Overview By Resource Type
API Name: API_V2_Resource
Note: Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-projects are selected.
- ProjectNumber
- ProjectTitle
- ProjectPMContactName
- ProjectBidContactName
- ProjectSalesContactName
- PrimeContractId
- PrimeContractNumber
- PrimeContractSubject
- PrimeContractIssueDateUtc
- PrimeContractIssueDateOrgLocal
- PrimeContractStatus
- PrimeContractStatusDateUtc
- PrimeContractStatusDateOrgLocal
- PrimeContractBillingType
- PrimeContractBillingTypeValue
- OwnerCompanyName
- OwnerContactName
- ContractorCompanyName
- ContractorContactName
- PrimeContractEstStartDateUtc
- PrimeContractEstFinishDateUtc
- PrimeContractEstFinishDateInclCODaysUtc
- PrimeContractEstStartDateOrgLocal
- PrimeContractEstFinishDateOrgLocal
- PrimeContractEstFinishDateInclCODaysOrgLocal
- JobCostCodeId
- JobCostCodeOrderNumber
- JobCostCode
- JobCostCodeDescription
- JobCostCodeQuantity
- JobCostCodeUnit
- JobCostCodeInternalDivision
- JobCostCodeInternalDivisionDesc
- JobCostCodeInternalMajor
- JobCostCodeInternalMajorDesc
- JobCostCodeInternalMinor
- JobCostCodeInternalMinorDesc
- JobCostCodeInternalSubMinor
- JobCostCodeInternalSubMinorDesc
- OwnerCostCode
- OwnerCostCodeDescription
- Percent_Field_EstimatedCompletion
- 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_Revised_M
- CostBudget_Revised_L
- CostBudget_Revised_E
- CostBudget_Revised_S
- CostBudget_Revised_O
- CostBudget_Revised
- CostBudget_PendingCOs_M
- CostBudget_PendingCOs_L
- CostBudget_PendingCOs_E
- CostBudget_PendingCOs_S
- CostBudget_PendingCOs_O
- CostBudget_PendingCOs
- CostBudget_ApprovedAndPendingCOs
- CostBudget_ApprovedCPRs
- CostBudget_PendingCPRs
- CostBudget_ApprovedAndPendingCPRs
- AnticipatedCost_M
- AnticipatedCost_L
- AnticipatedCost_E
- AnticipatedCost_S
- AnticipatedCost_O
- AnticipatedCost_Total
- CommittedCost_Approved_Subtotal_M
- CommittedCost_Approved_Subtotal_L
- CommittedCost_Approved_Subtotal_L_OnBillRates
- CommittedCost_Approved_Subtotal_E
- CommittedCost_Approved_Subtotal_E_OnBillRates
- CommittedCost_Approved_Subtotal_S
- CommittedCost_Approved_Subtotal_O
- CommittedCost_Approved_Subtotal
- CommittedCost_Approved_Subtotal_OnBillRates
- CommittedCost_Approved_Total_M
- CommittedCost_Approved_Total_L
- CommittedCost_Approved_Total_L_OnBillRates
- CommittedCost_Approved_Total_E
- CommittedCost_Approved_Total_E_OnBillRates
- CommittedCost_Approved_Total_S
- CommittedCost_Approved_Total_O
- CommittedCost_Approved_Total
- CommittedCost_Approved_Total_OnBillRates
- 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_Total_M
- CommittedCost_Pending_Total_L
- CommittedCost_Pending_Total_E
- CommittedCost_Pending_Total_S
- CommittedCost_Pending_Total_O
- CommittedCost_Pending_Total
- CommittedCost_ApprovedAndPending_Subtotal_M
- CommittedCost_ApprovedAndPending_Subtotal_L
- CommittedCost_ApprovedAndPending_Subtotal_E
- CommittedCost_ApprovedAndPending_Subtotal_S
- CommittedCost_ApprovedAndPending_Subtotal_O
- CommittedCost_ApprovedAndPending_Subtotal
- CommittedCost_ApprovedAndPending_Total_M
- CommittedCost_ApprovedAndPending_Total_L
- CommittedCost_ApprovedAndPending_Total_E
- CommittedCost_ApprovedAndPending_Total_S
- CommittedCost_ApprovedAndPending_Total_O
- CommittedCost_ApprovedAndPending_Total
- CostToDate_Approved_GrossTotal_S
- CostToDate_Pending_GrossTotal_S
- CostToDate_ApprovedAndPending_GrossTotal_S
- CostToDate_Approved_GrossTotal
- CostToDate_Approved_GrossTotal_OnBillRates
- CostToDate_Pending_GrossTotal
- CostToDate_ApprovedAndPending_GrossTotal
- CostToDate_Approved_Subtotal_M
- CostToDate_Approved_Subtotal_L
- CostToDate_Approved_Subtotal_L_OnBillRates
- CostToDate_Approved_Subtotal_E
- CostToDate_Approved_Subtotal_E_OnBillRates
- CostToDate_Approved_Subtotal_S
- CostToDate_Approved_Subtotal_O
- CostToDate_Approved_Subtotal
- CostToDate_Approved_Subtotal_OnBillRates
- CostToDate_Approved_Total_M
- CostToDate_Approved_Total_L
- CostToDate_Approved_Total_L_OnBillRates
- CostToDate_Approved_Total_E
- CostToDate_Approved_Total_E_OnBillRates
- CostToDate_Approved_Total_S
- CostToDate_Approved_Total_O
- CostToDate_Approved_Total
- CostToDate_Approved_Total_OnBillRates
- 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_Total_M
- CostToDate_Pending_Total_L
- CostToDate_Pending_Total_E
- CostToDate_Pending_Total_S
- CostToDate_Pending_Total_O
- CostToDate_Pending_Total
- CostToDate_ApprovedAndPending_Subtotal_M
- CostToDate_ApprovedAndPending_Subtotal_L
- CostToDate_ApprovedAndPending_Subtotal_E
- CostToDate_ApprovedAndPending_Subtotal_S
- CostToDate_ApprovedAndPending_Subtotal_O
- CostToDate_ApprovedAndPending_Subtotal
- CostToDate_ApprovedAndPending_Total_M
- CostToDate_ApprovedAndPending_Total_L
- CostToDate_ApprovedAndPending_Total_E
- CostToDate_ApprovedAndPending_Total_S
- CostToDate_ApprovedAndPending_Total_O
- CostToDate_ApprovedAndPending_Total
- Variance_CostBudgetCommitted_Revised_Subtotal_M
- Variance_CostBudgetCommitted_Revised_Subtotal_L
- Variance_CostBudgetCommitted_Revised_Subtotal_E
- Variance_CostBudgetCommitted_Revised_Subtotal_S
- Variance_CostBudgetCommitted_Revised_Subtotal_O
- Variance_CostBudgetCommitted_Revised_Subtotal
- Variance_CostBudgetCommitted_Revised_Total_M
- Variance_CostBudgetCommitted_Revised_Total_L
- Variance_CostBudgetCommitted_Revised_Total_E
- Variance_CostBudgetCommitted_Revised_Total_S
- Variance_CostBudgetCommitted_Revised_Total_O
- Variance_CostBudgetCommitted_Revised_Total
- Variance_CostBudgetCostToDate_Revised_GrossTotal_S
- Variance_CostBudgetCostToDate_Revised_GrossTotal
- Variance_CostBudgetCostToDate_Revised_Subtotal_M
- Variance_CostBudgetCostToDate_Revised_Subtotal_L
- Variance_CostBudgetCostToDate_Revised_Subtotal_E
- Variance_CostBudgetCostToDate_Revised_Subtotal_S
- Variance_CostBudgetCostToDate_Revised_Subtotal_O
- Variance_CostBudgetCostToDate_Revised_Subtotal
- Variance_CostBudgetCostToDate_Revised_Total_M
- Variance_CostBudgetCostToDate_Revised_Total_L
- Variance_CostBudgetCostToDate_Revised_Total_E
- Variance_CostBudgetCostToDate_Revised_Total_S
- Variance_CostBudgetCostToDate_Revised_Total_O
- Variance_CostBudgetCostToDate_Revised_Total
- Variance_CommittedCostToDate_Approved_GrossTotal_S
- Variance_CommittedCostToDate_Approved_GrossTotal
- Variance_CommittedCostToDate_Approved_Subtotal_M
- Variance_CommittedCostToDate_Approved_Subtotal_L
- Variance_CommittedCostToDate_Approved_Subtotal_E
- Variance_CommittedCostToDate_Approved_Subtotal_S
- Variance_CommittedCostToDate_Approved_Subtotal_O
- Variance_CommittedCostToDate_Approved_Subtotal
- Variance_CommittedCostToDate_Approved_Total_M
- Variance_CommittedCostToDate_Approved_Total_L
- Variance_CommittedCostToDate_Approved_Total_E
- Variance_CommittedCostToDate_Approved_Total_S
- Variance_CommittedCostToDate_Approved_Total_O
- Variance_CommittedCostToDate_Approved_Total
- Percent_CommittedCostBudget_Subtotal
- Percent_CommittedCostBudget_Total
- Percent_CostToDateCostBudget_Gross
- Percent_CostToDateCostBudget_Subtotal
- Percent_CostToDateCostBudget_Total
- Percent_CostToDateCommittedCost_Gross
- Percent_CostToDateCommittedCost_Subtotal
- Percent_CostToDateCommittedCost_Total
- ERP_JobToDate_CostTotal
- RevenueBudget_Prime_Subtotal
- RevenueBudget_Prime_Total
- RevenueBudget_ApprovedCOs_Subtotal
- RevenueBudget_ApprovedCOs_Total
- RevenueBudget_Revised_Subtotal
- RevenueBudget_Revised_Total
- RevenueBudget_PendingCOs_Subtotal
- RevenueBudget_PendingCOs_Total
- RevenueBudget_ApprovedAndPendingCOs_Subtotal
- RevenueBudget_ApprovedAndPendingCOs_Total
- RevenueBudget_ApprovedCPRs_Subtotal
- RevenueBudget_ApprovedCPRs_Total
- RevenueBudget_PendingCPRs_Subtotal
- RevenueBudget_PendingCPRs_Total
- RevenueBudget_ApprovedAndPendingCPRs_Subtotal
- RevenueBudget_ApprovedAndPendingCPRs_Total
- PrimeInvoice_Approved_GrossTotal
- PrimeInvoice_Approved_Subtotal
- PrimeInvoice_Approved_Total
- PrimeInvoice_Approved_NetRetainage
- PrimeInvoice_Pending_GrossTotal
- PrimeInvoice_Pending_Subtotal
- PrimeInvoice_Pending_Total
- PrimeInvoice_Pending_NetRetainage
- Variance_RevenueCostBudget_Prime_Subtotal
- Variance_RevenueCostBudget_Prime_Total
- Variance_RevenueCostBudget_ApprovedCO_Subtotal
- Variance_RevenueCostBudget_ApprovedCO_Total
- Variance_RevenueCostBudget_Revised_Subtotal
- Variance_RevenueCostBudget_Revised_Total
- Variance_RevenueBudgetCommittedCost_Approved_Subtotal
- Variance_RevenueBudgetCommittedCost_Approved_Total
- Variance_RevenueBudgetCostToDate_Approved_Subtotal
- Variance_RevenueBudgetCostToDate_Approved_Total
- Variance_RevenueBudgetCostToDate_Approved_Subtotal_OnBillRates
- Variance_RevenueBudgetCostToDate_Approved_Total_OnBillRates
- Variance_RevenueBudgetPrimeInvoice_Approved_GrossTotal
- Variance_RevenueBudgetPrimeInvoice_Approved_Subtotal
- Variance_RevenueBudgetPrimeInvoice_Approved_Total
- Variance_PrimeInvoiceCostToDate_Approved_GrossTotal
- Variance_PrimeInvoiceCostToDate_Approved_Subtotal
- Variance_PrimeInvoiceCostToDate_Approved_Total
- Percent_PrimeInvoiceRevenueBudget_Approved_Gross
- Percent_PrimeInvoiceRevenueBudget_Approved_Subtotal
- Percent_PrimeInvoiceRevenueBudget_Approved_Total
- Percent_ProfitMargin_PrimeInvoiceCostToDate_Approved_Gross
- Percent_ProfitMargin_PrimeInvoiceCostToDate_Approved_Subtotal
- Percent_ProfitMargin_PrimeInvoiceCostToDate_Approved_Total
- Percent_ProfitMarkup_PrimeInvoiceCostToDate_Approved_Gross
- Percent_ProfitMarkup_PrimeInvoiceCostToDate_Approved_Subtotal
- Percent_ProfitMarkup_PrimeInvoiceCostToDate_Approved_Total
- HourBudget_Prime_L
- HourBudget_ApprovedCOs_L
- HourBudget_Revised_L
- HourBudget_PendingCOs_L
- HourBudget_ApprovedAndPendingCOs_L
- HourBudget_ApprovedCPRs_L
- HourBudget_PendingCPRs_L
- HourBudget_ApprovedAndPendingCPRs_L
- LbrTimecard_Approved_Hours
- LbrTimecard_Pending_Hours
- LbrTimecard_ApprovedAndPending_Hours
- Variance_HourBudgetTimecard_L
- Percent_TimecardHourBudget_L
- LbrTimecard_Approved_Total
- LbrTimecard_Approved_Total_OnBillRates
- Projected_Hours_L
- Projected_Cost_Total_L
- HourBudget_Prime_E
- HourBudget_ApprovedCOs_E
- HourBudget_Revised_E
- HourBudget_PendingCOs_E
- HourBudget_ApprovedAndPendingCOs_E
- HourBudget_ApprovedCPRs_E
- HourBudget_PendingCPRs_E
- HourBudget_ApprovedAndPendingCPRs_E
- EqpTimecard_Hours
- Variance_HourBudgetTimecard_E
- Percent_TimecardHourBudget_E
- EqpTimecard_Total
- EqpTimecard_Total_OnBillRates
- Projected_Hours_E
- Projected_Cost_Total_E