# Tabel odd_part_est_stock

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

41 velden en waar hun waarde vandaan kan komen.

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

## Velden van odd_part_est_stock

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`bo_ctr_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.bo_ctr_id.md) | bo_ctr_id | integer | 2 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.created.md) | Aangelegd | timestamp | 1 |
| [`fc_flag`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.fc_flag.md) | Prognose | text | 0 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.guid.md) | Guid | text | 0 |
| [`has_wrong_location`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.has_wrong_location.md) | Loc.fout? | boolean | 1 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.id.md) | Id | integer | 0 |
| [`is_deleted_source`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.is_deleted_source.md) | is_deleted_source | boolean | 1 |
| [`last_check`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.last_check.md) | Invent.datum | date | 0 |
| [`last_purchase`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.last_purchase.md) | Laatste inkoop | date | 0 |
| [`last_sale`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.last_sale.md) | Laatste verkoop | date | 0 |
| [`location`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location.md) | Locatie 1 | text | 1 |
| [`location_other`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location_other.md) | Locatie overig | text | 0 |
| [`location2`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location2.md) | Locatie 2 | text | 0 |
| [`location3`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location3.md) | Locatie 3 | text | 0 |
| [`location4`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location4.md) | Locatie 4 | text | 0 |
| [`location5`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.location5.md) | Locatie 5 | text | 0 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.modified.md) | Gemodificeerd | timestamp | 1 |
| [`odd_cfg_sto_ind_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.odd_cfg_sto_ind_typ_id.md) | Voorraadindicator | integer | 0 |
| [`odd_part_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.odd_part_id.md) | Onderdeel | integer | 1 |
| [`price_cost_avg`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.price_cost_avg.md) | Kostprijs (gem) | decimal | 0 |
| [`price_sell`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.price_sell.md) | Verk.prijs | decimal | 0 |
| [`qty_free_stock`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_free_stock.md) | qty_free_stock | decimal | 0 |
| [`qty_loc`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_loc.md) | Vrd.loc1 | decimal | 0 |
| [`qty_loc2`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_loc2.md) | Vrd.loc2 | decimal | 0 |
| [`qty_loc3`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_loc3.md) | Vrd.loc3 | decimal | 0 |
| [`qty_loc4`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_loc4.md) | Vrd.loc4 | decimal | 0 |
| [`qty_loc5`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_loc5.md) | Vrd.loc5 | decimal | 0 |
| [`qty_max`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_max.md) | Max.voorraad | decimal | 0 |
| [`qty_max_manual`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_max_manual.md) | qty_max_manual | decimal | 1 |
| [`qty_min`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_min.md) | Min.voorraad | decimal | 0 |
| [`qty_min_manual`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_min_manual.md) | Min.voorr.handmatig | decimal | 1 |
| [`qty_ordered`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_ordered.md) | # op inkooporder | decimal | 0 |
| [`qty_reserved`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_reserved.md) | Gereserveerd | decimal | 0 |
| [`qty_sold_pyear`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_sold_pyear.md) | Verkocht vorig jr. | decimal | 0 |
| [`qty_sold_year`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_sold_year.md) | Verkocht dit jaar | decimal | 0 |
| [`qty_stock`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.qty_stock.md) | Voorraad | decimal | 0 |
| [`remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.remarks.md) | Opm.voorraad | clob | 1 |
| [`s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.s_est_id.md) | Vestiging | integer | 0 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.status.md) | Status | integer | 1 |
| [`value_stock`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.value_stock.md) | Voorr.waarde | decimal | 0 |
| [`value_suppl`](https://knowledgebase.syntec-it.nl/enterprise/velden/odd_part_est_stock.value_suppl.md) | Toeslagwaarde | decimal | 0 |

---

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