# Tabel a_lease_dump

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

58 velden en waar hun waarde vandaan kan komen.

## Velden van a_lease_dump

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.a_bra_id.md) | Merk | integer | 1 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.a_car_id.md) | Auto | integer | 1 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.a_mod_id.md) | Model | integer | 0 |
| [`addition_perc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.addition_perc.md) | Bijtellingsperc. | text | 0 |
| [`brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.brand.md) | Merk | text | 0 |
| [`calculation_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.calculation_type.md) | Calculatietype | text | 0 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.car_description.md) | Auto omschrijving | text | 0 |
| [`co2`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.co2.md) | CO2 uitstoot | text | 0 |
| [`coc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.coc.md) | KVK nummer | text | 0 |
| [`comm_field_service`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.comm_field_service.md) | Commerciele Buitendienst | text | 0 |
| [`comm_office_service`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.comm_office_service.md) | Commerciele Binnendienst | text | 0 |
| [`contract_end_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_end_date.md) | Contract einddatum | date | 0 |
| [`contract_end_date_planned`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_end_date_planned.md) | Contract einddatum (gepland) | date | 0 |
| [`contract_ref`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_ref.md) | Contract Referentie | text | 0 |
| [`contract_ref_upcoming_cont`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_ref_upcoming_cont.md) | Contract ref. opvolg. contract | text | 0 |
| [`contract_start_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_start_date.md) | Contract startdatum | date | 0 |
| [`contract_status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.contract_status.md) | Contract Status | text | 0 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.created.md) | Aangelegd | timestamp | 0 |
| [`customer_ref`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.customer_ref.md) | Klant ref. | text | 0 |
| [`customer_tradename`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.customer_tradename.md) | Klant Handelsnaam | text | 0 |
| [`date_contract_status_validated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.date_contract_status_validated.md) | Datum contract status gevalideerd | date | 0 |
| [`date_contract_status_vehicle_order`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.date_contract_status_vehicle_order.md) | Datum contract status voertuig in bestelling | date | 0 |
| [`driver_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.driver_name.md) | Berijder | text | 0 |
| [`duration_months`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.duration_months.md) | Looptijd mnd | text | 0 |
| [`energy_label`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.energy_label.md) | Energielabel | text | 0 |
| [`fuel`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.fuel.md) | Brandstof | text | 0 |
| [`fuel_card_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.fuel_card_cost.md) | Brandstofpaskosten | text | 0 |
| [`fuel_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.fuel_type.md) | Brandstoftype | text | 0 |
| [`fuel_yn`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.fuel_yn.md) | Brandstof ja/nee | text | 0 |
| [`greenfield_order_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.greenfield_order_type.md) | Soort Greenfield order | text | 0 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.id.md) | Id | integer | 0 |
| [`invest_ex_btw`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.invest_ex_btw.md) | Investering ex. btw | text | 0 |
| [`isic_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.isic_code.md) | Isic Code | text | 0 |
| [`isic_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.isic_description.md) | Isic Beschrijving | text | 0 |
| [`last_mileage`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.last_mileage.md) | Laatste KM-stand | text | 0 |
| [`last_mileage_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.last_mileage_date.md) | Laatste KM-stand (datum) | text | 0 |
| [`leaseprice_ex_btw`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.leaseprice_ex_btw.md) | Leaseprijs ex. btw | text | 0 |
| [`leaseprice_ex_fuel_ex_btw`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.leaseprice_ex_fuel_ex_btw.md) | Leaseprijs ex br. ex. btw | text | 0 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.licenseplate.md) | Kenteken | text | 0 |
| [`licenseplate_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.licenseplate_type.md) | Kentekensoort | text | 0 |
| [`mileage_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.mileage_year.md) | KM per jaar | text | 0 |
| [`mileage_year_perc_deviation`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.mileage_year_perc_deviation.md) | KM per jaar % afwijking | text | 0 |
| [`mileage_year_real`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.mileage_year_real.md) | KM per jaar werkelijk | text | 0 |
| [`model`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.model.md) | Model | text | 0 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.modified.md) | Gemodificeerd | timestamp | 0 |
| [`month_contract_status_validated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.month_contract_status_validated.md) | Maand contract status gevalideerd | text | 0 |
| [`repair_maintenance_yn`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.repair_maintenance_yn.md) | Reparatie & onderhoud ja/nee | text | 0 |
| [`reporting_product`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.reporting_product.md) | Reporting product | text | 0 |
| [`s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.s_prt_id.md) | Partner | integer | 2 |
| [`special_deal_yn`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.special_deal_yn.md) | Speciale deal ja/nee | text | 0 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.status.md) | Status | boolean | 0 |
| [`supplier_tradename`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.supplier_tradename.md) | Leverancier handelsnaam | text | 0 |
| [`tax_value`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.tax_value.md) | Fiscale waarde | text | 0 |
| [`tires_yn`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.tires_yn.md) | Banden ja/nee | text | 0 |
| [`week_contract_status_validated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.week_contract_status_validated.md) | Week contract status gevalideerd | text | 0 |
| [`winter_tires_yn`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.winter_tires_yn.md) | Winterbanden ja/nee | text | 0 |
| [`year_contract_status_validated`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_lease_dump.year_contract_status_validated.md) | Jaar contract status gevalideerd | text | 0 |

---

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