Categorie: entities
Bijgewerkt: 2026-05-27
company multi-company administratie stamgegevens valuta
Company (Bedrijf / administratie)
Company is de centrale administratie-entiteit in Ultimo: vrijwel alle transactionele en stamgegevens (equipment, jobs, medewerkers, inkoop, reserveringen, etc.) zijn aan een Company gekoppeld via SystemCompany. In een multi-company omgeving kunnen meerdere bedrijfseenheden of afdelingen als aparte Company worden ingericht, waarbij Currency en indexeringspercentages per administratie worden vastgelegd. De Company-structuur is de basis voor datascheiding, autorisatie en consolidatie in rapportages.
Entiteitsnaam: Company
Databasetabel: Company
Primaire sleutel: COMPID (UltimoString(6))
Contextsbewerken
| Value | Naam | Beschrijving |
|---|---|---|
| 0 | CompanyContext.None | Standaard |
Statussenbewerken
| Value | Naam | Beschrijving |
|---|---|---|
| -1 | CompanyStatus.Trash | Trash |
| 0 | CompanyStatus.None | None |
Belangrijkste propertiesbewerken
De entiteit heeft in totaal 16 properties. Hieronder de belangrijkste; gebruik
lookup_entity("Company")voor de volledige lijst.
| Property | Type | Kolom | Nullable | Default | Omschrijving |
|---|---|---|---|---|---|
| Id | UltimoString(6) | COMPID | Nee | Uniek ID van de Company (maximaal 6 tekens) | |
| Description | UltimoString(50) | COMPDESCR | Ja | Naam / omschrijving van de administratie | |
| Currency | Currency | COMPCURID | Nee | Standaardvaluta voor deze administratie | |
| ProviderMutationDate | DateTime? | COMPPROVIDERMUTDATE | Ja | Laatste mutatiedatum vanuit een externe data-provider | |
| Context | Context | COMPCONTEXT | Nee | Context van de Company (alleen None beschikbaar) | |
| DataProvider | UltimoString(50) | COMPDATAPROVIDER | Ja | Naam van de externe data-provider die dit record beheert | |
| ExternalId | UltimoString(50) | COMPEXTERNALID | Ja | Extern sleutelveld voor koppeling met bronsysteem | |
| ExternalStatus | UltimoString(50) | COMPEXTERNALSTATUS | Ja | Externe statuswaarde vanuit bronsysteem | |
| IndexLongTermAssetPercentage | Decimal | COMPINDEXLONGTERMASSETPERCENTAGE | Nee | Indexeringspercentage voor langetermijnactiva (LTAP) | |
| IndexPercentage | Decimal | COMPINDEXPERCENTAGE | Nee | Algemeen indexeringspercentage voor vervangingsplanning | |
| IndexReplacementPlanning | Decimal | COMPINDEXREPLACEMENTPLANNING | Nee | Indexeringspercentage specifiek voor vervangingsplanning | |
| StartLtapSpaceYearPlan | Int16 | COMPSTARTLTAPSPACEYEARPLAN | Nee | SystemYear | Startjaar voor LTAP-ruimtejaarplan (default: systeemjaar) |
| StartSpacePlanYear | Int16 | COMPSTARTSPACEPLANYEAR | Nee | SystemYear | Startjaar voor ruimtejaarplan (default: systeemjaar) |
| Status | Status | COMPRECSTATUS | Nee | Recordstatus (None of Trash) | |
| TransferNextTime | Boolean | COMPTRANSFERNEXTTIME | Nee | 0 | Vlag die aangeeft dat dit record bij de volgende overdracht meegenomen moet worden |
Relaties met andere entiteitenbewerken
| Property | Verwijst naar | Nullable |
|---|---|---|
| Currency | Currency | Nee |
Onderliggende / verwijzende entiteiten (1-op-veel)bewerken
De volgende entiteiten verwijzen naar Company:
| Entiteit | Via property |
|---|---|
| AbcDetermination | SystemCompany |
| Account | SystemCompany |
| Activity | SystemCompany |
| ApiKey | CompanyForUser |
| Approval | SystemCompany |
| ApprovalLevel | SystemCompany |
| ApprovalLevelEmployee | SystemCompany |
| ApprovalLevelRule | SystemCompany |
| Article | SystemCompany |
| ArticleHierarchy | SystemCompany |
| ArticleReplace | SystemCompany |
| ArticleShoppingCart | SystemCompany |
| ArticleSite | SystemCompany |
| ArticleSiteVendor | SystemCompany |
| ArticleWarehouse | SystemCompany |
| ArticleWarehouseLocation | SystemCompany |
| Assortment | SystemCompany |
| AssortmentCostCenter | SystemCompany |
| AssortmentDepartment | SystemCompany |
| AssortmentReservableObject | SystemCompany |
| AssortmentReservableObjectType | SystemCompany |
| Batch | SystemCompany |
| BatchWarehouseLocation | SystemCompany |
| BudgetPeriod | SystemCompany |
| Building | SystemCompany |
| BuildingFloor | SystemCompany |
| BuildingFloorSpaceTypeSum | SystemCompany |
| BuildingPart | SystemCompany |
| BuildingPartSpaceTypeSum | SystemCompany |
| BuildingSpaceTypeSum | SystemCompany |
| CadImportLine | SystemCompany |
| CadImportLineProperty | SystemCompany |
| CadImportLineRule | SystemCompany |
| CadImportRun | SystemCompany |
| CadImportRunError | SystemCompany |
| CausalFactor | SystemCompany |
| Change | SystemCompany |
| CompanyUser | SystemCompany |
| Competence | SystemCompany |
| ConditionFlawPresent | SystemCompany |
| ConditionMeasurement | SystemCompany |
| ConditionRiskPresent | SystemCompany |
| ContractLine | SystemCompany |
| ContractLineCost | SystemCompany |
| ContractLineCostMutation | SystemCompany |
| ContractLineCostMutationCreate | SystemCompany |
| ContractLineCostMutationCreateDetail | SystemCompany |
| ContractLineType | SystemCompany |
| ContractPeriod | SystemCompany |
| Cost | SystemCompany |
| CostCenter | SystemCompany |
| CraftsmanHourCategory | SystemCompany |
| Customer | SystemCompany |
| Cylinder | SystemCompany |
| CylinderKey | SystemCompany |
| Decomposition | SystemCompany |
| Department | SystemCompany |
| DepartmentHierarchy | SystemCompany |
| DepreciationMethod | SystemCompany |
| DocumentCadImportProfile | SystemCompany |
| DutyWorkOrderType | SystemCompany |
| SystemCompany | |
| EmailAttachment | SystemCompany |
| EmailRecipient | SystemCompany |
| EmailServerAccount | SystemCompany |
| EmailSubject | SystemCompany |
| Employee | SystemCompany |
| EmployeeConfirmationRole | SystemCompany |
| EmployeeLabour | SystemCompany |
| EmployeeLabourDateline | SystemCompany |
| EmployeeLabourLine | SystemCompany |
| EmployeeLabourPeriod | SystemCompany |
| EmployeeProcessFunction | SystemCompany |
| EmployeeWeek | SystemCompany |
| EmployeeWorkSchedule | SystemCompany |
| EnergyReportData | SystemCompany |
| Equipment | SystemCompany |
| EquipmentCostYear | SystemCompany |
| EquipmentFailType | SystemCompany |
| EquipmentHierarchy | SystemCompany |
| EquipmentJob | SystemCompany |
| EquipmentMeasurementPoint | SystemCompany |
| EquipmentMeasurementPointAlert | SystemCompany |
| EquipmentMeasurementPointValue | SystemCompany |
| EquipmentMove | SystemCompany |
| EquipmentMoveLine | SystemCompany |
| EquipmentMoveReceipt | SystemCompany |
| EquipmentMoveReceiptLine | SystemCompany |
| EquipmentPort | SystemCompany |
| EquipmentProcessFunctionMutation | SystemCompany |
| EquipmentSafetyDossier | SystemCompany |
| EquipmentServiceContract | SystemCompany |
| EquipmentSparePart | SystemCompany |
| EquipmentSubStatus | SystemCompany |
| EquipmentTypeActivity | SystemCompany |
| EquipmentTypeHierarchy | SystemCompany |
| EquipmentTypeMaterial | SystemCompany |
| EquipmentTypeProductDossier | SystemCompany |
| EquipmentTypeSparePart | SystemCompany |
| ExportConnector | CompanyForUser |
| GeoObject | SystemCompany |
| HourTariffCategory | SystemCompany |
| IPAddress | SystemCompany |
| ITRelease | SystemCompany |
| ImportConnector | CompanyForUser |
| Incident | SystemCompany |
| InspectionLine | SystemCompany |
| InspectionPlanLineLink | SystemCompany |
| InternalCharge | SystemCompany |
| InternalChargeCreate | SystemCompany |
| InternalChargeCreateCostCenter | SystemCompany |
| InternalChargeCreateCustomer | SystemCompany |
| InternalChargeCreateDepartment | SystemCompany |
| InternalChargeCreateProject | SystemCompany |
| InternalChargeLine | SystemCompany |
| Invoice | SystemCompany |
| InvoiceLine | SystemCompany |
| InvoicePeriod | SystemCompany |
| Job | SystemCompany |
| JobConditionFlawPresent | SystemCompany |
| JobExternal | SystemCompany |
| JobInspectionLine | SystemCompany |
| JobInternalChargeInstallment | SystemCompany |
| JobJobPlan | SystemCompany |
| JobMaterial | SystemCompany |
| JobMoveLine | SystemCompany |
| JobNotification | SystemCompany |
| JobOperationLoss | SystemCompany |
| JobPlanExternal | SystemCompany |
| JobProgressStatusHistory | SystemCompany |
| JobResource | SystemCompany |
| JobSchedulePart | SystemCompany |
| JobSuccessors | SystemCompany |
| JobTask | SystemCompany |
| JobTool | SystemCompany |
| JobWeek | SystemCompany |
| JobWeekLabour | SystemCompany |
| Journal | SystemCompany |
| KanbanBoard | SystemCompany |
| KnowledgeDomain | SystemCompany |
| KnowledgeTopic | SystemCompany |
| LDAPImportConnector | DefaultCompany |
| LandRegistry | SystemCompany |
| LendableObject | SystemCompany |
| LendableObjectMutation | SystemCompany |
| LendableObjectMutationLine | SystemCompany |
| Location | SystemCompany |
| LockoutTagoutPlan | SystemCompany |
| LockoutTagoutPlanLine | SystemCompany |
| LockoutTagoutRequest | SystemCompany |
| LockoutTagoutRequestLine | SystemCompany |
| LongTermAsset | SystemCompany |
| LongTermAssetAvailabilityEstimates | SystemCompany |
| LongTermAssetCostEstimates | SystemCompany |
| MaintenanceClassification | SystemCompany |
| MaintenancePart | SystemCompany |
| MaintenancePartActivity | SystemCompany |
| MaintenancePartActivityExtra | SystemCompany |
| Meeting | SystemCompany |
| MeetingTopic | SystemCompany |
| MemorandumBook | SystemCompany |
| MemorandumBookLine | SystemCompany |
| MultijobTemplate | SystemCompany |
| MultijobTemplateLine | SystemCompany |
| MultijobTemplateLineSuccessor | SystemCompany |
| Notes | SystemCompany |
| ObjectBatch | SystemCompany |
| ObjectChange | SystemCompany |
| ObjectCompetence | SystemCompany |
| ObjectConfirmation | SystemCompany |
| ObjectConfirmationRole | SystemCompany |
| ObjectConsideration | SystemCompany |
| ObjectContact | SystemCompany |
| ObjectDamage | SystemCompany |
| ObjectDepreciationTax | SystemCompany |
| ObjectDowntime | SystemCompany |
| ObjectImportedPreventiveMaintenanceTask | SystemCompany |
| ObjectIncident | SystemCompany |
| ObjectInspectionLine | SystemCompany |
| ObjectInspectionLineLink | SystemCompany |
| ObjectInspectionPlan | SystemCompany |
| ObjectLandRegistry | SystemCompany |
| ObjectProgressStatus | SystemCompany |
| ObjectProgressStatusHistory | SystemCompany |
| ObjectProject | SystemCompany |
| ObjectRealEstateValueDecision | SystemCompany |
| ObjectRiskAnalysis | SystemCompany |
| ObjectRiskAnalysisAspect | SystemCompany |
| ObjectRiskFactorScore | SystemCompany |
| ObjectServiceContract | SystemCompany |
| ObjectServiceDeskReportType | SystemCompany |
| PaymentCard | SystemCompany |
| PaymentCardIssue | SystemCompany |
| PaymentTransaction | SystemCompany |
| PaymentTransactionAbnormality | SystemCompany |
| PaymentTransactionRun | SystemCompany |
| Permit | SystemCompany |
| PermitTaskRiskAnalysis | SystemCompany |
| PickList | SystemCompany |
| PickListLine | SystemCompany |
| PickListRun | SystemCompany |
| PmJob | SystemCompany |
| PmJobExternal | SystemCompany |
| PmJobInspectionLine | SystemCompany |
| PmJobJobPlan | SystemCompany |
| PmJobMaterial | SystemCompany |
| PmJobOperationLoss | SystemCompany |
| PmJobPurchaseRequestLine | SystemCompany |
| PmJobResource | SystemCompany |
| PmJobTool | SystemCompany |
| PmSchedule | SystemCompany |
| PmScheduleAoc | SystemCompany |
| PmScheduleCostCenter | SystemCompany |
| PmScheduleCraftsman | SystemCompany |
| PmScheduleDepartment | SystemCompany |
| PmScheduleEquipment | SystemCompany |
| PmScheduleEquipmentType | SystemCompany |
| PmSchedulePmWorkOrder | SystemCompany |
| PmScheduleProcessFunction | SystemCompany |
| PmScheduleSkillCategory | SystemCompany |
| PmScheduleSpace | SystemCompany |
| PmScheduleWorkOrderType | SystemCompany |
| PmWeekScheme | SystemCompany |
| PmWorkOrder | SystemCompany |
| PriceMutation | SystemCompany |
| PriceMutationLine | SystemCompany |
| ProcessFunction | SystemCompany |
| ProcessFunctionCostYear | SystemCompany |
| ProcessFunctionFailType | SystemCompany |
| ProcessFunctionHierarchy | SystemCompany |
| ProcessFunctionJob | SystemCompany |
| ProcessFunctionMeasurementPoint | SystemCompany |
| ProcessFunctionMeasurementPointValue | SystemCompany |
| ProcessFunctionOperation | SystemCompany |
| ProcessFunctionServiceContract | SystemCompany |
| ProcessFunctionSparePart | SystemCompany |
| ProductDossier | SystemCompany |
| ProductDossierFinance | SystemCompany |
| Project | SystemCompany |
| Purchase | SystemCompany |
| PurchaseAdvice | SystemCompany |
| PurchaseAdviceArticleGroupLine | SystemCompany |
| PurchaseAdviceArticleLine | SystemCompany |
| PurchaseAdviceLine | SystemCompany |
| PurchaseAdviceVendorLine | SystemCompany |
| PurchaseLine | SystemCompany |
| PurchaseRequest | SystemCompany |
| PurchaseRequestLine | SystemCompany |
| RealEstateValueDecision | SystemCompany |
| Receipt | SystemCompany |
| ReceiptLine | SystemCompany |
| ReceivedEmail | SystemCompany |
| ReceivedEmailAttachment | SystemCompany |
| ReceivedEmailRecipient | SystemCompany |
| Reminder | SystemCompany |
| ReminderEmployee | SystemCompany |
| ReminderSubject | SystemCompany |
| RentableObjectPart | SystemCompany |
| RentableRealEstateContractLine | SystemCompany |
| RentableRealEstateContractLineCostMutation | SystemCompany |
| RentableRealEstateTaxAdministrationLine | SystemCompany |
| RentableRealEstateTaxAdministrationRun | SystemCompany |
| RequestForQuotation | SystemCompany |
| ReservableObject | SystemCompany |
| ReservableObjectTariffGroup | SystemCompany |
| ReservableObjectType | SystemCompany |
| ReservableObjectTypeSpace | SystemCompany |
| ReservableObjectTypeTariffGroup | SystemCompany |
| Reservation | SystemCompany |
| ReservationLine | SystemCompany |
| ReservationOccurrence | SystemCompany |
| RootCauseAnalysis | SystemCompany |
| RosterGroupEntry | SystemCompany |
| SCIMImportConnector | Company |
| SafetyDossier | SystemCompany |
| SafetyDossierReview | SystemCompany |
| SafetyDossierReviewer | SystemCompany |
| SafetyIncident | SystemCompany |
| SafetyIncidentFailType | SystemCompany |
| ServiceContract | SystemCompany |
| ServiceContractLine | SystemCompany |
| ServiceContractNotification | SystemCompany |
| ServiceContractServiceLevel | SystemCompany |
| ServiceDefinition | SystemCompany |
| ServiceDeskReportType | SystemCompany |
| ServiceDeskReportTypeJobPlan | SystemCompany |
| ServiceLevel | SystemCompany |
| ServiceServiceContract | SystemCompany |
| ShiftLog | SystemCompany |
| ShiftLogLine | SystemCompany |
| ShiftLogbook | SystemCompany |
| ShiftLogbookWorkPeriod | SystemCompany |
| Site | SystemCompany |
| SkillCategory | SystemCompany |
| SkillCategoryCapacity | SystemCompany |
| SoftwareInstallation | SystemCompany |
| SoftwareLicense | SystemCompany |
| Space | SystemCompany |
| SpaceCylinder | SystemCompany |
| SpaceFinishing | SystemCompany |
| SpaceHierarchy | SystemCompany |
| SpaceInventory | SystemCompany |
| SpaceMaintenance | SystemCompany |
| SpaceMaintenanceActivity | SystemCompany |
| SpaceMaintenanceActivityMoment | SystemCompany |
| SpaceSetup | SystemCompany |
| StandardArticleWarehouseSkillCategory | SystemCompany |
| StateAgenda | SystemCompany |
| StateTimeslot | SystemCompany |
| StockCount | SystemCompany |
| StockCountLine | SystemCompany |
| Task | SystemCompany |
| TaskDefinition | SystemCompany |
| TaskRiskAnalysis | SystemCompany |
| TaskRiskAnalysisLine | SystemCompany |
| TimeReservation | SystemCompany |
| ToolsPrice | SystemCompany |
| Visitor | SystemCompany |
| WallOutlet | SystemCompany |
| Warehouse | SystemCompany |
| WarehouseLocation | SystemCompany |
| WarehouseServeOut | SystemCompany |
| WarehouseServeOutline | SystemCompany |
| WorkOrder | SystemCompany |
| WorkOrderBudgetSupply | SystemCompany |
| WorkOrderSchedule | SystemCompany |
| WorkOrderScheduleDepartment | SystemCompany |
| WorkOrderScheduleJob | SystemCompany |
| WorkOrderScheduleProgressStatus | SystemCompany |
| WorkOrderScheduleWorkOrderType | SystemCompany |
| YearPlan | SystemCompany |
| YearPlanScenario | SystemCompany |
| YearPlanScenarioLine | SystemCompany |
| YearPlanScenarioLineMaintenanceMoment | SystemCompany |
Tips voor consultantsbewerken
- Multi-company basis: Bijna elke entiteit bevat een
SystemCompany-veld. In queries en workflows is dit de isolatielaag tussen administraties. Vergeet bij maatwerk nooit te filteren op company. - Valuta per administratie: De
Currencyop Company is bepalend voor de weergave van bedragen in die administratie. Zorg dat deze overeenkomt met de financiële boekhouding als Ultimo aan een ERP is gekoppeld. - Indexering: De drie indexvelden (
IndexPercentage,IndexLongTermAssetPercentage,IndexReplacementPlanning) worden gebruikt in het jaarplan en de vervangingsplanning; pas ze jaarlijks aan op basis van inflatie of sectorindexen. - Trigger bij UPDATE: Tabel
Companyheeft een AFTER UPDATE-trigger (TRGU_Company). Directe SQL-updates kunnen onverwacht gedrag geven; gebruik altijd de applicatielaag of een UCT-workflow. - Beperkte properties: Met slechts 16 properties is Company een smal maar cruciaal stamgegeven. De echte configuratie per administratie zit grotendeels in DomainSettings (globaal, één record).
- SCIM/LDAP-koppeling:
SCIMImportConnectorenLDAPImportConnectorverwijzen respectievelijk viaCompanyenDefaultCompanynaar dit record — relevant bij SSO-inrichting.
Database Detailsbewerken
De tabel dba.Company bevat 16 kolommen, 1 eigen trigger(s), 0 externe triggers en 1 foreign keys.
Belangrijke defaultsbewerken
| Kolom | Default |
|---|---|
CompContext |
0 |
CompRecStatus |
0 |
CompStartLtapSpaceYearPlan |
0 |
CompStartSpacePlanYear |
0 |
CompTransferNextTime |
0 |
Brondatabewerken
Let op: De wiki-samenvatting hierboven toont een curated subset van properties en praktische consultant-tips. Voor ground truth (exacte kolomnamen, alle properties, defaults, triggers) gebruik de onderstaande tools.
- Entity-definitie —
lookup_entity("Company")· reference/entities/Company Alle properties, contexts en statussen. Bron:Entities.xml. - DB-schema —
lookup_table_schema("Company")· reference/tables/Company Alle DB-kolommen, triggers, computed columns en defaults. Bron:database-schema.json. - Gerelateerde workflows —
find_workflows("", entity="Company")Alle Before/After Save events en andere workflow-ActionFields. Bron:workflows.xml.
Zie ookbewerken
- domain-settings - Globale domeininstellingen die gelden voor de gehele Ultimo-omgeving
- currency - Valuta gekoppeld aan de administratie
- site - Sites vallen onder een Company
- cost-center - Kostenplaatsen gekoppeld aan een Company
- employee - Medewerkers gekoppeld aan een Company
- budget-period - Budgetperioden per Company
- year-plan - Jaarplan per Company