# Tabel mv_a_lead

[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_a_lead

79 velden en waar hun waarde vandaan kan komen.

## Velden van mv_a_lead

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_lead_channel_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.a_lead_channel_grp_id.md) | a_lead_channel_grp_id | integer | 1 |
| [`a_lead_first_channel`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.a_lead_first_channel.md) | Eerste kanaal | text | 1 |
| [`a_ord_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.a_ord_typ.md) | Ordersoort | text | 1 |
| [`a_ord_typ_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.a_ord_typ_cid.md) | a_ord_typ_cid | text | 1 |
| [`assigned_by`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.assigned_by.md) | Toegewezen door | text | 1 |
| [`assigned_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.assigned_name.md) | Toegewezen aan | text | 1 |
| [`brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.brand.md) | Merk | text | 1 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.car_description.md) | Auto omschrijving | text | 1 |
| [`channel`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.channel.md) | Kanaal | text | 1 |
| [`channel_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.channel_cid.md) | channel_cid | text | 1 |
| [`channel_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.channel_group.md) | Kanaalgroep | text | 1 |
| [`channel_group_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.channel_group_cid.md) | channel_group_cid | text | 1 |
| [`close_reason`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.close_reason.md) | Sluitreden | text | 1 |
| [`close_reason_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.close_reason_cid.md) | close_reason_cid | text | 1 |
| [`closed_by_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.closed_by_name.md) | Gesloten door | text | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.created.md) | Aangelegd | timestamp | 1 |
| [`cus_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.cus_typ.md) | Klantsoort | text | 1 |
| [`cus_typ_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.cus_typ_cid.md) | cus_typ_cid | text | 1 |
| [`customer_email`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.customer_email.md) | Klant email | text | 1 |
| [`customer_fullname`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.customer_fullname.md) | Klantnaam | text | 1 |
| [`customer_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.customer_name.md) | Klant | text | 1 |
| [`customer_phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.customer_phone.md) | Klant telefoon | text | 1 |
| [`date_closed`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.date_closed.md) | Datum gesloten | timestamp | 1 |
| [`date_first_assigned`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.date_first_assigned.md) | Eerste toewijzing | timestamp | 0 |
| [`date_last_assigned`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.date_last_assigned.md) | Datum laatst toegewezen | timestamp | 1 |
| [`date_opened`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.date_opened.md) | Datum geopend | timestamp | 1 |
| [`date_reminder`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.date_reminder.md) | Opvolgdatum | date | 1 |
| [`escalation_level`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.escalation_level.md) | Escalatie level | text | 1 |
| [`escalation_level_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.escalation_level_cid.md) | escalation_level_cid | text | 1 |
| [`est_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.est_name.md) | Vestiging | text | 1 |
| [`ext_cat`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.ext_cat.md) | Externe categorie | text | 1 |
| [`ext_cat_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.ext_cat_cid.md) | ext_cat_cid | text | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.guid.md) | Guid | text | 1 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.id.md) | Id | integer | 0 |
| [`is_appointment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_appointment.md) | Afspraak | boolean | 0 |
| [`is_contacted`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_contacted.md) | Gesproken | boolean | 1 |
| [`is_escalated`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_escalated.md) | Geëscaleerd | boolean | 0 |
| [`is_proefrit`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_proefrit.md) | Proefrit | boolean | 1 |
| [`is_quotation`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_quotation.md) | Offerte | boolean | 2 |
| [`is_unreachable`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_unreachable.md) | Onbereikbaar | boolean | 1 |
| [`is_voicemail`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.is_voicemail.md) | Voicemail | boolean | 1 |
| [`last_contact_remark`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.last_contact_remark.md) | Laatste opmerking | clob | 1 |
| [`last_contact_remark_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.last_contact_remark_date.md) | Laatste contactmoment | timestamp | 1 |
| [`last_contact_remark_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.last_contact_remark_typ.md) | Laatste notitie type | text | 1 |
| [`last_contact_remark_typ_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.last_contact_remark_typ_cid.md) | last_contact_remark_typ_cid | text | 1 |
| [`lead_cat`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_cat.md) | Lead categorie | text | 1 |
| [`lead_cat_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_cat_cid.md) | lead_cat_cid | text | 1 |
| [`lead_fase`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_fase.md) | Lead fase | text | 1 |
| [`lead_fase_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_fase_cid.md) | lead_fase_cid | text | 1 |
| [`lead_process_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_process_typ.md) | Bron | text | 1 |
| [`lead_process_typ_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_process_typ_color.md) | Bron type (kleur) | text | 1 |
| [`lead_process_typ_view_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_process_typ_view_name.md) | Bron type (naam) | text | 1 |
| [`lead_result`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_result.md) | Lead resultaat | text | 1 |
| [`lead_result_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_result_cid.md) | lead_result_cid | text | 1 |
| [`lead_segment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_segment.md) | Lead segment | text | 1 |
| [`lead_segment_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_segment_cid.md) | lead_segment_cid | text | 1 |
| [`lead_step`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_step.md) | Lead stap | text | 1 |
| [`lead_variant`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_variant.md) | Lead variant | text | 1 |
| [`lead_variant_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.lead_variant_cid.md) | lead_variant_cid | text | 1 |
| [`model`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.model.md) | Model | text | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.modified.md) | Gemodificeerd | timestamp | 1 |
| [`poid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.poid.md) | POID | integer | 1 |
| [`remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.remarks.md) | Opmerkingen | text | 1 |
| [`s_prt_first_assigned`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.s_prt_first_assigned.md) | Eerst toegewezen door | text | 0 |
| [`s_prt_opened`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.s_prt_opened.md) | Geopend door | text | 1 |
| [`sold_checked_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.sold_checked_name.md) | Verkocht gecontroleerd door | text | 1 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.source.md) | Bron | text | 1 |
| [`source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.source_id.md) | Bron ID | integer | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.status.md) | Status | boolean | 0 |
| [`sub_cat`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.sub_cat.md) | Subcategorie | text | 1 |
| [`sub_cat_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.sub_cat_cid.md) | sub_cat_cid | text | 1 |
| [`subject`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.subject.md) | Onderwerp | text | 1 |
| [`sum_lead_ids`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.sum_lead_ids.md) | PON Lead ID's | clob | 1 |
| [`time_reminder`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.time_reminder.md) | Opvolgtijd | time | 1 |
| [`trade_in_brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.trade_in_brand.md) | Inruiler merk | text | 1 |
| [`trade_in_licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.trade_in_licenseplate.md) | Inruiler kenteken | text | 1 |
| [`trade_in_milage`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.trade_in_milage.md) | Inruiler KM-stand | text | 1 |
| [`trade_in_model`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.trade_in_model.md) | Inruiler model | text | 1 |
| [`user_pseudo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_lead.user_pseudo_id.md) | user_pseudo_id | text | 1 |

---

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