# Debiteuren: Debtors ## Documentation Customers - Name: `Debiteuren` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Debtors ## 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` | Country ISO alpha-2 | | | | `A_Land1` | `string` | Visiting address country | | | | `A_Postcode` | `string` | Visiting address postal code | | | | `A_Straat` | `string` | Visiting address street | | | | `A_Toevoeging` | `string` | Visiting address house number suffix | | | | `A_Woonplaats` | `string` | Visiting address city | | | | `Activate` | `string` | Activate | | | | `Bank-_girorekeningnummer` | `string` | Bank/giro account number | | | | `Bedrijf` | `string` | Relation name | | | | `BTW` | `string` | VAT number | | | | `Contactpersoon_factuur` | `int32` | Invoice contact person | | | | `DebiteurID` | `string` | Customer | | | | `F_Huisnummer` | `int32` | Postal address house number | | | | `F_Id` | `int32` | Postal address | | | | `F_Land` | `string` | ISO Alpha-2 | | | | `F_Land1` | `string` | Postal address country | | | | `F_Postcode` | `string` | Postal address postal code | | | | `F_Straat` | `string` | Postal address street | | | | `F_Toevoeging` | `string` | Postal address house number suffix | | | | `F_Woonplaats` | `string` | Postal address city | | | | `Fax` | `string` | Work fax | | | | `Geboortedatum__JJJJMMDD_` | `string` | Date of birth (YYYYMMDD) | | | | `Geslacht` | `string` | Contact type code | | | | `KvK` | `string` | Chamber of Commerce number | | | | `Mail` | `string` | Work email | | | | `Naam` | `string` | Name | | | | `OrgId` | `string` | OrgId | | | | `Password` | `string` | Password | | | | `Rechtsvorm` | `string` | Legal form | | | | `Tel` | `string` | Work phone number | | | | `Voorl` | `string` | Initials | | | | `Voorn` | `string` | First Name | | | | `Voorv` | `string` | Name prefix | | |