Bewerken: EquipmentMspValue

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `EqmmspvEqmId` | nvarchar(24) | Nee | — | — |
| `EqmmspvMspId` | nvarchar(70) | Nee | — | — |
| `EqmmspvLineId` | nvarchar(14) | Nee | — | — |
| `EqmmspvContext` | bigint | Nee | ((0)) | — |
| `EqmmspvRecStatus` | int | Nee | ((0)) | — |
| `EqmmspvAbsoluteValue` | smallint | Nee | ((0)) | — |
| `EqmMspvCancelDate` | datetimeoffset(7) | Ja | — | — |
| `EqmMspvCancelEmpId` | nvarchar(9) | Ja | — | — |
| `EqmMspvCancelReason` | nvarchar(max) | Ja | — | — |
| `EqmmspvCompId` | nvarchar(6) | Nee | — | — |
| `EqmmspvDataProvider` | nvarchar(50) | Ja | — | — |
| `EqmmspvDate` | datetimeoffset(7) | Ja | — | — |
| `EqmmspvDifference` | decimal(21,2) | Nee | ((0)) | — |
| `EqmmspvEmpId` | nvarchar(9) | Ja | — | — |
| `EqmmspvEqmPartOfEqmId` | nvarchar(24) | Ja | — | — |
| `EqmmspvEqmPrfId` | nvarchar(50) | Ja | — | — |
| `EqmmspvEqmSpcId` | nvarchar(40) | Ja | — | — |
| `EqmmspvExported` | smallint | Nee | ((0)) | — |
| `EqmmspvExternalId` | nvarchar(50) | Ja | — | — |
| `EqmmspvExternalStatus` | nvarchar(50) | Ja | — | — |
| `EqmmspvFail` | smallint | Nee | ((0)) | — |
| `EqmmspvInpDate` | datetimeoffset(7) | Ja | — | — |
| `EqmMspvIsReset` | smallint | Nee | ((0)) | — |
| `EqmmspvOriginalValue` | decimal(21,2) | Nee | ((0)) | — |
| `EqmmspvPmwId` | nvarchar(5) | Ja | — | — |
| `EqmmspvProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `EqmmspvRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `EqmmspvText` | nvarchar(max) | Ja | — | — |
| `EqmmspvTransferNextTime` | smallint | Nee | ((0)) | — |
| `EqmmspvValue` | decimal(21,2) | Nee | ((0)) | — |