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