Bewerken: Equipment

Sectie: Properties

Reden:

## Properties

| 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 |  |