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

Document

Type: Entity Properties: 48 Contexts: 10 Statussen: 5

Zie ook het handgeschreven artikel: document

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

Contextsbewerken

0: Standaard (DocumentContext.None)
1: Standaard (DocumentContext.Standard)
2: CAD (DocumentContext.Cad)
4: IT (DocumentContext.IT)
8: Verhuuradministratie (DocumentContext.Rental)
16: Inkoop (DocumentContext.Purchase)
32: Infra (DocumentContext.Infra)
64: Getuigschrift (DocumentContext.Certificate)
128: Communicatie (DocumentContext.Communication)
256: Tekstveldbijlage (DocumentContext.TextFieldAttachment)

Statussenbewerken

-1: Trash (DocumentStatus.Trash)
0: None (DocumentStatus.None)
1: Concept (DocumentStatus.Concept)
32: Actief (DocumentStatus.Active)
256: Vervallen (DocumentStatus.Expired)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	DOCID	11	false
_DOCAI	UltimoString	_DOCAINR	50	true
CadDefaultLayout	UltimoString	DOCCADDEFAULTLAYOUT	50	true
CadImportProfile	CadImportProfile	DOCCIMPID		true
CadImportRuns	List[CadImportRun]	CIMRDOCID		true
Context	Context	DOCCONTEXT		false	1
CreateDate	DateTime?	DOCCREATEDATE		true	SYSDATETIME
CreateEmployee	Employee	DOCCREATEEMPID		true	USERID
DataProvider	UltimoString	DOCDATAPROVIDER	50	true
Description	UltimoString	DOCDESCR	200	true
DocumentType	DocumentType	DOCDOCTID		true
Exported	Boolean	DOCEXPORTED		false
ExternalId	UltimoString	DOCEXTERNALID	50	true
ExternalStatus	UltimoString	DOCEXTERNALSTATUS	50	true
Extra1	Int32	DOCEXTRA1		false
Extra2	Int32	DOCEXTRA2		false
Extra3	Int32	DOCEXTRA3		false
Extra4	UltimoString	DOCEXTRA4	5	true
Extra5	UltimoString	DOCEXTRA5	5	true
Extra6	UltimoString	DOCEXTRA6	5	true
Extra7	UltimoString	DOCEXTRA7	5	true
FileMissing	Boolean	DOCFILEMISSING		false	0
FileName	UltimoString	DOCFILENAME	255	true
FileSystemPath	FileSystemPath	DOCFSPID		true
Language	Language	DOCLNGID		true
Location	UltimoString	DOCLOCATION	81	true
ManageEmployee	Employee	DOCMANAGEMPID		true
Manufacturer	Vendor	DOCMANUFVDRID		true
ManufacturerDescription	UltimoString	DOCMANUFACTURER	41	true
ModifyDate	DateTime?	DOCMODIFYDATE		true
ProductCode	UltimoString	DOCPRODUCTCODE	81	true
ProviderMutationDate	DateTime?	DOCPROVIDERMUTDATE		true
RecordChangeDate	DateTime?	DOCRECCHANGEDATE		true
RecordCreateDate	DateTime?	DOCRECCREATEDATE		true	SYSDATETIME
Site	Site	DOCSITID		true
Status	Status	DOCRECSTATUS		false	1
StatusActivatedDate	DateTime?	DOCACTIVATEDDATE		true
StatusActivatedEmployee	Employee	DOCACTIVATEDEMPID		true
StatusConceptDate	DateTime?	DOCCONCEPTDATE		true	SYSDATETIME
StatusConceptEmployee	Employee	DOCCONCEPTEMPID		true	USERID
StatusExpiredDate	DateTime?	DOCEXPIREDDATE		true
StatusExpiredEmployee	Employee	DOCEXPIREDEMPID		true
Text	UltimoString	DOCTEXT		true
TransferNextTime	Boolean	DOCTRANSFERNEXTTIME		false	0
Vendor	Vendor	DOCVDRID		true
Version	UltimoString	DOCVERSION	10	true
XmlLayer	UltimoString	DOCLAYERXML		true
XrefDocument	Document	DOCXREFDOCID		true

Brondatabewerken

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