# AFASPocket_User: Users ## Documentation AFASPocket_User - Name: `AFASPocket_User` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Users - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/AFASPocket_User` - Insert Service URL (OData-specific): `/connectors/AFASPocket_User` - Update Service URL (OData-specific): `/connectors/AFASPocket_User` - Delete Service URL (OData-specific): `/connectors/AFASPocket_User` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `AFASPocket_User` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `blocked` | `boolean` | Blocked | | | | `city` | `string(50)` | City | | | | `city_work` | `string(50)` | Work city | | | | `country` | `string(3)` | Country | | | | `country_work` | `string(3)` | Work country | | | | `date_of_birth` | `datetime` | Date of birth | | | | `email_work` | `string(255)` | Work email | | | | `employer` | `string(255)` | Employer name | | | | `employment_id` | `int32` | Employment | | | | `firstname` | `string(50)` | First Name | | | | `gender` | `string(100)` | Gender | | | | `given_name` | `string(80)` | Nickname | | | | `housenumber` | `int32` | House number | | | | `housenumber_extension` | `string(30)` | House number suffix | | | | `housenumber_extension_work` | `string(30)` | Work house number suffix | | | | `housenumber_work` | `int32` | Work house number | | | | `id` | `string(15)` | Employee | | | | `initials` | `string(15)` | Initials | | | | `lastname` | `string(80)` | Last Name | | | | `mobile_private` | `string(255)` | Private mobile | | | | `mobile_work` | `string(255)` | Work mobile | | | | `phone_private` | `string(255)` | Private phone number | | | | `phone_work` | `string(255)` | Work phone number | | | | `position` | `string(80)` | Job title (translated description) | | | | `postalcode_work` | `string(15)` | Work postal code | | | | `prefix` | `string(15)` | Name prefix | | | | `street` | `string(60)` | Street | | | | `street_work` | `string(60)` | Work street | | | | `username` | `string(80)` | User | | | | `zipcode` | `string(15)` | Postcode | | |