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
| Customer ID | External ID |
| Status | Client Active |
| Account Name | Client Name |
| Address Line 1 | Address |
| City | City |
| State | State |
| Postal Code | Zipcode |
| Account Email | |
| Phone 1 | Mobile |
| Phone 2 | Office Phone |
| GUID | Integration_ID |
Acumatica Equipment → Assignar Equipment
|
Description |
Description |
|
Equipment ID |
Equipment Name |
|
Equipment ID |
External ID |
|
GUID |
Integration_ID |
Acumatica Employees → Assignar Fieldworkers
|
Employee ID |
Employee ID |
|
Status |
IsActive/Active |
|
First Name |
First Name |
|
Last Name |
Last Name |
|
Phone1 |
ContactPhone/Contact |
|
|
|
|
Address Line 1 |
Address |
|
City |
Suburb |
|
State |
State |
|
Postal Code |
Postcode |
|
GUID |
Integration_ID |
|
-- |
User Type (Fieldworker) |
|
-- |
Employment Type (Full Time) |
|
|
Username |
Acumatica Projects → Assignar Projects
|
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
|
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
|
ID (Guid) |
IntegrationID |
|
Description |
Role Name |
|
Inventory ID |
External ID |
Acumatica Cost Codes → Assignar Activities
|
ID (Guid) |
IntegrationID |
|
Cost Code (ID) |
External ID |
|
Description |
Activity Name |
|
-- |
Status (Active) |
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) |