ProductTemplates
Stores reusable template records that define product configuration defaults. This table supports consistent product setup and catalog scalability.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The names of the teams that have access to this product template record. This field supports access control and visibility management. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the team set that defines access control for this product template. Team sets allow multiple teams to share access to the same record. |
| Active_Status | String | False |
The active status of the product template (for example, 'Active', 'Inactive', or 'Retired'). This status determines whether the template may be used when creating new product records. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to manage this product template. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to manage this product template. |
| Base_Rate | String | False |
The base exchange rate that applies to pricing calculations for this product template when multiple currencies are in use. |
| Category_Id | String | False |
The Id of the product category that classifies this product template. Product categories support catalog organization and reporting. |
| Category_Name | String | True |
The display name of the product category that classifies this product template. |
| Commentlog | String | True |
A reference to log entries that contain conversational or activity-based comments associated with the product template. |
| Cost_Price | Decimal | False |
The cost of producing or procuring the product that this template represents. |
| Cost_Usdollar | Decimal | True |
The product cost expressed in U.S. dollars (USDs). This value standardizes cost representation across currency contexts. |
| Created_By | String | True |
The Id of the user who created this product template record. |
| Created_By_Name | String | True |
The display name of the user who created this product template record. |
| Currency_Id | String | False |
The Id of the currency that is associated with this product template's pricing. |
| Currency_Name | String | True |
The display name of the currency that is associated with this product template's pricing. |
| Currency_Symbol | String | True |
The currency symbol that is associated with this product template's pricing. |
| Date_Available | Date | False |
The date when the product that is represented by this template becomes available for sale or distribution. |
| Date_Cost_Price | Date | False |
The date when the cost price value became valid for this product template. |
| Date_Entered | Datetime | True |
The date and time when this product template record was created. |
| Date_Modified | Datetime | True |
The date and time when this product template record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the product template is marked for deletion. It returns a value of 'false' when the product template remains active. |
| Description | String | False |
A detailed description that provides context, usage notes, or business meaning for the product template. |
| Discount_Price | Decimal | False |
The discounted price that applies to the product that is represented by this template. |
| Discount_Usdollar | Decimal | True |
The discounted product price expressed in USDs. This value standardizes discount representation across currency contexts. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this product template. It returns a value of 'false' when the template is not being followed. |
| Id [KEY] | String | True |
The unique Id of the product template record. |
| List_Price | Decimal | False |
The list price for the product that is represented by this template. |
| List_Usdollar | Decimal | True |
The list price expressed in U.S. dollars. This value standardizes pricing across currencies. |
| Lock_Duration | Bool | False |
A Boolean field that returns a value of 'true' when users are prevented from manually editing the duration fields that are associated with the product. It returns a value of 'false' when the duration fields are editable. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification to preserve data integrity. |
| Manufacturer_Id | String | False |
The Id of the manufacturer that supplies the product represented by this template. |
| Manufacturer_Name | String | True |
The display name of the manufacturer that supplies the product represented by this template. |
| Mft_Part_Num | String | False |
The manufacturer's part number that uniquely identifies the product in supplier catalogs. |
| Modified_By_Name | String | True |
The display name of the user who last modified this product template record. |
| Modified_User_Id | String | True |
The Id of the user who last modified this product template record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the product template is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The name of the product template. This value identifies the template in catalog lists and record searches. |
| Pricing_Factor | Decimal | True |
A multiplier that is used when applying the pricing formula to calculate the final product price. |
| Pricing_Formula | String | True |
The pricing formula that determines how the final price is calculated (for example, 'Fixed' or 'Markup over Cost'). |
| Qty_In_Stock | Int | True |
The quantity of the product that is currently available in stock. This value supports inventory and fulfillment workflows. |
| Renewable | Bool | False |
A Boolean field that returns a value of 'true' when the product that is represented by this template is renewable (for example, subscription services). It returns a value of 'false' when the product does not support renewal. |
| Service | Bool | False |
A Boolean field that returns a value of 'true' when the product represents a service. It returns a value of 'false' when the product is a tangible good. |
| Service_Duration_Unit | String | False |
The unit of measurement for the service duration (for example, 'Days', 'Months', or 'Years'). |
| Service_Duration_Value | Int | True |
The numeric value of the service duration that applies to the product. For example, a value of '4' with a unit of 'Months' represents a four-month service period. |
| Status | String | False |
The status of the product template (not used in product catalog selection workflows). |
| Support_Contact | String | False |
The contact who is responsible for providing support for this product. |
| Support_Description | String | False |
A descriptive summary of the support resources or conditions that are associated with the product. |
| Support_Name | String | False |
The name of the support entry that applies to the product that is represented by this template. |
| Support_Term | String | False |
The length or duration of the support contract that applies to this product template. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile this product template record across systems and integrations. |
| Tag | String | False |
The tags that are assigned to this product template record. Tags support categorization, filtering, and workspace organization. |
| Tax_Class | String | False |
The tax classification that applies to the product (for example, 'Taxable' or 'Non-taxable'). |
| Team_Count | String | False |
The count of teams that are associated with this product template record. |
| Team_Id | String | False |
The Id of the primary team that is associated with this product template for access control. |
| Team_Name | String | False |
The display name of the primary team that is associated with this product template. |
| Team_Set_Id | String | False |
The Id of the team set that is used to define access control for this product template. |
| Type_Id | String | False |
The Id of the product type that categorizes the product represented by this template (for example, 'Hardware' or 'Software'). |
| Type_Name | String | True |
The display name of the product type that categorizes the product represented by this template. |
| Vendor_Part_Num | String | False |
The vendor-supplied part number for the product that is represented by this template. |
| Website | String | False |
The URL that links to product details, documentation, or supplier resources. |
| Weight | Decimal | True |
The weight of the product. This value is used for logistics planning and shipping calculations. |