ProductTypes
Stores product type classification values. This table supports segmentation, reporting, and filtering of product offerings.
Columns
| Name | Type | ReadOnly | Description |
| Commentlog | String | True |
The comment log entries that are associated with this product type. This field stores references to related discussions or notes that provide collaboration history. |
| Created_By | String | True |
The unique identifier (Id) of the user who created this product type record. This value identifies the record author for auditing and ownership tracking. |
| Created_By_Name | String | True |
The display name of the user who created this product type record. This value is used for readability in the user interface and reports. |
| Date_Entered | Datetime | True |
The date and time when this product type record was initially created. This value provides historical context for record lifecycle management. |
| Date_Modified | Datetime | True |
The date and time when this product type record was most recently updated. This field helps track change activity over time. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this product type record is marked as deleted. It returns a value of 'false' when the record is active and available for use. |
| Description | String | False |
A detailed description of the product type. This field can provide explanations, usage notes, or classification guidance for cataloging and reporting. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this product type record to receive activity updates. It returns a value of 'false' when the user is not following the record. |
| Id [KEY] | String | True |
The unique Id for the product type record. This value is used to reference and differentiate this record from other product types. |
| List_Order | Int | False |
The numeric position of this product type in ordered lists. This value determines the display order when selecting or presenting product types. |
| Locked_Fields | String | True |
The list of fields that are restricted from editing for this product type. This value ensures data integrity by preventing updates to protected attributes. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this product type record. This value supports auditing and visibility into change history. |
| Modified_User_Id | String | True |
The Id of the user who most recently modified this product type record. This field identifies the user responsible for the latest update. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the record is marked as a favorite by the current user for quick access. It returns a value of 'false' when the record is not marked as a favorite. |
| Name | String | False |
The name of the product type. This value is the primary label that is used to identify the product type throughout the system. |
| Sync_Key | String | True |
The key that is used to support data synchronization with external systems. This value ensures that records remain matched between SugarCRM and integrated applications. |
| Tag | String | False |
The tags that are associated with this product type. Tags support flexible grouping, filtering, and classification across modules. |