Data Views and Standard Log Reports - Purchase Orders (PO)

Data Views - Primary

• vw_ProjectInfo
• vw_ProjectInfoSimple
• vw_PrimeContractInfo
• vw_PrimeContractInfoSimple
• vw_POInfo
• vw_POItems

Data Views - Optional

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

Standard Log Reports - Cross Projects - POs

Report Name	Filter Parameters
Cross Project - PO Open Balance Details by Manufacturer, Project and Supplier	POFromDate, POToDate, Manufacturer, SupplierId, POItemCompleteStatus
Cross Project - PO Open Balance Summary by Supplier	POFromDate, POToDate, SupplierId, POCompleteStatus

Standard Log Reports - Individual Project - POs

Report Name	Filter Parameters
PO Items Grouped by Prime Contract, Manufacturer and Status	ProjectId, PrimeContractId, Manufacturer, POStatus
PO Items Grouped by Prime Contract, Status and Cost Code	ProjectId, PrimeContractId, POStatus, JCCId
PO Items Grouped by Prime Contract, Status and Division	ProjectId, PrimeContractId, POStatus, JCCDivision
PO Items Grouped by Prime Contract, Status and Owner Code	ProjectId, PrimeContractId, POStatus, OwnerCostCodeId
PO Items Grouped by Prime Contract, Supplier and Status	ProjectId, PrimeContractId, SupplierId, POStatus
PO Open Balance Details by Contract and Supplier	ProjectId, PrimeContractId, SupplierId, POItemCompleteStatus
PO Open Balance Details by Contract, Supplier and Cost Code	ProjectId, PrimeContractId, JCCId, SupplierId, POItemCompleteStatus
PO Open Balance Summary by Prime Contract and Supplier	ProjectId, PrimeContractId, SupplierId, POType, POCompleteStatus
POs Grouped by Prime Contract and CO	ProjectId, PrimeContractId, COId, POStatus
POs Grouped by Prime Contract and Status	ProjectId, PrimeContractId, POType, POStatus
POs Grouped by Prime Contract and Supplier	ProjectId, PrimeContractId, SupplierId, POType, POStatus
POs Grouped by Prime Contract, Status and Type	ProjectId, PrimeContractId, POType, POStatus