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_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_type_color | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_type_id | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_type_label | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_type_type | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_color | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_id | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_label | |||
person_ |
varchar2 |
itgen_spe_person_relation_type_type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: