| InvoiceProjects: Simplicate Factuurprojecten | 
Fetches all invoices
Catalogus: Simplicate
Schema: Invoices
Label: Factuurprojecten
Dit is een alleen-lezen tabel. De Simplicate API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Simplicate ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Simplicate-API.
Tabelkolommen
De kolommen van de tabel InvoiceProjects worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
| Naam | Datatype | Label | Verplicht | Documentatie | 
|---|---|---|---|---|
| comments | string | Aantekeningen | ☐ | 
 | 
| composition_type | string | Compositietype | ☐ | 
 | 
| contact_id | string | Contactpersoon ID | ☐ | 
 | 
| created_at | string | Aangemaakt op | ☐ | 
 | 
| created | string | Gemaakt | ☐ | 
 | 
| date | string | Datum | ☐ | 
 | 
| has_register_mileage_enabled | boolean | 
 | ☐ | 
 | 
| id_2 | string | 
 | ☐ | 
 | 
| id | string | ID | ☐ | 
 | 
| invoice_number | string | Factuurnummer | ☐ | 
 | 
| my_organization_profile_id_2 | string | 
 | ☐ | 
 | 
| my_organization_profile_id | string | Mijn Organisatieprofiel ID | ☐ | 
 | 
| my_organization_profile_organization_id | string | 
 | ☐ | 
 | 
| my_organization_profile_organization_name | string | 
 | ☐ | 
 | 
| my_organization_profile_organization_relation_number | string | 
 | ☐ | 
 | 
| name | string | Naam | ☐ | 
 | 
| organization_id_2 | string | 
 | ☐ | 
 | 
| organization_id_3 | string | 
 | ☐ | 
 | 
| organization_id | string | Organisatie ID | ☐ | 
 | 
| organization_name_2 | string | 
 | ☐ | 
 | 
| organization_name | string | Organisatienaam | ☐ | 
 | 
| organization_relation_number_2 | string | 
 | ☐ | 
 | 
| organization_relation_number | string | 
 | ☐ | 
 | 
| payment_term_days | int64 | Betalingstermijn Dagen | ☐ | 
 | 
| payment_term_id | string | Betalingstermijn-ID | ☐ | 
 | 
| payment_term_method | string | Betaaltermijn Methode | ☐ | 
 | 
| payment_term_name | string | Betalingstermijn Naam | ☐ | 
 | 
| person_full_name_2 | string | 
 | ☐ | 
 | 
| person_full_name | string | Volledige Naam Persoon | ☐ | 
 | 
| person_id_2 | string | 
 | ☐ | 
 | 
| person_id_3 | string | 
 | ☐ | 
 | 
| person_id | string | Persoon ID | ☐ | 
 | 
| person_relation_number_2 | string | 
 | ☐ | 
 | 
| person_relation_number | string | 
 | ☐ | 
 | 
| project_has_register_mileage_enabled | boolean | 
 | ☐ | 
 | 
| project_id_2 | string | 
 | ☐ | 
 | 
| project_id | string | Project ID | ☐ | 
 | 
| project_manager_amount | float | 
 | ☐ | 
 | 
| project_manager_declarable | string | 
 | ☐ | 
 | 
| project_manager_employee_id | string | 
 | ☐ | 
 | 
| project_manager_id | string | 
 | ☐ | 
 | 
| project_manager_name | string | 
 | ☐ | 
 | 
| project_manager_person_id | string | 
 | ☐ | Added in order to comply with the original sales/sales responsible_employee response | 
| project_manager_tariff | float | 
 | ☐ | 
 | 
| project_name | string | Projectnaam | ☐ | 
 | 
| project_number | string | Projectnummer | ☐ | 
 | 
| project_organization_id | string | Projectorganisatie-ID | ☐ | 
 | 
| project_organization_name | string | Naam Projectorganisatie | ☐ | 
 | 
| project_organization_relation_number | string | 
 | ☐ | 
 | 
| project_person_full_name | string | Project Persoon Volledige naam | ☐ | 
 | 
| project_person_id | string | Projectpersoon-ID | ☐ | 
 | 
| project_person_relation_number | string | 
 | ☐ | 
 | 
| project_project_manager_amount | float | Projectmanager Bedrag | ☐ | 
 | 
| project_project_manager_declarable | string | Projectmanager Declarable | ☐ | 
 | 
| project_project_manager_employee_id | string | Projectmanager Werknemer ID | ☐ | 
 | 
| project_project_manager_id | string | Projectmanager ID | ☐ | 
 | 
| project_project_manager_name | string | Projectmanager Naam | ☐ | 
 | 
| project_project_manager_person_id | string | Projectmanager Persoon ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | 
| project_project_manager_tariff | float | Projectmanager Tarief | ☐ | 
 | 
| project_project_number | string | Projectnummer | ☐ | 
 | 
| reference | string | Verwijzing | ☐ | 
 | 
| reminder_next_action | string | 
 | ☐ | 
 | 
| reminder_paused | boolean | 
 | ☐ | 
 | 
| reminder_set_disabled | boolean | 
 | ☐ | 
 | 
| reminder_set_label | string | 
 | ☐ | 
 | 
| reminder_status | string | 
 | ☐ | 
 | 
| sending_method | string | Verzendmethode | ☐ | 
 | 
| simplicate_url | string | Simplicate URL | ☐ | 
 | 
| status | string | Status | ☐ | 
 | 
| subject | string | Onderwerp | ☐ | 
 | 
| subscription_cycle_end_date | string | 
 | ☐ | 
 | 
| subscription_cycle_is_invoiced | boolean | 
 | ☐ | 
 | 
| subscription_cycle_start_date | string | 
 | ☐ | 
 | 
| timeline_email_address | string | Tijdlijn e-mailadres | ☐ | 
 | 
| total_excluding_vat | float | Totaal exclusief BTW | ☐ | 
 | 
| total_including_vat | float | Totaal inclusief BTW | ☐ | 
 | 
| total_outstanding | float | Totaal Uitstaand | ☐ | 
 | 
| total_vat | float | Totaal BTW | ☐ | 
 | 
| updated_at | string | Bijgewerkt op | ☐ | 
 | 
18-10-2024 06:48 Versie 24.0.345-PROD+4945
 Simplicate API Data Model
Simplicate API Data Model
  