Products
Create, update, delete, and query the Products module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the product is a favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier for the record. |
| Name | String | False |
The name of the product. |
| Date_Entered | Datetime | True |
Date the record was created. |
| Date_Modified | Datetime | True |
Date the record was last modified. |
| Modified_User_Id | String | True |
The Id of the user who last modified the record. |
| Modified_By_Name | String | True |
The username of the user who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The name of the user who created the record. |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The user favorites for the record. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
Record deletion indicator. |
| Assigned_User_Id | String | False |
The Id of the user assigned to the record. |
| Assigned_User_Name | String | False |
The username of the user assigned to the record. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Revenuelineitem_Id | String | False |
The Id of the associated revenue line item that served as the source. |
| Revenuelineitem_Name | String | False |
The name of the associated revenue line item that served as the source. |
| Product_Template_Id | String | False |
Id of the product (in Admin Products) from which this product is derived (in user Products). |
| Product_Template_Name | String | False |
Name of the product (in Admin Products) from which this product is derived (in user Products). |
| Account_Id | String | False |
Id of the account this product is associated with. |
| Contact_Id | String | False |
Id of the contact this product is associated with. |
| Total_Amount | Double | False |
The total amount of the product. |
| Contact_Name | String | False |
The name of the contact for the product. |
| Type_Id | String | False |
Product type (e.g., hardware or software). |
| Quote_Id | String | False |
If product is created via Quote, this is quote Id. |
| Manufacturer_Id | String | False |
The Id of the manufacturer of the product. |
| Manufacturer_Name | String | False |
The name of the manufacturer of the product. |
| Category_Id | String | False |
The Id of the product category. |
| Category_Name | String | False |
The name of the product category. |
| Mft_Part_Num | String | False |
Manufacturer part number. |
| Vendor_Part_Num | String | False |
Vendor part number. |
| Date_Purchased | Datetime | False |
Date the product was purchased. |
| Cost_Price | Double | False |
Product cost (Cost in Quote). |
| Discount_Price | Double | False |
Discounted price (Unit Price in Quote). |
| Discount_Amount | String | False |
Discounted amount. |
| Discount_Rate_Percent | Decimal | False |
Discounted percent. |
| Discount_Amount_Usdollar | Double | False |
Discount amount in USD. |
| Discount_Select | Bool | False |
The select discount. |
| Deal_Calc | Double | False |
The deal calculation. |
| Deal_Calc_Usdollar | Double | False |
The deal calculation in USD. |
| List_Price | Double | False |
List price of product (List in Quote). |
| Cost_Usdollar | Double | False |
Cost expressed in USD. |
| Discount_Usdollar | Double | False |
Discount price expressed in USD. |
| List_Usdollar | Double | False |
List price expressed in USD. |
| Currency_Id | String | False |
Currency of the product. |
| Base_Rate | Decimal | False |
The base rate of the product. |
| Status | String | False |
Product status (e.g., Quoted, Ordered, or Shipped). |
| Tax_Class | String | False |
Tax classification (e.g., Taxable or Non-taxable). |
| Website | String | False |
Product URL. |
| Weight | Decimal | False |
Weight of the product. |
| Quantity | Decimal | False |
Quantity in use. |
| Support_Name | String | False |
Name of product for support purposes. |
| Support_Description | String | False |
Description of product for support purposes. |
| Support_Contact | String | False |
Contact for support purposes. |
| Support_Term | String | False |
Term (length) of support contract. |
| Date_Support_Expires | Datetime | False |
Support expiration date. |
| Date_Support_Starts | Datetime | False |
Support start date. |
| Pricing_Formula | String | False |
Pricing formula (e.g., Fixed or Markup over Cost). |
| Pricing_Factor | Int | False |
Variable pricing factor depending on pricing_formula. |
| Serial_Number | String | False |
Serial number of the product in use. |
| Asset_Number | String | False |
Asset tag number of the product in use. |
| Book_Value | Double | False |
Book value of the product in use. |
| Book_Value_Usdollar | Double | False |
Book value expressed in USD. |
| Book_Value_Date | Datetime | False |
Date of book value for the product in use. |
| Date_Closed | Datetime | False |
Expected or actual date the product (for opportunity) will close. |
| Date_Closed_Timestamp | Int | False |
The timestamp of date_closed. |
| Next_Step | String | False |
The next step in the sales process. |
| Campaign_Id | String | False |
The Id of the campaign that generated the lead. |
| Campaign_Name | String | False |
The name of the campaign that generated the lead. |
| Currency_Name | String | False |
The name of the currency. |
| Currency_Symbol | String | False |
The symbol of the currency. |
| Quote_Name | String | False |
Quote name. |
| Opportunity_Id | String | False |
The opportunity Id for the line item entry. |
| Opportunity_Name | String | False |
The opportunity name associated with the opportunity. |
| Type_Name | String | False |
The name of the type. |
| Account_Name | String | False |
The name of the account. |
| Product_Index | String | False |
The product index. |