Unbilled Summary (Inquiry)

The Unbilled Summary Inquiry allows you to review unbilled transactions that need to be billed on a project bill term.

This inquiry provides authorized users the ability to view attachments on documents. See attachments for more information.

Restrictions

The inquiry contains the following default restrictions:

Req'd	Restriction	Description
	From Posting Date	Enter or select a posting date. This is the first date in the date range to include open items. This field defaults to the current posting period.
	To Posting Date	Enter or select a posting date. This is the last date in the date range to include open items. This field defaults to the current posting period.
	From Transaction Date	Enter or select a transaction date. It is the first date in the date range to include transactions. This is an additional date used to further refine results returned from the Posting Date range.
	To Transaction Date	Enter or select a transaction date. It is the last date in the date range to include transactions. This is an additional date used to further refine results returned from the Posting Date range.
	Currency Type	Select a currency type. Available selections are Base Currency, Company Currency, and Project Currency.
	Project	Enter or select a project to further limit the list.
	Aging Criteria	Select the date that is used to create Aging Buckets in the inquiry and that is not used to restrict data. Available selections are Document Date and Transaction Date.
	Document Number	Enter or select a document instance based on the document number assigned to it.

The following optional restrictions are available:

Account Activity Type Bill Client Bill Cycle Bill Term Bill Term Contract Billable Task Biller Days Old Document Type Employee EVC Fee Type Home Company Home Organization Hours Type Labor / Expense Organization Map Organization Map Level Organization Posting Source Project

Project Administrator Project Client Project Client Parent Project Company Project Contract Project Director Project Manager Project Organization Project Owner Project Primary Location City Project Primary Location Country Project Primary Location State / Province Project Work Type Reviewed Task Task Company Task Manager Task Organization Transaction Location Vendor Working Organization

Bill Item Summary

The inquiry contains a first level of information for Bill Item Summary, which includes Project Code, Project Name, Task Code, Task Name, EVC Type, Employee / Vendor Code, Employee / Vendor Name, Posting Date, Transaction Date, Document Number, Cost, Effort, Quantity, Bill Effort, Bill Cost, Bill Quantity, Bill Term Code, and Bill Term Name. You can right-click on a line item to open an input document.

The following optional columns of information are available:

Activity Code Activity Name Activity Type Code Activity Type Name Bill Term Contract Code Bill Term Contract Name Billable Task Biller Code Biller Name Budget Category Code Budget Category Name Cost Basis Cost Rate Override Currency Code Days Old Employee / Vendor Code Employee / Vendor Name Employee Type Equipment Code Equipment Name Equipment Type Code Equipment Type Name Expense Report Category Code Expense Report Category Name External Reference Date External Reference Number Fee Type Code Fee Type Name Hold Cost Hold Effort Hold Quantity Home Company Code Home Company Name Home Organization Code Home Organization Name Hours Type Code Hours Type Name Labor / Expense Labor Bill Class Code Labor Bill Class Name Organization Map Level 2 Name Organization Map Level 3 Name Organization Map Level 4 Name Organization Map Level 5 Name Organization Map Level 6 Name Original Document Date Original Document Number Original Document Type Original Posting Date Original Posting Period Original Project Code Original Project Name Original Task Code Original Task Name Overtime Premium Effort Multiplier Project Administrator Code Project Administrator Name Project Business Unit Code Project Business Unit Name Project Client Code Project Client Name Project Client Parent Code Project Client Parent Name Project Company Code Project Company Name

Project Contract Code Project Contract Name Project Description Project Director Code Project Director Name Project Manager Code Project Manager Name Project Market Segment Code Project Market Segment Name Project Organization Code Project Organization Name Project Owner Code Project Owner Name Project Primary Location City Project Primary Location Country Code Project Primary Location Country Name Project Primary Location Name Project Primary Location State / Province Code Project Primary Location State / Province Name Project Primary Location Zip / Postal Code Project Service Line Code Project Service Line Name Project Status Project Work Type Code Project Work Type Name Regular Bill Cost Rate Regular Cost Rate Revenue Rule Reviewed Task Business Unit Code Task Business Unit Name Task Company Code Task Company Name Task Hierarchy Code Task Location Code Task Location Name Task Manager Code Task Manager Name Task Market Segment Code Task Market Segment Name Task Organization Code Task Organization Name Task Service Line Code Task Service Line Name Task Status Task Work Type Code Task Work Type Name Transaction Location City Transaction Location Country Code Transaction Location Country Name Transaction Location Name Transaction Location State / Province Code Transaction Location State / Province Name Unit Code Unit Measure Code Unit Measure Name Unit Name Unit Type Code Unit Type Name Working Company Code Working Company Name Working Organization Code Working Organization Name Write-off Cost Write-off Effort Write-off Quantity

Unbilled Detail

The inquiry also contains a second level of information for Unbilled Detail, which includes Document Number, Document Date, Document Type, Document Source, Quantity, Cost, and Effort. You can right-click on a line item to open an input document.

The following optional columns of information are available:

Document Suffix Code Document Suffix Name Hold Cost Hold Effort Hold Quantity Posting Date

Posting Period Process Time Write-off Cost Write-off Effort Write-off Quantity