Columns for Expense Detail Report

You can select the columns to display on your report.

Contents

Field Description
Bill Rate per Unit This column displays the amount to bill the client for each unit. If your firm uses date-based rates, the billing rate in effect at the time that the transaction was posted is the rate used.
Billing Currency Code This column displays the three-character code for the billing currency.
Billing Status This column displays the billing status of the labor hours. The following are the possible status settings:
  • B: Billable: The transaction is released and available for billing to the client.
  • D: To Be Deleted: The transaction is marked for deletion.
  • F: Final Billed: The transaction has been billed to the client.
  • H: Held: The transaction is being held temporarily to prevent billing to the client.
  • M: Modified: The transaction has been modified in some way from its original form.
  • N: Not Billable: The transaction is not billable.
  • O: Deleted: The transaction was marked for deletion, included in a billing run, and deleted.
  • R: Partial Hold/Released: Part of the transaction has been held or released.
  • T: Transferred: The transaction was moved from one project, phase, or task to another.
  • W: To Be Written Off: The transaction has been written off, but the invoice has not been posted.
  • X: Written Off: The transaction has been written off, and the invoice has been posted.
Cost Rate per Unit This column displays the cost amount per unit. If your firm uses date-based rates, the cost rate in effect at the time that the transaction was posted is the rate used.
Description This column displays the description of the transaction.
Description 1, Description 2 These columns display the descriptions for each transaction detail line. The following types of descriptions are stored for each transaction:
  • Description 1 is a general description of the transaction (for example, the name of the vendor for an accounts payable voucher).
  • Description 2 is a more specific description of the transaction (for example, the description entered during transaction entry for a single item on a voucher).
Fiscal Period This column displays the accounting period in which the transaction was posted.
Functional Currency Code This column displays the three-character code for the functional currency.
Invoice Number This column displays the billed invoice number of the transaction.
Line Number This column displays the voucher line number if the transaction type is one of the following:
  • AP: Accounts Payable voucher
  • CV: Accounts Payable disbursement
  • EX: Employee expense
Phase This column displays the phase number for the transaction.
Posting Sequence This column displays the posting sequence number of the transaction. Vantagepoint assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on.

To see a numbered list of all of the postings for the current accounting period, select Transaction Center > Posting Review in the Navigation pane.

Project This column displays the project number for the transaction.
Project Currency Code This column displays the three-character code for the project currency.
Reference Number This column displays the reference number, voucher number, or journal entry number for the transaction.
Row Count This column displays the row number of a line item.
Supporting Document This column displays the document icon to indicate that the transaction has one or more supporting documents. Click this icon to launch the supporting documents in the application you use to view .PDF files rather than in the standard report Preview window.
Task This column displays the task number associated with the transaction.
Transaction Amount This column displays the total amount of the transaction, expressed in the transaction currency.
Transaction Date This column displays the date on which the transaction was posted. There is one exception: If the detail is from the History Loading utility, this column displays the accounting period.
Transaction Organization This column displays the organization assigned to the project at the time of the transaction.
Transaction Type This column displays the two-letter abbreviation for the type of transaction (such as CD for cash disbursements, IN for invoices, AP for accounts payable vouchers, or EX for employee expense reports).
Transfer Phase For a labor adjustment, this column displays the phase from which the labor adjustment transaction was transferred.
Transfer Project If the transaction is a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred.
Transfer Task For a labor adjustment, this column displays the task from which the labor adjustment transaction was transferred.
Unit Quantity This column displays the number of units for the transaction.
Vendor Name This column displays the name of the vendor associated with expenses.
Vendor or Unit Number This column displays the vendor number if the transaction type is one of the following:
  • AP: Accounts Payable voucher
  • CV: Accounts Payable disbursement

This column displays the unit number for transactions involving units.

Vendor Organization This column displays the organization for which this vendor provides goods or services.
Voucher This column displays the voucher number for the transaction.