Project Financial Analytics - APIs - V2 - Retainage

API Name: API_V2_Retainage


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

  • PrimeInvoice_Approved_GrossTotal
  • PrimeInvoice_Approved_Subtotal
  • PrimeInvoice_Approved_Total
  • PrimeInvoice_Approved_Retainage
  • PrimeInvoice_Approved_RetainageBilled
  • PrimeInvoice_Approved_NetRetainage

  • PrimeInvoice_Pending_GrossTotal
  • PrimeInvoice_Pending_Subtotal
  • PrimeInvoice_Pending_Total
  • PrimeInvoice_Pending_Retainage
  • PrimeInvoice_Pending_RetainageBilled
  • PrimeInvoice_Pending_NetRetainage

  • PrimeInvoice_ApprovedAndPending_GrossTotal
  • PrimeInvoice_ApprovedAndPending_Subtotal
  • PrimeInvoice_ApprovedAndPending_Total
  • PrimeInvoice_ApprovedAndPending_Retainage
  • PrimeInvoice_ApprovedAndPending_RetainageBilled
  • PrimeInvoice_ApprovedAndPending_NetRetainage

  • SubInvoice_Approved_GrossTotal
  • SubInvoice_Approved_Subtotal
  • SubInvoice_Approved_Total
  • SubInvoice_Approved_Retainage
  • SubInvoice_Approved_RetainageBilled
  • SubInvoice_Approved_NetRetainage

  • SubInvoice_Pending_GrossTotal
  • SubInvoice_Pending_Subtotal
  • SubInvoice_Pending_Total
  • SubInvoice_Pending_Retainage
  • SubInvoice_Pending_RetainageBilled
  • SubInvoice_Pending_NetRetainage

  • SubInvoice_ApprovedAndPending_GrossTotal
  • SubInvoice_ApprovedAndPending_Subtotal
  • SubInvoice_ApprovedAndPending_Total
  • SubInvoice_ApprovedAndPending_Retainage
  • SubInvoice_ApprovedAndPending_RetainageBilled
  • SubInvoice_ApprovedAndPending_NetRetainage