Products
Stores standard product records that are available for quoting and order processing. This table supports catalog management, pricing, and sales enablement.
Columns
| Name | Type | ReadOnly | Description |
| Account_Id | String | True |
The identifier (Id) of the account that is associated with this product record. This field links the product to a customer, company, or organization for sales and reporting purposes. |
| Account_Name | String | True |
The display name of the associated account. |
| Acl_Team_Names | String | True |
A list of team names that are associated with access control rules for this product record. These values help determine visibility and edit rights. |
| Acl_Team_Set_Id | String | False |
The Id of the team set that is associated with this product record for access control. |
| Add_On_To_Id | String | False |
The Id of the purchased line item that this product record is considered an add-on to. This field supports product bundling and dependent sale structures. |
| Add_On_To_Name | String | True |
The display name of the purchased line item that this product record is considered an add-on to. |
| Asset_Number | String | False |
The asset tag number that is assigned to the product when it is actively deployed or in use. This value is used for inventory tracking and reference. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to manage this product record. This field controls ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to manage this product record. |
| Base_Rate | String | False |
The base currency exchange rate that is used to convert monetary values for the product record. |
| Book_Value | Decimal | True |
The book value of the product when it is in use. This value is commonly used in financial reporting and asset management. |
| Book_Value_Date | Date | False |
The date on which the book value was recorded or last evaluated. |
| Book_Value_Usdollar | Decimal | True |
The book value of the product expressed in U.S. dollars (USD). This field is used for standardized financial reporting. |
| Campaign_Id | String | False |
The Id of the campaign that generated interest in or influenced the sale of the product. |
| Campaign_Name | String | True |
The display name of the associated campaign. |
| Catalog_Service_Duration_Unit | String | True |
The unit of measurement (UOM) that defines the service duration (for example, 'month' or 'year') for the product catalog entry. This value is used for service fulfillment and contract planning. |
| Catalog_Service_Duration_Value | Int | True |
The numeric value that represents the length of the service duration. This value is used along with the service duration unit to calculate total service terms. |
| Category_Id | String | False |
The Id of the product category that is associated with this product record. This field supports product classification and catalog navigation. |
| Category_Name | String | True |
The display name of the product category that is associated with this product record. |
| Commentlog | String | True |
A reference to the CommentLog entries that are associated with this product. This field supports collaboration and auditability. |
| Contact_Id | String | False |
The Id of the contact who is associated with this product. This link supports service tracking, customer follow-up, and relationship management. |
| Contact_Name | String | True |
The display name of the associated contact. |
| Cost_Price | Decimal | True |
The cost value of the product. This value is used for calculating margins and profitability. |
| Cost_Usdollar | Decimal | True |
The cost value of the product expressed in USDs. |
| Created_By | String | True |
The Id of the user who created this product record. |
| Created_By_Name | String | True |
The display name of the user who created this product record. |
| Currency_Id | String | False |
The Id of the currency that is assigned to this product record. This field ensures accurate financial representation. |
| Currency_Name | String | True |
The display name of the currency that is assigned to this product record. |
| Currency_Symbol | String | True |
The symbol for the currency that is assigned to this product record. This value is used for UI display formatting. |
| Date_Closed | Date | False |
The expected or actual closing date of the sale that is associated with this product. This value is often tied to opportunity pipeline tracking. |
| Date_Closed_Timestamp | String | True |
The timestamp representation of the closing date. This field is commonly used for sorting, grouping, and reporting. |
| Date_Entered | Datetime | True |
The date and time when this product record was created. |
| Date_Modified | Datetime | True |
The date and time when this product record was last modified. |
| Date_Purchased | Date | False |
The date when the product was purchased. |
| Date_Support_Expires | Date | False |
The date when support coverage for this product ends. |
| Date_Support_Starts | Date | False |
The date when support coverage for this product begins. |
| Deal_Calc | Decimal | True |
The calculated deal value that is associated with this product based on pricing and discount configurations. |
| Deal_Calc_Usdollar | Decimal | True |
The calculated deal value for this product expressed in USDs. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the product record is flagged for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows. |
| Description | String | False |
A full-text description of the product. This field is commonly used to describe product details, usage context, or special terms. |
| Discount_Amount | String | True |
The discount that is applied to the product price. This value affects final sale amount calculations. |
| Discount_Amount_Signed | Decimal | True |
The discount amount with sign indication to represent whether the value increases or reduces total cost. |
| Discount_Amount_Usdollar | Decimal | True |
The discount amount that is applied to the product price expressed in USDs. |
| Discount_Price | Decimal | True |
The price of the product after the discount is applied. |
| Discount_Rate_Percent | Decimal | True |
The discount rate applied as a percentage of the list price. |
| Discount_Select | Bool | False |
A Boolean field that returns a value of 'true' when a discount has been selected for the product. It returns a value of 'false' when no discount has been selected. |
| Discount_Usdollar | Decimal | True |
The discounted price of the product expressed in USDs. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this product record. It returns a value of 'false' when the record is not being followed. |
| Id [KEY] | String | True |
The unique Id of the product record. |
| List_Price | Decimal | True |
The standard list price of the product before any discount is applied. |
| List_Usdollar | Decimal | True |
The standard list price of the product expressed in USDs. |
| Lock_Duration | Bool | False |
A Boolean field that returns a value of 'true' when the duration field is restricted from direct editing. It returns a value of 'false' when the duration field can be edited. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field helps preserve data integrity. |
| Manufacturer_Id | String | False |
The Id of the manufacturer that is associated with this product. |
| Manufacturer_Name | String | True |
The name of the manufacturer that is associated with this product. |
| Mft_Part_Num | String | False |
The manufacturer part number that uniquely identifies this product in external supplier catalogs. |
| Modified_By_Name | String | True |
The display name of the user who last modified this product record. |
| Modified_User_Id | String | True |
The Id of the user who last modified this product record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the product is marked as a favorite by the current user. It returns a value of 'false' when the product is not marked as a favorite. |
| Name | String | False |
The name of the product record. This value is used to identify the product in lists, searches, and reports. |
| Next_Step | String | False |
The next planned step in the sales process for the product. This field is often used in pipeline management and follow-up scheduling. |
| Opportunity_Id | String | False |
The identifier (Id) of the opportunity that is associated with this product. This relationship ties the product line item to an active or completed sales opportunity. |
| Opportunity_Name | String | True |
The display name of the opportunity that is associated with this product. |
| Parent_Rli_Id | String | False |
The Id of the revenue line item that served as the original source of this product record. This value supports roll-up reporting and linked revenue forecasting. |
| Parent_Rli_Name | String | True |
The display name of the revenue line item that served as the original source for this product record. |
| Position | Int | True |
The numeric position of the product in a list or grouping. This field is commonly used to control ordering when products are bundled or arranged in quotes. |
| Pricing_Factor | Int | True |
A pricing multiplier used when applying the selected pricing formula. This value affects the calculated list or discount price. |
| Pricing_Formula | String | False |
The pricing rule that is used to calculate the product price (for example, 'Fixed' or 'Markup over Cost'). This formula determines how list, cost, and discount inputs interact. |
| Product_Template_Id | String | False |
The Id of the product template from which this product record is derived. Product templates serve as reusable catalog definitions for end-user product instances. |
| Product_Template_Name | String | True |
The display name of the product template from which this product was derived. |
| Quantity | Decimal | True |
The quantity of the product that is in use or being quoted. This value is used when calculating totals and extended pricing. |
| Quote_Id | String | False |
The Id of the quote from which this product record was created, if it is applicable. This field supports quoting workflow traceability. |
| Quote_Name | String | True |
The display name of the quote from which this product record was created, if it is applicable. |
| Renewable | Bool | False |
A Boolean field that returns a value of 'true' when the product represents a renewable item such as a subscription or recurring service. It returns a value of 'false' when the product does not support renewal. |
| Renewal | Bool | True |
A Boolean field that returns a value of 'true' when this product record represents a renewal of a prior product or service. It returns a value of 'false' when the product is not a renewal. |
| Revenuelineitem_Id | String | False |
The Id of the revenue line item that served as the source of this product record. This relationship supports forecasting and revenue roll-ups. |
| Revenuelineitem_Name | String | True |
The display name of the revenue line item that served as the source of this product record. |
| Serial_Number | String | False |
The serial number that uniquely identifies the product when it is in use or deployed. This field is often used for warranty, asset tracking, and service validation. |
| Service | Bool | False |
A Boolean field that returns a value of 'true' when the product represents a service rather than a tangible item. It returns a value of 'false' when the product is a physical good. |
| Service_Duration_Multiplier | Decimal | True |
A multiplier that represents how the service duration for this product relates to the duration defined in the product template or catalog entry. |
| Service_Duration_Unit | String | False |
The unit of measure for the service duration (for example, 'Days', 'Months', or 'Years'). |
| Service_Duration_Value | Int | True |
The numeric value of the service duration. For example, a value of '4' with a unit of 'Months' indicates a four-month term. |
| Service_End_Date | String | True |
The date when the service period ends. This value is commonly used for renewal scheduling and support planning. |
| Service_Start_Date | Date | False |
The date when the service period begins. This field helps determine eligibility for service delivery and support. |
| Status | String | False |
The status of the product record in the sales or fulfillment process (for example, 'Quoted', 'Ordered', or 'Shipped'). |
| Subtotal | Decimal | True |
The total value of the product line item before any discounts are applied, including prorated adjustments when applicable. |
| Support_Contact | String | False |
The contact who is responsible for providing support for this product. This value is used for customer service and escalation routing. |
| Support_Description | String | False |
A descriptive summary of support considerations or service instructions that relate to the product. |
| Support_Name | String | False |
The display name that identifies the support entry associated with the product. |
| Support_Term | String | False |
The length of the support agreement for the product. This value is typically used for contract fulfillment and renewal scheduling. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile this product record across systems and integrations. |
| Tag | String | False |
The tags that are assigned to this product record. Tags support searching, grouping, and filtered workspace views. |
| 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 record for access control and visibility purposes. |
| Team_Id | String | False |
The Id of the primary team associated with this product record. |
| Team_Name | String | False |
The display name of the primary team associated with this product record. |
| Team_Set_Id | String | False |
The Id of the team set that is associated with this product record for expanded access control. |
| Total_Amount | Decimal | True |
The total amount for this product line item after pricing, discount, and quantity calculations are applied. |
| Type_Id | String | False |
The Id of the product type that classifies the product (for example, 'Hardware' or 'Software'). |
| Type_Name | String | True |
The display name of the product type that classifies the product. |
| Vendor_Part_Num | String | False |
The vendor-provided part number for the product. This field supports external procurement and supplier matching. |
| Website | String | False |
A URL that points to the product details, vendor listing, or documentation page. |
| Weight | Decimal | True |
The weight of the product. This value is often used for shipping cost calculations and logistics planning. |