phonecall
The table storing phone call records, used to track customer service interactions, sales calls, and other telecommunication events.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to the record, used to reference and manage the entry within the system. | |
| accesslevel | Boolean | Indicates whether the record is private, restricting access to specific users based on their permissions. | |
| assigned | String | The person or entity to whom the record is assigned, often used to track responsibility or ownership of tasks or projects. | |
| bom | String | The Bill of Materials (BOM) associated with the record, used to list the raw materials and components needed for manufacturing. | |
| bomrevision | String | The revision or version number of the BOM, used to track changes and updates to the materials list. | |
| company | String | The company associated with the record, typically used to track the organization or business unit related to the item or process. | |
| completeddate | Date | The date on which the task, project, or record was completed, used for tracking progress and performance. | |
| contact | String | The contact person associated with the record, often used for customer or client interactions and communications. | |
| createddate | Date | The date on which the record was created, used to track the origin and timeline of the entry. | |
| externalid | String | A unique identifier for the record assigned by an external system, used for integration or synchronization between systems. | |
| lastmodifieddate | Date | The date on which the record was last modified, used for tracking changes and ensuring data integrity. | |
| message | String | The comments or notes associated with the record, often used for internal communication or additional context. | |
| mfgrouting | String | The manufacturing routing associated with the record, detailing the process steps or workflow required to produce the item. | |
| owner | String | The person who created or owns the record, often used for tracking accountability and responsibility for managing the entry. | |
| priority | String | The priority level of the task or record, indicating its importance or urgency in relation to other records or projects. | |
| relateditem | String | The item related to the record, often used for associating products, parts, or resources with the current entry. | |
| reminderminutes | String | The number of minutes before the event or task is due when a reminder should be set up to alert the responsible party. | |
| remindertype | String | The type of reminder to be used (such as an email, popup, or notification), indicating how the reminder will be delivered. | |
| startdate | Date | The start date of the task, project, or process, marking the beginning of the associated activity or event. | |
| status | String | The current status of the record (such as 'open', 'in progress', 'completed', or 'closed'), used for tracking the progress of tasks or projects. | |
| supportcase | String | The support case associated with the record, typically used for tracking customer service or technical support inquiries. | |
| timedevent | Boolean | Indicates whether the event is time-based (such as a scheduled task or automated process), that occurs at a specific time. | |
| title | String | The title or name of the record, used for identification and display in user interfaces or reports. |