InvoiceProjects: Simplicate Invoice Projects
read only REST
- Catalog:
Simplicate - Schema:
Invoices - Label: Invoice Projects
Fetches all invoices
Can only retrieve data.
API Source
- Endpoint:
/invoices/invoice - Operation:
get /invoices/invoice
Table Columns
The columns of the table InvoiceProjects are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
comments |
varchar2 |
Comments | |||
composition_ |
varchar2 |
Composition Type | |||
contact_ |
varchar2 |
Contact ID | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
date |
varchar2 |
Date | |||
has_ |
char |
itgen_spe_has_register_mileage_enabled | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Invoice Number | |||
my_ |
varchar2 |
My Organisation Profile 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 | |||
name |
varchar2 |
Name | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
itgen_spe_organization_id_3 | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_name_2 | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number_2 | |||
payment_ |
int64 |
Payment Term Days | |||
payment_ |
varchar2 |
Payment Term ID | |||
payment_ |
varchar2 |
Payment Term Method | |||
payment_ |
varchar2 |
Payment Term Name | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
itgen_spe_person_full_name_2 | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_id_3 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_number_2 | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
itgen_spe_project_id_2 | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Number | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
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 | |||
sending_ |
varchar2 |
Sending Method | |||
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 |
Timeline Email Address | |||
total_ |
double |
Total excluding VAT | |||
total_ |
double |
Total including VAT | |||
total_ |
double |
Total Outstanding | |||
total_ |
double |
Total VAT | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: