activity
A table that captures user and system-generated activities in NetSuite, including task assignments, calls, events, and follow-ups. This table supports audit trails, calendar integration, and activity-based workflows across customer relationship management (CRM) and project management modules.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The system-generated identifier (Id) that uniquely distinguishes each activity record within NetSuite. This Id is used as the primary key for referencing and data relationships. | |
| activity | Integer | The Id that links the record to a specific customer relationship management (CRM) or project-related activity, such as tasks, phone calls, or events tracked within the system. | |
| bom | Integer | The Id that references the Bill of Materials (BOM) that is associated with the activity. This Id supports traceability in manufacturing or planning workflows. | |
| bomrevision | Integer | The Id that specifies the revision level of the associated BOM. This Id allows for version tracking and configuration control. | |
| company | Integer | The Id for the company or customer that is involved in the activity. This Id supports relationship tracking and CRM integration. | |
| completeddate | Date | The date on which the activity was marked as completed. This date provides visibility into progress and performance tracking. | |
| contact | Integer | The Id that associates the activity with a specific contact. This Id enables detailed CRM engagement and interaction history. | |
| createddate | Date | The date on which the activity record was created in the system. This field supports audit trails and time-based analysis. | |
| externalid | String | An optional, user-defined external Id that is used to integrate or map the activity to records in external systems or applications. | |
| lastmodifieddate | Datetime | The timestamp of the most recent update to the activity record. This field supports synchronization, version control, and audit purposes. | |
| mfgrouting | Integer | The Id that links the activity to a specific manufacturing routing record. This Id is used in production planning and execution workflows. | |
| relateditem | Integer | The Id for the inventory item or assembly item that is related to the activity. This Id aids in material planning, traceability, and reporting. | |
| reminderminutes | String | The number of minutes prior to the scheduled activity start time that a reminder should be triggered. Values include '5', '10', '15', '30', '60', and '120'. | |
| remindertype | String | The delivery method or format of the reminder that is associated with the activity. Values include 'popup', 'email', and 'SMS'. | |
| startdate | Date | The date when the activity is scheduled to begin. This date is used in scheduling, calendar views, and resource planning. | |
| status | String | The current state of the activity, such as 'Not Started', 'In Progress', or 'Completed'. This field is used for workflow tracking and reporting. | |
| supportcase | Integer | The Id that links the activity to a specific support case. This Id enables contextual visibility within the customer service process. | |
| timedevent | Boolean | A Boolean flag that indicates whether the activity is time-based ('true') or not ('false'). This flag is used in calendar displays and time management. | |
| title | String | The subject or title of the activity. This field provides a brief and descriptive label for easy identification in lists and reports. | |
| transaction | Integer | The Id that links the activity to a transaction record, such as a sales order or invoice, for contextual insights and follow-ups. | |
| type | String | The classification of the activity, such as 'task', 'call', or 'meeting'. This value defines the behavior, icons, and available fields in NetSuite workflows. |