ODBC Driver for SugarCRM

Build 24.0.9062

ForecastWorksheets

The ForecastWorksheets table.

Columns

Name Type ReadOnly Description
Account_Id String False

Account_Name String True

Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate String False

Best_Case Decimal True

Campaign_Id String False

Campaign_Name String True

Category_Id String False

Category_Name String True

Commit_Stage String False

Forecast commit ranges: Include, Likely, Omit etc.

Cost_Price Decimal True

Product cost (

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Closed Date False

Expected or actual date the oppportunity will close

Date_Closed_Timestamp String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Discount_Amount Decimal True

Discounted amount

Discount_Price Decimal True

Discounted price (

Draft Int True

Is A Draft Version

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Lead_Source String False

Source of the product

Likely_Case Decimal True

List_Price Decimal True

List price of product (

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Next_Step String False

The next step in the sales process

Opportunity_Id String False

Opportunity_Name String True

Parent_Deleted Int True

Is Parent Deleted

Parent_Id String False

Account ID of the parent of this account

Parent_Name String True

Parent_Type String True

Sugar module the Worksheet is associated with

Probability Int True

The probability of closure

Product_Template_Id String False

Product_Template_Name String True

Product_Type String False

Type of product ( from opportunities opportunity_type ex: Existing, New)

Quantity Int True

Quantity in use

Sales_Stage String False

Indication of progression towards closure

Sales_Status String False

Sync_Key String True

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Total_Amount Decimal True

Worst_Case Decimal True

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