Data Views and Standard Log Reports - Subcontracts
Data Views - Primary
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_SubcontractInfo
- vw_SubcontractInfoSimple
- vw_SubcontractItemsFLS
- vw_SubcontractItemsUnitPrice
Data Views - Optional
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_ChangeOrderInfo
- vw_ChangeOrderInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
Standard Log Reports - Cross Projects - Subcontracts
| Report Name | Filter Parameters |
| Cross Project - Revised Subcontract Summary by Vendor | SubcontractFromDate, SubcontractToDate, SubcontractorCompanyId, BillingType |
Standard Log Reports - Individual Project - Subcontracts
| Report Name | Filter Parameters |
| Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Cost Code | ProjectId, PrimeContractId, SubcontractStatus, JCCId |
| Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Division | ProjectId, PrimeContractId, SubcontractStatus, JCCDivision |
| Fixed Lump Sum Subcontract Items Grouped by Prime, Status and Owner Code | ProjectId, PrimeContractId, SubcontractStatus, OwnerCostCodeId |
| Subcontracts and Approved SCOs Grouped By Prime and Billing Type | ProjectId, PrimeContractId |
| Subcontracts Grouped by Prime Contract and CO | ProjectId, PrimeContractId, COId, SubcontractStatus |
| Subcontracts Grouped by Prime Contract, Status and Billing Type | ProjectId, PrimeContractId, SubcontractStatus, BillingType |
| Unit Price Subcontract Items Grouped by Prime, Status and Cost Code | ProjectId, PrimeContractId, SubcontractStatus, JCCId |
Copyright © 2023 Corecon Technologies, Inc.