# Tabel 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) › a_car

113 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`a_car_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_autoline.md) · 17 velden
- [`a_car_autotelex_expected`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_autotelex_expected.md) · 12 velden
- [`a_car_autotelex_expected_doc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_autotelex_expected_doc.md) · 11 velden
- [`a_car_bijtelling`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_bijtelling.md) · 11 velden
- [`a_car_cm_sta_his`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_cm_sta_his.md) · 7 velden
- [`a_car_elsa`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_elsa.md) · 17 velden
- [`a_car_elsa_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_elsa_color.md) · 10 velden
- [`a_car_elsa_contract`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_elsa_contract.md) · 18 velden
- [`a_car_elsa_recall`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_elsa_recall.md) · 12 velden
- [`a_car_fil`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_fil.md) · 9 velden
- [`a_car_fil_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_fil_typ.md) · 7 velden
- [`a_car_free_fld`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_free_fld.md) · 31 velden
- [`a_car_free_fld_translation`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_free_fld_translation.md) · 7 velden
- [`a_car_grp`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_grp.md) · 9 velden
- [`a_car_img`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_img.md) · 10 velden
- [`a_car_img_fol`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_img_fol.md) · 8 velden
- [`a_car_img_fol_img`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_img_fol_img.md) · 9 velden
- [`a_car_keyreader`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_keyreader.md) · 7 velden
- [`a_car_loan`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_loan.md) · 41 velden
- [`a_car_loan_codes`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_loan_codes.md) · 7 velden
- [`a_car_maintenance`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_maintenance.md) · 11 velden
- [`a_car_occ_sold`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_occ_sold.md) · 10 velden
- [`a_car_opt`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_opt.md) · 2 velden
- [`a_car_prt`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_prt.md) · 8 velden
- [`a_car_recall`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_recall.md) · 31 velden
- [`a_car_src`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_src.md) · 8 velden
- [`a_car_txt`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_txt.md) · 8 velden
- [`a_car_usage`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_usage.md) · 7 velden
- [`a_car_warranty_contract`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_warranty_contract.md) · 15 velden
- [`a_car_workshop_img`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car_workshop_img.md) · 8 velden

