# SalesQuotes: Simplicate Sales Quotes Fetches all available quote templates for sales Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Sales` - Primary Keys: `id` - Label: Sales Quotes ## Table Columns The columns of the table `SalesQuotes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_at` | `string` | Created On | ☐ | | | `created_by` | `string` | Created By | ☐ | | | `customer_reference` | `string` | Customer Reference | ☐ | | | `download_url` | `string` | Download URL | ☐ | | | `grand_totals` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `is_blocked` | `int64` | Blocked | ☐ | | | `is_outdated` | `int64` | Is Outdated | ☐ | | | `is_sepa_authorization` | `int64` | | ☐ | | | `json` | `string` | JSON | ☐ | | | `last_updated_approval_status` | `string` | | ☐ | | | `payment_term` | `string` | | ☐ | | | `quote_date` | `string` | Quote Date | ☐ | | | `quote_number` | `string` | Quote Number | ☐ | | | `quote_subject` | `string` | Quote Subject | ☐ | | | `quotestatus_color` | `string` | | ☐ | | | `quotestatus_id` | `string` | | ☐ | | | `quotestatus_label` | `string` | | ☐ | | | `quotetemplate_created_at` | `string` | | ☐ | | | `quotetemplate_description` | `string` | | ☐ | | | `quotetemplate_html` | `string` | | ☐ | | | `quotetemplate_id` | `string` | | ☐ | | | `quotetemplate_is_blocked` | `boolean` | | ☐ | | | `quotetemplate_json` | `string` | | ☐ | | | `quotetemplate_name` | `string` | | ☐ | | | `quotetemplate_type` | `string` | | ☐ | | | `quotetemplate_updated_at` | `string` | | ☐ | | | `receivers` | `string` | | ☐ | | | `sales_id` | `string` | Sale ID | ☐ | | | `send_type` | `string` | Delivery Type | ☐ | | | `sent_at` | `string` | Sent On | ☐ | | | `total_excl` | `string` | Total excl | ☐ | | | `total_incl` | `string` | Total incl | ☐ | | | `total_vat` | `string` | Total VAT | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `valid_days` | `int64` | Valid Days | ☐ | | | `vat` | `string` | | ☐ | |