Project Financial Analytics - APIs - V2 - Overview By Transaction Type
API Name: API_V2_Transaction
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
- CostBudget_ApprovedCOs
- CostBudget_Revised
- CostBudget_PendingCOs
- CostBudget_ApprovedAndPendingCOs
- CostBudget_ApprovedCPRs
- CostBudget_PendingCPRs
- CostBudget_ApprovedAndPendingCPRs
- PO_Approved_Subtotal
- PO_Approved_Total
- PO_Pending_Subtotal
- PO_Pending_Total
- PO_ApprovedAndPending_Subtotal
- PO_ApprovedAndPending_Total
- PO_Approved_Open_Subtotal
- PO_Approved_Open_Total
- Bill_Approved_Subtotal
- Bill_Approved_Total
- Bill_Pending_Subtotal
- Bill_Pending_Total
- Bill_ApprovedAndPending_Subtotal
- Bill_ApprovedAndPending_Total
- Bill_NoPO_Approved_Subtotal
- Bill_NoPO_Approved_Total
- Bill_NoPO_Pending_Subtotal
- Bill_NoPO_Pending_Total
- Bill_NoPO_ApprovedAndPending_Subtotal
- Bill_NoPO_ApprovedAndPending_Total
- Subcontract_Approved_Subtotal
- Subcontract_Approved_Total
- Subcontract_Pending_Subtotal
- Subcontract_Pending_Total
- Subcontract_ApprovedAndPending_Subtotal
- Subcontract_ApprovedAndPending_Total
- SCO_Approved_Subtotal
- SCO_Approved_Total
- SCO_Pending_Subtotal
- SCO_Pending_Total
- SCO_ApprovedAndPending_Subtotal
- SCO_ApprovedAndPending_Total
- RevisedSubcontract_Approved_Subtotal
- RevisedSubcontract_Approved_Total
- RevisedSubcontract_Approved_Open_GrossTotal
- RevisedSubcontract_Approved_Open_Subtotal
- RevisedSubcontract_Approved_Open_Total
- SubInvoice_Approved_GrossTotal
- SubInvoice_Approved_Subtotal
- SubInvoice_Approved_Total
- SubInvoice_Approved_NetRetainage
- SubInvoice_Pending_GrossTotal
- SubInvoice_Pending_Subtotal
- SubInvoice_Pending_Total
- SubInvoice_Pending_NetRetainage
- SubInvoice_ApprovedAndPending_GrossTotal
- SubInvoice_ApprovedAndPending_Subtotal
- SubInvoice_ApprovedAndPending_Total
- SubInvoice_ApprovedAndPending_NetRetainage
- MiscExpense_Approved_Subtotal
- MiscExpense_Approved_Total
- MiscExpense_Pending_Subtotal
- MiscExpense_Pending_Total
- MiscExpense_ApprovedAndPending_Subtotal
- MiscExpense_ApprovedAndPending_Total
- LbrTimecard_Approved_Total
- LbrTimecard_Approved_Total_OnBillRates
- LbrTimecard_Pending_Total
- LbrTimecard_ApprovedAndPending_Total
- EqpTimecard_Total
- EqpTimecard_Total_OnBillRates
- AnticipatedCost_Total
- CommittedCost_Approved_Subtotal_NoCORef
- CommittedCost_Approved_Subtotal_WithCORef
- CommittedCost_Approved_Subtotal
- CommittedCost_Approved_Subtotal_OnBillRates
- CommittedCost_Approved_Total_NoCORef
- CommittedCost_Approved_Total_WithCORef
- CommittedCost_Approved_Total
- CommittedCost_Approved_Total_OnBillRates
- CommittedCost_Pending_Subtotal
- CommittedCost_Pending_Total
- CommittedCost_ApprovedAndPending_Subtotal
- CommittedCost_ApprovedAndPending_Total
- CostToDate_Approved_GrossTotal_NoCORef
- CostToDate_Approved_GrossTotal_WithCORef
- CostToDate_Approved_GrossTotal
- CostToDate_Approved_GrossTotal_OnBillRates
- CostToDate_Approved_Subtotal_NoCORef
- CostToDate_Approved_Subtotal_WithCORef
- CostToDate_Approved_Subtotal
- CostToDate_Approved_Subtotal_OnBillRates
- CostToDate_Approved_Total_NoCORef
- CostToDate_Approved_Total_WithCORef
- CostToDate_Approved_Total
- CostToDate_Approved_Total_OnBillRates
- CostToDate_Pending_GrossTotal
- CostToDate_Pending_Subtotal
- CostToDate_Pending_Total
- CostToDate_ApprovedAndPending_GrossTotal
- CostToDate_ApprovedAndPending_Subtotal
- CostToDate_ApprovedAndPending_Total
- Projected_Cost_GrossTotal
- Projected_Cost_GrossTotal_Without_Anticipated
- Projected_Cost_GrossTotal_Without_ProjectedLbrEqp
- Projected_Cost_GrossTotal_Without_AnticipatedAndProjectedLbrEqp
- Variance_CostBudgetCommitted_Revised_Subtotal
- Variance_CostBudgetCommitted_Revised_Total
- Variance_CostBudgetCostToDate_Revised_GrossTotal
- Variance_CostBudgetCostToDate_Revised_Subtotal
- Variance_CostBudgetCostToDate_Revised_Total
- Variance_CostBudgetProjectedCost_Revised_GrossTotal
- Variance_CostBudgetProjectedCost_Revised_GrossTotal_Without_Anticipated
- Variance_CostBudgetProjectedCost_Revised_GrossTotal_Without_ProjectedLbrEqp
- Variance_CostBudgetProjectedCost_Revised_GrossTotal_Without_AnticipatedAndProjectedLbrEqp
- Variance_CommittedCostToDate_Approved_GrossTotal
- Variance_CommittedCostToDate_Approved_Subtotal
- 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_ProfitMargin_RevenueCostBudget_Revised_Subtotal
- Percent_ProfitMargin_RevenueCostBudget_Revised_Total
- Percent_ProfitMarkup_RevenueCostBudget_Revised_Subtotal
- Percent_ProfitMarkup_RevenueCostBudget_Revised_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_NoCORef
- LbrTimecard_Approved_Hours_WithCORef
- LbrTimecard_Approved_Hours
- LbrTimecard_Pending_Hours_NoCORef
- LbrTimecard_Pending_Hours_WithCORef
- LbrTimecard_Pending_Hours
- LbrTimecard_ApprovedAndPending_Hours_NoCORef
- LbrTimecard_ApprovedAndPending_Hours_WithCORef
- LbrTimecard_ApprovedAndPending_Hours
- Variance_HourBudgetTimecard_L
- Percent_TimecardHourBudget_L
- 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_NoCORef
- EqpTimecard_Hours_WithCORef
- EqpTimecard_Hours
- Variance_HourBudgetTimecard_E
- Percent_TimecardHourBudget_E
- Projected_Hours_E
- Projected_Cost_Total_E