JDBC Driver for SugarCRM

Build 24.0.9062

Quotes

The Quotes table.

Columns

Name Type ReadOnly Description
Account_Id String True

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

Billing_Account_Id String True

Billing_Account_Name String False

Billing_Address_City String False

Billing_Address_Country String False

Billing_Address_Postalcode String False

Billing_Address_State String False

Billing_Address_Street String False

Billing_Contact_Id String True

Billing_Contact_Name String True

Bundles String True

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_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Date_Order_Shipped Date False

Date_Quote_Closed Date False

Date_Quote_Expected_Closed Date False

Deal_Tot Decimal True

Deal_Tot_Discount_Percentage Double True

Deal_Tot_Usdollar Decimal True

Deleted Bool False

Record deletion indicator

Denorm_Billing_Account_Name String False

Name of the Company

Description String False

Full text of the note

Discount Decimal True

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

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

New_Sub Decimal True

New_Sub_Usdollar Decimal True

Opportunity_Id String True

Opportunity_Name String True

Order_Stage String False

Original_Po_Date Date False

Payment_Terms String False

Purchase_Order_Num String False

Quote_Num Int False

Quote_Stage String False

Quote_Type String False

Renewal Bool True

Indicates whether this quote is a renewal

Shipper_Id String False

Shipper_Name String True

Shipper Name

Shipping Decimal True

Shipping_Account_Id String True

Shipping_Account_Name String True

Shipping_Address_City String False

Shipping_Address_Country String False

Shipping_Address_Postalcode String False

Shipping_Address_State String False

Shipping_Address_Street String False

Shipping_Contact_Id String True

Shipping_Contact_Name String True

Shipping_Usdollar Decimal True

Show_Line_Nums Bool False

Subtotal Decimal True

Subtotal_Usdollar Decimal True

Sync_Key String True

Tag String False

Tax Decimal True

Tax_Usdollar Decimal True

Taxable_Subtotal Decimal True

Rollup of product bundles taxable_subtotal values

Taxrate_Id String False

Taxrate_Name String True

Tax Rate Name

Taxrate_Value Decimal True

Tax Rate Value

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Total Decimal True

Total_Usdollar Decimal True

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