# Tabel a_csat_itv_hdr

[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) › a_csat_itv_hdr

68 velden en waar hun waarde vandaan kan komen.

Hoort bij de module [Klanttevredenheid (KTV)](https://knowledgebase.syntec-it.nl/enterprise/ktv.md).

## Gekoppelde tabellen

- [`a_csat_itv_hdr_changepointer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr_changepointer.md) · 11 velden
- [`a_csat_itv_hdr_fil`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr_fil.md) · 9 velden
- [`a_csat_itv_hdr_tmp`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr_tmp.md) · 4 velden

## Velden van a_csat_itv_hdr

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_bra_id.md) | a_bra_id | integer | 4 |
| [`a_csat_itv_cfg_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_csat_itv_cfg_typ_id.md) | a_csat_itv_cfg_typ_id | integer | 4 |
| [`a_ktv_complaint_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ktv_complaint_reason_id.md) | Reden | integer | 2 |
| [`a_ktv_complaint_source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ktv_complaint_source_id.md) | Bron | integer | 2 |
| [`a_ktv_complaint_sub_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ktv_complaint_sub_reason_id.md) | Sub reden | integer | 2 |
| [`a_ktv_complaint_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ktv_complaint_type_id.md) | Type | integer | 0 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ord_id.md) | a_ord_id | integer | 4 |
| [`a_ord_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.a_ord_typ_id.md) | a_ord_typ_id | integer | 1 |
| [`anonym_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.anonym_cid.md) | anonym_cid | text | 1 |
| [`as_wo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.as_wo_id.md) | as_wo_id | integer | 5 |
| [`cem_score_general`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_general.md) | cem_score_general | decimal | 3 |
| [`cem_score_q001`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q001.md) | Q001 | decimal | 0 |
| [`cem_score_q002`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q002.md) | Q002 | decimal | 0 |
| [`cem_score_q003`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q003.md) | Q003 | decimal | 0 |
| [`cem_score_q004`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q004.md) | Q004 | decimal | 1 |
| [`cem_score_q005`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q005.md) | Q005 | decimal | 0 |
| [`cem_score_q13a`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.cem_score_q13a.md) | Q13A | decimal | 0 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.chassisnr.md) | Chassisnr | text | 1 |
| [`complaint_prevention_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.complaint_prevention_remarks.md) | Preventieve maatregelen | clob | 1 |
| [`complaints`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.complaints.md) | Klachtomschrijving | clob | 3 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.created.md) | Aangelegd | timestamp | 2 |
| [`date_assigned`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_assigned.md) | Datum toegewezen | timestamp | 2 |
| [`date_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_completed.md) | Datum afgesloten | timestamp | 3 |
| [`date_notified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_notified.md) | Notificatie datum | timestamp | 2 |
| [`date_questionair`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_questionair.md) | Datum rapport | date | 3 |
| [`date_workshop`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_workshop.md) | Datum bezoek | date | 4 |
| [`date_workshop_anonymous`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.date_workshop_anonymous.md) | date_workshop_anonymous | date | 1 |
| [`dealeralert_calculated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.dealeralert_calculated.md) | dealeralert_calculated | boolean | 1 |
| [`diakeyf`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.diakeyf.md) | Diakeyf | text | 2 |
| [`email_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.email_customer.md) | Klant email | text | 2 |
| [`escalation_mail_sent`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.escalation_mail_sent.md) | escalation_mail_sent | boolean | 1 |
| [`est_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.est_cid.md) | Vestiging | text | 3 |
| [`feedback_status_change_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.feedback_status_change_date.md) | Feedback status change date | timestamp | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.guid.md) | Guid | text | 1 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.id.md) | Id | integer | 0 |
| [`invoice_no`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.invoice_no.md) | invoice_no | text | 2 |
| [`is_cem`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.is_cem.md) | is_cem | boolean | 4 |
| [`is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.is_completed.md) | Afgerond ? | boolean | 3 |
| [`is_dealeralert`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.is_dealeralert.md) | Dealeralert ? | boolean | 2 |
| [`is_follow_up`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.is_follow_up.md) | Opvolgen? | boolean | 1 |
| [`is_hotalert`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.is_hotalert.md) | Hotalert ? | boolean | 2 |
| [`last_date_sent_to_cem`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.last_date_sent_to_cem.md) | Laatst verz. CEM | timestamp | 2 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.licenseplate.md) | Kenteken | text | 5 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.modified.md) | Gemodificeerd | timestamp | 5 |
| [`name_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.name_customer.md) | Klantnaam | text | 6 |
| [`nps`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.nps.md) | NPS | boolean | 2 |
| [`opening_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.opening_date.md) | Openingdate | timestamp | 1 |
| [`opt_out_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.opt_out_date.md) | Opt-out datum | timestamp | 1 |
| [`phone_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.phone_customer.md) | Klant telefoon | text | 1 |
| [`qa_date_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.qa_date_completed.md) | Datum afgehandeld | timestamp | 1 |
| [`qa_is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.qa_is_completed.md) | Afgehandeld door afd.kwalitiet | boolean | 1 |
| [`qa_s_prt_completed_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.qa_s_prt_completed_id.md) | Afgehandeld door | integer | 1 |
| [`registration_date_2`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.registration_date_2.md) | Datum deel 2 | date | 3 |
| [`reminder_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.reminder_date.md) | Herinneringsdatum | timestamp | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_est_id.md) | s_est_id | integer | 4 |
| [`s_fil_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_fil_id.md) | Bestand | integer | 4 |
| [`s_prt_assigned_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_prt_assigned_id.md) | Toegewezen aan | integer | 2 |
| [`s_prt_completed_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_prt_completed_id.md) | Afgesloten door | integer | 3 |
| [`s_prt_created_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_prt_created_id.md) | Aangemaakt door | integer | 1 |
| [`s_prt_customer_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_prt_customer_id.md) | Partner | integer | 2 |
| [`s_prt_employee_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.s_prt_employee_id.md) | Medewerker | integer | 7 |
| [`sent_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.sent_date.md) | Datum verzonden | timestamp | 1 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.source.md) | Bron | text | 3 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.status.md) | Status | integer | 5 |
| [`survey_version`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.survey_version.md) | survey_version | text | 1 |
| [`type_questionair`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.type_questionair.md) | Soort | text | 2 |
| [`user_agent`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.user_agent.md) | Useragent | text | 1 |
| [`wave`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_csat_itv_hdr.wave.md) | wave | text | 0 |

---

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