# Profit_Debtor: Debtors ## Documentation Profit_Debtor - Name: `Profit_Debtor` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Debtors ## 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` | Address line 1 (street - house no.) | | | | `AdressLine3` | `string` | Address line 3 (postal code - city) | | | | `AdressLine4` | `string` | Address line 4 (country) | | | | `AutoPayment` | `boolean` | Collect automatically | | | | `BcCo` | `string` | Org./person number | | | | `Blocked` | `boolean` | Blocked for delivery | | | | `ChOfCommNr` | `string` | Chamber of Commerce number | | | | `CollectAccount` | `string` | Control account | | | | `CreateDate` | `datetime` | Created on | | | | `CreditLimit` | `decimal` | Credit limit | | | | `CurrencyId` | `string` | Currency | | | | `DebtorId` | `string` | Customer number | | | | `DebtorName` | `string` | Customer name | | | | `Email` | `string` | Work email | | | | `IBAN` | `string` | IBAN number | | | | `ModifiedDate` | `datetime` | Modified on | | | | `PayCon` | `string` | Payment term | | | | `SearchName` | `string` | Search name | | | | `TelNr` | `string` | Work phone number | | | | `VatDuty` | `string` | VAT liability | | | | `VatNr` | `string` | VAT number | | |