Data Views and Standard Log Reports - Sub Invoices

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_SubcontractInfo
• vw_SubcontractInfoSimple
• vw_SubInvoiceInfo
• vw_SubInvoiceInfoFinancialSummary
• vw_SubInvoiceItemsCostPlus
• vw_SubInvoiceItemsFLS
• vw_SubInvoiceItemsFLSHistory
• vw_SubInvoiceItemsUnitPrice
• vw_SubInvoiceItemsUnitPriceHistory
• vw_SubInvoiceJCCSummary

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo
• vw_JobCostCodes
• vw_ChangeOrderInfo
• vw_ChangeOrderInfoSimple
• vw_WorkOrderInfo
• vw_WorkOrderInfoSimple
• vw_SubcontractItemsFLS
• vw_SubcontractItemsUnitPrice
• vw_SCOInfo
• vw_SCOInfoSimple
• vw_SCOItems

Standard Log Reports - Cross Projects - Sub Invoices

Report Name	Filter Parameters
Cross Project - Approved Sub Invoice Retainage Balance by Project, Prime and Sub
Cross Project - Approved Sub Invoice Retainage Balance by Sub
Cross Project - Sub Invoices Grouped by Export Status, Subcontractor and Project	SubInvFromDate, SubInvToDate, Exported, SubCompanyId
Cross Project - Sub Invoices Grouped by Project and Subcontractor	SubInvFromDate, SubInvToDate, SubCompanyId, SubcontractType, SubInvStatus
Cross Project - Sub Invoices Grouped by Status and Subcontractor	SubInvFromDate, SubInvToDate, SubCompanyId, SubcontractType, SubInvStatus
Cross Project - Sub Invoices Grouped by Subcontractor and Status	SubInvFromDate, SubInvToDate, SubCompanyId, SubcontractType, SubInvStatus
Cross Project - Sub Invoices Grouped by Status and Subcontractor With Payment Info	SubInvFromDate, SubInvToDate, SubInvStatus, SubcontractType, PaymentStatus
Cross Project - Sub Invoices Grouped by Subcontractor and Status With Payment Info	SubInvFromDate, SubInvToDate, SubInvStatus, SubcontractType, PaymentStatus
Cross Project - Sub Invoices Grouped by Project Subcontractor and Status With Payment Info (Not completed)	SubInvFromDate, SubInvToDate, SubInvStatus, SubcontractType, PaymentStatus

Standard Log Reports - Individual Project - Sub Invoices

Report Name	Filter Parameters
Fixed Lump Sum Subcontract Item Invoice History	ProjectId, PrimeContractId, SubcontractId, JCCId, SubcontractItemId, SCOId
Sub Invoices Details by Contract, Division and Cost Code	ProjectId, PrimeContractId, SubInvStatus, JCCDivision
Sub Invoices Details by Contract, Status and Cost Code	ProjectId, PrimeContractId, SubInvStatus, JCCId
Sub Invoices Details by Contract, Status and Owner Code	ProjectId, PrimeContractId, SubInvStatus, OwnerCostCodeId
Sub Invoices Grouped by Prime, Status and Subcontract	ProjectId, PrimeContractId, SubcontractType, SubInvStatus
Sub Invoices Grouped by Prime, Status and Subcontract With Payment Info	ProjectId, PrimeContractId, SubcontractType, SubInvStatus, PaymentStatus
Sub Invoices Grouped by Subcontractor and Status With Payment Info	ProjectId, PrimeContractId, SubcontractType, SubInvStatus, PaymentStatus
Unit Price Subcontract Item Invoice History	ProjectId, PrimeContractId, SubcontractId, JCCId, SubcontractItemId, SCOId