Accounting Balances Report - Row Fields
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 |