# SalesServiceQuotes: Simplicate Sales Service Targets Fetches all available quote templates for sales This is a read-only table. The Simplicate API may not support modifying the data, or the Invantive UniversalSQL driver for Simplicate does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Simplicate API. - Catalog: `Simplicate` - Schema: `Sales` - Label: Sales Service Targets ## Table Columns The columns of the table `SalesServiceQuotes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `float` | Amount | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created_by` | `string` | Created By | ☐ | | | `customer_reference` | `string` | Customer Reference | ☐ | | | `default_service_id` | `string` | Default Service ID | ☐ | | | `download_url` | `string` | Download URL | ☐ | | | `explanation` | `string` | Explanation | ☐ | | | `grand_totals` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_method` | `string` | Invoice Method: | ☐ | | | `is_blocked` | `int64` | Blocked | ☐ | | | `is_outdated` | `int64` | Is Outdated | ☐ | | | `is_sepa_authorization` | `int64` | | ☐ | | | `json` | `string` | JSON | ☐ | | | `last_updated_approval_status` | `string` | | ☐ | | | `name` | `string` | Name | ☐ | | | `payment_term` | `string` | | ☐ | | | `position` | `int64` | Position | ☐ | | | `price` | `float` | Price | ☐ | | | `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_2` | `string` | | ☐ | | | `sales_id` | `string` | Sale ID | ☐ | | | `send_type` | `string` | Delivery Type | ☐ | | | `sent_at` | `string` | Sent On | ☐ | | | `show_itemtype` | `int64` | Display Item Type | ☐ | | | `subscription_cycle` | `string` | Subscription Cycle | ☐ | | | `total_excl` | `string` | Total excl | ☐ | | | `total_incl` | `string` | Total incl | ☐ | | | `total_vat` | `string` | Total VAT | ☐ | | | `total` | `string` | Sum | ☐ | | | `track_cost` | `boolean` | Track Costs | ☐ | | | `track_hours` | `boolean` | Register Hours | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `valid_days` | `int64` | Valid Days | ☐ | | | `vat_code` | `string` | VAT Code | ☐ | | | `vat_description` | `string` | VAT Description | ☐ | | | `vat` | `string` | | ☐ | |