Bewerken: PmSchedule

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmsId` | nvarchar(5) | Nee | — | — |
| `PmsDescr` | nvarchar(200) | Ja | — | — |
| `PmsContext` | bigint | Nee | ((1)) | — |
| `PmsRecStatus` | int | Nee | ((0)) | — |
| `PmsCompId` | nvarchar(6) | Nee | — | — |
| `PmsEndDate` | date | Ja | — | — |
| `PmsExported` | smallint | Nee | ((0)) | — |
| `PmsExtra1` | smallint | Nee | ((0)) | — |
| `PmsExtra2` | int | Nee | ((0)) | — |
| `PmsExtra3` | int | Nee | ((0)) | — |
| `PmsExtra4` | nvarchar(5) | Ja | — | — |
| `PmsExtra5` | nvarchar(5) | Ja | — | — |
| `PmsFrqId` | nvarchar(3) | Ja | — | — |
| `PmsIncludeAutoPmWorkOrders` | smallint | Nee | ((0)) | — |
| `PmsPmsGrByPaId` | nvarchar(5) | Ja | — | — |
| `PmsPmwInSchemaSearchType` | smallint | Nee | ((0)) | — |
| `PmsRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmsSearchOnlyDateNextMaint` | smallint | Nee | ((0)) | — |
| `PmsShowAssetsInStructure` | smallint | Nee | ((1)) | — |
| `PmsShowExpectedPM` | smallint | Nee | ((1)) | — |
| `PmsShowExtCalc` | smallint | Nee | ((1)) | — |
| `PmsShowFleetEquipment` | smallint | Nee | ((1)) | — |
| `PmsShowFleetObjects` | smallint | Nee | ((1)) | — |
| `PmsShowHoursCosts` | smallint | Nee | ((1)) | — |
| `PmsShowInfraBuildingPart` | smallint | Nee | ((1)) | — |
| `PmsShowInfraComplex` | smallint | Nee | ((1)) | — |
| `PmsShowInfraElement` | smallint | Nee | ((1)) | — |
| `PmsShowInfraObject` | smallint | Nee | ((1)) | — |
| `PmsShowInfraRoute` | smallint | Nee | ((1)) | — |
| `PmsShowInstallations` | smallint | Nee | ((1)) | — |
| `PmsShowInventories` | smallint | Nee | ((1)) | — |
| `PmsShowJobs` | smallint | Nee | ((1)) | — |
| `PmsShowJobsWithStatusOpen` | smallint | Nee | ((1)) | — |
| `PmsShowMatCalc` | smallint | Nee | ((1)) | — |
| `PmsShowOnlyAssetsWithJob` | smallint | Nee | ((0)) | — |
| `PmsShowOnlyJobsWithDowntimeRequired` | smallint | Nee | ((0)) | — |
| `PmsShowProcessFunctions` | smallint | Nee | ((1)) | — |
| `PmsShowPurchaseRequestCalc` | smallint | Nee | ((1)) | — |
| `PmsShowPurchCalc` | smallint | Nee | ((1)) | — |
| `PmsShowResCalc` | smallint | Nee | ((1)) | — |
| `PmsShowTlsCalc` | smallint | Nee | ((1)) | — |
| `PmsSitId` | nvarchar(8) | Ja | — | — |
| `PmsSkcId` | nvarchar(9) | Ja | — | — |
| `PmsStartDate` | date | Ja | — | — |
| `PmsTakeCourseRoute` | smallint | Nee | ((0)) | — |
| `PmsWeek` | int | Nee | ((0)) | — |
| `PmsWoAct` | int | Nee | ((0)) | — |
| `PmsWoFnd` | int | Nee | ((0)) | — |
| `PmsShowExchangeParts` | smallint | Nee | ((1)) | — |