# Ricoh_Relaties: Ricoh Relations ## Documentation Ricoh - Employees, purchase relations, sales relations (Profit) - Name: `Ricoh_Relaties` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Ricoh Relations - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Ricoh_Relaties` - Insert Service URL (OData-specific): `/connectors/Ricoh_Relaties` - Update Service URL (OData-specific): `/connectors/Ricoh_Relaties` - Delete Service URL (OData-specific): `/connectors/Ricoh_Relaties` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Ricoh_Relaties` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Achternaam` | `string(80)` | Last Name | | | | `Inkooprelatie` | `decimal` | Purchase relation (1/0) | | | | `KeyInkooprelatie` | `string(16)` | Purchase relation | | | | `KeyMedewerker` | `string(15)` | Employee | | | | `KeyVerkooprelatie` | `string(16)` | Sales relation | | | | `Medewerker` | `decimal` | Employee (1/0) | | | | `OrgPersNr` | `string(15)` | Organisation/person | | | | `Soort` | `string(100)` | Basic contact type | | | | `Titel` | `string(255)` | Name | | | | `Verkooprelatie` | `decimal` | Sales relation (1/0) | | | | `Zoeknaam` | `string(10)` | Search name | | |