# Tabel a_work_invoice

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

27 velden en waar hun waarde vandaan kan komen.

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

Gekoppeld aan de hoofdtabel [`a_work`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work.md).

## Velden van a_work_invoice

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.created.md) | Aangelegd | timestamp | 1 |
| [`date_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.date_checked.md) | Gecontroleerd op | timestamp | 2 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.id.md) | Id | integer | 0 |
| [`invoice_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.invoice_date.md) | Factuurdatum | date | 1 |
| [`invoice_month`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.invoice_month.md) | Periode (maand) | integer | 0 |
| [`invoice_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.invoice_year.md) | Periode (jaar) | integer | 0 |
| [`is_checked`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.is_checked.md) | Gecontroleerd | boolean | 2 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.modified.md) | Gemodificeerd | timestamp | 1 |
| [`period_from`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.period_from.md) | Periode (van) | date | 3 |
| [`period_to`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.period_to.md) | Periode (tot) | date | 3 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.s_est_id.md) | Vestiging | integer | 3 |
| [`s_fil_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.s_fil_id.md) | Bestand | integer | 5 |
| [`s_prt_checked_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.s_prt_checked_id.md) | Gecontroleerd door | integer | 2 |
| [`s_prt_worker_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.s_prt_worker_id.md) | Uitvoerder ID | integer | 3 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.status.md) | Status | boolean | 1 |
| [`total_ex`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.total_ex.md) | Totaal ex. btw | decimal | 2 |
| [`total_in`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.total_in.md) | Totaal in. btw | decimal | 1 |
| [`total_vat`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.total_vat.md) | Totaal BTW | decimal | 1 |
| [`worker_city`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_city.md) | Uitvoerder (stad) | text | 1 |
| [`worker_country`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_country.md) | Uitvoerder (land) | text | 1 |
| [`worker_email`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_email.md) | Uitvoerder (email) | text | 1 |
| [`worker_houseno`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_houseno.md) | Uitvoerder (nr) | text | 1 |
| [`worker_name`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_name.md) | Uitvoerder (naam) | text | 1 |
| [`worker_phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_phone.md) | Uitvoerder (telefoon) | text | 1 |
| [`worker_street`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_street.md) | Uitvoerder (adres) | text | 1 |
| [`worker_zipcode`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_work_invoice.worker_zipcode.md) | Uitvoerder (postcode) | text | 1 |

---

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