Acumatica Workflow Data Specs

Christina Griffin
Christina Griffin
  • Updated

Below is a comprehensive list of the Assignar & Acumatica objects, field mappings, filter settings, sync settings, and dependencies. 

Each workflow below runs hourly, and has a manual trigger in the UI to start a sync at any time. 

Acumatica Customer → Assignar Client

Acumatica (Customer)

Assignar (Client)

Customer ID External ID
Status Client Active
Account Name Client Name
Address Line 1 Address
City City
State State
Postal Code Zipcode
Account Email Email
Phone 1 Mobile
Phone 2 Office Phone
GUID Integration_ID

 

Acumatica Equipment → Assignar Equipment

Acumatica (Equipment)

Assignar (Equipment)

Description

Description

Equipment ID

Equipment Name

Equipment ID

External ID

GUID

Integration_ID

 

Acumatica Employees → Assignar Fieldworkers

Acumatica (Employees)

Assignar (Fieldworkers)

Employee ID

Employee ID

Status

IsActive/Active

First Name

First Name

Last Name

Last Name

Phone1

ContactPhone/Contact

Email

Email

Address Line 1

Address

City

Suburb

State

State

Postal Code

Postcode

GUID

Integration_ID

--

User Type (Fieldworker)

--

Employment Type (Full Time)

Email

Username

 

Acumatica Projects → Assignar Projects

Acumatica (Project)

Assignar (Project)

Start Date

Start

Project ID

Project External ID

Project ID - Description

Project Name

GUID

Integration_ID

End Date

End

Customer

Client

Address Line 1, City, State, Postal Code

Project Address

 

Acumatica Project Tasks → Assignar Work Orders

Acumatica (Project Tasks)

Assignar (Work Order)

ID (Guid)

IntegrationID

Project ID

Project

Task ID

WO Number

Status

Status

Description

Job Description

Planned Start Date

Start Date

Planned End Date

End Date

Customer

Client

 

Acumatica Items → Assignar Roles

Acumatica (Items)

Assignar (Roles)

ID (Guid)

IntegrationID

Description

Role Name

Inventory ID

External ID

 

Acumatica Cost Codes → Assignar Activities

Acumatica (Cost Code)

Assignar (Activities)

ID (Guid)

IntegrationID

Cost Code (ID)

External ID

Description

Activity Name

--

Status (Active)

 

Assignar Timesheets  → Acumatica Time Activities

Assignar (Timesheets)

Acumatica (Time Activities)

IntegrationID

ID (GUID)

Project Integration ID

Project ID

Order Integration ID

Task ID

Timesheet ID - Activity Name (Job Description)

Summary

Total Time

Time Spent

Cost Code/Activity (Ext ID)

Cost Code

Order IntegrationID

Project Task

User Role (Ext ID)

Labor Item

--

Released (T/F)

 

Was this article helpful?

0 out of 0 found this helpful