Accounting Analysis Report - Row Fields
The available fields for this report are listed below alphabetically. The following UDFs are available. Client, Engagement, Project, Resource, Time Card, and Cost Card.
Field | Field Category | Description |
|---|---|---|
Accounting Period Code | Transaction Fields | Accounting period code |
Accounting Period Name | Transaction Fields | Accounting period name |
Accounting System Voucher Number | Transaction Fields | Accounting system identifier for the transaction |
Client Name | Client Fields | Client name |
Client Number | Client Fields | Client number |
Company Name | Transaction Fields | Company name |
Company Number | Transaction Fields | Company number |
Confirmed Timestamp | Transaction Fields | Time that the accounting system confirmed the transaction |
Cost Card Description | Cost Card Fields | Cost Card Description |
Cost Center Name | Transaction Fields | Cost center name |
Cost Center Number | Transaction Fields | Cost center number |
Credit Memo (Y/N) | Invoice Fields | Yes = this is a credit memo transaction |
Details Exist (Y/N) | Transaction Fields | Yes if there are detail records associated with the transaction |
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 Company Number | Engagement Fields | The number of the company associated with the engagement's cost center |
Engagement Cost Center Name | Engagement Fields |
|
Engagement Cost Center Number | Engagement Fields |
|
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 accountnumber |
GL Cost Center Number | Transaction Fields | G/L cost center number |
GL Currency Code | Transaction Fields | G/L currency code |
Invoice Number | Transaction Fields | Invoice number |
Operating Period Code | Transaction Fields | Operating period code |
Operating Period Name | Transaction Fields | Operating period name |
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 End Date | Project Fields | The latest date for which time or cost can be incurred for this project |
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 |
| Project Start Date | Project Fields | The earliest date for which time or cost can be incurred for this project |
Projector Transaction Number | Transaction Fields | Projector identifier for the transaction |
Reconciliation Item Notes | Payment Voucher Fields | Payment voucher reconciliation item notes |
Resource Company | Resource Fields | The name of the company associated with the resource's cost center |
Resource Company Number | Resource Fields | The number of the company associated with the resource's cost center |
Resource Cost Center Name | Resource Fields |
|
Resource Cost Center Number | Resource Fields |
|
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 |
|
Time Card Description | Time Card Fields | Time Card Description |
Transaction Action | Transaction Fields | Approve, Unapprove, Issue, Void |
Transaction Batch Close Time | Transaction Fields | Time that the batch was closed (applies to G/L transactions only) |
Transaction Batch Number | Transaction Fields | Sequentially assigned batch number. |
Transaction Date | Transaction Fields | Either the time card work date or the cost card incurred date |
Transaction Notes | Transaction Fields | Notes associated with the transaction |
Transaction Record Code | Transaction Fields | Unique identifier for the transaction record. There can be more than one transaction record per transaction for GL transactions. |
Transaction Status | Transaction Fields | Pending, Transmitted, Confirmed, Failed, or Void |
Transaction Subtype | Transaction Fields | Direct, Intercompany, Time WIP, Cost WIP, etc. |
Transaction Type | Transaction Fields | GL, AR, or AP |
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 as displayed on the vendor invoice |
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 |