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_ |
varchar2 |
Compositietype | |||
contact_ |
varchar2 |
Contactpersoon ID | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
itgen_spe_created_2 | |||
created_ |
varchar2 |
Aangemaakt op | |||
created_ |
varchar2 |
itgen_spe_created_at_2 | |||
date |
varchar2 |
Date | |||
date_2 |
varchar2 |
itgen_spe_date_2 | |||
default_ |
varchar2 |
Standaard Service ID | |||
description |
varchar2 |
Description | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Factuurnummer | |||
is_ |
char |
itgen_spe_is_advance_deposit | |||
my_ |
varchar2 |
Mijn Organisatieprofiel ID | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_id_2 | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_id | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_name | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_relation_number | |||
organization_ |
varchar2 |
Organisatie ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisatienaam | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
payment_ |
int64 |
Betalingstermijn Dagen | |||
payment_ |
varchar2 |
Betalingstermijn-ID | |||
payment_ |
varchar2 |
Betaaltermijn Methode | |||
payment_ |
varchar2 |
Betalingstermijn Naam | |||
person_ |
varchar2 |
Volledige Naam Persoon | |||
person_ |
varchar2 |
Persoon ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
price |
double |
Price | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
itgen_spe_project_id_2 | |||
project_ |
varchar2 |
Projectnaam | |||
project_ |
varchar2 |
Projectorganisatie-ID | |||
project_ |
varchar2 |
Naam Projectorganisatie | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Persoon Volledige naam | |||
project_ |
varchar2 |
Projectpersoon-ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Projectmanager Bedrag | |||
project_ |
varchar2 |
Projectmanager Declarable | |||
project_ |
varchar2 |
Projectmanager Werknemer ID | |||
project_ |
varchar2 |
Projectmanager ID | |||
project_ |
varchar2 |
Projectmanager Naam | |||
project_ |
varchar2 |
Projectmanager Persoon ID | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
project_ |
double |
Projectmanager Tarief | |||
project_ |
varchar2 |
Projectnummer | |||
reference |
varchar2 |
Reference | |||
reminder_ |
varchar2 |
itgen_spe_reminder_next_action | |||
reminder_ |
char |
itgen_spe_reminder_paused | |||
reminder_ |
char |
itgen_spe_reminder_set_disabled | |||
reminder_ |
varchar2 |
itgen_spe_reminder_set_label | |||
reminder_ |
varchar2 |
itgen_spe_reminder_status | |||
revenue_ |
varchar2 |
Inkomstengroep-ID | |||
revenue_ |
varchar2 |
Omzetgroep Label | |||
sending_ |
varchar2 |
Verzendmethode | |||
service_ |
varchar2 |
Service-ID | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
status |
varchar2 |
Status | |||
subject |
varchar2 |
Subject | |||
subscription_ |
varchar2 |
itgen_spe_subscription_cycle_end_date | |||
subscription_ |
char |
itgen_spe_subscription_cycle_is_invoiced | |||
subscription_ |
varchar2 |
itgen_spe_subscription_cycle_start_date | |||
timeline_ |
varchar2 |
Tijdlijn e-mailadres | |||
total_ |
double |
Totaal exclusief BTW | |||
total_ |
double |
Totaal inclusief BTW | |||
total_ |
double |
Totaal Uitstaand | |||
total_ |
double |
Totaal BTW | |||
total_ |
double |
itgen_spe_total_vat_2 | |||
updated_ |
varchar2 |
Bijgewerkt op | |||
updated_ |
varchar2 |
itgen_spe_updated_at_2 | |||
vat_ |
varchar2 |
BTW-klassecode | |||
vat_ |
varchar2 |
BTW-klasse ID | |||
vat_ |
varchar2 |
Btw-Klasse Label | |||
vat_ |
varchar2 |
BTW-klasse Naam | |||
vat_ |
double |
BTW-Klasse Percentage |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: