# Tabel a_ktv_complaint

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

27 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`a_ktv_complaint_reason`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint_reason.md) · 7 velden
- [`a_ktv_complaint_source`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint_source.md) · 8 velden
- [`a_ktv_complaint_sub_reason`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint_sub_reason.md) · 8 velden
- [`a_ktv_complaint_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint_type.md) · 7 velden

## Velden van a_ktv_complaint

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_bra_id.md) | Merk | integer | 1 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_car_id.md) | Auto | integer | 1 |
| [`a_ktv_answer_satisfied_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ktv_answer_satisfied_id.md) | Tevredenheid | integer | 1 |
| [`a_ktv_complaint_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ktv_complaint_reason_id.md) | Reden | integer | 1 |
| [`a_ktv_complaint_source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ktv_complaint_source_id.md) | Bron | integer | 1 |
| [`a_ktv_complaint_sub_reason_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ktv_complaint_sub_reason_id.md) | Sub reden | integer | 1 |
| [`a_ktv_header_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ktv_header_id.md) | KTV rapport | integer | 0 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.a_ord_id.md) | Verkooporder | integer | 1 |
| [`as_wo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.as_wo_id.md) | Werkorder | integer | 1 |
| [`complaint_details`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.complaint_details.md) | Klacht details | clob | 1 |
| [`complaint_summary`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.complaint_summary.md) | Klacht | clob | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.created.md) | Aangelegd | timestamp | 1 |
| [`cust_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.cust_name.md) | Naam klant | text | 1 |
| [`date_caused`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.date_caused.md) | Datum bezoek | date | 1 |
| [`date_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.date_completed.md) | Datum afgerond | date | 1 |
| [`date_received`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.date_received.md) | Datum ontvangen | date | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.id.md) | Id | integer | 0 |
| [`is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.is_completed.md) | Afgerond? | boolean | 1 |
| [`license_plate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.license_plate.md) | Kenteken | text | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.modified.md) | Gemodificeerd | timestamp | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.s_est_id.md) | Vestiging | integer | 1 |
| [`s_prt_blame_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.s_prt_blame_id.md) | Verwijtbaar aan | integer | 1 |
| [`s_prt_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.s_prt_completed.md) | Afgerond door | integer | 1 |
| [`s_prt_owner_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.s_prt_owner_id.md) | In behandeling bij | integer | 1 |
| [`s_prt_resp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.s_prt_resp_id.md) | Verantwoordelijke | integer | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ktv_complaint.status.md) | Status | integer | 1 |

---

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