Power BI Connector for SugarCRM

Build 20.0.7587

RevenueLineItems

This is a table representing the RevenueLineItems module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is the favorite for the user.

Following Bool False

Whether the user is following the record.

Id [KEY] String False

The unique identifier of the revenue line item.

Name String False

The name of the revenue line item.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The 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 name 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 favorites of the user.

Description String False

The full text of the note.

Deleted Bool False

The record deletion indicator.

Assigned_User_Id String False

The user Id assigned to the record.

Assigned_User_Name String False

The name 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.

Product_Template_Id String False

The Id of the product (in Admin Products) from which this product is derived (in user Products).

Product_Template_Name String False

The name of the product (in Admin Products) from which this product is derived (in user Products).

Account_Id String False

Account this product is associated with.

Total_Amount Double False

The total amount.

Type_Id String False

Product type (e.g., hardware or software).

Quote_Id String False

The Id of the quote the product is associated with.

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 product purchased.

Cost_Price Double False

Product cost (Cost in Quote).

Discount_Price Double False

Discounted price (Unit Price in Quote).

Discount_Amount Double False

Discounted amount.

Discount_Rate_Percent Decimal False

Discount rate percent.

Discount_Amount_Usdollar Decimal True

Discount amount in USD.

Discount_Select Bool False

Select discount.

Deal_Calc Double False

The calculated deal.

Deal_Calc_Usdollar Double True

The calculated deal in USD.

List_Price Double False

List price of product (List in Quote).

Cost_Usdollar Double True

Cost expressed in USD.

Discount_Usdollar Double True

Discount price expressed in USD.

List_Usdollar Double True

List price expressed in USD.

Currency_Id String False

Currency of the product.

Base_Rate Decimal False

The base rate.

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 product in use.

Asset_Number String False

Asset tag number of product in use.

Book_Value Double False

Book value of product in use.

Book_Value_Usdollar Double True

Book value expressed in USD.

Book_Value_Date Datetime False

Date of book value for product in use.

Best_Case Double False

The most optimistic scenario.

Likely_Case Double False

The likely scenario.

Worst_Case Double False

The least optimistic scenario.

Date_Closed Datetime False

Expected or actual date the product (for opportunity) will close.

Date_Closed_Timestamp Int False

The timestamp of the close date for the opportunity.

Next_Step String False

The next step in the sales process.

Commit_Stage String False

Forecast commit category: Include, Likely, Omit etc.

Sales_Stage String False

Indication of progression towards closure.

Probability Int False

The probability of closure.

Lead_Source String False

Source of the product.

Campaign_Id String False

The campaign that generated the lead.

Campaign_Name String False

The name of the campaign.

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 Id of the opportunity for the line item entry.

Opportunity_Name String False

The name of the opportunity for the line item entry.

Product_Type String False

Type of product from the opportunity type. For example: Existing or New.

Type_Name String False

The type name.

Account_Name String False

The account name.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587