# Tabel as_pre_wo

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

38 velden en waar hun waarde vandaan kan komen.

Hoort bij de module [Aftersales](https://knowledgebase.syntec-it.nl/enterprise/aftersales.md).

## Gekoppelde tabellen

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

## Velden van as_pre_wo

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.a_bra_id.md) | Merk | integer | 1 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.a_car_id.md) | Auto | integer | 1 |
| [`as_cfg_planit_rental_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.as_cfg_planit_rental_car_id.md) | Verv.vervoer | integer | 2 |
| [`as_cfg_pre_wo_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.as_cfg_pre_wo_type_id.md) | Type | integer | 1 |
| [`as_cfg_workshop_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.as_cfg_workshop_id.md) | Werkplaats | integer | 2 |
| [`as_log_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.as_log_id.md) | as_log_id | integer | 0 |
| [`as_wo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.as_wo_id.md) | WO | integer | 1 |
| [`bo_ctr_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.bo_ctr_id.md) | Banden | integer | 0 |
| [`car_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.car_code.md) | Meldcode | text | 2 |
| [`completed_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.completed_date.md) | Afgerond op | timestamp | 1 |
| [`completed_s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.completed_s_prt_id.md) | Afgerond door | integer | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.created.md) | Aangelegd | timestamp | 1 |
| [`created_s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.created_s_prt_id.md) | created_s_prt_id | integer | 1 |
| [`date_in`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.date_in.md) | Auto brengen | timestamp | 1 |
| [`date_opened`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.date_opened.md) | date_opened | timestamp | 0 |
| [`date_out`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.date_out.md) | Auto halen | timestamp | 1 |
| [`date_planned`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.date_planned.md) | Ingepland op | timestamp | 1 |
| [`est_milage`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.est_milage.md) | Km stand | integer | 2 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.id.md) | Id | integer | 0 |
| [`is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.is_completed.md) | Afgerond | boolean | 1 |
| [`is_maintenance`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.is_maintenance.md) | Onderhoud? | boolean | 0 |
| [`is_tyre_swap`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.is_tyre_swap.md) | Bandenwissel ? | boolean | 0 |
| [`is_urgent`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.is_urgent.md) | is_urgent | boolean | 1 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.licenseplate.md) | Kenteken | text | 2 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.modified.md) | Gemodificeerd | timestamp | 1 |
| [`planit_confirmed`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.planit_confirmed.md) | PlanIt bevestigd | timestamp | 1 |
| [`quot_completed_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.quot_completed_date.md) | Offerte gemaakt | timestamp | 1 |
| [`quot_completed_s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.quot_completed_s_prt_id.md) | Offerte door | integer | 0 |
| [`quot_request`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.quot_request.md) | Offerte vooraf | boolean | 2 |
| [`remarks_planner`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.remarks_planner.md) | Opm.planner | clob | 1 |
| [`remarks_summary`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.remarks_summary.md) | Opmerkingen | clob | 2 |
| [`s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.s_prt_id.md) | Klantnaam | integer | 2 |
| [`s_prt_opened_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.s_prt_opened_id.md) | s_prt_opened_id | integer | 0 |
| [`source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.source_id.md) | source_id | text | 0 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.status.md) | Status | integer | 1 |
| [`testdrive`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.testdrive.md) | testdrive | boolean | 1 |
| [`works_summary`](https://knowledgebase.syntec-it.nl/enterprise/velden/as_pre_wo.works_summary.md) | Werkzaamheden | clob | 2 |

---

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