# Tabel s_mm_mat

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

44 velden en waar hun waarde vandaan kan komen.

## Gekoppelde tabellen

- [`s_mm_mat_cms_con`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat_cms_con.md) · 16 velden
- [`s_mm_mat_col`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat_col.md) · 8 velden
- [`s_mm_mat_lng`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat_lng.md) · 6 velden

## Velden van s_mm_mat

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`code`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.code.md) | Artikelnummer | text | 1 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.created.md) | Aangelegd | timestamp | 1 |
| [`fam_group`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.fam_group.md) | Familie groep | text | 1 |
| [`fam_picture`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.fam_picture.md) | fam_picture | boolean | 1 |
| [`fam_sort`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.fam_sort.md) | Familie volgorde | integer | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.guid.md) | Guid | text | 0 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.id.md) | Id | integer | 0 |
| [`mat_ce_count`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_ce_count.md) | CE hoeveelheid | integer | 1 |
| [`mat_ce_count_ammount`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_ce_count_ammount.md) | CE entity count | integer | 1 |
| [`mat_delivery_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_delivery_type.md) | Uitlever type | text | 1 |
| [`mat_depth`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_depth.md) | Diepte | decimal | 1 |
| [`mat_ean`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_ean.md) | EAN code | text | 1 |
| [`mat_exc`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_exc.md) | Uitsluiten | boolean | 1 |
| [`mat_exc_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_exc_date.md) | Uitsluit datum | date | 1 |
| [`mat_exc_indv_sale`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_exc_indv_sale.md) | Indv. verkoop uitsluiten | boolean | 1 |
| [`mat_gross_weight`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_gross_weight.md) | Brutto gewicht | decimal | 1 |
| [`mat_height`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_height.md) | Hoogte | decimal | 1 |
| [`mat_is_virt`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_is_virt.md) | Virtueel artikel | boolean | 1 |
| [`mat_net_weight`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_net_weight.md) | Netto gewicht | decimal | 1 |
| [`mat_pkg_depth`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_pkg_depth.md) | Pakket diepte | decimal | 1 |
| [`mat_pkg_gross_weight`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_pkg_gross_weight.md) | Pakket brutto gewicht | decimal | 1 |
| [`mat_pkg_height`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_pkg_height.md) | Pakket hoogte | decimal | 1 |
| [`mat_pkg_net_weight`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_pkg_net_weight.md) | Pakket netto gewicht | decimal | 1 |
| [`mat_pkg_width`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_pkg_width.md) | Pakket breedte | decimal | 1 |
| [`mat_width`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.mat_width.md) | Breedte | decimal | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.modified.md) | Gemodificeerd | timestamp | 1 |
| [`s_fil_thumb_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_fil_thumb_id.md) | Thumbnail | integer | 1 |
| [`s_mm_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_bra_id.md) | Merk | integer | 1 |
| [`s_mm_grp1_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_grp1_id.md) | Groep 1 | integer | 1 |
| [`s_mm_grp2_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_grp2_id.md) | Groep 2 | integer | 1 |
| [`s_mm_grp3_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_grp3_id.md) | Groep 3 | integer | 1 |
| [`s_mm_raw_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_raw_id.md) | Grondstof | integer | 1 |
| [`s_mm_tax_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_tax_id.md) | BTW | integer | 1 |
| [`s_mm_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_typ_id.md) | Artikel type | integer | 1 |
| [`s_mm_unt_count_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_unt_count_id.md) | Teleenheid hoeveelheid | integer | 1 |
| [`s_mm_unt_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_unt_id.md) | Eenheid | integer | 1 |
| [`s_mm_unt_mat_par_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_mm_unt_mat_par_id.md) | s_mm_unt_mat_par_id | integer | 1 |
| [`s_prt_sup_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.s_prt_sup_id.md) | Leverancier | integer | 1 |
| [`source`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.source.md) | Bron | text | 1 |
| [`source_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.source_id.md) | Bron Identificatie | text | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.status.md) | Status | integer | 1 |
| [`sup_code`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.sup_code.md) | Lev. artikelnummer | text | 1 |
| [`sup_delivery_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.sup_delivery_time.md) | Levertijd | integer | 1 |
| [`sup_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/s_mm_mat.sup_description.md) | Lev. omschrijving | text | 1 |

---

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