Data Views and Standard Log Reports - Prime Invoices

Data Views - Primary

  • vw_ProjectInfo
  • vw_ProjectInfoSimple
  • vw_PrimeContractInfo
  • vw_PrimeContractInfoSimple
  • vw_PrimeInvoiceInfo
  • vw_PrimeInvoiceInfoFinancialSummary
  • vw_PrimeInvoiceItemsCostPlus
  • vw_PrimeInvoiceItemsFLS
  • vw_PrimeInvoiceItemsFLSHistory
  • vw_PrimeInvoiceItemsUnitPrice
  • vw_PrimeInvoiceItemsUnitPriceHistory
  • vw_PrimeInvoiceJCCSummary

Data Views - Optional

  • vw_PrimeInvoiceCostPlusPreBillingDetails
  • vw_PrimeInvoiceCostPlusPreBillingSummary
  • vw_CompanyInfo
  • vw_CompanyInfoSimple
  • vw_ContactInfo
  • vw_JobCostCodes
  • vw_PrimeContractItemsFLSCostPlusGMP
  • vw_PrimeContractItemsUnitPrice
  • vw_ChangeOrderInfo
  • vw_ChangeOrderInfoSimple
  • vw_ChangeOrderItems
  • vw_WorkOrderInfo
  • vw_WorkOrderInfoSimple

Standard Log Reports - Cross Projects - Prime Invoices

Report Name Filter Parameters
Cross Project - Approved Prime Invoice Retainage Balance
Cross Project - Prime Invoices Grouped by Export Status, Owner and Project PrimeInvFromDate, PrimeInvToDate, Exported, OwnerId, PaymentStatus
Cross Project - Prime Invoices Grouped by Status and Project PrimeInvFromDate, PrimeInvToDate, Exported, OwnerId
Cross Project - Cost Plus Contracts - Unbilled Items Grouped by Project Contract Transaction Type and Company PrimeInvFromDate, PrimeInvToDate, Exported, OwnerId

Standard Log Reports - Individual Project - Prime Invoices

Report Name Filter Parameters
Cost Plus - Billed Items by Contract, Cost Code and Company ProjectId, PrimeContractId, JCCId, Company, TransactionType
Cost Plus - Billed Items by Contract, Transaction Type and Company ProjectId, PrimeContractId, TransactionType, Company, JCCId
Cost Plus - Prime Invoice Summary by Contract, Status and Transaction Type ProjectId, PrimeContractId, PrimeInvStatus
Cost Plus - Unbilled Items by Contract, Cost Code and Company ProjectId, BillableStatus, PrimeContractId, TransactionType, Company
Cost Plus - Unbilled Items by Contract, Transaction Type and Company ProjectId, BillableStatus, PrimeContractId, TransactionType, Company
Cost Plus - Unbilled Summary by Contract and Transaction Type ProjectId, BillableStatus, PrimeContractId, TransactionType, Company
Fixed Lump Sum - Prime Contract Item Invoice History ProjectId, PrimeContractId, JCCId, PrimeContractItemId, COId
Prime Invoice Details by Contract, Division and Cost Code ProjectId, PrimeContractId, PrimeInvStatus, JCCDivision
Prime Invoice Details by Contract, Status and Owner Code ProjectId, PrimeContractId, PrimeInvStatus, OwnerCostCodeId
Prime Invoices Details by Contract, Status and Cost Code ProjectId, PrimeContractId, PrimeInvStatus, JCCId
Prime Invoices Grouped by Contract and Status With Payment Info ProjectId, PrimeContractType, PrimeContractId, PrimeInvStatus, PaymentStatus
Prime Invoices Grouped by Prime Contract and Status ProjectId, PrimeContractType, PrimeContractId, PrimeInvStatus
Unit Price - Prime Contract Item Invoice History ProjectId, PrimeContractId, JCCId, PrimeContractUPItemId, COId