# Profit_Debtor: Debtors ## Documentation Profit_Debtor - Name: `Profit_Debtor` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Debtors - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Debtor` - Insert Service URL (OData-specific): `/connectors/Profit_Debtor` - Update Service URL (OData-specific): `/connectors/Profit_Debtor` - Delete Service URL (OData-specific): `/connectors/Profit_Debtor` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Debtor` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AdressLine1` | `string(255)` | Address line 1 (street - house no.) | | | | `AdressLine3` | `string(255)` | Address line 3 (postal code - city) | | | | `AdressLine4` | `string(255)` | Address line 4 (country) | | | | `AutoPayment` | `boolean` | Collect automatically | | | | `BcCo` | `string(15)` | Org./person number | | | | `Blocked` | `boolean` | Blocked for delivery | | | | `ChOfCommNr` | `string(30)` | Chamber of Commerce number | | | | `CollectAccount` | `string(16)` | Control account | | | | `CreateDate` | `datetime` | Created on | | | | `CreditLimit` | `decimal` | Credit limit | | | | `CurrencyId` | `string(3)` | Currency | | | | `DebtorId` | `string(16)` | Customer number | | | | `DebtorName` | `string(80)` | Customer name | | | | `Email` | `string(255)` | Work email | | | | `IBAN` | `string(40)` | IBAN number | | | | `ModifiedDate` | `datetime` | Modified on | | | | `PayCon` | `string(5)` | Payment term | | | | `SearchName` | `string(10)` | Search name | | | | `TelNr` | `string(255)` | Work phone number | | | | `VatDuty` | `string(3)` | VAT liability | | | | `VatNr` | `string(21)` | VAT number | | |