Accelo: Most-used fields

The table below gives information about most-used fields that you can import from Accelo. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Use in Adverity
activity_class.id	activity_class.id	metric
activity_class.status	activity_class.status	dimension
activity_class.title	activity_class.title	dimension
activity_priority.level	activity_priority.level	metric
affiliation.company.id	affiliation.company.id	metric
affiliation.company.name	affiliation.company.name	dimension
against	against	dimension
against_id	against_id	dimension
against_type	against_type	dimension
billable	billable	metric
billable_affiliation	billable_affiliation	metric
body	body	dimension
budget.type	budget.type	dimension
budget.value	budget.value	dimension
budget_type	budget_type	dimension
comments	comments	dimension
company.id	company.id	metric
company.name	company.name	dimension
company_status.id	company_status.id	metric
company_status.title	company_status.title	dimension
contract.affiliation	contract.affiliation	metric
contract.against	contract.against	dimension
contract.against_id	contract.against_id	dimension
contract.billable_affiliation	contract.billable_affiliation	metric
contract.company	contract.company	metric
contract.contract_type	contract.contract_type	metric
contract.date_expires	contract.date_expires	dimension
contract.date_period_expires	contract.date_period_expires	dimension
contract.date_started	contract.date_started	dimension
contract.id	contract.id	metric
contract.manager	contract.manager	metric
contract.standing	contract.standing	dimension
contract.status	contract.status	metric
contract.title	contract.title	dimension
contract_status.id	contract_status.id	metric
contract_status.title	contract_status.title	dimension
contract_type.id	contract_type.id	metric
contract_type.title	contract_type.title	dimension
date_commenced	date_commenced	dimension
date_completed	date_completed	dimension
date_created	date_created	dimension
date_due	date_due	dimension
date_ended	date_ended	dimension
date_expires	date_expires	dimension
date_logged	date_logged	dimension
date_modified	date_modified	dimension
date_started	date_started	dimension
id	id	dimension
job.date_created	job.date_created	dimension
job.id	job.id	dimension
job.job_status.id	job.job_status.id	dimension
job.job_status.title	job.job_status.title	dimension
job.job_type.id	job.job_type.id	dimension
job.job_type.title	job.job_type.title	dimension
job.title	job.title	dimension
job_object_budget.against_id	job_object_budget.against_id	dimension
job_object_budget.against_type	job_object_budget.against_type	dimension
job_object_budget.billable	job_object_budget.billable	metric
job_object_budget.billable_subtotal	job_object_budget.billable_subtotal	metric
job_object_budget.charged	job_object_budget.charged	metric
job_object_budget.charged_subtotal	job_object_budget.charged_subtotal	metric
job_object_budget.expense_price	job_object_budget.expense_price	metric
job_object_budget.id	job_object_budget.id	metric
job_object_budget.is_billable	job_object_budget.is_billable	dimension
job_object_budget.logged	job_object_budget.logged	metric
job_object_budget.logged_subtotal	job_object_budget.logged_subtotal	metric
job_object_budget.material_cost	job_object_budget.material_cost	metric
job_object_budget.material_cost_subtotal	job_object_budget.material_cost_subtotal	metric
job_object_budget.material_price	job_object_budget.material_price	metric
job_object_budget.material_price_subtotal	job_object_budget.material_price_subtotal	metric
job_object_budget.nonbillable	job_object_budget.nonbillable	metric
job_object_budget.nonbillable_subtotal	job_object_budget.nonbillable_subtotal	metric
job_object_budget.object	job_object_budget.object	dimension
job_object_budget.object_id	job_object_budget.object_id	dimension
job_object_budget.object_table	job_object_budget.object_table	dimension
job_object_budget.remaining_subtotal	job_object_budget.remaining_subtotal	metric
job_object_budget.service_price	job_object_budget.service_price	metric
job_object_budget.service_price_estimate	job_object_budget.service_price_estimate	metric
job_object_budget.service_price_subtotal	job_object_budget.service_price_subtotal	metric
job_object_budget.service_price_subtotal_estimate	job_object_budget.service_price_subtotal_estimate	metric
job_object_budget.service_time	job_object_budget.service_time	metric
job_object_budget.service_time_estimate	job_object_budget.service_time_estimate	metric
job_object_budget.service_time_subtotal_estimate	job_object_budget.service_time_subtotal_estimate	metric
job_status.id	job_status.id	metric
job_status.title	job_status.title	dimension
job_type.id	job_type.id	metric
job_type.title	job_type.title	dimension
manager.firstname	manager.firstname	dimension
manager.id	manager.id	metric
manager.surname	manager.surname	dimension
manager.title	manager.title	dimension
name	name	dimension
nonbillable	nonbillable	metric
notes	notes	dimension
owner	owner	dimension
owner_id	owner_id	dimension
owner_type	owner_type	dimension
paused	paused	metric
phone	phone	dimension
postal_address.city	postal_address.city	dimension
price	price	dimension
staff.email	staff.email	dimension
staff.firstname	staff.firstname	dimension
staff.id	staff.id	metric
staff.surname	staff.surname	dimension
staff.username	staff.username	dimension
standing	standing	dimension
subject	subject	dimension
task.against	task.against	dimension
task.against_id	task.against_id	dimension
task.against_type	task.against_type	dimension
task.company.id	task.company.id	dimension
task.company.name	task.company.name	dimension
task.creator	task.creator	dimension
task.creator_id	task.creator_id	dimension
task.date_created	task.date_created	dimension
task.id	task.id	metric
thread	thread	dimension
time_allocation.billable	time_allocation.billable	metric
time_allocation.nonbillable	time_allocation.nonbillable	metric
title	title	dimension
total	total	metric
website	website	dimension