Quotes
Create, update, delete, and query the Quotes module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the record is the favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier of the quote. |
| Name | String | False |
The name of the quote. |
| Date_Entered | Datetime | True |
Date the record was created. |
| Date_Modified | Datetime | True |
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 user name 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 user name of the user who created the record |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The favorites of the user. |
| Description | String | False |
The full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| Assigned_User_Id | String | False |
The user Id assigned to the record. |
| Assigned_User_Name | String | False |
The name 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. |
| Shipper_Id | String | False |
The Id of the shipper. |
| Shipper_Name | String | False |
The name of the shipper. |
| Currency_Id | String | False |
The Id of the currency. |
| Base_Rate | Decimal | False |
The base rate. |
| Taxrate_Id | String | False |
The Id of the tax rate. |
| Show_Line_Nums | Bool | False |
Whether to show the line numbers of the quote. |
| Calc_Grand_Total | Bool | False |
The grand total of the quote. |
| Quote_Type | String | False |
The type of the quote. |
| Date_Quote_Expected_Closed | Datetime | False |
The expected close date of the quote. |
| Original_Po_Date | Datetime | False |
The original PO date |
| Payment_Terms | String | False |
The payment terms. |
| Date_Quote_Closed | Datetime | False |
The close date of the quote. |
| Date_Order_Shipped | Datetime | False |
The ship date of the order. |
| Order_Stage | String | False |
The stage of the order |
| Quote_Stage | String | False |
The stage of the quote. |
| Purchase_Order_Num | String | False |
The purchase order number. |
| Quote_Num | Int | True |
The quote number. |
| Subtotal | Double | False |
The subtotal of the quote. |
| Subtotal_Usdollar | Double | False |
The subtotal of the quote in USD. |
| Shipping | Double | False |
The shipping cost. |
| Shipping_Usdollar | Double | False |
The shipping cost in USD. |
| Discount | Double | False |
The discount amount. |
| Deal_Tot | Double | False |
The deal total. |
| Deal_Tot_Usdollar | Double | False |
The deal total in USD. |
| New_Sub | Double | False |
The new subtotal. |
| New_Sub_Usdollar | Double | False |
The new subtotal in USD. |
| Tax | Double | False |
The tax amount. |
| Tax_Usdollar | Double | False |
The tax amount in USD. |
| Total | Double | False |
The total. |
| Total_Usdollar | Double | False |
The total in USD. |
| Billing_Address_Street | String | False |
The street of the billing address. |
| Billing_Address_City | String | False |
The city used for the billing address. |
| Billing_Address_State | String | False |
The state used for the billing address. |
| Billing_Address_Postalcode | String | False |
The postal code used for the billing address. |
| Billing_Address_Country | String | False |
The country used for the billing address. |
| Shipping_Address_Street | String | False |
The street address used for for shipping purposes. |
| Shipping_Address_City | String | False |
The city used for the shipping address. |
| Shipping_Address_State | String | False |
The state used for the shipping address. |
| Shipping_Address_Postalcode | String | False |
The ZIP code used for the shipping address. |
| Shipping_Address_Country | String | False |
The country used for the shipping address. |
| System_Id | Int | False |
The system Id. |
| Shipping_Account_Name | String | False |
The shipping account name. |
| Shipping_Account_Id | String | False |
The shipping account Id. |
| Shipping_Contact_Name | String | False |
The shipping contact name. |
| Shipping_Contact_Id | String | False |
The shipping contact Id. |
| Account_Name | String | False |
The account name. |
| Account_Id | String | False |
The account Id. |
| Billing_Account_Name | String | False |
The billing account name. |
| Billing_Account_Id | String | False |
The billing account Id. |
| Billing_Contact_Name | String | False |
The billing contact name. |
| Billing_Contact_Id | String | False |
The billing contact Id. |
| Opportunity_Name | String | False |
The opportunity name. |
| Opportunity_Id | String | False |
The opportunity Id. |