# SalesServices: Simplicate Sales Service Fetches all services Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Sales` - Primary Keys: `id` - Label: Sales Service ## Table Columns The columns of the table `SalesServices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `float` | Amount | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `default_service_id` | `string` | Default Service ID | ☐ | | | `explanation` | `string` | Explanation | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_date` | `string` | Invoice Date | ☐ | | | `invoice_method` | `string` | Invoice Method: | ☐ | | | `name` | `string` | Name | ☐ | | | `position` | `int64` | Position | ☐ | | | `price` | `float` | Price | ☐ | | | `sales_id` | `string` | Sale ID | ☐ | | | `show_itemtype` | `int64` | Display Item Type | ☐ | | | `subscription_cycle` | `string` | Subscription Cycle | ☐ | | | `total` | `string` | Sum | ☐ | | | `track_cost` | `boolean` | Track Costs | ☐ | | | `track_hours` | `boolean` | Register Hours | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `vat_class_code` | `string` | VAT Class Code | ☐ | | | `vat_class_id` | `string` | VAT Class ID | ☐ | | | `vat_class_label` | `string` | VAT Class Label | ☐ | | | `vat_class_name` | `string` | VAT Class Name | ☐ | | | `vat_class_percentage` | `float` | VAT Class Percentage | ☐ | | | `vat_code` | `string` | VAT Code | ☐ | | | `vat_description` | `string` | VAT Description | ☐ | |