Bewerken: Equipment

Sectie: Kolommen

Reden:

## Kolommen

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