# AFASPocket_Projects: Projects (AFAS Pocket) ## Documentation AFASPocket_Projects - Name: `AFASPocket_Projects` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Projects (AFAS Pocket) - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/AFASPocket_Projects` - Insert Service URL (OData-specific): `/connectors/AFASPocket_Projects` - Update Service URL (OData-specific): `/connectors/AFASPocket_Projects` - Delete Service URL (OData-specific): `/connectors/AFASPocket_Projects` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `AFASPocket_Projects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `client_id` | `string(15)` | Number | | | | `end_date` | `datetime` | Actual completion date | | | | `finished` | `boolean` | Reported off | | | | `project_billable` | `boolean` | Sales relation | | | | `project_id` | `string(15)` | Project | | | | `project_name` | `string(100)` | Description | | |