Quotes
Create, update, delete, and query quotes saved in SuiteCRM
Table Specific Information
Select
You can query the Quotes table using any criteria in the WHERE clause. The add-in will use the SuiteCRM API to filter the results.
SELECT * FROM Quotes WHERE [Valid Until] < '2017-04-30'
Insert
Create a Quote by specifying any writable column.
INSERT INTO Quotes (Title, Account, [Valid Until], [Quote Number]) VALUES ('Brand Quote', 'BillingAccountZ3', ''2018-02-24', 3)
Update
You can update any Quote column that is writable, by specifying the Id.
UPDATE Quotes SET [Approval Status] = 'Incomplete',[Approval Issues] = 'Delays from the DMV' WHERE Id = 'Test123'
Delete
Remove a Quote by specifying the Id.
DELETE FROM Quotes WHERE Id = 10003
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False | |
| ApprovalIssues | String | False | |
| ApprovalStatus | String | False | |
| Assignedto | String | True | |
| AssignedUserId | String | False | |
| BillingCity | String | False |
City where the billing account is recorded in |
| BillingCountry | String | False |
Country where the billing account is recorded in |
| BillingPostal_Code | String | False |
Postal code of the billing account |
| BillingState | String | False |
State where the billing account is recorded in |
| BillingStreet | String | False |
Street where the billing account is recorded in |
| billing_account_id | String | False |
Id of the billing account |
| Account | String | True |
Billing account name for the quote |
| billing_contact_id | String | False |
Id of the billing contact |
| Contact | String | True |
Name of the billing contact |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| Currency | String | False |
Id of the currency used for currency values |
| DateCreated | Datetime | True |
The date the record was created. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
The record deletion indicator. |
| Description | String | False |
Description for the quote |
| Discount | Double | False |
The quote's discount amount |
| Discount(DefaultCurrency) | Double | False |
The quote's discount amount in the system's default currency |
| GrandTotal | Double | False |
The quote's grand total |
| GrandTotal(DefaultCurrency) | Double | False |
The quote's grand total in the system's default currency |
| InvoiceStatus | String | False |
Quote's invoice status |
| LineItems | String | True |
The list of the quote's line items |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| Opportunity | String | True |
Opportunity name of the quote |
| opportunity_id | String | False |
Opportunity Id of the quote |
| PaymentTerms | String | False |
Selected terms for quote's payments |
| QuoteNumber | Int | False |
The assigned quote number |
| QuoteStage | String | False |
The quote's assigned stage |
| QuoteTemplate | String | False |
The quote's template |
| Shipping | Double | False |
The quote's shipping amount |
| Shipping(DefaultCurrency) | Double | False |
The quote's shipping amount in the system's default currency |
| ShippingCity | String | False |
City of the shipping destination |
| ShippingCountry | String | False |
Country of the shipping destination |
| ShippingPostalCode | String | False |
Postal code of the shipping destination |
| ShippingState | String | False |
State of the shipping destination |
| ShippingStreet | String | False |
Street address of the shipping destination |
| ShippingTax | String | False |
The quote's shipping tax costs |
| ShippingTax(DefaultCurrency) | Double | False |
The quotes's discountamount in the system's default currency |
| ShippingTaxAmount | Double | False |
The quotes's shipping tax amount |
| Subtotal | Double | False |
The quotes's subtotal amount |
| Subtotal(DefaultCurrency) | Double | False |
The quotes's subtotal amount in the system's default currency |
| SubtotalTax | Double | False |
The quotes's subtotal and tax amount |
| SubtotalTaxAmount | Double | False |
The quotes's subtotal and tax amount in the system's default currency |
| Tax | Double | False |
The quotes's tax amount |
| Tax(DefaultCurrency) | Double | False |
The quotes's tax amount in the system's default currency |
| Terms | String | False |
The quote's terms |
| Title | String | False |
Title assigned to the quote |
| Total | Double | False |
The quotes's total amount |
| Total(DefaultCurrency) | Double | False |
The quotes's total amount in the system's default currency |
| ValidUntil | Date | False |
The date the quote expires |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |