# VPLAN_PurchaseRelation: Vplan Purchase Relation ## Documentation VPLAN_PurchaseRelation - Name: `VPLAN_PurchaseRelation` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Vplan Purchase Relation - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/VPLAN_PurchaseRelation` - Insert Service URL (OData-specific): `/connectors/VPLAN_PurchaseRelation` - Update Service URL (OData-specific): `/connectors/VPLAN_PurchaseRelation` - Delete Service URL (OData-specific): `/connectors/VPLAN_PurchaseRelation` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `VPLAN_PurchaseRelation` 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 | | | | `email` | `string(255)` | Work email | | | | `external_ref` | `string(16)` | Supplier number | | | | `fax` | `string(255)` | Work fax | | | | `name` | `string(80)` | Supplier name | | | | `note` | `string` | Remark | | | | `phone` | `string(255)` | Work phone number | | | | `website` | `string(255)` | Website | | |