Project Financial Analytics - APIs - V1 - Details (aka Transaction Details)

  • Id

  • TransactionItemSource
  • TransactionSource
  • TransactionCategoryLevel1
  • TransactionCategoryLevel2
  • TransactionCategoryLevel3

  • ProjectId
  • ProjectNumber
  • ProjectTitle
  • ProjectBidContactName
  • ProjectSalesContactName
  • ProjectPMContactName
  • ProjectEstStartDateUtc
  • ProjectEstStartDateOrgLocal
  • ProjectEstFinishDateUtc
  • ProjectEstFinishDateOrgLocal

  • PrimeContractId
  • PrimeContractNumber
  • PrimeContractSubject
  • PrimeContractBillingType
  • PrimeContractBillingTypeValue
  • PrimeContractIssueDateUtc
  • PrimeContractIssueDateOrgLocal
  • PrimeContractStatus
  • PrimeContractStatusDateUtc
  • PrimeContractStatusDateOrgLocal
  • OwnerCompanyName
  • OwnerContact
  • PrimeCompanyName
  • PrimeContact
  • PrimeContractEstStartDateUtc
  • PrimeContractEstFinishDateUtc
  • PrimeContractEstStartDateOrgLocal
  • PrimeContractEstFinishDateOrgLocal

  • COId
  • CONumber
  • COSubject
  • COIssueDateUtc
  • COIssueDateOrgLocal
  • COStatusDateUtc
  • COStatusDateOrgLocal

  • WorkOrderId
  • WorkOrderNumber
  • WorkOrderSubject
  • WorkOrderIssueDateUtc
  • WorkOrderIssueDateOrgLocal
  • WorkOrderStatusDateUtc
  • WorkOrderStatusDateOrgLocal

  • JobCostCodeId
  • JobCostCodeOrderNumber
  • JobCostCode
  • JobCostCodeDescription
  • JobCostCodeQuantity
  • JobCostCodeUnit

  • JobCostCodeInternalDivision
  • JobCostCodeInternalDivisionDesc
  • JobCostCodeInternalMajor
  • JobCostCodeInternalMajorDesc
  • JobCostCodeInternalMinor
  • JobCostCodeInternalMinorDesc
  • JobCostCodeInternalSubMinor
  • JobCostCodeInternalSubMinorDesc

  • OwnerCostCode
  • OwnerCostCodeDescription

  • TransactionId
  • TransactionNumber
  • TransactionSubject
  • TransactionType
  • TransactionDateUtc
  • TransactionDateOrgLocal
  • TransactionStatus

  • TransactionCompanyId
  • TransactionCompanyName
  • TransactionCompanyCode
  • TransactionContactId
  • TransactionContact

  • TransactionExportStatus
  • TransactionExportId
  • TransactionExportDateUtc
  • TransactionExportDateOrgLocal

  • TransactionPaymentAmount

  • TransactionItemId
  • TransactionItemOrderNumber
  • TransactionItemDescription
  • TransactionItemQuantity
  • TransactionItemUnit
  • TransactionItemUnitPrice
  • TransactionItemUnitPrice2
  • TransactionItemGrossTotal
  • TransactionItemSubtotal
  • TransactionItemTaxId
  • TransactionItemTaxTotal
  • TransactionItemTotal
  • TransactionItemResourceType
  • TransactionItemBillableStatus
  • TransactionProjectMultiplier
  • TransactionOrgMultiplier
  • TransactionItemCreatedUtc
  • TransactionItemModifiedUtc