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