Columns for Invoice Transaction Detail Report

You can select the columns to display on your report.

Contents

Field Description
Billing Amount This column displays the billing value (billing extension) for the transaction.
Billing Status

This column displays the billing status of the transaction:

  • F: Final billed: The transaction has been billed to the client.
  • D: Deleted: The transaction was marked for deletion, included in a billing run, and deleted (the bill status is stored as O in the database.)
  • W: Written off: The transaction has been written off, and the invoice has been posted (the bill status is stored as X in the database)
  • N: Not billable: The transaction is not billable (the bill status is stored as F in the database, and the NonBill field is set to Y to differentiate these transactions from those with F that were actually billed to the client.)
Cost Amount This column displays the cost amount for the transaction. For labor, this is the cost amount for all labor hours (sum of the cost of regular, overtime, and secondary overtime hours).
Description

This column displays the following, based on the type of transaction:

  • Labor: Employee name
  • Employee expense: Employee last name, first name
  • Accounts payable expense: Invoice number, invoice date, and vendor name
  • Unit: Unit name, description, number of units, unit amount
Employee/Reference

This column displays the following, based on the type of transaction:

  • Labor: Employee number
  • Employee expense: EX + reference number
  • Accounts payable expense: AP + reference number
  • Unit: UN + reference number
  • Expense from other sources: <other source code> + reference number
Hours/Units For labor, this column displays the total number of hours (sum of regular, overtime, and secondary overtime hours).

For units, this column displays the number of units.

Phase This column displays the phase number associated with the transaction.
Project This column displays the number of the project that is associated with the transaction.
Row Count This column displays the row number of a line item.
Task This column displays the task number associated with the transaction.
Transaction Date This column displays the date on which the transaction was posted.