Open topic with navigation

You are here: Ajera Help (A-Z) > dashboards > Widget Bases > Transaction Base

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.

      

 

 

© 2024 Deltek Inc. All rights reserved.