InvoiceLineInvoices |
Fetches all invoices
Catalogus: Simplicate
Schema: Invoices
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 InvoiceLineInvoices worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
amount |
float |
Bedrag |
☐ |
|
comments |
string |
Aantekeningen |
☐ |
|
composition_type |
string |
Compositietype |
☐ |
|
contact_id |
string |
Contactpersoon ID |
☐ |
|
created_2 |
string |
|
☐ |
|
created_at_2 |
string |
|
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
created |
string |
Gemaakt |
☐ |
|
date_2 |
string |
|
☐ |
|
date |
string |
Datum |
☐ |
|
default_service_id |
string |
Standaard Service ID |
☐ |
|
description |
string |
Omschrijving |
☐ |
|
id_2 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_number |
string |
Factuurnummer |
☐ |
|
is_advance_deposit |
boolean |
|
☐ |
|
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 |
|
☐ |
|
price |
float |
Prijs |
☐ |
|
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 |
|
☐ |
|
revenue_group_id |
string |
Inkomstengroep-ID |
☐ |
|
revenue_group_label |
string |
Omzetgroep Label |
☐ |
|
sending_method |
string |
Verzendmethode |
☐ |
|
service_id |
string |
Service-ID |
☐ |
|
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_2 |
float |
|
☐ |
|
total_vat |
float |
Totaal BTW |
☐ |
|
updated_at_2 |
string |
|
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
vat_class_code |
string |
BTW-klassecode |
☐ |
|
vat_class_id |
string |
BTW-klasse ID |
☐ |
|
vat_class_label |
string |
Btw-Klasse Label |
☐ |
|
vat_class_name |
string |
BTW-klasse Naam |
☐ |
|
vat_class_percentage |
float |
BTW-Klasse Percentage |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945