JDBC Driver for SugarCRM

Build 23.0.8839

ForecastManagerWorksheets

The ForecastManagerWorksheets table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

Quota Decimal True

Best_Case Decimal True

Best_Case_Adjusted Decimal True

Likely_Case Decimal True

Likely_Case_Adjusted Decimal True

Worst_Case Decimal True

Worst_Case_Adjusted Decimal True

Timeperiod_Id String False

Draft Bool False

Is_Manager Bool False

needed for commitLog field logic

User_Id String False

Opp_Count Int True

Number of opportunities represented by this forecast

Pipeline_Opp_Count Int True

Number of opportunities minus closed won/closed lost represented by this forecast

Pipeline_Amount Decimal True

Total of opportunities minus closed won/closed lost represented by this forecast

Closed_Amount Decimal True

Total of closed won items in the forecast

Manager_Saved Bool False

Show_History_Log Int True

Draft_Save_Type String False

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Locked_Fields String True

Sync_Key String True

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Currency_Id String False

Base_Rate String False

Currency_Name String True

Currency_Symbol String True

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839