title: "Material" category: reference tags: [entity, material, datamodel] source: Entities.xml date: 2026-04-17 status: published
Material
Type: Entity Properties: 15 Contexts: 1 Statussen: 2
DB-schema:
lookup_table_schema("Material")· ../tables/Material
Contextsbewerken
- 0: Standaard (
MaterialContext.None)
Statussenbewerken
- -1: Trash (
MaterialStatus.Trash) - 0: None (
MaterialStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | MATID | 9 | false | |
| ConditionFlawMaterials | List[ConditionFlawMaterial] | CONDFLMMATID | false | ||
| ConditionFlawPresents | List[ConditionFlawPresent] | CONFLPMATID | true | ||
| Context | Context | MATCONTEXT | false | ||
| DataProvider | UltimoString | MATDATAPROVIDER | 50 | true | |
| Description | UltimoString | MATDESCR | 200 | true | |
| EquipmentTypeMaterials | List[EquipmentTypeMaterial] | EQMTMMATID | false | ||
| Exported | Boolean | MATEXPORTED | false | 0 | |
| ExternalId | UltimoString | MATEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | MATEXTERNALSTATUS | 50 | true | |
| ProviderMutationDate | DateTime? | MATPROVIDERMUTDATE | true | ||
| RecordChangeDate | DateTime? | MATRECCHANGEDATE | true | ||
| RecordCreateDate | DateTime? | MATRECCREATEDATE | true | SYSDATETIME | |
| Status | Status | MATRECSTATUS | false | ||
| TransferNextTime | Boolean | MATTRANSFERNEXTTIME | false |
Brondatabewerken
- Entity-definitie —
lookup_entity("Material")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Material")· ../tables/Material DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Material")Before/After Save events voor Material. Bron:workflows.xml.