Power BI Connector for SugarCRM

Build 25.0.9454

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454