title: "Equipment (table)" category: reference tags: [table, equipment, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Equipment
Schema: dba
Aantal kolommen: 218
Zie ook de entity-pagina: ../entities/Equipment
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
EqmId |
nvarchar(24) | Nee | — | — |
EqmDescr |
nvarchar(200) | Ja | — | — |
EqmContext |
bigint | Nee | ((1)) | — |
EqmRecStatus |
int | Nee | ((0)) | — |
EqmActiveDate |
datetimeoffset(7) | Ja | — | — |
EqmActiveEmpId |
nvarchar(9) | Ja | — | — |
EqmAocId |
nvarchar(11) | Ja | — | — |
EqmArtId |
nvarchar(9) | Ja | — | — |
EqmBdwId |
nvarchar(5) | Ja | — | — |
EqmBldfBldId |
nvarchar(11) | Ja | — | — |
EqmBldfBldpId |
nvarchar(11) | Ja | — | — |
EqmBldfId |
nvarchar(23) | Ja | — | — |
EqmBldId |
nvarchar(11) | Ja | — | — |
EqmBldpBldId |
nvarchar(11) | Ja | — | — |
EqmBldpId |
nvarchar(11) | Ja | — | — |
EqmBtchId |
nvarchar(9) | Ja | — | — |
EqmCadDocId |
nvarchar(11) | Ja | — | — |
EqmCadHandle |
decimal(21,0) | Nee | ((0)) | — |
EqmCadHandleDocId |
nvarchar(11) | Ja | — | — |
EqmCcrId |
nvarchar(9) | Ja | — | — |
EqmClrId |
nvarchar(5) | Ja | — | — |
EqmCode |
nvarchar(12) | Ja | — | — |
EqmCompId |
nvarchar(6) | Nee | — | — |
EqmConcessionPolicy |
smallint | Nee | ((0)) | — |
EqmCopyFromEqmId |
nvarchar(24) | Ja | — | — |
EqmCostLY |
decimal(21,5) | Nee | ((0)) | — |
EqmCurrAppearanceMntsDate |
date | Ja | — | — |
EqmCurrAppearanceMntsId |
nvarchar(11) | Ja | — | — |
EqmCurrentMntsDate |
date | Ja | — | — |
EqmCurrentMntsId |
nvarchar(11) | Ja | — | — |
EqmCusId |
nvarchar(6) | Ja | — | — |
EqmDataProvider |
nvarchar(50) | Ja | — | — |
EqmDateState |
datetimeoffset(7) | Ja | — | — |
EqmDecId |
nvarchar(15) | Ja | — | — |
EqmDepId |
nvarchar(11) | Ja | — | — |
EqmDeprActivated |
smallint | Nee | ((0)) | — |
EqmDepreciationDate |
date | Ja | — | — |
EqmDeprLife |
smallint | Nee | ((0)) | — |
EqmDeprStartdate |
date | Ja | — | — |
EqmDeviceName |
nvarchar(100) | Ja | — | — |
EqmDrawingNr |
nvarchar(20) | Ja | — | — |
EqmEcoDeprmId |
nvarchar(3) | Ja | — | — |
EqmEnergyMeterType |
int | Nee | ((0)) | — |
EqmEqmsId |
nvarchar(11) | Ja | — | — |
EqmEqmtId |
nvarchar(9) | Ja | — | — |
EqmExchangePart |
smallint | Nee | ((0)) | — |
EqmExchangePartLoc |
nvarchar(1) | Ja | — | — |
EqmExchangePartStatus |
nvarchar(1) | Ja | — | — |
EqmExchangePartVdrId |
nvarchar(6) | Ja | — | — |
EqmExported |
smallint | Nee | ((0)) | — |
EqmExternalId |
nvarchar(50) | Ja | — | — |
EqmExternalStatus |
nvarchar(50) | Ja | — | — |
EqmExtra1 |
smallint | Nee | ((0)) | — |
EqmExtra2 |
int | Nee | ((0)) | — |
EqmExtra3 |
int | Nee | ((0)) | — |
EqmExtra4 |
int | Nee | ((0)) | — |
EqmExtra5 |
int | Nee | ((0)) | — |
EqmExtra6 |
nvarchar(5) | Ja | — | — |
EqmExtra7 |
nvarchar(5) | Ja | — | — |
EqmExtra8 |
nvarchar(5) | Ja | — | — |
EqmExtra9 |
nvarchar(5) | Ja | — | — |
EqmFinId |
nvarchar(8) | Ja | — | — |
EqmFintFinId |
nvarchar(8) | Ja | — | — |
EqmFintId |
nvarchar(8) | Ja | — | — |
EqmFuelTankCapacity |
decimal(21,2) | Nee | ((0)) | — |
EqmFulId |
nvarchar(5) | Ja | — | — |
EqmGearId |
nvarchar(5) | Ja | — | — |
EqmGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
EqmGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
EqmGeoId |
nvarchar(8) | Ja | — | — |
EqmGroupPmEmpId |
nvarchar(9) | Ja | — | — |
EqmGroupPmSkcId |
nvarchar(9) | Ja | — | — |
EqmImageFile |
nvarchar(max) | Ja | — | — |
EqmImagefile2 |
nvarchar(max) | Ja | — | — |
EqmImagefile3 |
nvarchar(max) | Ja | — | — |
EqmImagefile4 |
nvarchar(max) | Ja | — | — |
EqmImpId |
nvarchar(11) | Ja | — | — |
EqmImportedCriticality |
smallint | Nee | ((0)) | — |
EqmIncludedObject |
smallint | Nee | ((0)) | — |
EqmIndexedReplCost |
decimal(21,5) | Nee | ((0)) | — |
EqmInstDate |
date | Ja | — | — |
EqmInstEmpId |
nvarchar(9) | Ja | — | — |
EqmIPAddress |
nvarchar(22) | Ja | — | — |
EqmIsBulk |
smallint | Nee | ((0)) | — |
EqmIssueDate |
datetimeoffset(7) | Ja | — | — |
EqmLastEqmmDate |
datetimeoffset(7) | Ja | — | — |
EqmLastEqmmId |
nvarchar(8) | Ja | — | — |
EqmLastPmMaintDate |
date | Ja | — | — |
EqmLastPmModel |
nvarchar(5) | Ja | — | — |
EqmLicenseRequired |
smallint | Nee | ((0)) | — |
EqmLocation |
nvarchar(26) | Ja | — | — |
EqmLocId |
nvarchar(14) | Ja | — | — |
EqmLowestLevelForExport |
smallint | Nee | ((0)) | — |
EqmLtaId |
nvarchar(10) | Ja | — | — |
EqmMaintTotal |
decimal(21,5) | Nee | ((0)) | — |
EqmMaintYear |
decimal(21,5) | Nee | ((0)) | — |
EqmManufId |
nvarchar(6) | Ja | — | — |
EqmManufYear |
int | Nee | ((0)) | — |
EqmMissingDate |
datetimeoffset(7) | Ja | — | — |
EqmMissingEmpId |
nvarchar(9) | Ja | — | — |
EqmMntcId |
nvarchar(5) | Ja | — | — |
EqmMntsId |
nvarchar(11) | Ja | — | — |
EqmModel |
nvarchar(50) | Ja | — | — |
EqmNen2767P4Compliant |
smallint | Nee | ((1)) | — |
EqmNen2767P4CompliantInit |
smallint | Nee | ((0)) | — |
EqmNextPmMaintDate |
date | Ja | — | — |
EqmNextPmMaintJobId |
nvarchar(12) | Ja | — | — |
EqmNextPmModel |
nvarchar(5) | Ja | — | — |
EqmNoGroupPm |
smallint | Nee | ((1)) | — |
EqmNoPM |
smallint | Nee | ((0)) | — |
EqmNotQualifiedHumaneUse |
smallint | Nee | ((0)) | — |
EqmObjImpPmTasksToProcess |
int | Nee | ((0)) | — |
EqmOrgId |
nvarchar(4) | Ja | — | — |
EqmOriginalVdrId |
nvarchar(6) | Ja | — | — |
EqmOriginEndDate |
date | Ja | — | — |
EqmOutOfServiceDate |
date | Ja | — | — |
EqmOwnerEmpId |
nvarchar(9) | Ja | — | — |
EqmPartOfEqmId |
nvarchar(24) | Ja | — | — |
EqmPartOfMeterEqmId |
nvarchar(24) | Ja | — | — |
EqmPowersource |
smallint | Nee | ((0)) | — |
EqmPowersource2 |
smallint | Nee | ((0)) | — |
EqmPowersource3 |
smallint | Nee | ((0)) | — |
EqmPrddId |
nvarchar(6) | Ja | — | — |
EqmPrdDossierAddedDate |
datetimeoffset(7) | Ja | — | — |
EqmPrdDossierAddedEmpId |
nvarchar(9) | Ja | — | — |
EqmPrddOutboundEmpId |
nvarchar(9) | Ja | — | — |
EqmPrddOutboundId |
nvarchar(6) | Ja | — | — |
EqmPrfId |
nvarchar(50) | Ja | — | — |
EqmProdId |
nvarchar(9) | Ja | — | — |
EqmProductDossierOutboundDate |
datetimeoffset(7) | Ja | — | — |
EqmProductionLossPerHour |
decimal(21,5) | Nee | ((0)) | — |
EqmProviderMutDate |
datetimeoffset(7) | Ja | — | — |
EqmPurchPrice |
decimal(21,5) | Nee | ((0)) | — |
EqmRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
EqmRegisterObjectDowntime |
smallint | Nee | ((0)) | — |
EqmRelcId |
nvarchar(5) | Ja | — | — |
EqmReleaseDate |
date | Ja | — | — |
EqmReleaseTillDate |
date | Ja | — | — |
EqmRemovalDate |
datetimeoffset(7) | Ja | — | — |
EqmRemovalEmpId |
nvarchar(9) | Ja | — | — |
EqmRemovalReason |
nvarchar(61) | Ja | — | — |
EqmRentHourTariff |
decimal(21,5) | Nee | ((0)) | — |
EqmRentUseEqmHourTariff |
smallint | Nee | ((0)) | — |
EqmReplCost |
decimal(21,5) | Nee | ((0)) | — |
EqmReplCostDate |
date | Ja | — | — |
EqmReplDate |
date | Ja | — | — |
EQMREPLLIFE |
int | Nee | ((0)) | — |
EqmReplYear |
smallint | Nee | ((0)) | — |
EqmReservable |
smallint | Nee | ((0)) | — |
EqmResidualValue |
decimal(21,5) | Nee | ((0)) | — |
EqmResoId |
nvarchar(11) | Ja | — | — |
EqmReturnDate |
date | Ja | — | — |
EqmRiscId |
nvarchar(5) | Ja | — | — |
EqmRiskScore |
decimal(21,2) | Nee | ((0)) | — |
EqmSecondFuelTankCapacity |
decimal(21,2) | Nee | ((0)) | — |
EqmSecondFulId |
nvarchar(5) | Ja | — | — |
EqmSerialNr |
nvarchar(40) | Ja | — | — |
EqmServiceOnBestEffort |
smallint | Nee | ((0)) | — |
EqmServiceVdrId |
nvarchar(6) | Ja | — | — |
EqmSetUpDate |
datetimeoffset(7) | Ja | — | — |
EqmSetUpEmpId |
nvarchar(9) | Ja | — | — |
EqmSitId |
nvarchar(8) | Ja | — | — |
EqmSkcId |
nvarchar(9) | Ja | — | — |
EqmSpcId |
nvarchar(40) | Ja | — | — |
EqmState |
decimal(21,2) | Nee | ((0)) | — |
EqmStorageLocation |
nvarchar(26) | Ja | — | — |
EqmStorageSpcId |
nvarchar(40) | Ja | — | — |
EqmSvcId |
nvarchar(9) | Ja | — | — |
EqmTachographInspExpDate |
date | Ja | — | — |
EqmTaxDeprmId |
nvarchar(3) | Ja | — | — |
EqmTech1 |
nvarchar(12) | Ja | — | — |
EqmTech10 |
nvarchar(12) | Ja | — | — |
EqmTech2 |
nvarchar(12) | Ja | — | — |
EqmTech3 |
nvarchar(12) | Ja | — | — |
EqmTech4 |
nvarchar(12) | Ja | — | — |
EqmTech5 |
nvarchar(12) | Ja | — | — |
EqmTech6 |
nvarchar(12) | Ja | — | — |
EqmTech7 |
nvarchar(12) | Ja | — | — |
EqmTech8 |
nvarchar(12) | Ja | — | — |
EqmTech9 |
nvarchar(12) | Ja | — | — |
EqmTechDeprLife |
smallint | Nee | ((0)) | — |
EqmText1 |
nvarchar(max) | Ja | — | — |
EqmText2 |
nvarchar(max) | Ja | — | — |
EqmText3 |
nvarchar(max) | Ja | — | — |
EqmThirdFuelTankCapacity |
decimal(21,2) | Nee | ((0)) | — |
EqmThirdFulId |
nvarchar(5) | Ja | — | — |
EqmTopOfEqmId |
nvarchar(24) | Ja | — | — |
EqmTransferNextTime |
smallint | Nee | ((0)) | — |
EqmTypeNr |
nvarchar(180) | Ja | — | — |
EqmUdi |
nvarchar(80) | Ja | — | — |
EqmUdiImageFile |
nvarchar(max) | Ja | — | — |
EqmUrgId |
nvarchar(11) | Ja | — | — |
EqmUseSpecificFailTypes |
smallint | Nee | ((0)) | — |
EqmVdrId |
nvarchar(6) | Ja | — | — |
EqmVehicleInspExpDate |
date | Ja | — | — |
EqmVirtualMeterType |
int | Nee | ((0)) | — |
EqmWantedMntsId |
nvarchar(11) | Ja | — | — |
EqmWarrentDate |
date | Ja | — | — |
EqmWhsId |
nvarchar(10) | Ja | — | — |
EqmScrappedDate |
datetimeoffset(7) | Ja | — | — |
EqmScrappedEmpId |
nvarchar(9) | Ja | — | — |
EqmTrackAndTraceLocation |
nvarchar(max) | Ja | — | — |
EqmTrackAndTrace |
smallint | Nee | ((0)) | — |
EqmTrackAndTraceLastSyncDate |
datetimeoffset(7) | Ja | — | — |
EqmPrsId |
nvarchar(11) | Ja | — | — |
EqmNFCSerialNumber |
nvarchar(40) | Ja | — | — |
EqmFileExtension |
nvarchar(5) | Nee | — | — |
EQMTEXT1_FT |
varbinary(max) | Ja | — | — |
EQMTEXT2_FT |
varbinary(max) | Ja | — | — |
EQMTEXT3_FT |
varbinary(max) | Ja | — | — |
EqmObjraId |
nvarchar(8) | Ja | — | — |
EqmRiscIdCriticality |
nvarchar(5) | Ja | — | — |
EqmScoreCritical |
decimal(21,2) | Nee | ((0)) | — |
EqmLowestLevelAssessment |
smallint | Nee | ((0)) | — |
EqmRisOcId |
nvarchar(9) | Ja | — | — |
EqmCriticalityRemarkText |
nvarchar(max) | Ja | — | — |
EqmLmraIspId |
nvarchar(11) | Ja | — | — |
EqmFDARegulated |
smallint | Nee | ((0)) | — |
Computed columnsbewerken
EqmFileExtension—(N'.html')EQMTEXT1_FT—(case when [EQMTEXT1] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([EQMTEXT1],(5))=N'<html' then [EQMTEXT1] else N'<html lang="en-gb">'+[EQMTEXT1] end) end)EQMTEXT2_FT—(case when [EQMTEXT2] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([EQMTEXT2],(5))=N'<html' then [EQMTEXT2] else N'<html lang="en-gb">'+[EQMTEXT2] end) end)EQMTEXT3_FT—(case when [EQMTEXT3] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([EQMTEXT3],(5))=N'<html' then [EQMTEXT3] else N'<html lang="en-gb">'+[EQMTEXT3] end) end)
Trigger-gevulde kolommenbewerken
EqmBldId← TRGI_ReservableObject, TRGU_ReservableObjectEqmCcrId← TRGI_ReservableObject, TRGU_ReservableObjectEqmCostLY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTEqmDepId← TRGI_ReservableObject, TRGU_ReservableObjectEqmMaintTotal← TRSD_COST, TRSM_COSTEqmMaintYear← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTEqmNen2767P4Compliant← TRGD_EqmTypeHierarchy, TRGI_Equipment, TRGU_EquipmentEqmObjImpPmTasksToProcess← TRGD_ObjectImportedPmTask, TRGI_ObjectImportedPmTask, TRGU_ObjectImportedPmTaskEqmPartOfEqmId← TRGD_Equipment, TRGI_EqmTypeHierarchy, TRGI_Equipment, TRGU_EqmTypeHierarchy, TRGU_EquipmentEqmPrfId← TRGD_ProcessFunction, TRGI_EqmTypeHierarchy, TRGU_EqmTypeHierarchyEqmReplCost← TRGU_CompanyEqmResoId← TRGU_ReservableObjectEqmSitId← TRGI_ReservableObject, TRGU_ReservableObjectEqmTopOfEqmId← TRGD_Equipment, TRGI_Equipment, TRGU_EquipmentEqmPrsId← TRGI_Equipment
Brondatabewerken
- DB-schema —
lookup_table_schema("Equipment")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Equipment")· ../entities/Equipment Properties, contexts, statussen. Bron:Entities.xml.