# Tabel a_ord_vspec

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

26 velden en waar hun waarde vandaan kan komen.

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

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

## Velden van a_ord_vspec

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`actcost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.actcost.md) | Werkelijke kosten | decimal | 6 |
| [`analysis`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.analysis.md) | Analyze code | text | 3 |
| [`credate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.credate.md) | Datum aangelegd | timestamp | 9 |
| [`cretime`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.cretime.md) | Tijd aangelegd | integer | 5 |
| [`creuser`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.creuser.md) | Aangelegd door | text | 6 |
| [`desc001`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.desc001.md) | Omschrijving 1 | text | 9 |
| [`desc002`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.desc002.md) | Omschrijving 2 | text | 9 |
| [`desc003`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.desc003.md) | Omschrijving 3 | text | 9 |
| [`editdate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.editdate.md) | Datum gemodificeerd | timestamp | 9 |
| [`edituser`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.edituser.md) | Gemodificeerd door | text | 6 |
| [`estcost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.estcost.md) | Geschatte kosten | decimal | 6 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.guid.md) | Guid | text | 3 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.id.md) | Id | integer | 0 |
| [`invalue`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.invalue.md) | Invalue | decimal | 6 |
| [`latecost`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.latecost.md) | Nagekomen kosten | decimal | 3 |
| [`magic`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.magic.md) | VSB-nummer | integer | 6 |
| [`optkey`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.optkey.md) | Optkey | text | 6 |
| [`orddate`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.orddate.md) | orddate | date | 3 |
| [`orderno`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.orderno.md) | Order-nummer | integer | 3 |
| [`otype`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.otype.md) | Otype | text | 6 |
| [`product`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.product.md) | Product | text | 6 |
| [`row_sequence`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.row_sequence.md) | Rij-nummer | integer | 5 |
| [`row_uni`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.row_uni.md) | Unieke sleutel | text | 3 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.source.md) | Bron | text | 6 |
| [`vat`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.vat.md) | vat | decimal | 3 |
| [`vtype`](https://knowledgebase.syntec-it.nl/enterprise/velden/a_ord_vspec.vtype.md) | Vtype | text | 5 |

---

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