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

Reservation

Type: Entity Properties: 37 Contexts: 7 Statussen: 4

Zie ook het handgeschreven artikel: reservation

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

Contextsbewerken

0: (ReservationContext.None)
1: Zaalreservering (ReservationContext.SpaceReservation)
2: Evenement (ReservationContext.Event)
4: Catering-/Middelreservering (ReservationContext.Catering)
8: Bezoek (ReservationContext.Visit)
16: Poolautoreservering (ReservationContext.PoolCar)
256: Outlook-reservering (ReservationContext.Exchange)

Statussenbewerken

-1: Trash (ReservationStatus.Trash)
0: None (ReservationStatus.None)
1: Open (ReservationStatus.Created)
2: Aangevraagd (ReservationStatus.Requested)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	RESID	6	false
Applicant	Employee	RESAPPLICANTEMPID		true
ApplicantEmailAddress	UltimoString	RESAPPLICANTEMAILADDRESS	80	true
ApplicantPhone	UltimoString	RESAPPLICANTPHONE	25	true
ApplicantToExchange	Boolean	RESAPPLICANTTOEXCHANGE		false	1
Context	Context	RESCONTEXT		false
CostCenter	CostCenter	RESCCRID		true
CostType	CostType	RESCSTTID		true
Customer	Customer	RESCUSID		true
DataProvider	UltimoString	RESDATAPROVIDER	50	true
Department	Department	RESDEPID		true
Description	UltimoString	RESDESCR	200	true
ExchangeChangeKey	UltimoString	RESEXCHANGECHANGEKEY	8	true
ExchangeWarnings	UltimoString	RESEXCHANGEWARNINGS		true
Exported	Boolean	RESEXPORTED		false
ExternalId	UltimoString	RESEXTERNALID	250	true
ExternalStatus	UltimoString	RESEXTERNALSTATUS	50	true
NextReservation	Reservation	RESNEXTRESID		true
Occurrences	List[ReservationOccurrence]	RESOCRESID		false
Pattern	TimeslotPattern	RESPATTERN		true
Project	Project	RESPRJID		true
ProviderMutationDate	DateTime?	RESPROVIDERMUTDATE		true
RecordChangeDate	DateTime?	RESRECCHANGEDATE		true
RecordCreateDate	DateTime?	RESRECCREATEDATE		true	SYSDATETIME
RejectText	UltimoString	RESREJECTTEXT		true
ReservationType	ReservationType	RESRESTID		true
Site	Site	RESSITID		true
Status	Status	RESRECSTATUS		false	1
StatusCreatedDate	DateTime?	RESCREATEDATE		true	SYSDATETIME
StatusCreatedEmployee	Employee	RESCREATEEMPID		true	USERID
StatusRejectedEmployee	Employee	RESREJEMPID		true
StatusRequestedDate	DateTime?	RESREQDATE		true
StatusRequestedEmployee	Employee	RESREQEMPID		true
SystemCompany	Company	RESCOMPID		false
TariffGroup	TariffGroup	RESTRFGID		true
TransferNextTime	Boolean	RESTRANSFERNEXTTIME		false	0
WorkOrder	WorkOrder	RESWOID		true

Brondatabewerken

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