Invoices: Simplicate Invoices
insert update delete REST
- Catalog:
Simplicate - Schema:
Invoices - Primary Keys:
id - Label: Invoices
Fetches all invoices
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/invoices/invoice - Operation:
get /invoices/invoice
Table Columns
The columns of the table Invoices 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 | |||
id |
varchar2 |
ID | |||
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 | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
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 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
itgen_spe_project_id_2 | |||
project_ |
varchar2 |
Project Name | |||
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: