The available fields for this report are listed below alphabetically. Please note that Client, Engagement, Project and Resource level User Defined Fields are not available in this report.
Field | Field Category | Description |
---|---|---|
Balance Type | Transaction Fields | Time WIP, Cost WIP, or AP Clearing |
Client Name | Transaction Fields | Client name |
Client Number | Transaction Fields | Client number |
Company Name | Transaction Fields | Company name |
Company Number | Transaction Fields | Company number |
Cost Card Unique ID | Transaction Fields | The unique ID of the transaction's cost card |
Cost Center Name | Transaction Fields | Cost center name |
Cost Center Number | Transaction Fields | Cost center number |
Engagement | Engagement Fields |
|
Engagement Billable (Yes/No) | Engagement Fields | Yes if the engagement is a billable type |
Engagement Billing Address Attention | Engagement Fields |
|
Engagement Billing Address City | Engagement Fields |
|
Engagement Billing Address Company Name | Engagement Fields |
|
Engagement Billing Address Country | Engagement Fields |
|
Engagement Billing Address Line 1 | Engagement Fields |
|
Engagement Billing Address Line 2 | Engagement Fields |
|
Engagement Billing Address State/Province | Engagement Fields |
|
Engagement Billing Address Zip/PostalCode | Engagement Fields |
|
Engagement Busy (Yes/No) | Engagement Fields | Yes if the engagement is a busy type (which includes all billable types) |
Engagement Code | Engagement Fields |
|
Engagement Company | Engagement Fields | The name of the company associated with the engagement's cost center |
Engagement Manager | Engagement Fields |
|
Engagement Manager Display Name | Engagement Fields |
|
Engagement Manager Email Address | Engagement Fields |
|
Engagement Name | Engagement Fields |
|
Engagement Stage | Engagement Fields | Name of the engagement stage |
Engagement Type | Engagement Fields |
|
Expense Document Name | Expense Document Fields | Name of the expense report or vendor invoice |
Expense Document Number | Expense Document Fields | Identifying number associated with the expense report or vendor invoice |
Expense Document Type | Expense Document Fields | Expense Report, Vendor Invoice, or Soft Cost |
Expense Location | Cost Fields | Location in which the expense was incurred |
Expense Type | Transaction Fields | Expense type |
GL Account Number | Transaction Fields | G/L account number |
GL Cost Center Number | Transaction Fields | G/L cost center number |
GL Currency Code | Transaction Fields | G/L currency code |
Invoice Number | Transaction Fields | The invoice number when the transaction occurred. This can be different than the invoice's current invoice number. |
Payment Voucher Date | Payment Voucher Fields | Date on which the associated vendor invoices were presented for payment |
Payment Voucher Number | Payment Voucher Fields | Unique identifier for the payment voucher |
Payment Voucher Reconciliation Complete Flag | Payment Voucher Fields | Yes = reconciliation is complete |
Project | Project Fields |
|
Project Code | Project Fields |
|
Project Description | Project Fields | Limited to 255 characters to support Excel 2003. Please use the Report Web Services if you require the full description. |
Project Location | Project Fields |
|
Project Manager | Project Fields |
|
Project Manager Display Name | Project Fields |
|
Project Manager Email Address | Project Fields |
|
Project Name | Project Fields |
|
Project Stage | Project Fields | Name of the project stage |
Reconciliation Item Notes | Payment Voucher Fields | Payment voucher reconciliation item notes |
Resource Display Name | Resource Fields |
|
Resource Employee ID | Resource Fields |
|
Resource First Name | Resource Fields |
|
Resource Last Name | Resource Fields |
|
Resource Middle Name | Resource Fields |
|
Task Code | Transaction Fields | Task code |
Time Card Unique ID | Transaction Fields | The unique ID of the transaction's time card |
Transaction Date | Transaction Fields | Either the time card work date or the cost card incurred date |
Vendor Name | Vendor Fields |
|
Vendor Number | Vendor Fields |
|
Vendor's Invoice Date | Vendor Fields | Date of the vendor's invoice |
Vendor's Invoice Number (Expense Document) | Expense Document Fields | |
Vendor's Invoice Number (Payment Voucher) | Payment Voucher Fields | Vendor's invoice number as displayed on the payment voucher |
Work Location | Hours Fields | Location where the work was performed |