## Velden van a_car

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_bra_id.md) | Merk | integer | 21 |
| [`a_car_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_car_grp_id.md) | Autogroep | integer | 24 |
| [`a_car_usage_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_car_usage_id.md) | Auto gebruik | integer | 3 |
| [`a_coa_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_coa_id.md) | Carrosserie | integer | 19 |
| [`a_fue_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_fue_id.md) | Brandstof | integer | 22 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_mod_id.md) | Model | integer | 18 |
| [`a_ord_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_ord_typ_id.md) | Nieuw / Gebruikt | integer | 3 |
| [`a_road_tax_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_road_tax_id.md) | Wegenbelasting | integer | 0 |
| [`a_tra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_tra_id.md) | Transmissie | integer | 17 |
| [`a_vehicle_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.a_vehicle_typ_id.md) | Voertuigsoort | integer | 1 |
| [`ad_source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.ad_source_id.md) | AWD bron ID | integer | 3 |
| [`base_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.base_color.md) | Basis kleur | text | 9 |
| [`battery_voltage`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.battery_voltage.md) | Accu spanning | integer | 2 |
| [`bruto_bpm`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.bruto_bpm.md) | bruto_bpm | decimal | 6 |
| [`build_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.build_year.md) | Bouwjaar | integer | 4 |
| [`catalogusprijs`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.catalogusprijs.md) | catalogusprijs | decimal | 5 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.chassisnr.md) | Chassisnummer | text | 27 |
| [`cm_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.cm_checked.md) | CM afgehandeld | boolean | 5 |
| [`cm_reason`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.cm_reason.md) | CM inactivatie reden | text | 3 |
| [`co2`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.co2.md) | CO2 | integer | 14 |
| [`color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.color.md) | Kleur | text | 19 |
| [`color_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.color_code.md) | Kleur code | text | 6 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.created.md) | Aangelegd | timestamp | 1 |
| [`date_apk`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_apk.md) | APK datum | date | 8 |
| [`date_appointment`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_appointment.md) | Werkplaats afspraak | timestamp | 5 |
| [`date_finance_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_finance_end.md) | Eind datum financierings contract | date | 1 |
| [`date_lease_end_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_lease_end_autoline.md) | Einde leasedatum | date | 2 |
| [`date_sales`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_sales.md) | Verkoop datum | date | 2 |
| [`date_sales_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_sales_final.md) | Verkoop datum (Final) | date | 3 |
| [`date_service_final`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_service_final.md) | Service datum (Final) | date | 3 |
| [`date_visit`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_visit.md) | Datum laatste wp-bezoek | date | 2 |
| [`date_warranty`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_warranty.md) | Einde fabrieksgarantie | date | 3 |
| [`date_warranty_carr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_warranty_carr.md) | Einde carrosseriegarantie | date | 3 |
| [`date_warranty_ext`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_warranty_ext.md) | Einde verlengde garantie | date | 3 |
| [`date_works`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.date_works.md) | Datum laatste onderhoud | date | 2 |
| [`datumaanvangtenaamstelling`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.datumaanvangtenaamstelling.md) | Datum aanvang tenaamstelling | date | 15 |
| [`datumaanvangtenaamstelling_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.datumaanvangtenaamstelling_autoline.md) | datumaanvangtenaamstelling_autoline | date | 2 |
| [`datumeersteafgiftenederland`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.datumeersteafgiftenederland.md) | Datum eerste afgifte nederland | date | 20 |
| [`datumeerstetoelating`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.datumeerstetoelating.md) | Datum eerste toelating | date | 17 |
| [`description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.description.md) | Omschrijving | text | 19 |
| [`dispo`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.dispo.md) | dispo |  (niet in de tabeldefinitie) | 1 |
| [`doors`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.doors.md) | Deuren | integer | 10 |
| [`empty_weight`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.empty_weight.md) | Leeggewicht | integer | 9 |
| [`energy_label`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.energy_label.md) | Energie label | text | 1 |
| [`engine`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.engine.md) | Motor | text | 10 |
| [`engine_capacity`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.engine_capacity.md) | Motor capaciteit | integer | 11 |
| [`etgnum`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.etgnum.md) | ETG nummer | text | 2 |
| [`etgvar`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.etgvar.md) | ETG var | text | 2 |
| [`etgver`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.etgver.md) | ETG ver | text | 2 |
| [`getchassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.getchassisnr.md) | getchassisnr |  (niet in de tabeldefinitie) | 1 |
| [`getkomnummer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.getkomnummer.md) | getkomnummer |  (niet in de tabeldefinitie) | 1 |
| [`getlicenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.getlicenseplate.md) | getlicenseplate |  (niet in de tabeldefinitie) | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.id.md) | Id | integer | 0 |
| [`implementation`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.implementation.md) | Uitvoering | text | 7 |
| [`implementation_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.implementation_code.md) | Uitvoering code | text | 4 |
| [`information`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.information.md) | Informatie | clob | 5 |
| [`internet_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.internet_description.md) | Internet omschrijving | text | 12 |
| [`is_cm_active`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.is_cm_active.md) | Actief voor CM | boolean | 4 |
| [`is_economy_service`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.is_economy_service.md) | Economy service | boolean | 1 |
| [`is_elsa_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.is_elsa_checked.md) | ELSA gecontroleerd | boolean | 3 |
| [`is_rdw_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.is_rdw_checked.md) | RDW gecontroleerd | boolean | 3 |
| [`is_replacement_vehicle`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.is_replacement_vehicle.md) | Vervangend vervoer | boolean | 1 |
| [`komnummer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.komnummer.md) | Komnummer | text | 14 |
| [`komnummer_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.komnummer_autoline.md) | Komnummer Autoline | integer | 8 |
| [`komnummer_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.komnummer_year.md) | Komnummer jaar | integer | 5 |
| [`kwh`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.kwh.md) | Kwh | integer | 1 |
| [`last_remark`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.last_remark.md) | Laatste opmerking | clob | 2 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.licenseplate.md) | Kenteken | text | 22 |
| [`lining`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.lining.md) | Bekleding | text | 17 |
| [`meets_cm_requirements`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.meets_cm_requirements.md) | Voldoet aan CM auto criteria | boolean | 2 |
| [`milage`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.milage.md) | Kilometerstand | integer | 18 |
| [`mileage_end_autoline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.mileage_end_autoline.md) | Einde lease km-stand | integer | 2 |
| [`model_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.model_code.md) | Model code | text | 4 |
| [`model_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.model_group.md) | Modelgroep | text | 2 |
| [`model_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.model_type.md) | Modeltype | text | 7 |
| [`model_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.model_year.md) | Modeljaar | integer | 9 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.modified.md) | Gemodificeerd | timestamp | 1 |
| [`options_long`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.options_long.md) | Opties lang | clob | 4 |
| [`options_short`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.options_short.md) | Opties kort | clob | 4 |
| [`ovis_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.ovis_check.md) | OVIS gecontroleerd | date | 3 |
| [`performance_hp`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.performance_hp.md) | Vermogen PK | integer | 14 |
| [`performance_kw`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.performance_kw.md) | Vermogen Kw | integer | 18 |
| [`private_lease_end_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.private_lease_end_date.md) | Prive lease eind datum | date | 1 |
| [`rdw_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.rdw_check.md) | RDW gecontroleerd datum | date | 5 |
| [`replacement_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.replacement_remarks.md) | Vervangend vervoer opmerkingen | text | 1 |
| [`s_est_replacement_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_replacement_id.md) | Vervangend vervoer vestiging | integer | 1 |
| [`s_est_sales_final_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_sales_final_id.md) | Verkoop vestiging (Final) | integer | 3 |
| [`s_est_sales_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_sales_id.md) | Verkoop vestiging | integer | 2 |
| [`s_est_service_final_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_service_final_id.md) | Service vestiging (Final) | integer | 3 |
| [`s_est_visit_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_visit_id.md) | Vest. laatste wp-bezoek | integer | 1 |
| [`s_est_works_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_est_works_id.md) | Vest. laatste onderhoud | integer | 2 |
| [`s_fil_thumb_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_fil_thumb_id.md) | Kleine foto | integer | 5 |
| [`s_prt_debtor_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_prt_debtor_id.md) | Debiteur | integer | 3 |
| [`s_prt_les_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_prt_les_id.md) | Lessee | integer | 1 |
| [`s_prt_sal_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.s_prt_sal_id.md) | Verkoper | integer | 7 |
| [`service_interval`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.service_interval.md) | Service interval (Jaren) | integer | 2 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.source.md) | Bron | text | 9 |
| [`source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.source_id.md) | Bron ID | integer | 7 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.status.md) | Status | integer | 2 |
| [`top_color`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.top_color.md) | Kleur kap | text | 4 |
| [`type_gas_installatie`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.type_gas_installatie.md) | Type gas installatie | text | 2 |
| [`typekeurnum`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.typekeurnum.md) | Typekeuring | text | 2 |
| [`variant_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.variant_code.md) | Variant | text | 7 |
| [`vinservice_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.vinservice_check.md) | VinService gecontroleerd | date | 2 |
| [`vinservice_modelname`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.vinservice_modelname.md) | VinService Modelnaam | text | 2 |
| [`warranty_deadline`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.warranty_deadline.md) | Uiterste registratie datum garantie | date | 6 |
| [`wo_appointment`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wo_appointment.md) | Werkplaats afspraak WO | text | 5 |
| [`wpl_0103`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wpl_0103.md) | Grote beurt | date | 0 |
| [`wpl_0104`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wpl_0104.md) | Kleine beurt | date | 0 |
| [`wpl_0109`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wpl_0109.md) | Longlife | date | 0 |
| [`wpl_053`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wpl_053.md) | APK keuring | date | 0 |
| [`wpl_87a`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_car.wpl_87a.md) | Aircocheck | date | 0 |

---

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