# AFASPocket_Contacts: Contacts (AFAS Pocket) ## Documentation AFASPocket_Contacts - Name: `AFASPocket_Contacts` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Contacts (AFAS Pocket) - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/AFASPocket_Contacts` - Insert Service URL (OData-specific): `/connectors/AFASPocket_Contacts` - Update Service URL (OData-specific): `/connectors/AFASPocket_Contacts` - Delete Service URL (OData-specific): `/connectors/AFASPocket_Contacts` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `AFASPocket_Contacts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `city` | `string(50)` | City | | | | `country` | `string(3)` | country | | | | `customer` | `boolean` | Sales relation | | | | `date_of_birth` | `datetime` | Date of birth | | | | `email_work` | `string(255)` | Work email | | | | `firstname` | `string(50)` | First Name | | | | `gender` | `string(10)` | Gender | | | | `housenumber` | `int32` | House number | | | | `housenumber_extension` | `string(30)` | House number suffix | | | | `id` | `string(15)` | Number | | | | `initials` | `string(15)` | Initials | | | | `lastname` | `string(80)` | Last Name | | | | `name` | `string(255)` | Name | | | | `phone_mobile` | `string(255)` | Work mobile | | | | `phone_work` | `string(255)` | Work phone number | | | | `position` | `string(50)` | Job title description | | | | `prefix` | `string(15)` | Name prefix | | | | `street` | `string(60)` | Street | | | | `type` | `string(100)` | Basic contact type | | | | `updated_at` | `datetime` | Modified on | | | | `website` | `string(255)` | Website | | | | `zipcode` | `string(15)` | Postcode | | |