Data Views and Standard Log Reports - Bills

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_BillInfo
• vw_BillItems

Data Views - Optional

• vw_CompanyInfo
• vw_CompanyInfoSimple
• vw_ContactInfo
• vw_JobCostCodes
• vw_POInfo
• vw_POItems
• vw_ChangeOrderInfo
• vw_ChangeOrderInfoSimple
• vw_WorkOrderInfo
• vw_WorkOrderInfoSimple

Standard Log Reports - Cross Projects - Bills

Report Name	Filter Parameters
Cross Project - Bill Items Grouped by Manufacturer and Supplier	BillFromDate, BillToDate, Manufacturer, SupplierId, BillStatus
Cross Project - Bill Items Grouped by Resource Type	BillFromDate, BillToDate, SupplierId, BillStatus
Cross Project - Bills Grouped by Export Status, Supplier and Project	BillFromDate, BillToDate, Exported, SupplierId
Cross Project - Bills Grouped by Status and Supplier	BillFromDate, BillToDate, SupplierId, BillStatus, BillType
Cross Project - Bills Grouped by Supplier and Status	BillFromDate, BillToDate, SupplierId, BillStatus, BillType
Cross Project - Bills Grouped by Status and Supplier with Payment Info	BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus
Cross Project - Bills Grouped by Supplier and Status with Payment Info	BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus
Cross Project - Bills Grouped by Project Supplier and Status with Payment Info	BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus

Standard Log Reports - Individual Project - Bills

Report Name	Filter Parameters
Bill Items Grouped by Prime Contract, Manufacturer and Status	ProjectId, PrimeContractId, Manufacturer, BillStatus
Bill Items Grouped by Prime Contract, Status and Cost Code	ProjectId, PrimeContractId, BillStatus, JCCId
Bill Items Grouped by Prime Contract, Status and Division	ProjectId, PrimeContractId, BillStatus, JCCDivision
Bill Items Grouped by Prime Contract, Status and Owner Code	ProjectId, PrimeContractId, BillStatus, OwnerCostCodeId
Bill Items Grouped by Prime Contract, Supplier and Status	ProjectId, PrimeContractId, SupplierId, BillStatus
Bills Grouped by Contract, Status and Type with Payment Info	ProjectId, PrimeContractId, BillStatus, PaymentStatus
Bills Grouped by Prime Contract and CO	ProjectId, PrimeContractId, COId, BillStatus
Bills Grouped by Prime Contract and Status	ProjectId, PrimeContractId, BillStatus, BillType
Bills Grouped by Prime Contract and Status with Payment Info	ProjectId, PrimeContractId, BillStatus, BillType, PaymentStatus
Bills Grouped by Prime Contract and Supplier	ProjectId, PrimeContractId, BillStatus, BillType
Bills Grouped by Prime Contract, Status and Type	ProjectId, PrimeContractId, BillStatus