# Tabel a_pre_ord

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

107 velden en waar hun waarde vandaan kan komen.

Hoort bij de module [Offertes en pre-order](https://knowledgebase.syntec-it.nl/enterprise/offertes.md).

## Gekoppelde tabellen

- [`a_pre_ord_chk`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_chk.md) · 10 velden
- [`a_pre_ord_chk_lnk`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_chk_lnk.md) · 8 velden
- [`a_pre_ord_cla`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_cla.md) · 15 velden
- [`a_pre_ord_div_lnk`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_div_lnk.md) · 7 velden
- [`a_pre_ord_doc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_doc.md) · 11 velden
- [`a_pre_ord_error_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_error_typ.md) · 7 velden
- [`a_pre_ord_fld_dis`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_fld_dis.md) · 6 velden
- [`a_pre_ord_fld_required`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_fld_required.md) · 6 velden
- [`a_pre_ord_salesforce`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_salesforce.md) · 63 velden
- [`a_pre_ord_salesforce_log`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_salesforce_log.md) · 7 velden
- [`a_pre_ord_wrk_con`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord_wrk_con.md) · 3 velden

## Velden van a_pre_ord

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_bra_id.md) | Merk | integer | 3 |
| [`a_insurance_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_insurance_type_id.md) | Verzekering type | integer | 2 |
| [`a_loc_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_loc_id.md) | Locatie | integer | 1 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_mod_id.md) | Model | integer | 3 |
| [`a_ord_check_status_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_ord_check_status_id.md) | a_ord_check_status_id | integer | 1 |
| [`a_ord_fin_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_ord_fin_id.md) | Fin. type | integer | 1 |
| [`a_ord_plates_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_ord_plates_id.md) | Te bestellen plaattypen | integer | 1 |
| [`a_ord_trade_dest_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_ord_trade_dest_id.md) | Inruilbestemming | integer | 1 |
| [`a_ord_trade_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_ord_trade_type_id.md) | Inruilsoort | integer | 2 |
| [`a_pre_ord_error_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_pre_ord_error_typ_id.md) | Fout reden | integer | 1 |
| [`a_quo_occ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_quo_occ_id.md) | Occasion offerte | integer | 3 |
| [`a_war_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_war_id.md) | Garantie | integer | 1 |
| [`a_war_milage_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.a_war_milage_id.md) | Garantie km-stand | integer | 1 |
| [`al_muv`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.al_muv.md) | Autoline bijleveringen | clob | 1 |
| [`autoline_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.autoline_check.md) | Autoline check | boolean | 0 |
| [`autoline_order_created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.autoline_order_created.md) | Order aangemaakt in Autoline | boolean | 1 |
| [`autoline_quotation_magic`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.autoline_quotation_magic.md) | Offerte magic | integer | 1 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.car_description.md) | Auto omschrijving | text | 2 |
| [`claims_required`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.claims_required.md) | Claims verplicht (ja/nee) | boolean | 1 |
| [`claims_required_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.claims_required_remarks.md) | Claims verplicht (opmerkingen) | clob | 1 |
| [`config_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.config_code.md) | CST config code | text | 1 |
| [`contract_fin`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.contract_fin.md) | Fin. looptijd (mnd) | text | 1 |
| [`contract_ver`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.contract_ver.md) | Contractnummer (Ver.) | text | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.created.md) | Aangelegd | timestamp | 1 |
| [`customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.customer.md) | Klant | text | 5 |
| [`date_approved`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_approved.md) | Datum/tijd gecontroleerd | timestamp | 4 |
| [`date_delivery_wish`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_delivery_wish.md) | Afleverdatum | date | 3 |
| [`date_disapproved`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_disapproved.md) | Afgekeurd (op) | timestamp | 3 |
| [`date_finance_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_finance_end.md) | Eind datum financierings contract | date | 2 |
| [`date_lease_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_lease_end.md) | Eind datum lease contract | date | 1 |
| [`date_lease_end_new`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_lease_end_new.md) | Eind datum lease contract (nieuw) | date | 1 |
| [`date_minimum_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.date_minimum_delivery.md) | Niet leveren voor | date | 2 |
| [`datetime_delivery_edit`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.datetime_delivery_edit.md) | datetime_delivery_edit | boolean | 2 |
| [`dealer_warranty`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.dealer_warranty.md) | Extra garantie | boolean | 1 |
| [`dealer_warranty_info`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.dealer_warranty_info.md) | Garantie opmerkingen | text | 2 |
| [`disapprove_reason`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.disapprove_reason.md) | Reden afgekeurd | text | 3 |
| [`fin_amount`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.fin_amount.md) | Bedrag (Financiering) | decimal | 1 |
| [`fin_months`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.fin_months.md) | Contractnummer (Fin.) | integer | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.guid.md) | Guid | text | 0 |
| [`has_insurance_form`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.has_insurance_form.md) | Formulier door klant ingevuld | boolean | 1 |
| [`has_insurance_quotation`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.has_insurance_quotation.md) | Verzekeringsofferte gemaakt | boolean | 1 |
| [`has_order_link`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.has_order_link.md) | Heeft link naar order | boolean | 0 |
| [`honeymoon_text_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.honeymoon_text_type.md) | Honeymoon type | text | 2 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.id.md) | Id | integer | 0 |
| [`is_asap_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_asap_delivery.md) | ZSM leveren | boolean | 3 |
| [`is_copied`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_copied.md) | Overgenomen naar order | boolean | 2 |
| [`is_disapproved`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_disapproved.md) | Afgekeurd | boolean | 5 |
| [`is_fin`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_fin.md) | Is financiering | boolean | 1 |
| [`is_fin_kcc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_fin_kcc.md) | Kcc medewerker (Fin.) | integer | 1 |
| [`is_finance_request`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_finance_request.md) | Klant wil fin. offerte | integer | 1 |
| [`is_finance_request_send`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_finance_request_send.md) | Klant wil verzekerings offerte (Verstuurd) | boolean | 0 |
| [`is_honeymoon`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_honeymoon.md) | Honeymoon | boolean | 1 |
| [`is_insurance_request`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_insurance_request.md) | Klant wil verzekerings offerte | integer | 2 |
| [`is_insurance_request_send`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_insurance_request_send.md) | Klant wil verzekerings offerte (Verstuurd) | integer | 0 |
| [`is_insurred_kcc`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_insurred_kcc.md) | Kcc medewerker (Verz.) | integer | 1 |
| [`is_overloop`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_overloop.md) | Overloop | boolean | 1 |
| [`is_polis`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_polis.md) | Is polis | boolean | 1 |
| [`is_private_lease`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_private_lease.md) | Prive lease | boolean | 1 |
| [`is_salesforce_order`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_salesforce_order.md) | Salesforce order | boolean | 2 |
| [`is_viewed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_viewed.md) | Bekeken | boolean | 4 |
| [`is_vsb_progress`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.is_vsb_progress.md) | In behandeling VSB | boolean | 1 |
| [`komnummer`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.komnummer.md) | komnummer | text | 3 |
| [`lease_delivery_deviation_info`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.lease_delivery_deviation_info.md) | Afw. Voorl./Def. week lease geinformeerd | date | 1 |
| [`mail_send_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.mail_send_date.md) | mail_send_date | date | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.modified.md) | Gemodificeerd | timestamp | 1 |
| [`muv_extra`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.muv_extra.md) | Bijleveringen | clob | 1 |
| [`num_white_plates`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.num_white_plates.md) | Aantal te bestellen witte platen | integer | 3 |
| [`ocw_agreed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.ocw_agreed.md) | OCW Akkoord | boolean | 1 |
| [`order_nr_lease`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.order_nr_lease.md) | Ordernr Lease | text | 4 |
| [`order_nr_pon`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.order_nr_pon.md) | Bestelbon nr. | integer | 4 |
| [`order_nr_vsb`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.order_nr_vsb.md) | VSB-nr | integer | 2 |
| [`polish_info`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.polish_info.md) | Poetsinformatie | clob | 1 |
| [`private_lease_end_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.private_lease_end_date.md) | Prive lease eind datum | date | 1 |
| [`private_lease_months`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.private_lease_months.md) | Prive lease looptijd | integer | 1 |
| [`private_lease_tradein_bonus`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.private_lease_tradein_bonus.md) | Prive lease inruilbonus | decimal | 1 |
| [`provision`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.provision.md) | Provisie | decimal | 1 |
| [`provision_finance`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.provision_finance.md) | Provisie bedrag | decimal | 2 |
| [`provision_insurrance`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.provision_insurrance.md) | Provisie bedrag (Verzekering) | decimal | 0 |
| [`reason_minimum_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.reason_minimum_delivery.md) | Reden niet rijden | text | 1 |
| [`remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.remarks.md) | Opmerkingen | clob | 2 |
| [`rent_typ`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.rent_typ.md) | Rente type | text | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_est_id.md) | Vestiging | integer | 3 |
| [`s_prt_appr_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_appr_id.md) | Gecontroleerd door | integer | 4 |
| [`s_prt_disapproved_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_disapproved_id.md) | Afgekeurd (door) | integer | 3 |
| [`s_prt_extra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_extra_id.md) | Tussenpersoon | integer | 1 |
| [`s_prt_fin_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_fin_id.md) | Gefinancierd door | integer | 1 |
| [`s_prt_insured_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_insured_id.md) | Verzekerd door | integer | 1 |
| [`s_prt_sal_delivery_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_sal_delivery_id.md) | Aflevering door | integer | 1 |
| [`s_prt_sal_extra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_sal_extra_id.md) | Extra contactpersoon | integer | 1 |
| [`s_prt_sal_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_sal_id.md) | Verkoper | integer | 5 |
| [`s_prt_sub_grp_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.s_prt_sub_grp_id.md) | Klantgroep | integer | 2 |
| [`salesmanager_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.salesmanager_check.md) | Verkoopmanager gecontroleerd | boolean | 5 |
| [`send_to_leaselink`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.send_to_leaselink.md) | Leaselink | boolean | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.status.md) | Status | integer | 2 |
| [`time_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.time_delivery.md) | Aflevertijd | time | 2 |
| [`trade_in_brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_brand.md) | Inruiler merk | text | 3 |
| [`trade_in_destination`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_destination.md) | Inruilbestemming | text | 0 |
| [`trade_in_licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_licenseplate.md) | Inruiler kenteken | text | 3 |
| [`trade_in_mileage`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_mileage.md) | Inruiler km-stand | integer | 2 |
| [`trade_in_model`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_model.md) | Inruiler model | text | 3 |
| [`trade_in_tax_price`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.trade_in_tax_price.md) | Inruiler tax prijs | decimal | 3 |
| [`verwachte_opbrengst`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.verwachte_opbrengst.md) | Verwachte opbrengst | decimal | 1 |
| [`vsb_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.vsb_remarks.md) | VSB opmerkingen | clob | 1 |
| [`week_delivery_est`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.week_delivery_est.md) | Verw. afleverwk. | integer | 2 |
| [`week_production_lib`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.week_production_lib.md) | Prod. wk. LIB | integer | 3 |
| [`wo_other_works`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.wo_other_works.md) | Overige werkzaamheden | clob | 1 |
| [`wo_works`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_pre_ord.wo_works.md) | Werkzaamheden | clob | 1 |

---

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