Transaction Base
Use this base to see information about each transaction, such as transaction type, activity type, date, project ID and description, and cost and spent amounts.
| Available Columns | Description | Date Range Available | Chartable | Links to Page |
| General Information | ||||
|
Activity Type Value |
The numeric value for activity type. Examples: Labor = 1, Expense = 2, and Consultant = 3 |
|||
| Activity Type |
The activity type associated with the transaction Examples: Consultant, Expense, Labor |
|||
| Activity |
The type of work or expense associated with the transaction You use an activity for establishing billing rates, invoicing, and reporting. Examples: Billable Time, Administration, Project Management |
Activity | ||
| Beginning Balance Type |
The type of beginning balance associated with the transaction Examples: Open Vendor Invoice, Unpaid Client Invoice, Unbilled WIP |
|||
| Client Invoice Employee Type | The name of the employee type associated with the transaction on the client invoice | Employee Type | ||
| Client Invoice Number | The user-provided alphanumeric identifier of the client invoice associated with the transaction | Client Invoice | ||
| Client Invoice Status |
The status of the client invoice associated with the transaction Examples: Draft, Approved, Hold, Final |
Client Invoice | ||
| Client Type | The client type associated with the transaction | Client Type | ||
| Client | The client associated with the transaction | Client | ||
| Company Name | The name of the company associated with the transaction | Company | ||
| Employee Company Name | The name of the company linked to the employee associated with the transaction | Company | ||
| Employee Department Name | The department of the employee associated with the transaction | Department | ||
| Employee Status | The status of the employee associated with the transaction | |||
| Employee Type |
The employee type associated with the transaction Examples: Architect, Project Manager, Principal, Administration |
Employee Type | ||
| Expense Credit Card | The expense credit card associated with the transaction | GL Activity | ||
| Expense Payee | The recipient of the payment for the expense associated with the transaction | |||
| Expense Personal Item |
Indicates whether the expense associated with the transaction is a personal expense 1 indicates that it is; 0 indicates that it is not. |
|||
| Expense Reference | The number used to group the expense associated with the transaction on the credit card bank register | Expense Report | ||
| Expense Report Company Name | The name of the company linked to the expense report associated with the transaction | Company | ||
| Expense Report Row | The row in the expense report associated with the transaction | Expense Report | ||
| In-house Expense Report Company Name | The name of the company linked to the in-house expense associated with the transaction | Company | ||
| Invoice Group | The invoice group associated with the transaction | |||
| Is Cost | Indicates whether the transaction is a cost | |||
| Is Current | Indicates whether the transaction is current | |||
| Is Deleted | Indicates whether the transaction is deleted | |||
| Is Effective Cost | Indicates whether the transaction is part of effective cost | |||
| Is Exempt | Indicates whether the transaction is exempt. (Alabama state only) | |||
| Is Fee | Indicates whether the transaction is a fee | |||
| Is Imported | Indicates whether the transaction was created from an import | |||
| Is Invoiced | Indicates whether the transaction has been added to a client invoice | X | ||
| Is Non 1099 | Indicates whether the transaction is a non 1099 transaction | |||
| Is Personal Expense | Indicates whether the transaction is a personal expense | |||
| Is Salary |
Indicates if the employee is salaried based on the transaction date |
|||
| Is Time Rejected | Indicates whether the transaction is rejected time | |||
| Is Utilization | Indicates if the transaction is used in employee utilization | |||
| Is WIP | Indicates whether the transaction is work-in-progress | |||
| Is Writeoff | Indicates whether the transaction is a write-off | |||
| Local | Indicates whether the transaction is part of Local tax | |||
| Manager Notes |
Any notes from the manager about the transaction Applies to timesheet and expense report transactions |
|||
| Markup Accumulate 2 | Indicates if a markup is applied to the cost plus previously applied markups, not just the cost | |||
| Markup Accumulate 3 | Indicates if a markup is applied to the cost plus previously applied markups, not just the cost | |||
| Markup Accumulate 4 | Indicates if a markup is applied to the cost plus previously applied markups, not just the cost | |||
| Markup Accumulate 5 | Indicates if a markup is applied to the cost plus previously applied markups, not just the cost | |||
| Notes | Any notes about the transaction | |||
| Overhead Group | The name of the overhead group associated with the transaction | |||
| Pay Description | The description of the pay associated with the transaction | |||
| Pay Type | The assigned pay type | |||
| Paycheck Status |
The status of the paycheck associated with the transaction Examples: Preliminary, Processed, Paid, Void |
|||
| Payroll Company Name | The name of the company linked to the paycheck associated with the transaction | Company | ||
| Phase Department Name | The name of the phase department associated with the transaction | Department | ||
| Phase Description | The description of the phase associated with the transaction | Phase | ||
| Phase ID & Description | The ID and description of the phase associated with the transaction | Phase | ||
| Phase ID | The ID of the phase associated with the transaction | Phase | ||
| Phase Order | The order of the phase associated with the transaction | Phase | ||
| Phase Status | The name of the phase department associated with the transaction | |||
| Project Company Name | The name of the company associated with the project | Company | ||
|
Project Description |
The description of the project associated with the transaction | Project | ||
| Project ID & Description | The ID and description of the project associated with the transaction | Project | ||
| Project ID | The ID of the project associated with the transaction | Project | ||
| Project Status |
The status of the project associated with the transaction |
|||
| Project Type |
The type of project associated with the transaction Examples: Commercial, Educational Facilities, Environmental Planning, Interiors, Medical Facilities, Residential |
Project Type | ||
| Purchase Order Detail Description | The description of the purchase order detail | |||
| Purchase Order Number | The number of the purchase order | |||
| State |
Applies only when you set up Ajera to process withholding for multiple states. The state for state withholding assigned to the transaction. |
|||
| Status |
The status of the transaction Examples: Billable, Nonbillable, Hold |
|||
| Time Approval Status | Shows whether the time submitted for the transaction is approved, rejected, or neither | |||
| Timesheet Company Name | The name of the company linked to the timesheet associated with the transaction | Company | ||
| Timesheet Overhead Group Detail | The name of the overhead item associated with the transaction | |||
| Timesheet Row | The timesheet row associated with the transaction | |||
| Transaction Type |
The type of transaction Examples: Worksheet, Entry, Expense Report Advance |
|||
| Utilization Description |
The name of the utilization type associated with the transaction Utilization types define employee time as direct or indirect, such as direct, sick, vacation, or marketing |
|||
| Utilization Order | The order of the utilization type associated with the transaction | |||
| Vendor Invoice Company Name | The name of the company linked to the vendor invoice associated with the transaction | Company | ||
| Vendor Invoice Description | The description of the vendor invoice associated with the transaction | Vendor Invoice | ||
| Vendor Invoice Notes | Any notes for the vendor invoice associated with the transaction | |||
| Vendor Invoice Number | The user-provided alphanumeric identifier of the vendor invoice associated with the transaction | |||
| Vendor Invoice On Hold | Indicates whether the vendor invoice associated with the transaction is on hold | |||
| Vendor Type | The vendor type associated with the transaction | |||
| Vendor | The vendor associated with the transaction | Vendor | ||
| People | ||||
| Billing Contact | The billing contact associated with the transaction | Contact | ||
| Billing Manager | The billing manager associated with the transaction | Employee | ||
| Employee | The name of the employee associated with the transaction | Employee | ||
| Expense Rejected By | The name of the employee who rejected the expense associated with the transaction | Employee | ||
| Principal In Charge | The principal associated with the transaction | Project Manager | ||
| Project Manager Approved | Indicates if the transaction has been approved by a project manager | Project Manager | ||
| Project Manager | The project manager associated with the transaction | Project Manager | ||
| Supervisor | The supervisor of the employee associated with the transaction | Employee | ||
| Time Rejected By | The name of the employee who rejected the time submitted for the transaction | Employee | ||
| Dates | ||||
| Client Invoice Cutoff Date | The date on the client invoice that determines when the transaction is billed to the client | Client Invoice | ||
| Client Invoice Date | The date of the client invoice associated with the transaction | Client Invoice | ||
| Date | The date of the transaction | Transaction | ||
| Expense Rejected Date | The date of the expense report rejection associated with the transaction | |||
| Pay Date | The date the paycheck associated with the transaction was paid | Paycheck | ||
| Project Manager Approved Date | The date of the project manager approval associated with the transaction | |||
| Time End Time | The time when the timer on the timesheet was stopped for the transaction | |||
| Time Rejected By Date | The date when the time submitted for the transaction was rejected | |||
| Time Start Time | The time when the timer on the timesheet was started for the transaction | |||
| Timesheet Date | The end date of the timesheet associated with the transaction | Timesheet | ||
| Vendor Invoice Accounting Date | The reporting date Ajera uses for the vendor invoice associated with the transaction | |||
| Vendor Invoice Date | The date of the vendor invoice associated with the transaction | Vendor Invoice | ||
| Hours/Units | ||||
| Billed Units/Hours | The number of units or hours billed for the transaction | X | X | |
| Hours Type |
The type of time associated with the hours worked on the transaction Examples: Regular, Premium 1 |
|||
| Premium 1 Hours | The number premium 1 hours associated with the transaction | X | X | |
| Premium 2 Hours | The number premium 2 hours associated with the transaction | X | X | |
| Premium 3 Hours | The number premium 3 hours associated with the transaction | X | X | |
| Regular Hours | The number regular hours associated with the transaction | X | X | |
| Units/Hours | The number of hours or units required to complete the transaction | X | X | |
| WIP Hours | The total number of WIP hours associated with the transaction | X | X | |
| Written off Hours | The total number of write-off hours associated with the transaction | X | X | |
| Dollars | ||||
| Billed Adjustments | The amount of billed adjustments for the transaction | X | X | |
| Billed Amount | The amount billed for the transaction | X | X | |
| Billed Rate |
The rate used to bill a client for work or expenses incurred for a transaction Ajera determines the billing rate from the billing rate table. |
|||
| Billing Rounding Adjustment | The amount Ajera adjusts the billed amount of the transaction on the client invoice so that the invoice total matches the total of the subtotals | X | ||
| Billed Sales Tax Amount | The amount of billed sales tax for the transaction | X | X | |
| Billing Cost Amount | When a billing rate is determined as a multiple of cost, this is the total amount for the transaction based on that billing rate | X | X | |
| Billing Cost Rate | When a billing rate is determined as a multiple of cost, this is the cost rate that is multiplied to calculate the billing rate for the transaction | |||
| Cash Fringe Amount | The amount of cash fringe for the transaction | X | X | |
| Cost + DPE + OH | The cost amount of the transaction + the direct personal expense + the overhead amount | |||
| Cost + Premium + DPE + OH | The cost amount of the transaction + the premium cost + the direct personal expense + the overhead amount | |||
| Cost + Premium Amount Burdened | The cost amount of the transaction + the premium cost + the overhead amount | X | X | |
| Cost + Premium |
The cost amount Closed of the transaction + the premium costClosed This does not include any markups. |
X | X | |
| Cost Amount Burdened | The cost amount of the transaction + the overhead amount | X | X | |
| Cost Amount | The amount paid to employees for work performed or for out-of-pocket costs for expenses and consultants for the transaction | X | X | |
| Cost Rate | The rate that reflects the actual cost of the transaction without overhead or profit | |||
| Fringe Rate | The fringe rate for the transaction | |||
| Labor Activity Add-on Amount |
The activity specific add-on to any labor billing rate calculated, if used. |
X | ||
| Labor Activity Add-on Rate | The activity specific add-on rate, if used | X | ||
| Labor Add-on Amount | A flat amount added to any labor billing rate calculated. If used | X | ||
| Labor Add-on Rate | The rate used for the labor add-on | X | ||
| Labor DPE Rate | The percentage to mark up labor to reflect the cost of direct personnel expense associated with the transaction | |||
| Labor Overhead Rate | The percentage to mark up labor to reflect the cost of overhead associated with the transaction | |||
| Markup Amount 1 | The amount added to a cost amount to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Amount 2 | The amount added to a cost amount to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Amount 3 | The amount added to a cost amount to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Amount 4 | The amount added to a cost amount to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Amount 5 | The amount added to a cost amount to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Rate 1 | An increase to a cost by a specified percentage to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Rate 2 | An increase to a cost by a specified percentage to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Rate 3 | An increase to a cost by a specified percentage to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Rate 4 | An increase to a cost by a specified percentage to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Markup Rate 5 | An increase to a cost by a specified percentage to reflect direct personnel expense, overhead, and/or profit for the transaction | |||
| Payroll Cost Burdened w/Exp & Cons |
The payroll cost of labor for the transaction with overhead and DPE costs included, plus expenses and consultants Payroll cost is the total sum of money to be paid out to employees at a given time. |
X | X | |
| Payroll Cost w/Exp & Cons |
The payroll cost of labor for the transaction without overhead and DPE costs, plus expenses and consultants Payroll cost is the total sum of money to be paid out to employees at a given time. |
X | X | |
| Premium Cost | The cost amount of representing the increase to the employee's pay to reflect pay for hours entered as premium time (such as overtime and double time) for the transaction | X | X | |
| Premium Markup Rate | The percentage by which special types of hourly rates, such as overtime or double time, are marked up for the transaction | |||
| Sales Tax Amount | The amount of sales tax calculated for the transaction | X | X | |
| Spent Amount |
The total amount of expense expended on the transaction at the billing rates/markup Ajera determines the spent amount from the billing rate table. |
X | X | |
| Spent Rate | The rate at which time and expense were expended on the transaction at the billing rates | |||
|
Vendor Amount To Pay |
The amount to pay on the vendor payment associated with the transaction | X | X | |
| Vendor Amount To Write-Off | The amount to write off on the vendor payment associated with the transaction | X | X | |
| WIP Amount | The amount of WIP associated with the transaction | X | X | |
| Written off Amount | The total amount of write-off associated with the transaction | X | X | |
| Keys | ||||
| Activity Key | The database identifier of the activity associated with the transaction | Activity | ||
| Billing Contact Key | The database identifier of the billing contact associated with the transaction | Contact | ||
| Billing Manager Key | The database identifier of the billing manager associated with the transaction | Employee | ||
| Client Invoice Employee Type Key | The database identifier of the employee type associated with the transaction on the client invoice | Employee Type | ||
| Client Invoice Key | The database identifier of the client invoice associated with the transaction | Client Invoice | ||
| Client Key | The database identifier of the client associated with the transaction | Client | ||
| Client Type Key | The database identifier of the client type associated with the transaction | Client Type | ||
| Company Key | The database identifier of the company associated with the transaction | Company | ||
| Credit Card Import Detail Key | The database identifier of the credit card import detail | |||
| Employee Company Key | The database identifier of the company linked to the employee associated with the transaction | Company | ||
| Employee Department Key | The database identifier of the department of the employee associated with the transaction | Department | ||
| Employee Key | The database identifier of the employee associated with the transaction | Employee | ||
| Employee Type Key | The database identifier of the employee type associated with the transaction | Employee Type | ||
| Expense Credit Card Key | The database identifier of the credit card used to charge the expense associated with the transaction | GL Account | ||
| Expense Rejected By Key | The database identifier of the employee who rejected the expense associated with the transaction | Employee | ||
| Expense Report Company Key | The database identifier of the expense report company associated with the transaction | Company | ||
| Expense Report Key | The database identifier of the expense report associated with the transaction | Expense Report | ||
| In-house Expense Company Key | The database identifier of the company linked to the in-house expense associated with the transaction | Company | ||
| In-house Expense Log Key | The database identifier of the in-house expense associated with the transaction | In-house Expense | ||
| Invoice Group Key | The database identifier of the invoice group associated with the transaction | |||
| Original Transaction Key | The original database identifier of the transaction | Transaction | ||
| Pay Key | The database identifier of the pay associated with the transaction | |||
| Paycheck Key | The database identifier of the paycheck associated with the transaction | Paycheck | ||
| Payroll Company Key | The database identifier of the company linked to the paycheck associated with the transaction | Company | ||
| Phase Department Key | The database identifier of the department for the phase that is associated with the transaction | Department | ||
| Phase Key | The database identifier of the phase associated with the transaction | Phase | ||
| PR Service Vendor Invoice Key |
The database identifier of the payroll service vendor invoice associated with the transaction This is used when you outsource payroll and create an payroll service vendor invoice. |
|||
| Principal In Charge Key | The database identifier of the principal associated with the transaction | Project Manager | ||
| Project Company Key | The database identifier of the company associated with the project | Company | ||
| Project Key | The database identifier of the project associated with the transaction | Project | ||
| Project Manager Approved Key | The database identifier of the project manager who approved the timesheet associated with the transaction | Project Manager | ||
| Project Manager Key | The database identifier of the project manager associated with the transaction | Project Manager | ||
| Project Type Key | The database identifier of the type of project associated with the transaction | Project Type | ||
| Purchase Order Detail Key | ||||
| Purchase Order Key | ||||
| Supervisor Key | The database identifier of the supervisor of the employee associated with the transaction | Employee | ||
| Time Rejected By Key | The database identifier of the employee who rejected the time submitted for the transaction | Employee | ||
| Timesheet Company Key | The database identifier of the company linked to the timesheet associated with the transaction | Company | ||
| Timesheet Key | The database identifier of the timesheet associated with the transaction | Timesheet | ||
| Timesheet Overhead Group Detail Key | The database identifier of the overhead item associated with the transaction | |||
| Transaction Key | The database identifier of the transaction | Transaction | ||
| Utilization Key | The database identifier of the utilization type associated with the transaction | |||
| Vendor Invoice Company Key | The database identifier of the company of the vendor invoice associated with the transaction | Company | ||
| Vendor Invoice Key | The database identifier of the vendor invoice associated with the transaction | Vendor Invoice | ||
| Vendor Key | The database identifier of the vendor associated with the transaction | Vendor | ||
| Vendor Type Key | The database identifier of the vendor type associated with the transaction | Vendor Type | ||
| Action | ||||
| Gantt |
unavailable in ajeraCore Select to add the Gantt chart to your table widget. |
|||
