# DDI_Profit_Crediteuren: DDI Profit Creditors ## Documentation DDI_Suppliers (Profit) - Name: `DDI_Profit_Crediteuren` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: DDI Profit Creditors - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/DDI_Profit_Crediteuren` - Insert Service URL (OData-specific): `/connectors/DDI_Profit_Crediteuren` - Update Service URL (OData-specific): `/connectors/DDI_Profit_Crediteuren` - Delete Service URL (OData-specific): `/connectors/DDI_Profit_Crediteuren` - Field Selection Method (OData-specific): NotRequired ## 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(255)` | Address | | | | `Automatisch_betalen` | `boolean` | Pay automatically | | | | `Bank-_girorekeningnummer` | `string(40)` | Bank account | | | | `Betaalvoorwaarde` | `string(5)` | Payment term | | | | `BTW-nummer` | `string(21)` | VAT number | | | | `Crediteur` | `string(16)` | Number | | | | `Crediteurnaam` | `string(80)` | Supplier name | | | | `Debiteurennummer` | `string(14)` | Customer number | | | | `Debiteurnr_leverancier` | `string(14)` | Customer no. (supplier) | | | | `G-rekening` | `string(40)` | G-account | | | | `IBAN` | `string(40)` | IBAN | | | | `Land` | `string(3)` | Country | | | | `Nummer_KvK` | `string(30)` | Chamber of Commerce number | | | | `Postcode` | `string(15)` | Postcode | | | | `Tijdelijk_blokkeren` | `boolean` | Block temporarily | | | | `Vervaldagen` | `int32` | Due days | | | | `Volledig_blokkeren` | `boolean` | Block completely, no longer visible | | | | `Voorkeur_tegenrekening` | `string(16)` | Preferred contra account | | | | `Woonplaats` | `string(50)` | City | | | | `Zoeknaam` | `string(10)` | Search name | | |