Bewerken: MaintenanceClassification

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `MntcId` | nvarchar(5) | Nee | — | — |
| `MntcDescr` | nvarchar(200) | Ja | — | — |
| `MntcContext` | bigint | Nee | ((0)) | — |
| `MntcRecStatus` | int | Nee | ((0)) | — |
| `MntcApproveDate` | datetimeoffset(7) | Ja | — | — |
| `MntcApproveEmpId` | nvarchar(9) | Ja | — | — |
| `MntcBofId` | nvarchar(4) | Ja | — | — |
| `MntcCompId` | nvarchar(6) | Nee | — | — |
| `MntcDataProvider` | nvarchar(50) | Ja | — | — |
| `MntcEqmtId` | nvarchar(9) | Ja | — | — |
| `MntcExported` | smallint | Nee | ((0)) | — |
| `MntcExternalId` | nvarchar(50) | Ja | — | — |
| `MntcExternalReference` | nvarchar(8) | Ja | — | — |
| `MntcExternalStatus` | nvarchar(50) | Ja | — | — |
| `MntcFMEAEssential` | smallint | Nee | ((0)) | — |
| `MntcFMEAFinishdate` | datetimeoffset(7) | Ja | — | — |
| `MntcIspId` | nvarchar(11) | Ja | — | — |
| `MntcProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `MntcRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `MntcReOpenDate` | datetimeoffset(7) | Ja | — | — |
| `MntcReOpenEmpId` | nvarchar(9) | Ja | — | — |
| `MntcRiscId` | nvarchar(5) | Ja | — | — |
| `MntcRiskScore` | decimal(21,1) | Nee | ((0)) | — |
| `MntcText` | nvarchar(max) | Ja | — | — |
| `MntcTransferNextTime` | smallint | Nee | ((0)) | — |
| `MntcTransferNextTimeMntc` | smallint | Nee | ((1)) | — |
| `MntcTransferNextTimePmw` | smallint | Nee | ((1)) | — |
| `MntcWibazRiscId` | nvarchar(5) | Ja | — | — |
| `MntcWibazRiskScore` | decimal(21,1) | Nee | ((0)) | — |
| `MntcExecutionDays` | int | Nee | ((0)) | — |
| `MntcUseExecutionPercentage` | smallint | Nee | ((1)) | — |
| `MntcExecutionPercentage` | int | Nee | ((0)) | — |