JDBC Driver for SugarCRM

Build 22.0.8462

ForecastManagerWorksheets

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

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the forecast manager worksheet 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

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

Quota Double False

The quota for the forecast manager worksheet.

Best_Case Double False

The most optimistic scenario.

Best_Case_Adjusted Double False

The adjusted most optimistic scenario.

Likely_Case Double False

The likely scenario.

Likely_Case_Adjusted Double False

The adjusted likely scenario.

Worst_Case Double False

The least optimistic scenario.

Worst_Case_Adjusted Double False

The adjusted least optimistic scenario.

Currency_Id String False

The Id of the currency associated with the record.

Base_Rate Decimal False

The base rate of the record.

Timeperiod_Id String False

The Id of the time period associated with the worksheet.

Draft Bool False

Whether the worksheet is a draft.

Is_Manager Bool False

Whether the worksheet is visible to the manager.

User_Id String False

The Id of the user associated with the worksheet.

Opp_Count Int False

The number of opportunities represented by this forecast.

Pipeline_Opp_Count Int False

The number of opportunities minus closed won/closed lost represented by this forecast.

Pipeline_Amount Double False

The total of opportunities minus closed won/closed lost represented by this forecast.

Closed_Amount Double False

The total of closed/won items in the forecast.

Manager_Saved Bool False

Whether the manager has saved the forecast.

Show_History_Log Int False

Whether the forecast shows the history log.

Draft_Save_Type String False

The draft save type.

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