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

Equipment

Type: Entity Properties: 234 Contexts: 20 Statussen: 12

Zie ook het handgeschreven artikel: equipment

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

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString EQMID 14 false
_AIASS UltimoString _EQMAIASS 50 true
_EQMRep UltimoString _EQMREPONSE true
Aoc Aoc EQMAOCID true
Article Article EQMARTID true
Batch Batch EQMBTCHID true
Bodywork Bodywork EQMBDWID true
Building Building EQMBLDID true
BuildingFloor BuildingFloor EQMBLDFBLDID, EQMBLDFBLDPID, EQMBLDFID true , ,
BuildingPart BuildingPart EQMBLDPBLDID, EQMBLDPID true ,
BulkJobLines List[JobInspectionLine] JOBIEQMID true
CadDocument Document EQMCADDOCID true
CadHandle UInt64 EQMCADHANDLE false 0
CadHandleDocument Document EQMCADHANDLEDOCID true
Code UltimoString EQMCODE 12 true
Colour Colour EQMCLRID true
ConcessionPolicy Boolean EQMCONCESSIONPOLICY false 0
ConditionFlawPresentParts List[ConditionFlawPresent] CONFLPPARTOFEQMID true
ConditionFlawPresents List[ConditionFlawPresent] CONFLPEQMID true
ConditionMeasurements List[ConditionMeasurement] CONMEQMID true
ConfigurationItems List[SoftwareInstallation] SOICONFIGURATIONITEMEQMID true
Context Context EQMCONTEXT false 1
CopyFromEquipment Equipment EQMCOPYFROMEQMID true
CostCenter CostCenter EQMCCRID true
CostCurrentYear CompanyMoney EQMMAINTYEAR false 0
CostLastYear CompanyMoney EQMCOSTLY false 0
Criticality RiskClass EQMRISCIDCRITICALITY true
CriticalityRemarkText UltimoString EQMCRITICALITYREMARKTEXT true
CriticalityScore Decimal EQMSCORECRITICAL false 0
CurrentAppearanceMaintenanceState MaintenanceState EQMCURRAPPEARANCEMNTSID true
CurrentAppearanceMaintenanceStateDate Date? EQMCURRAPPEARANCEMNTSDATE true
CurrentMaintenanceState MaintenanceState EQMCURRENTMNTSID true
CurrentMaintenanceStateDate Date? EQMCURRENTMNTSDATE true
Customer Customer EQMCUSID true
DataProvider UltimoString EQMDATAPROVIDER 50 true
Decomposition Decomposition EQMDECID true
Department Department EQMDEPID true
DepreciationActivated Boolean EQMDEPRACTIVATED false
DepreciationDate Date? EQMDEPRECIATIONDATE true
DepreciationLife Int16 EQMDEPRLIFE false
DepreciationMethodEco DepreciationMethod EQMECODEPRMID true
DepreciationMethodTax DepreciationMethod EQMTAXDEPRMID true
DepreciationStartDate Date? EQMDEPRSTARTDATE true
DepreciationTaxRecords List[ObjectDepreciationTax] OBJDTEQMID true
Description UltimoString EQMDESCR 200 true
DeviceName UltimoString EQMDEVICENAME 100 true
DrawingNumber UltimoString EQMDRAWINGNR 20 true
EnergyMeterType EnergyMeterType EQMENERGYMETERTYPE false 0
EquipmentCostYear EquipmentCostYear EQMCYEQMID false
EquipmentHierarchy List[EquipmentHierarchy] EQMHPARTOFEQMID false
EquipmentMeasurementPoints List[EquipmentMeasurementPoint] EQMMSPEQMID false
EquipmentSafetyDossiers List[EquipmentSafetyDossier] EQMSDEQMID false
EquipmentServiceContracts List[EquipmentServiceContract] EQMSCEQMID false
EquipmentSubStatus EquipmentSubStatus EQMEQMSID true
EquipmentType EquipmentType EQMEQMTID true
ExchangePart Boolean EQMEXCHANGEPART false
ExchangePartLocation ExchangePartLocation EQMEXCHANGEPARTLOC true
ExchangePartStatus ExchangePartStatus EQMEXCHANGEPARTSTATUS true U
ExchangePartVendor Vendor EQMEXCHANGEPARTVDRID true
Exported Boolean EQMEXPORTED false
ExternalId UltimoString EQMEXTERNALID 50 true
ExternalStatus UltimoString EQMEXTERNALSTATUS 50 true
Extra1 Int16 EQMEXTRA1 false
Extra2 Int32 EQMEXTRA2 false
Extra3 Int32 EQMEXTRA3 false
Extra4 Int32 EQMEXTRA4 false
Extra5 Int32 EQMEXTRA5 false
Extra6 UltimoString EQMEXTRA6 5 true
Extra7 UltimoString EQMEXTRA7 5 true
Extra8 UltimoString EQMEXTRA8 5 true
Extra9 UltimoString EQMEXTRA9 5 true
FDARegulated Boolean EQMFDAREGULATED false 0
Finishing Finishing EQMFINID true
FinishingType FinishingType EQMFINTFINID, EQMFINTID true ,
Fuel Fuel EQMFULID true
FuelTankCapacity Decimal EQMFUELTANKCAPACITY false 0
Gearing Gearing EQMGEARID true
GeocodeX Decimal EQMGEOCODEX false
GeocodeY Decimal EQMGEOCODEY false
GeoObject GeoObject EQMGEOID true
GroupPMEmployee Employee EQMGROUPPMEMPID true
GroupPMSkillCategory SkillCategory EQMGROUPPMSKCID true
ImageFile UltimoString EQMIMAGEFILE true
ImageFile2 UltimoString EQMIMAGEFILE2 true
ImageFile3 UltimoString EQMIMAGEFILE3 true
ImageFile4 UltimoString EQMIMAGEFILE4 true
Impact Impact EQMIMPID true
ImportedCriticality Int16 EQMIMPORTEDCRITICALITY false 0
IncludedObject Boolean EQMINCLUDEDOBJECT false 0
IndexedReplacementCost CompanyMoney EQMINDEXEDREPLCOST false 0
IndicatorValue Decimal EQMSTATE false
IndicatorValueLastRecordingDate DateTime? EQMDATESTATE true
IndividualPM Boolean EQMNOGROUPPM false 1
InspectionLines List[InspectionLine] ISLEQMID true
InstallDate Date? EQMINSTDATE true
InstalledByEmployee Employee EQMINSTEMPID true
IPAddress UltimoString EQMIPADDRESS 22 true
IsBulk Boolean EQMISBULK false 0
IssueDate DateTime? EQMISSUEDATE true
LastEquipmentMove EquipmentMove EQMLASTEQMMID true
LastEquipmentMoveDate DateTime? EQMLASTEQMMDATE true
LastMinuteRiskAssessment InspectionPlan EQMLMRAISPID true
LastPmMaintenanceDate Date? EQMLASTPMMAINTDATE true
LastPmModel PmWorkOrder EQMLASTPMMODEL true
LicenseRequired Boolean EQMLICENSEREQUIRED false 0
Location UltimoString EQMLOCATION 26 true
LocationRef Location EQMLOCID true
LongTermAsset LongTermAsset EQMLTAID true
LowestLevelAssessment Boolean EQMLOWESTLEVELASSESSMENT false 0
LowestLevelForExport Boolean EQMLOWESTLEVELFOREXPORT false 0
MaintenanceClassification MaintenanceClassification EQMMNTCID true
MaintenanceState MaintenanceState EQMMNTSID true
Manufacturer Vendor EQMMANUFID true
ManufactureYear Int32 EQMMANUFYEAR false
Meters List[Equipment] EQMPARTOFMETEREQMID true
Model UltimoString EQMMODEL 50 true
Nen2767P4Compliant Boolean EQMNEN2767P4COMPLIANT false 1
Nen2767P4CompliantInitialized Boolean EQMNEN2767P4COMPLIANTINIT false 0
NextPmMaintenanceDate Date? EQMNEXTPMMAINTDATE true
NextPmMaintenanceJob Job EQMNEXTPMMAINTJOBID true
NextPmModel PmWorkOrder EQMNEXTPMMODEL true
NFCSerialNumber UltimoString EQMNFCSERIALNUMBER 40 true
NoPreventiveMaintenanceNeeded Boolean EQMNOPM false 0
NotQualifiedHumaneUse Boolean EQMNOTQUALIFIEDHUMANEUSE false 0
ObjectFeatures List[ObjectFeature] OBJFEQMID true
ObjectImportedPmTasksToProcess Int32 EQMOBJIMPPMTASKSTOPROCESS false 0
ObjectRiskAnalysis ObjectRiskAnalysis EQMOBJRAID true
Origin Origin EQMORGID true
OriginalVendor Vendor EQMORIGINALVDRID true
OriginEndDate Date? EQMORIGINENDDATE true
OutOfService Date? EQMOUTOFSERVICEDATE true
OwnerEmployee Employee EQMOWNEREMPID true
PartOfEquipment Equipment EQMPARTOFEQMID true
PartOfMeter Equipment EQMPARTOFMETEREQMID true
Parts List[Equipment] EQMPARTOFEQMID true
PmJobs List[PmJob] PMJEQMID true
PmWorkOrders List[PmWorkOrder] PMWEQMID true
PowerSource1 Int16 EQMPOWERSOURCE false
PowerSource2 Int16 EQMPOWERSOURCE2 false
PowerSource3 Int16 EQMPOWERSOURCE3 false
ProcessFunction ProcessFunction EQMPRFID true
ProductDossier ProductDossier EQMPRDDID true
ProductDossierAddedDate DateTime? EQMPRDDOSSIERADDEDDATE true
ProductDossierAddedEmployee Employee EQMPRDDOSSIERADDEDEMPID true
ProductDossierOutbound ProductDossier EQMPRDDOUTBOUNDID true
ProductDossierOutboundDate DateTime? EQMPRODUCTDOSSIEROUTBOUNDDATE true
ProductDossierOutboundEmployee Employee EQMPRDDOUTBOUNDEMPID true
ProductionLine ProductionLine EQMPRODID true
ProductionLossPerHour CompanyMoney EQMPRODUCTIONLOSSPERHOUR false 0
ProgressStatus ProgressStatus EQMPRSID true
ProgressStatusHistories List[ObjectProgressStatusHistory] OBJPRSHEQMID true
ProviderMutationDate DateTime? EQMPROVIDERMUTDATE true
PurchasePrice CompanyMoney EQMPURCHPRICE false 0
RecordChangeDate DateTime? EQMRECCHANGEDATE true
RecordCreateDate DateTime? EQMRECCREATEDATE true SYSDATETIME
RegisterObjectDowntime Boolean EQMREGISTEROBJECTDOWNTIME false 0
ReleaseCondition ReleaseCondition EQMRELCID true
ReleaseDate Date? EQMRELEASEDATE true
ReleaseTillDate Date? EQMRELEASETILLDATE true
RemovalReason UltimoString EQMREMOVALREASON 61 true
RentHourTariff CompanyMoney EQMRENTHOURTARIFF false 0
RentUseEquipmentHourTariff Boolean EQMRENTUSEEQMHOURTARIFF false 0
ReplacementCost CompanyMoney EQMREPLCOST false 0
ReplacementCostDate Date? EQMREPLCOSTDATE true
ReplacementDate Date? EQMREPLDATE true
ReplacementLife Int32 EQMREPLLIFE false
ReplacementYear Int16 EQMREPLYEAR false
Reservable Boolean EQMRESERVABLE false
ReservableObject ReservableObject EQMRESOID true
ResidualValue CompanyMoney EQMRESIDUALVALUE false 0
ReturnDate Date? EQMRETURNDATE true
RiskClass RiskClass EQMRISCID true
RiskOutcome RiskOutcome EQMRISOCID true
RiskScore Decimal EQMRISKSCORE false 0
SecondFuel Fuel EQMSECONDFULID true
SecondFuelTankCapacity Decimal EQMSECONDFUELTANKCAPACITY false 0
SerialNumber UltimoString EQMSERIALNR 40 true
ServiceContract ServiceContract EQMSVCID true
ServiceOnBestEffort Boolean EQMSERVICEONBESTEFFORT false
ServiceVendor Vendor EQMSERVICEVDRID true
Site Site EQMSITID true
SkillCategory SkillCategory EQMSKCID true
SoftwareInstallations List[SoftwareInstallation] SOISOFTWAREEQMID true
SoftwareLicenses List[SoftwareLicense] SOLSOFTWAREEQMID true
Space Space EQMSPCID true
SpareParts List[EquipmentSparePart] EQMSPEQMID false
Status Status EQMRECSTATUS false 1
StatusActiveDate DateTime? EQMACTIVEDATE true
StatusActiveEmployee Employee EQMACTIVEEMPID true
StatusCreatedDate DateTime? EQMSETUPDATE true
StatusCreatedEmployee Employee EQMSETUPEMPID true
StatusMissingDate DateTime? EQMMISSINGDATE true
StatusMissingEmployee Employee EQMMISSINGEMPID true
StatusScrappedDate DateTime? EQMSCRAPPEDDATE true
StatusScrappedEmployee Employee EQMSCRAPPEDEMPID true
StatusToDeleteDate DateTime? EQMREMOVALDATE true
StatusToDeleteEmployee Employee EQMREMOVALEMPID true
StorageLocation UltimoString EQMSTORAGELOCATION 26 true
StorageSpace Space EQMSTORAGESPCID true
SystemCompany Company EQMCOMPID false
TachographInspectionExpirationDate Date? EQMTACHOGRAPHINSPEXPDATE true
Tech1 UltimoString EQMTECH1 12 true
Tech10 UltimoString EQMTECH10 12 true
Tech2 UltimoString EQMTECH2 12 true
Tech3 UltimoString EQMTECH3 12 true
Tech4 UltimoString EQMTECH4 12 true
Tech5 UltimoString EQMTECH5 12 true
Tech6 UltimoString EQMTECH6 12 true
Tech7 UltimoString EQMTECH7 12 true
Tech8 UltimoString EQMTECH8 12 true
Tech9 UltimoString EQMTECH9 12 true
TechnicalDepreciationLife Int16 EQMTECHDEPRLIFE false
Text1 UltimoString EQMTEXT1 true
Text2 UltimoString EQMTEXT2 true
Text3 UltimoString EQMTEXT3 true
ThirdFuel Fuel EQMTHIRDFULID true
ThirdFuelTankCapacity Decimal EQMTHIRDFUELTANKCAPACITY false 0
TopOfEquipmentId Equipment EQMTOPOFEQMID true
TotalCost CompanyMoney EQMMAINTTOTAL false 0
TrackAndTrace Boolean EQMTRACKANDTRACE false 0
TrackAndTraceLastSynchronisation DateTime? EQMTRACKANDTRACELASTSYNCDATE true
TrackAndTraceLocation UltimoString EQMTRACKANDTRACELOCATION true
TransferNextTime Boolean EQMTRANSFERNEXTTIME false
TypeNumber UltimoString EQMTYPENR 40 true
Udi UltimoString EQMUDI 80 true
UdiImageFile UltimoString EQMUDIIMAGEFILE true
Urgency Urgency EQMURGID true
UseSpecificFailTypes Boolean EQMUSESPECIFICFAILTYPES false 0
VehicleInspectionExpirationDate Date? EQMVEHICLEINSPEXPDATE true
Vendor Vendor EQMVDRID true
VirtualMeterType VirtualMeterType EQMVIRTUALMETERTYPE false 0
WantedMaintenanceState MaintenanceState EQMWANTEDMNTSID true
Warehouse Warehouse EQMWHSID true
WarrantDate Date? EQMWARRENTDATE true

Brondatabewerken