# Tabel s_est

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

53 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`s_est_cap`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est_cap.md) · 7 velden
- [`s_est_printer`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est_printer.md) · 16 velden

## Velden van s_est

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`afas_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.afas_code.md) | AFAS code | text | 1 |
| [`autodata_client`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autodata_client.md) | Autodata ClientID | text | 2 |
| [`autodata_user`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autodata_user.md) | Autodata gebruikersnaam | text | 1 |
| [`autoline_cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_cid.md) | Autoline CID | text | 3 |
| [`autoline_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_id.md) | Autoline ID | text | 3 |
| [`autoline_vsb`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_vsb.md) | VSB branche | boolean | 1 |
| [`autoline_vsb_new_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_vsb_new_end.md) | VSB seq eind (Nieuw) | integer | 1 |
| [`autoline_vsb_new_start`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_vsb_new_start.md) | VSB seq start (Nieuw) | integer | 1 |
| [`autoline_vsb_occ_end`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_vsb_occ_end.md) | VSB seq eind (Occ) | integer | 1 |
| [`autoline_vsb_occ_start`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.autoline_vsb_occ_start.md) | VSB seq start (Occ) | integer | 1 |
| [`bank_account`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.bank_account.md) | Bank account | text | 1 |
| [`bank_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.bank_name.md) | Bank | text | 1 |
| [`bic`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.bic.md) | BIC | text | 1 |
| [`calldrip_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.calldrip_id.md) | Calldrip ID | text | 0 |
| [`cid`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.cid.md) | Sleutel | text | 4 |
| [`city`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.city.md) | Plaats | text | 5 |
| [`color`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.color.md) | Kleur | text | 2 |
| [`country`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.country.md) | Land | text | 2 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.created.md) | Aangelegd | timestamp | 2 |
| [`email`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.email.md) | E-mail | text | 3 |
| [`fax`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.fax.md) | Fax | text | 4 |
| [`greeting_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.greeting_name.md) | Brief einde (Service) | text | 3 |
| [`greeting_name_sales`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.greeting_name_sales.md) | Brief einde (Sales) | text | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.guid.md) | Guid | text | 1 |
| [`has_aftersales`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_aftersales.md) | Is aftersales vestiging | boolean | 2 |
| [`has_cm`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_cm.md) | Is CM vestiging | boolean | 1 |
| [`has_hrm`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_hrm.md) | Is HRM vestiging | boolean | 1 |
| [`has_sales`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_sales.md) | Is verkoop vestiging | boolean | 2 |
| [`has_trade`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_trade.md) | Is export vestiging | boolean | 2 |
| [`has_tyre_swap`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_tyre_swap.md) | Is bandenwissel vestiging | boolean | 3 |
| [`has_wms`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_wms.md) | Is WMS vestiging | boolean | 0 |
| [`has_workshop`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.has_workshop.md) | Is werkplaats vestiging | boolean | 2 |
| [`houseno`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.houseno.md) | Huisnummer | text | 5 |
| [`iban`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.iban.md) | IBAN | text | 1 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.id.md) | Id | integer | 0 |
| [`information`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.information.md) | Informatie | clob | 2 |
| [`is_autodata_stock_source`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.is_autodata_stock_source.md) | Gebruik AWD als bron | boolean | 1 |
| [`latitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.latitude.md) | Latitude | decimal | 1 |
| [`longitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.longitude.md) | Longitude | decimal | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.modified.md) | Gemodificeerd | timestamp | 2 |
| [`name`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.name.md) | Naam | text | 5 |
| [`name2`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.name2.md) | Naam 2 | text | 3 |
| [`name3`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.name3.md) | Naam 3 | text | 3 |
| [`openingtimes`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.openingtimes.md) | Openingstijden | clob | 3 |
| [`phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.phone.md) | Telefoon | text | 5 |
| [`s_fil_logo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.s_fil_logo_id.md) | Logo | integer | 1 |
| [`s_prt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.s_prt_id.md) | Partner | integer | 1 |
| [`short_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.short_name.md) | Korte naam | text | 2 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.status.md) | Status | integer | 2 |
| [`street`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.street.md) | Straat | text | 5 |
| [`tax_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.tax_code.md) | BTW nummer | text | 3 |
| [`website`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.website.md) | Website | text | 3 |
| [`zipcode`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_est.zipcode.md) | Postcode | text | 5 |

---

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