# Tabel a_work

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

33 velden en waar hun waarde vandaan kan komen.

Hoort bij de module [Werk derden](https://knowledgebase.syntec-it.nl/enterprise/derdenwerk.md).

## Gekoppelde tabellen

- [`a_work_file`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_file.md) · 8 velden
- [`a_work_invoice`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.md) · 27 velden
- [`a_work_invoice_line`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice_line.md) · 8 velden
- [`a_work_msg`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_msg.md) · 8 velden
- [`a_work_msg_not_cfg`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_msg_not_cfg.md) · 8 velden
- [`a_work_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_type.md) · 9 velden
- [`a_work_type_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_type_cost.md) · 10 velden
- [`a_work_worker_assignment`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_worker_assignment.md) · 9 velden

## Velden van a_work

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_bra_id.md) | Merk ID | integer | 14 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_car_id.md) | Auto ID | integer | 14 |
| [`a_loc_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_loc_id.md) | Locatie | integer | 13 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_mod_id.md) | Model ID | integer | 14 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_ord_id.md) | Order ID | integer | 13 |
| [`a_work_type_cost_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_work_type_cost_id.md) | Type kosten ID | integer | 1 |
| [`a_work_type_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.a_work_type_id.md) | Type ID | integer | 2 |
| [`act_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.act_cost.md) | Kosten (werkelijk) | decimal | 3 |
| [`calc_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.calc_cost.md) | Kosten (berekend) | decimal | 5 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.car_description.md) | Auto omschrijving | text | 14 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.chassisnr.md) | Chassisnr | text | 4 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.created.md) | Aangelegd | timestamp | 1 |
| [`date_approved`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.date_approved.md) | Goedgekeurd op | timestamp | 6 |
| [`date_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.date_completed.md) | Afgerond op | timestamp | 3 |
| [`date_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.date_delivery.md) | Datum afleveren | date | 12 |
| [`date_end_forecast`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.date_end_forecast.md) | Einddatum (prognose) | date | 1 |
| [`date_start_forecast`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.date_start_forecast.md) | Startdatum (prognose) | date | 1 |
| [`description`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.description.md) | Omschrijving | text | 13 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.id.md) | Id | integer | 0 |
| [`invoice_no`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.invoice_no.md) | Factuur nr. | text | 5 |
| [`is_approved`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.is_approved.md) | Goedgekeurd | boolean | 7 |
| [`is_completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.is_completed.md) | Afgerond | boolean | 2 |
| [`is_hidden`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.is_hidden.md) | Verborgen | boolean | 2 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.licenseplate.md) | Kenteken | text | 5 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.modified.md) | Gemodificeerd | timestamp | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.s_est_id.md) | Vestiging | integer | 14 |
| [`s_prt_approved_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.s_prt_approved_id.md) | Goedgekeurd door | integer | 10 |
| [`s_prt_completed_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.s_prt_completed_id.md) | Afgerond door | integer | 5 |
| [`s_prt_worker_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.s_prt_worker_id.md) | Uitvoerder ID | integer | 12 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.status.md) | Status | boolean | 1 |
| [`time_delivery`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.time_delivery.md) | Tijd afleveren | time | 12 |
| [`vsb`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.vsb.md) | VSB | integer | 3 |

---

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