# VPLAN_PurchaseOrder: Vplan Purchase Order ## Documentation VPLAN_PurchaseOrder - Name: `VPLAN_PurchaseOrder` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Vplan Purchase Order - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/VPLAN_PurchaseOrder` - Insert Service URL (OData-specific): `/connectors/VPLAN_PurchaseOrder` - Update Service URL (OData-specific): `/connectors/VPLAN_PurchaseOrder` - Delete Service URL (OData-specific): `/connectors/VPLAN_PurchaseOrder` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `VPLAN_PurchaseOrder` 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 | | | | `contact` | `string(80)` | Representative | | | | `date` | `datetime` | Date | | | | `delivered_date` | `datetime` | Actual delivery date | | | | `description` | `string(255)` | Description | | | | `desired_date` | `datetime` | Requested delivery date | | | | `external_ref` | `string(12)` | Number | | | | `note` | `string` | Remark | | | | `project` | `string(15)` | Project | | | | `promised_date` | `datetime` | Delivery date (promised) | | | | `relation` | `string(16)` | Purchase relation | | | | `relation_ref` | `string(50)` | Purchase relation reference | | | | `status` | `string(100)` | Status | | | | `warehouse` | `string(15)` | Warehouse | | |