title: "Theme" category: reference tags: [entity, theme, datamodel] source: Entities.xml date: 2026-04-17 status: published

Theme

Type: Entity Properties: 12 Contexts: 2 Statussen: 5

DB-schema: lookup_table_schema("Theme") · ../tables/Theme

Contextsbewerken

1: Leveranciersbeoordeling (ThemeContext.VendorRating)
2: Contractevaluatie (ThemeContext.ContractAssessment)

Statussenbewerken

-1: Trash (ThemeStatus.Trash)
0: None (ThemeStatus.None)
1: Open (ThemeStatus.Created)
2: Goedgekeurd (ThemeStatus.Approved)
4: Vervallen (ThemeStatus.Expired)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	THMID	10	false
Context	Context	THMCONTEXT		false	1
Description	UltimoString	THMDESCR	80	true
Exported	Boolean	THMEXPORTED		false	0
RecordCreateDate	DateTime	THMRECCREATEDATE		false	SYSDATETIME
Status	Status	THMRECSTATUS		false	1
StatusApprovedDate	DateTime?	THMAPPROVEDDATE		true
StatusApprovedEmployee	Employee	THMAPPROVEDEMPID		true
StatusCreatedDate	DateTime?	THMCREATEDDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	THMCREATEDEMPID		true	USERID
StatusExpiredDate	DateTime?	THMEXPIREDDATE		true
StatusExpiredEmployee	Employee	THMEXPIREDEMPID		true

Brondatabewerken

Entity-definitie — lookup_entity("Theme") Model-perspectief (properties, contexts, statussen). Bron: Entities.xml.
DB-schema — lookup_table_schema("Theme") · ../tables/Theme DB-perspectief (triggers, computed, defaults). Bron: database-schema.json.
Workflows — find_workflows("", entity="Theme") Before/After Save events voor Theme. Bron: workflows.xml.