# Invoices: Simplicate Invoices Fetches all invoices Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Invoices` - Primary Keys: `id` - Label: Invoices ## Table Columns The columns of the table `Invoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `comments` | `string` | Notes | ☐ | | | `composition_type` | `string` | Composition Type | ☐ | | | `contact_id` | `string` | Contact Person ID | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `date` | `string` | Date | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_number` | `string` | Invoice Number | ☐ | | | `my_organization_profile_id_2` | `string` | | ☐ | | | `my_organization_profile_id` | `string` | My Organisation Profile ID | ☐ | | | `my_organization_profile_organization_id` | `string` | | ☐ | | | `my_organization_profile_organization_name` | `string` | | ☐ | | | `my_organization_profile_organization_relation_number` | `string` | | ☐ | | | `organization_id_2` | `string` | | ☐ | | | `organization_id` | `string` | Organisation ID | ☐ | | | `organization_name` | `string` | Organisation Name | ☐ | | | `organization_relation_number` | `string` | | ☐ | | | `payment_term_days` | `int64` | Payment Term Days | ☐ | | | `payment_term_id` | `string` | Payment Term ID | ☐ | | | `payment_term_method` | `string` | Payment Term Method | ☐ | | | `payment_term_name` | `string` | Payment Term Name | ☐ | | | `person_full_name` | `string` | Person Full Name | ☐ | | | `person_id_2` | `string` | | ☐ | | | `person_id` | `string` | Person ID | ☐ | | | `person_relation_number` | `string` | | ☐ | | | `project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `project_id_2` | `string` | | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `project_name` | `string` | Project Name | ☐ | | | `project_organization_id` | `string` | Project Organisation ID | ☐ | | | `project_organization_name` | `string` | Project Organisation Name | ☐ | | | `project_organization_relation_number` | `string` | | ☐ | | | `project_person_full_name` | `string` | Project Person Full Name | ☐ | | | `project_person_id` | `string` | Project Person ID | ☐ | | | `project_person_relation_number` | `string` | | ☐ | | | `project_project_manager_amount` | `float` | Project Manager Amount | ☐ | | | `project_project_manager_declarable` | `string` | Project Manager Billable | ☐ | | | `project_project_manager_employee_id` | `string` | Project Manager Employee ID | ☐ | | | `project_project_manager_id` | `string` | Project Manager ID | ☐ | | | `project_project_manager_name` | `string` | Project Manager Name | ☐ | | | `project_project_manager_person_id` | `string` | Project Manager Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_project_manager_tariff` | `float` | Project Manager Rate | ☐ | | | `project_project_number` | `string` | Project Number | ☐ | | | `reference` | `string` | Reference | ☐ | | | `reminder_next_action` | `string` | | ☐ | | | `reminder_paused` | `boolean` | | ☐ | | | `reminder_set_disabled` | `boolean` | | ☐ | | | `reminder_set_label` | `string` | | ☐ | | | `reminder_status` | `string` | | ☐ | | | `sending_method` | `string` | Delivery Method | ☐ | | | `simplicate_url` | `string` | Simplicate URL | ☐ | | | `status` | `string` | Status | ☐ | | | `subject` | `string` | Subject | ☐ | | | `subscription_cycle_end_date` | `string` | | ☐ | | | `subscription_cycle_is_invoiced` | `boolean` | | ☐ | | | `subscription_cycle_start_date` | `string` | | ☐ | | | `timeline_email_address` | `string` | Timeline Email Address | ☐ | | | `total_excluding_vat` | `float` | Total excluding VAT | ☐ | | | `total_including_vat` | `float` | Total including VAT | ☐ | | | `total_outstanding` | `float` | Total Outstanding | ☐ | | | `total_vat` | `float` | Total VAT | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |