Invoices: Simplicate Facturen |
Fetches all invoices
Catalogus: Simplicate
Schema: Invoices
Primaire Sleutels: id
Label: Facturen
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Invoices worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
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 |
☐ |
|
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 |
|
☐ |
|
organization_id_2 |
string |
|
☐ |
|
organization_id |
string |
Organisatie ID |
☐ |
|
organization_name |
string |
Organisatienaam |
☐ |
|
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 |
string |
Volledige Naam Persoon |
☐ |
|
person_id_2 |
string |
|
☐ |
|
person_id |
string |
Persoon ID |
☐ |
|
person_relation_number |
string |
|
☐ |
|
project_has_register_mileage_enabled |
boolean |
|
☐ |
|
project_id_2 |
string |
|
☐ |
|
project_id |
string |
Project ID |
☐ |
|
project_name |
string |
Projectnaam |
☐ |
|
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