title: "EquipmentMsrPoint (table)" category: reference tags: [table, equipmentmsrpoint, datamodel] source: database-schema.json date: 2026-04-17 status: published

dba.EquipmentMsrPoint

Schema: dba Aantal kolommen: 37

Kolommenbewerken

Kolom Type Nullable Default Identity
EqmmspEqmId nvarchar(24) Nee — —
EqmmspMspId nvarchar(70) Nee — —
EqmmspDescr nvarchar(200) Ja — —
EqmmspContext bigint Nee ((0)) —
EqmmspRecStatus int Nee ((0)) —
EqmmspAllowDescValues smallint Nee ((0)) —
EqmMspAutoResetAtLowerValue smallint Nee ((0)) —
EqmmspCompId nvarchar(6) Nee — —
EqmmspConversionFactor decimal(21,6) Nee ((0)) —
EqmmspDataProvider nvarchar(50) Ja — —
EqmmspDefault smallint Nee ((0)) —
EqmmspExported smallint Nee ((0)) —
EqmmspExternalId nvarchar(50) Ja — —
EqmmspExternalStatus nvarchar(50) Ja — —
EqmmspExtra1 smallint Nee ((0)) —
EqmmspExtra2 int Nee ((0)) —
EqmmspExtra3 decimal(21,2) Nee ((0)) —
EqmmspExtra4 nvarchar(5) Ja — —
EqmmspFreqTrigger smallint Nee ((0)) —
EqmmspHistQty smallint Nee ((0)) —
EqmmspIsFeedIn smallint Nee ((0)) —
EqmmspLastDate datetimeoffset(7) Ja — —
EqmmspLastValue decimal(21,2) Nee ((0)) —
EqmmspMaxPmwId nvarchar(5) Ja — —
EqmmspMaxValue decimal(21,2) Nee ((0)) —
EqmmspMinPmwId nvarchar(5) Ja — —
EqmmspMinValue decimal(21,2) Nee ((0)) —
EqmmspMsrId nvarchar(6) Ja — —
EqmmspNominalValue decimal(21,2) Nee ((0)) —
EqmmspProviderMutDate datetimeoffset(7) Ja — —
EqmmspRecCreateDate datetimeoffset(7) Ja (sysdatetimeoffset()) —
EqmmspRocDelta decimal(21,0) Nee ((0)) —
EqmmspRocFrqId nvarchar(3) Ja — —
EqmmspRocInterval int Nee ((0)) —
EqmmspRocPmwId nvarchar(5) Ja — —
EqmmspTransferNextTime smallint Nee ((0)) —
EqmmspUpdateMethod nvarchar(1) Ja — —

Brondatabewerken