invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceById: Simplicate Invoice by ID

read only REST

  • Catalog: Simplicate
  • Schema: Invoices
  • Label: Invoice by ID

Fetches a single invoice by id

Can only retrieve data.

API Source

  • Endpoint: /invoices/invoice/{id}
  • Operation: get /invoices/invoice/{id}

Parameters

Name Data Type Required Default Documentation
id `` The template's id

Table Columns

The columns of the table InvoiceById 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_type varchar2 Composition Type
contact_id varchar2 Contact ID
created varchar2 Created
created_at varchar2 Created at
date varchar2 Date
id varchar2 ID
invoice_number varchar2 Invoice Number
my_organization_profile_id varchar2 My Organisation Profile 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 Organisation ID
organization_id_2 varchar2 itgen_spe_organization_id_2
organization_name varchar2 Organisation Name
organization_relation_number varchar2 itgen_spe_organization_relation_number
payment_term_days int64 Payment Term Days
payment_term_id varchar2 Payment Term ID
payment_term_method varchar2 Payment Term Method
payment_term_name varchar2 Payment Term Name
person_full_name varchar2 Person Full Name
person_id varchar2 Person ID
person_id_2 varchar2 itgen_spe_person_id_2
person_relation_number varchar2 itgen_spe_person_relation_number
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 Project Name
project_organization_id varchar2 Project Organisation ID
project_organization_name varchar2 Project Organisation Name
project_organization_relation_number varchar2 itgen_spe_project_organization_relation_number
project_person_full_name varchar2 Project Person Full Name
project_person_id varchar2 Project Person ID
project_person_relation_number varchar2 itgen_spe_project_person_relation_number
project_project_manager_amount double Project Manager Amount
project_project_manager_declarable varchar2 Project Manager Declarable
project_project_manager_employee_id varchar2 Project Manager Employee ID
project_project_manager_id varchar2 Project Manager ID
project_project_manager_name varchar2 Project Manager Name
project_project_manager_person_id varchar2 Project Manager Person ID Added in order to comply with the original sales/sales responsible_employee response
project_project_manager_tariff double Project Manager Tariff
project_project_number varchar2 Project Number
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
sending_method varchar2 Sending Method
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 Timeline Email Address
total_excluding_vat double Total excluding VAT
total_including_vat double Total including VAT
total_outstanding double Total Outstanding
total_vat double Total VAT
updated_at varchar2 Updated at

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: