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

Craftsman

Type: Entity Properties: 25 Contexts: 2 Statussen: 2

Zie ook het handgeschreven artikel: craftsman

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

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	CRMID	6	false
CalculationHourlyRate	Decimal	CRMHOURS		false
Comment1	UltimoString	CRMCMNT1	41	true
Comment2	UltimoString	CRMCMNT2	41	true
Comment3	UltimoString	CRMCMNT3	41	true
Context	Context	CRMCONTEXT		false	1
DataProvider	UltimoString	CRMDATAPROVIDER	50	true
Description	UltimoString	CRMDESCR1	41	true
EmployeeLabourLines	List[EmployeeLabourLine]	EMPLLCRMID		true
Employees	List[Employee]	EMPCRMID		true
Exported	Boolean	CRMEXPORTED		false
ExternalId	UltimoString	CRMEXTERNALID	50	true
ExternalStatus	UltimoString	CRMEXTERNALSTATUS	50	true
HourCategories	List[CraftsmanHourCategory]	CRMHCCRMID		false
JobResources	List[JobResource]	JOBRCRMID		true
Jobs	List[Job]	JOBCRMID		true
JobWeekLabours	List[JobWeekLabour]	JOBWLCRMID		true
PmJobResources	List[PmJobResource]	PMJRCRMID		true
PmJobs	List[PmJob]	PMJCRMID		true
ProviderMutationDate	DateTime?	CRMPROVIDERMUTDATE		true
RecordChangeDate	DateTime?	CRMRECCHANGEDATE		true
RecordCreateDate	DateTime?	CRMRECCREATEDATE		true	SYSDATETIME
SkillCategory	SkillCategory	CRMSKCID		true
Status	Status	CRMRECSTATUS		false
TransferNextTime	Boolean	CRMTRANSFERNEXTTIME		false

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