# Tabel a_plan

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

47 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`a_plan_aat`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_aat.md) · 7 velden
- [`a_plan_keylabel_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_keylabel_color.md) · 6 velden
- [`a_plan_line`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_line.md) · 19 velden
- [`a_plan_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_remarks.md) · 8 velden
- [`a_plan_task`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_task.md) · 12 velden
- [`a_plan_task_child`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_task_child.md) · 8 velden
- [`a_plan_task_prt_xref`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_task_prt_xref.md) · 8 velden
- [`a_plan_template`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan_template.md) · 11 velden

## Velden van a_plan

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.a_bra_id.md) | Merk | integer | 3 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.a_car_id.md) | Voertuig | integer | 5 |
| [`a_loc_current_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.a_loc_current_id.md) | Huidige locatie | integer | 8 |
| [`a_loc_delivery_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.a_loc_delivery_id.md) | Afleverlocatie | integer | 3 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.a_ord_id.md) | Order | integer | 5 |
| [`aat`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.aat.md) | AAT | text | 5 |
| [`aat_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.aat_check.md) | AAT check | integer | 2 |
| [`aat_extra1`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.aat_extra1.md) | AAT extra | text | 2 |
| [`aat_extra2`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.aat_extra2.md) | AAT extra 1 | text | 2 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.car_description.md) | Voertuig omschrijving | text | 8 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.chassisnr.md) | Chassisnummer | text | 8 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.created.md) | Aangelegd | timestamp | 1 |
| [`damage_days`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.damage_days.md) | Schade dagen | integer | 1 |
| [`date_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_delivery.md) | Afleverdatum | date | 3 |
| [`date_delivery_expected`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_delivery_expected.md) | Verwachte leverdatum | date | 3 |
| [`date_delivery_wish`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_delivery_wish.md) | Gewenste leverdatum | date | 3 |
| [`date_first_plan`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_first_plan.md) | Eerste plan datum | date | 0 |
| [`date_first_tech_ready`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_first_tech_ready.md) | Datum eerste technisch klaar | date | 0 |
| [`date_lease_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_lease_end.md) | Eind datum lease contract (huidig) | date | 2 |
| [`date_minimum_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_minimum_delivery.md) | Niet leveren voor | date | 2 |
| [`date_tech_ready_estimate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_tech_ready_estimate.md) | Geschatte technisch klaar datum | date | 2 |
| [`date_tech_start`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_tech_start.md) | Technisch startdatum | date | 2 |
| [`date_unload_dealer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.date_unload_dealer.md) | Gelost dealer | date | 5 |
| [`driver`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.driver.md) | Berijder | text | 2 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.id.md) | Id | integer | 0 |
| [`is_confirmed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.is_confirmed.md) | Bevestigen | boolean | 2 |
| [`is_damagefree`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.is_damagefree.md) | Schadevrij | boolean | 2 |
| [`keylabel_nr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.keylabel_nr.md) | Sleutellabel nr | text | 5 |
| [`keylabel_nr_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.keylabel_nr_color.md) | Sleutellabel nr kleur | text | 3 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.licenseplate.md) | Kenteken | text | 7 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.modified.md) | Gemodificeerd | timestamp | 1 |
| [`order_nr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.order_nr.md) | order_nr |  (niet in de tabeldefinitie) | 1 |
| [`order_nr_lease`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.order_nr_lease.md) | Bestelnr lease | text | 5 |
| [`order_nr_vsb`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.order_nr_vsb.md) | VSB nr | integer | 5 |
| [`reason_minimum_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.reason_minimum_delivery.md) | Reden niet rijden | text | 3 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_est_id.md) | Vestiging | integer | 2 |
| [`s_prt_delivering_dealer_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_prt_delivering_dealer_id.md) | Leverende dealer | integer | 1 |
| [`s_prt_les_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_prt_les_id.md) | Lessee | integer | 4 |
| [`s_prt_main_contractor_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_prt_main_contractor_id.md) | Hoofd uitvoerder | integer | 0 |
| [`s_prt_own_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_prt_own_id.md) | Eigenaar | integer | 4 |
| [`s_prt_sal_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.s_prt_sal_id.md) | Verkoper | integer | 4 |
| [`start_lead_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.start_lead_time.md) | Start doorlooptijd | date | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.status.md) | Status | integer | 1 |
| [`time_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.time_delivery.md) | Aflever tijdstip | time | 2 |
| [`wo_no_overwrite`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.wo_no_overwrite.md) | WO niet overschrijven | integer | 1 |
| [`wo_nr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_plan.wo_nr.md) | Werkordernummer | text | 5 |

---

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