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

JobJobPlan

Type: Entity Properties: 24 Contexts: 2 Statussen: 6

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

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	JOBJPLID	6	false
ApprovedCustomerContactPerson	Employee	JOBJPLAPPROVEDCUSCNTEMPID		true
ApprovedDateCustomerContactPerson	DateTime?	JOBJPLAPPROVEDCUSCNTDATE		true
CanceledCustomerContactPerson	Employee	JOBJPLCANCELEDCUSCNTEMPID		true
CanceledDateCustomerContactPerson	DateTime?	JOBJPLCANCELEDCUSCNTDATE		true
Context	Context	JOBJPLCONTEXT		false	1
CustomerText	UltimoString	JOBJPLCUSTOMERTEXT		true
Description	UltimoString	JOBJPLDESCR	200	true
Exported	Boolean	JOBJPLEXPORTED		false	0
Job	Job	JOBJPLJOBID		true
JobPlan	JobPlan	JOBJPLJPID		true
RecordChangeDate	DateTime?	JOBJPLRECCHANGEDATE		true
RecordCreateDate	DateTime?	JOBJPLRECCREATEDATE		true	SYSDATETIME
RemarkText	UltimoString	JOBJPLREMARKTEXT		true
Status	Status	JOBJPLRECSTATUS		false	1
StatusApprovedDate	DateTime?	JOBJPLAPPROVEDDATE		true
StatusApprovedEmployee	Employee	JOBJPLAPPROVEDEMPID		true
StatusCanceledDate	DateTime?	JOBJPLCANCELEDDATE		true
StatusCanceledEmployee	Employee	JOBJPLCANCELEDEMPID		true
StatusCreatedDate	DateTime?	JOBJPLCREATEDDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	JOBJPLCREATEDEMPID		true	USERID
StatusQuotationDate	DateTime?	JOBJPLQUOTATIONDATE		true
StatusQuotationEmployee	Employee	JOBJPLQUOTATIONEMPID		true
SystemCompany	Company	JOBJPLCOMPID		false

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