# VPLAN_SalesOrder: Vplan Sales Order ## Documentation VPLAN_SalesOrder - Name: `VPLAN_SalesOrder` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Vplan Sales Order - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/VPLAN_SalesOrder` - Insert Service URL (OData-specific): `/connectors/VPLAN_SalesOrder` - Update Service URL (OData-specific): `/connectors/VPLAN_SalesOrder` - Delete Service URL (OData-specific): `/connectors/VPLAN_SalesOrder` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `VPLAN_SalesOrder` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `afas_created_at` | `datetime` | Created on | | | | `afas_updated_at` | `datetime` | Modified on | | | | `city` | `string(50)` | City | | | | `contact` | `string(80)` | Representative | | | | `country` | `string(3)` | Country | | | | `date` | `datetime` | Date | | | | `delivered_date` | `datetime` | Actual delivery date | | | | `desired_date` | `datetime` | Requested delivery date | | | | `external_ref` | `string(12)` | Number | | | | `houseadd` | `string(30)` | House number suffix | | | | `houseno` | `int32` | House number | | | | `note` | `string` | Remark | | | | `postcode` | `string(15)` | Postcode | | | | `project` | `string(15)` | Project | | | | `promised_date` | `datetime` | Delivery date (promised) | | | | `relation` | `string(16)` | Sales relation | | | | `relation_ref` | `string(100)` | Assignment number/reference | | | | `status` | `string(100)` | Status | | | | `street` | `string(60)` | Street | | | | `warehouse` | `string(15)` | Warehouse | | |