# DDI_Profit_Crediteuren: DDI Profit Creditors ## Documentation DDI_Suppliers (Profit) - Name: `DDI_Profit_Crediteuren` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: DDI Profit Creditors ## Table Columns The columns of the table `DDI_Profit_Crediteuren` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Adres` | `string` | Address | | | | `Automatisch_betalen` | `boolean` | Pay automatically | | | | `Bank-_girorekeningnummer` | `string` | Bank account | | | | `Betaalvoorwaarde` | `string` | Payment term | | | | `BTW-nummer` | `string` | VAT number | | | | `Crediteur` | `string` | Number | | | | `Crediteurnaam` | `string` | Supplier name | | | | `Debiteurennummer` | `string` | Customer number | | | | `Debiteurnr_leverancier` | `string` | Customer no. (supplier) | | | | `G-rekening` | `string` | G-account | | | | `IBAN` | `string` | IBAN | | | | `Land` | `string` | Country | | | | `Nummer_KvK` | `string` | Chamber of Commerce number | | | | `Postcode` | `string` | Postcode | | | | `Tijdelijk_blokkeren` | `boolean` | Block temporarily | | | | `Vervaldagen` | `int32` | Due days | | | | `Volledig_blokkeren` | `boolean` | Block completely, no longer visible | | | | `Voorkeur_tegenrekening` | `string` | Preferred contra account | | | | `Woonplaats` | `string` | City | | | | `Zoeknaam` | `string` | Search name | | |