# Tabel a_ktv_header

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

59 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

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

## Velden van a_ktv_header

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_bra_id.md) | Merk | integer | 3 |
| [`a_ktv_answer_satisfactory_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_answer_satisfactory_id.md) | Algemene beoordeling | integer | 2 |
| [`a_ktv_car_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_car_type_id.md) | Auto type | integer | 2 |
| [`a_ktv_cat_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_cat_id.md) | Categorie | integer | 1 |
| [`a_ktv_complaint_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_complaint_reason_id.md) | a_ktv_complaint_reason_id | integer | 1 |
| [`a_ktv_complaint_sub_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_complaint_sub_reason_id.md) | a_ktv_complaint_sub_reason_id | integer | 1 |
| [`a_ktv_cus_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_cus_type_id.md) | Klant type | integer | 2 |
| [`a_ktv_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ktv_type_id.md) | Soort | integer | 2 |
| [`a_kvs_item_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_kvs_item_id.md) | KVS item ID | integer | 0 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.a_ord_id.md) | Order | integer | 2 |
| [`as_wo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.as_wo_id.md) | Werkorder | integer | 1 |
| [`brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.brand.md) | Merk (Anoniem) | text | 2 |
| [`cem_algemene_tevredenheid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_algemene_tevredenheid.md) | CEM Algemene tevredenheid | integer | 2 |
| [`cem_competentie`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_competentie.md) | CEM Competentie | integer | 2 |
| [`cem_hot_alert`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_hot_alert.md) | CEM hot alert | boolean | 2 |
| [`cem_interview_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_interview_id.md) | CEM interview ID | integer | 2 |
| [`cem_klantafhandeling`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_klantafhandeling.md) | CEM Klantafhandeling | integer | 2 |
| [`cem_organisatie`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.cem_organisatie.md) | CEM Organisatie | integer | 2 |
| [`complaints`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.complaints.md) | Klachten / opmerkingen | clob | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.created.md) | Aangelegd | timestamp | 0 |
| [`date_assigned`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.date_assigned.md) | Datum toegewezen | timestamp | 1 |
| [`date_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.date_completed.md) | Datum afgesloten | timestamp | 1 |
| [`date_questionair`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.date_questionair.md) | Datum beoordeling | date | 2 |
| [`date_workshop`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.date_workshop.md) | Datum werkplaats | date | 1 |
| [`dealer_number`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.dealer_number.md) | Dealer nr. | text | 2 |
| [`dealer_tav`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.dealer_tav.md) | T.a.v. | text | 1 |
| [`diakeyf`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.diakeyf.md) | diakeyf | text | 2 |
| [`email_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.email_customer.md) | E-mail | text | 2 |
| [`gen_improv`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.gen_improv.md) | Verbeterp.alg. | clob | 0 |
| [`gender`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.gender.md) | Geslacht | text | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.id.md) | Id | integer | 0 |
| [`indiv_complaints`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.indiv_complaints.md) | Klachten indiv. | clob | 0 |
| [`indiv_improv`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.indiv_improv.md) | Verbeterp.indiv. | clob | 0 |
| [`is_calculated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.is_calculated.md) | Is berekend | boolean | 0 |
| [`is_complaint`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.is_complaint.md) | is_complaint | boolean | 0 |
| [`is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.is_completed.md) | Gesloten | boolean | 1 |
| [`is_hotalert`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.is_hotalert.md) | Syntec hot alert | boolean | 2 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.licenseplate.md) | Kenteken | text | 2 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.modified.md) | Gemodificeerd | timestamp | 0 |
| [`name_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.name_customer.md) | Naam | text | 2 |
| [`name_surveyed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.name_surveyed.md) | Ondervraagde | text | 2 |
| [`oper_complaints`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.oper_complaints.md) | Klachten operationeel | clob | 0 |
| [`oper_improv`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.oper_improv.md) | Verbeterp.oper. | clob | 0 |
| [`phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.phone.md) | Telefoon | text | 2 |
| [`positive_negative_xp`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.positive_negative_xp.md) | Positieve of negatieve ervaringen | clob | 2 |
| [`reason_visit`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.reason_visit.md) | Reden bezoek | text | 1 |
| [`registration_date_2`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.registration_date_2.md) | Datum deel 1 | date | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.s_est_id.md) | Vestigiing | integer | 2 |
| [`s_fil_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.s_fil_id.md) | Bestand | integer | 2 |
| [`s_prt_assigned_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.s_prt_assigned_id.md) | Toegewezen aan | integer | 1 |
| [`s_prt_completed_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.s_prt_completed_id.md) | Afgesloten door | integer | 1 |
| [`s_prt_srv_adv_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.s_prt_srv_adv_id.md) | Serv. adviseur | integer | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.status.md) | Status | integer | 0 |
| [`type_questionair`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.type_questionair.md) | Soort | text | 4 |
| [`uni`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.uni.md) | Unieke sleutel | text | 1 |
| [`ver`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.ver.md) | Versie | boolean | 2 |
| [`works_complaints`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.works_complaints.md) | Klachten werkz. | clob | 0 |
| [`works_improv`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_header.works_improv.md) | Verbeterp.werkz. | clob | 0 |

---

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