# Tabel mv_s_prt

[Kennisbank](https://knowledgebase.syntec-it.nl/index.md) › [Syntec Enterprise](https://knowledgebase.syntec-it.nl/enterprise.md) › [Velden](https://knowledgebase.syntec-it.nl/enterprise/velden.md) › mv_s_prt

65 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`mv_s_prt_atr`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt_atr.md) · 37 velden

## Velden van mv_s_prt

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`aanhef`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.aanhef.md) | Aanhef | text | 2 |
| [`address`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.address.md) | Adres | text | 2 |
| [`birthday`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.birthday.md) | Geboortedatum | date | 2 |
| [`briefhoofd`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.briefhoofd.md) | Briefhoofd | text | 2 |
| [`channel`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.channel.md) | Kanaal | text | 2 |
| [`channel_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.channel_cid.md) | Kanaal CID | text | 2 |
| [`city`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.city.md) | Plaats | text | 2 |
| [`classification`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.classification.md) | Classificatie | text | 2 |
| [`code`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.code.md) | Code | integer | 2 |
| [`country`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.country.md) | Land | text | 2 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.created.md) | Aangelegd | timestamp | 2 |
| [`email_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.email_final.md) | E-mail final | text | 2 |
| [`email_guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.email_guid.md) | E-mail GUID 1 | text | 2 |
| [`email_guid2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.email_guid2.md) | E-mail GUID 2 | text | 2 |
| [`email1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.email1.md) | E-mail 1 (Prive) | text | 2 |
| [`email2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.email2.md) | E-mail 2 (Zak.) | text | 2 |
| [`exclude_callback`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.exclude_callback.md) | exclude_callback | boolean | 2 |
| [`exclude_cm`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.exclude_cm.md) | CM uitsluiten | boolean | 2 |
| [`external_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.external_id.md) | Extern ID | integer | 2 |
| [`firstname`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.firstname.md) | Voornaam | text | 2 |
| [`fnc_description_hrm`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.fnc_description_hrm.md) | Functie omschrijving (HRM) | text | 2 |
| [`gender`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.gender.md) | Geslacht | text | 2 |
| [`group1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.group1.md) | Vrije groep 1 | text | 2 |
| [`group2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.group2.md) | Vrije groep 2 | text | 2 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.guid.md) | Guid | text | 2 |
| [`houseno`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.houseno.md) | Huisnummer | text | 2 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.id.md) | Id | integer | 0 |
| [`initials`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.initials.md) | Voorletters | text | 2 |
| [`is_claimable`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_claimable.md) | Te claimen | boolean | 2 |
| [`is_fan`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_fan.md) | Fan | boolean | 2 |
| [`is_intern`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_intern.md) | Interne klant | boolean | 2 |
| [`is_send_email`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_send_email.md) | Contact via e-mail | boolean | 2 |
| [`is_send_post`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_send_post.md) | Contact via post | boolean | 2 |
| [`is_send_sms`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_send_sms.md) | Contact via SMS | boolean | 2 |
| [`is_trader`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.is_trader.md) | Handelaar | boolean | 2 |
| [`lastname`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.lastname.md) | Achternaam | text | 2 |
| [`mail_prefs`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.mail_prefs.md) | Mail voorkeuren | text | 3 |
| [`mailing_active`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.mailing_active.md) | Mailing actief | boolean | 2 |
| [`middlename`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.middlename.md) | Tussenvoegsel | text | 2 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.modified.md) | Gemodificeerd | timestamp | 2 |
| [`module`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.module.md) | Module | text | 2 |
| [`name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.name.md) | Naam | text | 2 |
| [`name_search`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.name_search.md) | Zoekveld | text | 2 |
| [`newsletter`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.newsletter.md) | Nieuwsbrief | boolean | 2 |
| [`partner_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.partner_type.md) | Partner type | text | 2 |
| [`partner_type_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.partner_type_cid.md) | Partner type CID | text | 2 |
| [`phone1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.phone1.md) | Telefoon 1 (Prive) | text | 2 |
| [`phone2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.phone2.md) | Telefoon 2 (Zak.) | text | 2 |
| [`phone3`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.phone3.md) | Telefoon 3 (GSM) | text | 2 |
| [`phone4`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.phone4.md) | Telefoon 4 (GSM zak.) | text | 2 |
| [`s_fil_signature_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_fil_signature_id.md) | Handtekening | integer | 2 |
| [`s_prt_adr_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_adr_id.md) | s_prt_adr_id | integer | 2 |
| [`s_prt_chan_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_chan_id.md) | Kanaal ID | integer | 2 |
| [`s_prt_cls_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_cls_id.md) | Classificatie ID | integer | 2 |
| [`s_prt_gen_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_gen_id.md) | Geslacht ID | integer | 2 |
| [`s_prt_sub_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_sub_grp_id.md) | Subgroep ID | integer | 2 |
| [`s_prt_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.s_prt_typ_id.md) | Partner type ID | integer | 2 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.source.md) | Bron | text | 3 |
| [`source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.source_id.md) | Bron ID | text | 3 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.status.md) | Status | integer | 3 |
| [`street`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.street.md) | Straat | text | 2 |
| [`subgroup`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.subgroup.md) | Subgroep | text | 2 |
| [`type`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.type.md) | Type | text | 2 |
| [`website`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.website.md) | Website | text | 2 |
| [`zipcode`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt.zipcode.md) | Postcode | text | 2 |

---

Kennisbank Syntec-IT · [Deze pagina op de website](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_s_prt) · [Overzicht voor AI-clients](https://knowledgebase.syntec-it.nl/llms.txt)
