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 |
Copyright © 2023 Corecon Technologies, Inc.