Data Views and Standard Log Reports - Work Orders (WO)
Data Views - Primary
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
- vw_WorkOrderItems
Data Views - Optional
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_PrimeInvoiceInfo
- vw_PrimeInvoiceItemsCostPlus
Standard Log Reports - Individual Project - Work Orders (WO)
Report Name | Filter Parameters |
WO Items Grouped by Prime Contract, Billable Status and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, WOBillableStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
WO Items Grouped by Prime Contract, Closed Status and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
WO Items Grouped by Prime Contract, Closed Status and Division | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCDivision, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
WO Items Grouped by Prime Contract, Closed Status and Owner Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, OwnerCostCodeId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
WO Items Grouped by Prime Contract, Issued To and Cost Code | ProjectId, PrimeContractId, EstORActual, WOApprovalStatus, WOClosedStatus, JCCId, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate |
Work Orders Grouped by Closed Status And Reference Field | ProjectId, PrimeContractId, EstORActual, Reference, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
Work Orders Grouped by Prime Contract and Closed Status | ProjectId, PrimeContractId, EstORActual, WOIssuedToCompanyId, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
Work Orders Grouped by Prime Contract, Billable Status and Type | ProjectId, PrimeContractId, EstORActual, WOType, WOApprovalStatus, WOClosedStatus, WOBillableStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
Work Orders Grouped by Prime Contract, Closed Status and Issued To | ProjectId, PrimeContractId, EstORActual, WOIssuedToCompanyId, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
Work Orders Grouped by Prime Contract, Closed Status and Type | ProjectId, PrimeContractId, EstORActual, WOType, WOApprovalStatus, WOClosedStatus, WOIssueFromDate, WOIssueToDate, WOStatusFromDate, WOStatusToDate, IncludeWODesc |
Copyright © 2023 Corecon Technologies, Inc.