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 cmdlet 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. |