# Debiteuren: Debtors ## Documentation Customers - Name: `Debiteuren` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Debtors - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Debiteuren` - Insert Service URL (OData-specific): `/connectors/Debiteuren` - Update Service URL (OData-specific): `/connectors/Debiteuren` - Delete Service URL (OData-specific): `/connectors/Debiteuren` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Debiteuren` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `A_Huisnummer` | `int32` | Visiting address house number | | | | `A_Id` | `int32` | Visiting address | | | | `A_Land` | `string(2)` | Country ISO alpha-2 | | | | `A_Land1` | `string(3)` | Visiting address country | | | | `A_Postcode` | `string(15)` | Visiting address postal code | | | | `A_Straat` | `string(60)` | Visiting address street | | | | `A_Toevoeging` | `string(30)` | Visiting address house number suffix | | | | `A_Woonplaats` | `string(50)` | Visiting address city | | | | `Activate` | `string(50)` | Activate | | | | `Bank-_girorekeningnummer` | `string(40)` | Bank/giro account number | | | | `Bedrijf` | `string(255)` | Relation name | | | | `BTW` | `string(21)` | VAT number | | | | `Contactpersoon_factuur` | `int32` | Invoice contact person | | | | `DebiteurID` | `string(16)` | Customer | | | | `F_Huisnummer` | `int32` | Postal address house number | | | | `F_Id` | `int32` | Postal address | | | | `F_Land` | `string(2)` | ISO Alpha-2 | | | | `F_Land1` | `string(3)` | Postal address country | | | | `F_Postcode` | `string(15)` | Postal address postal code | | | | `F_Straat` | `string(60)` | Postal address street | | | | `F_Toevoeging` | `string(30)` | Postal address house number suffix | | | | `F_Woonplaats` | `string(50)` | Postal address city | | | | `Fax` | `string(255)` | Work fax | | | | `Geboortedatum__JJJJMMDD_` | `string(8)` | Date of birth (YYYYMMDD) | | | | `Geslacht` | `string(20)` | Contact type code | | | | `KvK` | `string(30)` | Chamber of Commerce number | | | | `Mail` | `string(255)` | Work email | | | | `Naam` | `string(80)` | Name | | | | `OrgId` | `string(15)` | OrgId | | | | `Password` | `string(50)` | Password | | | | `Rechtsvorm` | `string(50)` | Legal form | | | | `Tel` | `string(255)` | Work phone number | | | | `Voorl` | `string(15)` | Initials | | | | `Voorn` | `string(50)` | First Name | | | | `Voorv` | `string(15)` | Name prefix | | |