---
title: "Debtors (Simplicate)"
description: "Debtors"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.CRM.Debtors
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.CRM.Debtors
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

