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