Power BI Connector for SugarCRM

Build 20.0.7587

ForecastWorksheets

Create, update, delete, and query the ForecastWorksheets module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is a favorite for the user.

Following Bool False

Whether the user is following the record.

Id [KEY] String False

Unique identifier of the worksheet.

Name String False

The name of the worksheet.

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 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 username of the user who created the worksheet.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the worksheet.

Description String False

Full text of the note.

Deleted Bool False

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

Parent_Id String False

The Id of the parent module associated with the worksheet.

Parent_Type String False

The type of the parent module associated with the worksheet.

Parent_Name String False

The name of the parent module associated with the worksheet.

Opportunity_Id String False

The Id of the opportunity associated with the worksheet.

Opportunity_Name String False

The name of the opportunity associated with the worksheet.

Account_Name String False

The name of the account associated with the worksheet.

Account_Id String False

The Id of the account associated with the worksheet.

Campaign_Id String False

The Id of the campaign associated with the worksheet.

Campaign_Name String False

The name of the campaign associated with the worksheet.

Product_Template_Id String False

The Id of the product template associated with the worksheet.

Product_Template_Name String False

The name of the product template associated with the worksheet.

Category_Id String False

The Id of the category associated with the worksheet.

Category_Name String False

The name of the category associated with the worksheet.

Sales_Status String False

The sales status of the worksheet.

Likely_Case Double False

The likely scenario.

Best_Case Double False

The most optimistic scenario.

Worst_Case Double False

The least optimistic scenario.

Base_Rate Decimal False

The base rate worksheet.

Currency_Id String False

The Id of the currency used for display purposes.

Currency_Name String False

The name of the currency used for display purposes.

Currency_Symbol String False

The symbol of the currency used for display purposes.

Date_Closed Datetime False

Expected or actual date the oppportunity will close.

Date_Closed_Timestamp Int False

The timestamp of the close date for the opportunity.

Sales_Stage String False

The stage that indicates the progression towards closure.

Probability Int False

The probability of closure.

Commit_Stage String False

The forecast commit range, such as Include, Likely, Omit, etc.

Draft Int False

Whether the forecast is a draft.

Next_Step String False

The next step in the sales process.

Lead_Source String False

The source of the product.

Product_Type String False

The type of product. An opportunity type. For example, Existing or New.

List_Price Double False

List price of product (List in Quote).

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.

Quantity Int False

Quantity in use.

Total_Amount Double False

The total amount.

Parent_Deleted Int False

Whether the parent object is deleted.

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