invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

InvoiceLineInvoices: Simplicate itgen_spe_invoicelineinvoices_plural

read only REST

  • Catalogus: Simplicate
  • Schema: Invoices
  • Label: itgen_spe_invoicelineinvoices_plural

Haalt alle facturen op

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /invoices/invoice
  • Operatie: get /invoices/invoice

Tabelkolommen

De kolommen van de tabel InvoiceLineInvoices 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.

Name Datatype Label Required Marks Documentation
amount double Amount
comments varchar2 Comments
composition_type varchar2 Compositietype
contact_id varchar2 Contactpersoon ID
created varchar2 Created
created_2 varchar2 itgen_spe_created_2
created_at varchar2 Aangemaakt op
created_at_2 varchar2 itgen_spe_created_at_2
date varchar2 Date
date_2 varchar2 itgen_spe_date_2
default_service_id varchar2 Standaard Service ID
description varchar2 Description
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
invoice_number varchar2 Factuurnummer
is_advance_deposit char itgen_spe_is_advance_deposit
my_organization_profile_id varchar2 Mijn Organisatieprofiel ID
my_organization_profile_id_2 varchar2 itgen_spe_my_organization_profile_id_2
my_organization_profile_organization_id varchar2 itgen_spe_my_organization_profile_organization_id
my_organization_profile_organization_name varchar2 itgen_spe_my_organization_profile_organization_name
my_organization_profile_organization_relation_number varchar2 itgen_spe_my_organization_profile_organization_relation_number
organization_id varchar2 Organisatie ID
organization_id_2 varchar2 itgen_spe_organization_id_2
organization_name varchar2 Organisatienaam
organization_relation_number varchar2 itgen_spe_organization_relation_number
payment_term_days int64 Betalingstermijn Dagen
payment_term_id varchar2 Betalingstermijn-ID
payment_term_method varchar2 Betaaltermijn Methode
payment_term_name varchar2 Betalingstermijn Naam
person_full_name varchar2 Volledige Naam Persoon
person_id varchar2 Persoon ID
person_id_2 varchar2 itgen_spe_person_id_2
person_relation_number varchar2 itgen_spe_person_relation_number
price double Price
project_has_register_mileage_enabled char itgen_spe_project_has_register_mileage_enabled
project_id varchar2 Project ID
project_id_2 varchar2 itgen_spe_project_id_2
project_name varchar2 Projectnaam
project_organization_id varchar2 Projectorganisatie-ID
project_organization_name varchar2 Naam Projectorganisatie
project_organization_relation_number varchar2 itgen_spe_project_organization_relation_number
project_person_full_name varchar2 Project Persoon Volledige naam
project_person_id varchar2 Projectpersoon-ID
project_person_relation_number varchar2 itgen_spe_project_person_relation_number
project_project_manager_amount double Projectmanager Bedrag
project_project_manager_declarable varchar2 Projectmanager Declarable
project_project_manager_employee_id varchar2 Projectmanager Werknemer ID
project_project_manager_id varchar2 Projectmanager ID
project_project_manager_name varchar2 Projectmanager Naam
project_project_manager_person_id varchar2 Projectmanager Persoon ID Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie
project_project_manager_tariff double Projectmanager Tarief
project_project_number varchar2 Projectnummer
reference varchar2 Reference
reminder_next_action varchar2 itgen_spe_reminder_next_action
reminder_paused char itgen_spe_reminder_paused
reminder_set_disabled char itgen_spe_reminder_set_disabled
reminder_set_label varchar2 itgen_spe_reminder_set_label
reminder_status varchar2 itgen_spe_reminder_status
revenue_group_id varchar2 Inkomstengroep-ID
revenue_group_label varchar2 Omzetgroep Label
sending_method varchar2 Verzendmethode
service_id varchar2 Service-ID
simplicate_url varchar2 Simplicate URL
status varchar2 Status
subject varchar2 Subject
subscription_cycle_end_date varchar2 itgen_spe_subscription_cycle_end_date
subscription_cycle_is_invoiced char itgen_spe_subscription_cycle_is_invoiced
subscription_cycle_start_date varchar2 itgen_spe_subscription_cycle_start_date
timeline_email_address varchar2 Tijdlijn e-mailadres
total_excluding_vat double Totaal exclusief BTW
total_including_vat double Totaal inclusief BTW
total_outstanding double Totaal Uitstaand
total_vat double Totaal BTW
total_vat_2 double itgen_spe_total_vat_2
updated_at varchar2 Bijgewerkt op
updated_at_2 varchar2 itgen_spe_updated_at_2
vat_class_code varchar2 BTW-klassecode
vat_class_id varchar2 BTW-klasse ID
vat_class_label varchar2 Btw-Klasse Label
vat_class_name varchar2 BTW-klasse Naam
vat_class_percentage double BTW-Klasse Percentage

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: