# Tabel mv_a_car

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

110 velden en waar hun waarde vandaan kan komen.

## Velden van mv_a_car

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_bra_id.md) | Merk ID | integer | 1 |
| [`a_car_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_car_grp_id.md) | Autogroep ID | integer | 1 |
| [`a_car_usage`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_car_usage.md) | Gebruik | text | 1 |
| [`a_car_usage_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_car_usage_cid.md) | Gebruik CID | text | 1 |
| [`a_car_usage_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_car_usage_id.md) | Gebruik ID | integer | 1 |
| [`a_coa_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_coa_grp_id.md) | a_coa_grp_id | integer | 1 |
| [`a_coa_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_coa_id.md) | Carrosserie ID | integer | 1 |
| [`a_fue_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_fue_grp_id.md) | a_fue_grp_id | integer | 1 |
| [`a_fue_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_fue_id.md) | Brandstof ID | integer | 1 |
| [`a_mod_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_mod_grp_id.md) | Modelgroep ID | integer | 1 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_mod_id.md) | Model ID | integer | 1 |
| [`a_ord_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_ord_typ.md) | Order type | text | 1 |
| [`a_ord_typ_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_ord_typ_cid.md) | Order type CID | text | 1 |
| [`a_ord_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_ord_typ_id.md) | Order type ID | integer | 1 |
| [`a_tra_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_tra_grp_id.md) | a_tra_grp_id | integer | 1 |
| [`a_tra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_tra_id.md) | Transmissie ID | integer | 1 |
| [`a_vehicle_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_vehicle_typ.md) | a_vehicle_typ | text | 0 |
| [`a_vehicle_typ_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_vehicle_typ_cid.md) | a_vehicle_typ_cid | text | 0 |
| [`a_vehicle_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.a_vehicle_typ_id.md) | a_vehicle_typ_id | integer | 0 |
| [`age`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.age.md) | Leeftijd (mnd) | integer | 1 |
| [`as_segment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.as_segment.md) | AS segment | integer | 1 |
| [`base_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.base_color.md) | Basis kleur | text | 1 |
| [`bool_free1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.bool_free1.md) | bool_free1 | boolean | 1 |
| [`bool_free2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.bool_free2.md) | bool_free2 | boolean | 1 |
| [`bool_free3`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.bool_free3.md) | bool_free3 | boolean | 1 |
| [`brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.brand.md) | Merk | text | 1 |
| [`build_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.build_year.md) | Bouwjaar | integer | 1 |
| [`car_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.car_group.md) | Autogroep | text | 1 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.chassisnr.md) | Chassisnummer | text | 1 |
| [`co2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.co2.md) | CO2 | integer | 1 |
| [`coachwork`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.coachwork.md) | Carrosserie | text | 1 |
| [`coachwork_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.coachwork_group.md) | coachwork_group | text | 1 |
| [`color`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.color.md) | Kleur | text | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.created.md) | Aangelegd | timestamp | 1 |
| [`date_apk`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_apk.md) | APK datum | date | 1 |
| [`date_appointment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_appointment.md) | Datum wp. afspraak | timestamp | 4 |
| [`date_free1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_free1.md) | date_free1 | date | 1 |
| [`date_free2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_free2.md) | date_free2 | date | 1 |
| [`date_free3`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_free3.md) | date_free3 | date | 1 |
| [`date_free4`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_free4.md) | date_free4 | date | 1 |
| [`date_free5`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_free5.md) | date_free5 | date | 1 |
| [`date_lease_end_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_lease_end_autoline.md) | date_lease_end_autoline | date | 1 |
| [`date_sales`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_sales.md) | Verkoop datum | date | 1 |
| [`date_sales_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_sales_final.md) | Verkoop datum final | date | 1 |
| [`date_service_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_service_final.md) | Service datum final | date | 1 |
| [`date_visit`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_visit.md) | Datum laatste wp-bezoek | date | 1 |
| [`date_warranty`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_warranty.md) | date_warranty | date | 1 |
| [`date_warranty_carr`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_warranty_carr.md) | date_warranty_carr | date | 1 |
| [`date_warranty_ext`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_warranty_ext.md) | date_warranty_ext | date | 1 |
| [`date_works`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.date_works.md) | Datum laatste onderhoud | date | 1 |
| [`datumaanvangtenaamstelling`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.datumaanvangtenaamstelling.md) | Datum aanvang tenaamstelling | date | 1 |
| [`datumeersteafgiftenederland`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.datumeersteafgiftenederland.md) | Datum eerste afgifte nederland | date | 1 |
| [`datumeerstetoelating`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.datumeerstetoelating.md) | Datum eerste toelating | date | 1 |
| [`description`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.description.md) | Auto omschrijving | text | 1 |
| [`doors`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.doors.md) | Deuren | integer | 1 |
| [`fuel`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.fuel.md) | Brandstof | text | 1 |
| [`fuel_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.fuel_group.md) | fuel_group | text | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.guid.md) | Guid | text | 1 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.id.md) | Id | integer | 0 |
| [`implementation`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.implementation.md) | Uitvoering | text | 1 |
| [`int_free1`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.int_free1.md) | int_free1 | integer | 1 |
| [`int_free2`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.int_free2.md) | int_free2 | integer | 1 |
| [`int_free3`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.int_free3.md) | int_free3 | integer | 1 |
| [`is_cm_active`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.is_cm_active.md) | Actief voor CM | boolean | 1 |
| [`is_economy_service`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.is_economy_service.md) | Economy service | boolean | 1 |
| [`is_rdw_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.is_rdw_checked.md) | Is RDW gecontroleerd | boolean | 1 |
| [`is_vag_brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.is_vag_brand.md) | Vag merk | boolean | 1 |
| [`komnummer`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.komnummer.md) | Komnummer | text | 1 |
| [`kwh`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.kwh.md) | kwh | integer | 0 |
| [`last_car_cm_sta_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.last_car_cm_sta_date.md) | last_car_cm_sta_date | timestamp | 1 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.licenseplate.md) | Kenteken | text | 1 |
| [`lining`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.lining.md) | Bekleding | text | 1 |
| [`meets_cm_requirements`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.meets_cm_requirements.md) | Voldoet aan CM auto criteria | boolean | 1 |
| [`milage`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.milage.md) | Km-stand | integer | 1 |
| [`mileage_end_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.mileage_end_autoline.md) | mileage_end_autoline | integer | 1 |
| [`model`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.model.md) | Model | text | 1 |
| [`model_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.model_year.md) | Model jaar | integer | 1 |
| [`modelgroup`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.modelgroup.md) | Model groep | text | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.modified.md) | Gemodificeerd | timestamp | 1 |
| [`performance_kw`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.performance_kw.md) | Vermogen Kw | integer | 1 |
| [`s_est_sales_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_sales_final.md) | Verkoop vestiging final | text | 1 |
| [`s_est_sales_final_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_sales_final_cid.md) | Verkoop vestiging final CID | text | 1 |
| [`s_est_sales_final_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_sales_final_id.md) | Verkoop vestiging final ID | integer | 1 |
| [`s_est_sales_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_sales_id.md) | Verkoop vestiging ID | integer | 1 |
| [`s_est_service_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_service_final.md) | Service vestiging final | text | 1 |
| [`s_est_service_final_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_service_final_cid.md) | Service vestiging final CID | text | 1 |
| [`s_est_service_final_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_service_final_id.md) | Service vestiging final ID | integer | 1 |
| [`s_est_visit_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_visit_id.md) | Vest. laatste wp-bezoek ID | integer | 1 |
| [`s_est_works_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_est_works_id.md) | Vest. laatste onderhoud ID | integer | 1 |
| [`s_prt_debtor_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_prt_debtor_id.md) | Debiteur | integer | 1 |
| [`s_prt_les_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_prt_les_id.md) | Lessee | integer | 1 |
| [`s_prt_sal_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.s_prt_sal_id.md) | s_prt_sal_id | integer | 1 |
| [`sales_establishment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.sales_establishment.md) | Verkoop vestiging | text | 1 |
| [`sales_establishment_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.sales_establishment_cid.md) | Verkoop vestiging CID | text | 1 |
| [`service_interval`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.service_interval.md) | Service interval (Jaren) | integer | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.status.md) | Status | integer | 1 |
| [`top_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.top_color.md) | top_color | text | 1 |
| [`transmission`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.transmission.md) | Transmissie | text | 1 |
| [`transmission_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.transmission_group.md) | transmission_group | text | 1 |
| [`vinservice_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.vinservice_check.md) | vinservice_check | date | 1 |
| [`vinservice_modelname`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.vinservice_modelname.md) | vinservice_modelname | text | 1 |
| [`visit_establishment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.visit_establishment.md) | Vest. laatste wp-bezoek | text | 1 |
| [`visit_establishment_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.visit_establishment_cid.md) | Vest. laatste wp-bezoek CID | text | 1 |
| [`wo_appointment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.wo_appointment.md) | Werkplaats afspraak | text | 3 |
| [`works_establishment`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.works_establishment.md) | Vest. laatste onderhoud | text | 1 |
| [`works_establishment_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.works_establishment_cid.md) | Vest. laatste onderhoud CID | text | 1 |
| [`wpl_0103`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.wpl_0103.md) | Grote beurt | date | 1 |
| [`wpl_0104`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.wpl_0104.md) | Kleine beurt | date | 1 |
| [`wpl_0109`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.wpl_0109.md) | Longlife | date | 1 |
| [`wpl_87a`](https://knowledgebase.syntec-it.nl/enterprise/velden/mv_a_car.wpl_87a.md) | Airco check | date | 1 |

---

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