JDBC Driver for SugarCRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462