invantive documentation
Invantive Support ForumsLog In / Sign Up

Debtors: Simplicate Debtors

read only REST

  • Catalog: Simplicate
  • Schema: CRM
  • Label: Debtors

Fetches all debtors available (organization and if business to consumer is enabled person also

Can only retrieve data.

API Source

  • Endpoint: /crm/debtor
  • Operation: get /crm/debtor

Table Columns

The columns of the table Debtors 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
organization_id varchar2 Organisation ID
organization_name varchar2 Organisation Name
organization_relation_number varchar2 itgen_spe_organization_relation_number
organization_relation_type_color varchar2 itgen_spe_organization_relation_type_color
organization_relation_type_id varchar2 itgen_spe_organization_relation_type_id
organization_relation_type_label varchar2 itgen_spe_organization_relation_type_label
organization_relation_type_type varchar2 itgen_spe_organization_relation_type_type
person_full_name varchar2 Person Full Name
person_id varchar2 Person ID
person_relation_number varchar2 itgen_spe_person_relation_number
person_relation_type_color varchar2 itgen_spe_person_relation_type_color
person_relation_type_id varchar2 itgen_spe_person_relation_type_id
person_relation_type_label varchar2 itgen_spe_person_relation_type_label
person_relation_type_type varchar2 itgen_spe_person_relation_type_type

Release Notes

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