Project Detail Results (Inquiry)
The Project Detail Inquiry allows you to view detail transactions posted to projects, which includes information such as labor hours, cost, and effort and expense and unit cost and effort by project and task.
This topic presents an explanation of each column presented output results from the Inquiry. Also, as presented in the Inquiry, the explanations are broken down by default / optional columns within.
|
Note: Information about calculations used to create the results may be answered by reviewing the metrics presented in the Business Calculations topic. |
Default Columns
| Column | Description / Calculation |
|---|---|
| Project Code | Displays the Project Code entered on the transaction. |
| Project Name | Displays the Project Name specified in Project Setup. |
| Task Code | Displays the Task Code entered on the transaction. |
| Task Name | Displays the Task Name specified in Project Setup. |
| EVC Type | Displays the EVC Type entered on the transaction. |
| Employee / Vendor / Client Code | Displays the Employee / Vendor / Client Code entered on the transaction. |
| Employee / Vendor / Client Name | Displays the Employee / Vendor / Client Name specified in the relevant EVC document setup. |
| Posting Date | Displays the Posting Date selected for the transaction. |
| Transaction Date | Displays the Transaction Date entered on the transaction. |
| Document Number | Displays the Document Number entered or generated for the transaction. |
| Cost | Displays the cost entered on the transaction. |
| Effort | Displays the effort calculated for the transaction. |
| Quantity | Displays the quantity if entered on the transaction. |
| Working Organization Code | Displays the Working Organization Code entered on the transaction. |
| Working Organization Name | Displays the Working Organization Name specified in Organization Setup. |
| Billable | Displays whether the transaction is Billable or not. |
| Unit Name | Displays the Unit Name specified in Unit Setup if the Unit code is entered on the transaction. |
Optional Columns
| Column | Description / Calculation |
|---|---|
| Account Code | Displays the Account Code entered or selected for the transaction. |
| Account Name | Displays the Account Name specified in Account Setup. |
| Activity Type Code | Displays the Activity Type Code entered or selected for the transaction. |
| Activity Type Name | Displays the Activity Type Name specified in Activity Type Setup. |
| Adjusted Effort | Displays the difference between Effort – Write-off/ons. |
| Bill Term Code | Displays the Bill Term Code entered or selected for the transaction. |
| Bill Term Name | Displays the Bill Term Name specified in Project Setup. |
| Biller Code | Displays the Biller Code entered or selected for the transaction. |
| Biller Name | Displays the Biller Name specified in Employee Setup. |
| Chargeable | Displays whether the transaction is Changeable or not. |
| Cost Basis | Displays the cost basis associated with the transaction. |
| Cost Rate | Displays the Cost Rate entered or selected for the transaction. |
| Cost Rate Override | Displays the Cost Rate Override entered or selected for the transaction. |
| Currency Code | Displays the Currency Code entered or selected for the transaction. |
| Document Date | Displays the Document Date entered or selected for the transaction. |
| Document Type | Displays the Document Type entered or selected for the transaction. |
| Effective Bill Cost | Displays the Effective Bill Cost entered or selected for the transaction. |
| Effective Bill Cost Rate | Displays the Effective Bill Cost Rate entered or selected for the transaction. |
| Effort Basis | Displays the effort basis associated with the transaction. |
| Effort Multiplier | Displays the Effort Multiplier selected for the transaction. |
| Effort Rate | Displays the Effort Rate selected for the transaction. |
| Equipment Code | Displays the Equipment Code entered or selected for the transaction. |
| Equipment Name | Displays the Equipment Name specified in Equipment Setup. |
| Equipment Type Code | Displays the Equipment Type Code entered or selected for the transaction. |
| Equipment Type Name | Displays the Equipment Type Name specified in Equipment Type Setup. |
| External Reference Date | Displays the External Reference Date entered or selected for the transaction. |
| External Reference Number | Displays the External Reference Number entered or selected for the transaction. |
| Fee Type Code | Displays the Fee Type Code entered or selected for the transaction. |
| Fee Type Name | Displays the Fee Type Name specified in Fee Type Setup. |
| Home Company Code | Displays the Home Company Code entered or selected for the transaction. |
|
|
Displays the Home Company Name specified in Company Setup. |
| Home Organization Code | Displays the Home Organization Code entered or selected for the transaction. |
| Home Organization Name | Displays the Home Organization Name specified in Organization Setup. |
| Hours Type Code | Displays the Hours Type Code entered or selected for the transaction. |
| Hours Type Name | Displays the Hours Type Name specified in Hours Type Setup. |
| Labor / Expense | Displays whether this transaction is Labor or Expense. |
| Labor Bill Class Code | Displays the Labor Bill Class Code entered or selected for the transaction. |
|
|
Displays the Labor Bill Class Name specified in Labor Bill Class Setup. |
| Organization Map Level Name(s) | Displays the name of the Map Level to which the Working Organization is assigned. |
| Overtime | Displays whether this transaction is Overtime or not. |
| Project Administrator Code | Displays the code of the Project Administrator specified in Project Setup. |
| Project Administrator Name | Displays the name of the Project Administrator specified in Employee Setup. |
| Project Business Unit Code | Displays the code of the Project Business Unit specified in Project Setup. |
| Project Business Unit Name | Displays the name of the Project Business Unit specified in Business Unit Setup. |
| Project Client Code | Displays the code of the Project Client specified in Project Setup. |
| Project Client Name | Displays the name of the Project Client specified in Client Setup. |
|
|
Displays the code of the Project Client Parent specified in Project Setup. |
| Project Client Parent Name | Displays the name of the Project Client Parent specified in Client Setup. |
| Project Company Code | Displays the code of the Project Company specified in Project Setup. |
| Project Company Name | Displays the name of the Project Company specified in Company Setup. |
| Project Contract Code | Displays the code of the Project Contract specified in Project Setup. |
| Project Contract Name | Displays the name of the Project Contract specified in Contract Setup. |
| Project Description | Displays the descriptive text entered about this transaction. |
| Project Director Code | Displays the code of the Project Director specified in Project Setup. |
| Project Director Name | Displays the name of the Project Director specified in Employee Setup. |
| Project Manager Code | Displays the code of the Project Manager specified in Project Setup. |
| Project Manager Name | Displays the name of the Project Manager specified in Employee Setup. |
| Project Market Segment Code | Displays the code of the Project Market Segment specified in Project Setup. |
| Project Market Segment Name | Displays the name of the Project Market Segment specified in Market Segment Setup. |
| Project Organization Code | Displays the Project Organization Code entered or selected for the transaction. |
| Project Organization Name | Displays the Project Organization Name specified in Organization Setup. |
| Project Owner Code | Displays the Project Owner Code entered or selected for the transaction. |
| Project Owner Name | Displays the Project Owner Name specified in Project Setup. |
| Project Primary Location City |
Displays the name of the Project Primary Location City specified in Project Setup. |
| Project Primary Location Country Code | Displays the code of the Project Primary Location Country code specified in Project Setup. |
| Project Primary Location Country Name | Displays the name of the Project Primary Location Country name specified in Country Setup. |
| Project Primary Location Name | Displays the name of the Project Primary Location specified in Location Setup. |
| Project Primary Location State / Province Code | Displays the code of the Project Primary Location State / Province specified in Project Setup. |
| Project Primary Location State / Province Name | Displays the name of the Project Primary Location State / Province specified in State / Province Setup. |
| Project Primary Location Zip / Postal Code | Displays the code of the Project Primary Location Zip / Postal specified in Project Setup. |
| Project Service Line Code | Displays the code of the Project Service Line specified in Project Setup. |
| Project Service Line Name | Displays the name of the Project Service Line specified in Service Line Setup. |
| Project Status | Displays the Project Status. |
| Project Work Type Code | Displays the code of the Project Work Type specified in Project Setup. |
| Project Work Type Name | Displays the name of the Project Work Type specified in Work Type Setup. |
| Regular Bill Cost Rate | Displays the Regular Bill Cost Rate entered or selected for the transaction. |
| Task Business Unit Code | Displays the code of the Task Business Unit specified in Project Setup. |
| Task Business Unit Name | Displays the name of the Task Business Unit specified in Business Unit Setup. |
| Task Company Code | Displays the code of the Task Company specified in Project Setup. |
| Task Company Name | Displays the name of the Task Company specified in Company Setup. |
| Task Hierarchy Code | Displays the code which is the concatenation of the current Task code with all of the up-level Task codes in the project hierarchy. |
| Task Location Code | Displays the code of the Task Location specified in Project Setup. |
| Task Location Name | Displays the name of the Task Location specified in Location Setup. |
| Task Manager Code | Displays the code of the Task Manager specified in Project Setup. |
| Task Manager Name | Displays the name of the Task Manager specified in Employee Setup. |
| Task Market Segment Code | Displays the code of the Task Market Segment specified in Project Setup. |
| Task Market Segment Name | Displays the name of the Task Market Segment specified in Market Segment Setup. |
| Task Organization Code | Displays the code of the Task Organization specified in Project Setup. |
| Task Organization Name | Displays the name of the Task Organization specified in Organization Setup. |
| Task Service Line Code | Displays the code of the Task Service Line specified in Project Setup. |
| Task Service Line Name | Displays the name of the Task Service Line specified in Service Line Setup. |
| Task Status | Displays the Task Status. |
| Task Work Type Code | Displays the code of the Task Work Type specified in Project Setup. |
| Task Work Type Name | Displays the name of the Task Work Type specified in Work Type Setup. |
| Transaction Location City |
Displays the name of the Location City as entered or selected for the transaction. |
| Transaction Location Country Code | Displays the code of the Location Country as entered or selected for the transaction. |
| Transaction Location Country Name | Displays the name of the Transaction Location Country as specified in Location Setup. |
| Transaction Location Name | Displays the name of the Transaction Location as specified in Location Setup. |
| Transaction Location State / Province Code | Displays the code of the Location State / Province as entered or selected for the transaction. |
| Transaction Location State / Province Name | Displays the name of the Transaction Location State / Province as specified in Location Setup. |
| Transaction Status |
Displays the Transaction Status. |
| Unbilled Cost | Displays the costs charged on the transaction that remain unbilled. |
| Unbilled Effort | Displays the effort recorded on the transaction that remains unbilled. |
| Unbilled Quantity | Displays the quantity recorded on the transaction that remains unbilled. |
| Unit Code | Displays the code of the Unit entered or selected for the transaction. |
| Unit Measure Code | Displays the code of the Unit Measure entered or selected for the transaction. |
| Unit Measure Name | Displays the name of the Unit Measure specified in Measure Setup. |
| Unit Type Code | Displays the code of the Unit Type entered or selected for the transaction. |
| Unit Type Name | Displays the name of the Unit Type specified in Unit Type Setup. |
| Working Company Code | Displays the code of the Working Company entered or selected for the transaction. |
| Working Company Name | Displays the name of the Working Company specified in Company Setup. |
| Write-off Cost | Displays the costs charged on the transaction that have been written off. |
| Write-off Effort | Displays the effort recorded on the transaction that has been written off. |
| Write-off Quantity | Displays the quantity charged on the transaction that has been written off. |