# Ricoh_Relaties: Ricoh Relations ## Documentation Ricoh - Employees, purchase relations, sales relations (Profit) - Name: `Ricoh_Relaties` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Ricoh Relations ## 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` | Last Name | | | | `Inkooprelatie` | `decimal` | Purchase relation (1/0) | | | | `KeyInkooprelatie` | `string` | Purchase relation | | | | `KeyMedewerker` | `string` | Employee | | | | `KeyVerkooprelatie` | `string` | Sales relation | | | | `Medewerker` | `decimal` | Employee (1/0) | | | | `OrgPersNr` | `string` | Organisation/person | | | | `Soort` | `string` | Basic contact type | | | | `Titel` | `string` | Name | | | | `Verkooprelatie` | `decimal` | Sales relation (1/0) | | | | `Zoeknaam` | `string` | Search name | | |