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