Bewerken: EquipmentMsrPoint

Sectie: Kolommen

Reden:

## Kolommen

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