Bewerken: MaintenancePartActivity

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `MntpaMntpId` | nvarchar(11) | Nee | — | — |
| `MntpaMntaId` | nvarchar(11) | Nee | — | — |
| `MntpaContext` | bigint | Nee | ((0)) | — |
| `MntpaRecStatus` | int | Nee | ((0)) | — |
| `MntpaCcrId` | nvarchar(9) | Ja | — | — |
| `MntpaCompId` | nvarchar(6) | Nee | — | — |
| `MntpaConditionAftAct` | nvarchar(11) | Ja | — | — |
| `MntpaCsttId` | nvarchar(9) | Ja | — | — |
| `MntpaDataProvider` | nvarchar(50) | Ja | — | — |
| `MntpaExported` | smallint | Nee | ((0)) | — |
| `MntpaExternalCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaExternalId` | nvarchar(50) | Ja | — | — |
| `MntpaExternalStatus` | nvarchar(50) | Ja | — | — |
| `MntpaExtraCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaHoursPerUnt` | decimal(21,4) | Nee | ((0)) | — |
| `MntpaHtcId` | nvarchar(5) | Ja | — | — |
| `MntpaImplementationPerc` | decimal(21,2) | Nee | ((0)) | — |
| `MntpaInspectionCycle` | smallint | Nee | ((0)) | — |
| `MntpaInspectionTime` | decimal(21,2) | Nee | ((0)) | — |
| `MntpaLabCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaMaintenanceCycle` | smallint | Nee | ((0)) | — |
| `MntpaMaintenanceTime` | decimal(21,2) | Nee | ((0)) | — |
| `MntpaMaintTimesPerYear` | smallint | Nee | ((0)) | — |
| `MntpaMaterialCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaMnttId` | nvarchar(11) | Ja | — | — |
| `MntpaNextMntsId` | nvarchar(11) | Ja | — | — |
| `MntpaObservationsPerCycle` | int | Nee | ((0)) | — |
| `MntpaPercOfReplacementCost` | decimal(21,2) | Nee | ((0)) | — |
| `MntpaProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `MntpaQty` | decimal(21,2) | Nee | ((0)) | — |
| `MntpaRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `MntpaStateImprovement` | smallint | Nee | ((0)) | — |
| `MntpaStdCostExLab` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaStdTotalCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaText` | nvarchar(max) | Ja | — | — |
| `MntpaToolsCost` | decimal(21,5) | Nee | ((0)) | — |
| `MntpaTransferNextTime` | smallint | Nee | ((0)) | — |
| `MntpaUntId` | nvarchar(6) | Ja | — | — |
| `MntpaUntPrice` | decimal(21,5) | Nee | ((0)) | — |