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) |