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

Department

Type: Entity Properties: 61 Contexts: 2 Statussen: 2

Zie ook het handgeschreven artikel: department

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

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString DEPID 11 false
AddressLine1 UltimoString DEPADDRESSLINE1 100 true
AddressLine2 UltimoString DEPADDRESSLINE2 100 true
CadReportColor UltimoString DEPCADREPORTCOLOR 6 true
CadReportPattern CadReportPattern DEPCRPTPID true
CadReportPatternAngle Int32 DEPCADREPORTPATTERNANGLE false 0
CadReportPatternScale Decimal DEPCADREPORTPATTERNSCALE false 0
ChildDepartments List[Department] DEPPARTOFDEPID true
City UltimoString DEPCITY 40 true
Comment UltimoString DEPCMNT1 71 true
Context Context DEPCONTEXT false 1
CostCenter CostCenter DEPCCRID true
CostCurrentYear CompanyMoney DEPCOSTBY false 0
CostLastYear CompanyMoney DEPCOSTLY false 0
Country Country DEPCNTRID true DefaultCountryId
DataProvider UltimoString DEPDATAPROVIDER 50 true
Date Date? DEPDATE true
DebtorNumber UltimoString DEPDEBTORNR 9 true
DefaultPrinter Printer DEPPRTID true
Description UltimoString DEPDESCR 200 true
EmailAddress UltimoString DEPEMAILADDRESS 100 true
Employee Employee DEPEMPID true
Exported Boolean DEPEXPORTED false
ExternalId UltimoString DEPEXTERNALID 50 true
ExternalStatus UltimoString DEPEXTERNALSTATUS 50 true
Extra1 Int16 DEPEXTRA1 false
Extra2 Int32 DEPEXTRA2 false
Extra3 Int32 DEPEXTRA3 false
Extra4 UltimoString DEPEXTRA4 5 true
Extra5 UltimoString DEPEXTRA5 5 true
GroupRecordAuthorizations List[GroupRecordAuthorization] SGRADEPID true
Invest CompanyMoney DEPINVEST false 0
Invoice UltimoString DEPINVOICE 2 true
InvoiceOutPerServiceContract Boolean DEPINVOPERSVC false 1
Jobs List[Job] JOBDEPID true
LedgerCode1 UltimoString DEPLGCODE1 11 true
LedgerCode2 UltimoString DEPLGCODE2 11 true
LedgerCode3 UltimoString DEPLGCODE3 11 true
LedgerCode4 UltimoString DEPLGCODE4 11 true
LedgerCode5 UltimoString DEPLGCODE5 11 true
Location UltimoString DEPLOCATION 27 true
LongTermAsset LongTermAsset DEPLTAID true
LowestLevelForExport Boolean DEPLOWESTLEVELFOREXPORT false 0
PartOfDepartment Department DEPPARTOFDEPID true
ProductDossiers List[ProductDossier] PRDDDEPID true
ProviderMutationDate DateTime? DEPPROVIDERMUTDATE true
ProvinceStateRegion UltimoString DEPPROVINCESTATEREGION 40 true
RecordChangeDate DateTime? DEPRECCHANGEDATE true
RecordCreateDate DateTime? DEPRECCREATEDATE true SYSDATETIME
Replace Decimal DEPREPLACE false
SafetyDossiers List[SafetyDossier] SAFDDEPID true
Site Site DEPSITID true
Status Status DEPRECSTATUS false
SystemCompany Company DEPCOMPID false
TariffGroup TariffGroup DEPTRFGID true
Text UltimoString DEPTEXT true
TopOfDepartmentId Department DEPTOPOFDEPID true
TotalCost CompanyMoney DEPMAINTTOT false 0
TransferNextTime Boolean DEPTRANSFERNEXTTIME false
UserRecordAuthorizations List[UserRecordAuthorization] SUSERADEPID true
ZipCode UltimoString DEPZIPCODE 10 true

Brondatabewerken