Bewerken: PmWorkOrder

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmwId` | nvarchar(5) | Nee | — | — |
| `PmwDescr` | nvarchar(250) | Ja | — | — |
| `PmwContext` | bigint | Nee | ((1)) | — |
| `PmwRecStatus` | int | Nee | ((0)) | — |
| `PmwApprvDate` | datetimeoffset(7) | Ja | — | — |
| `PmwApprvEmpId` | nvarchar(9) | Ja | — | — |
| `PmwAutoClose` | smallint | Nee | ((0)) | — |
| `PmwAutoPmActive` | smallint | Nee | ((0)) | — |
| `PmwAutoPmTimuId` | nvarchar(11) | Ja | — | — |
| `PmwAutoPmTimuQty` | smallint | Nee | ((0)) | — |
| `PmwBelongsToSchema` | smallint | Nee | ((0)) | — |
| `PmwCcrId` | nvarchar(9) | Ja | — | — |
| `PmwCompId` | nvarchar(6) | Nee | — | — |
| `PmwCsttId` | nvarchar(9) | Ja | — | — |
| `PmwDataProvider` | nvarchar(50) | Ja | — | — |
| `PmwDayOccurrence` | smallint | Nee | ((0)) | — |
| `PmwDays` | int | Nee | ((0)) | — |
| `PmwDaysAWeek` | smallint | Nee | ((0)) | — |
| `PmwDepId` | nvarchar(11) | Ja | — | — |
| `PmwEmpId` | nvarchar(9) | Ja | — | — |
| `PmwEndDate` | date | Ja | — | — |
| `PmwEqmId` | nvarchar(24) | Ja | — | — |
| `PmwEqmmspEqmId` | nvarchar(24) | Ja | — | — |
| `PmwEqmmspMspId` | nvarchar(70) | Ja | — | — |
| `PmwExported` | smallint | Nee | ((0)) | — |
| `PmwExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwExternalId` | nvarchar(50) | Ja | — | — |
| `PmwExternalStatus` | nvarchar(50) | Ja | — | — |
| `PmwExtra1` | smallint | Nee | ((0)) | — |
| `PmwExtra10` | nvarchar(5) | Ja | — | — |
| `PmwExtra11` | nvarchar(5) | Ja | — | — |
| `PmwExtra12` | decimal(21,0) | Nee | ((0)) | — |
| `PmwExtra2` | int | Nee | ((0)) | — |
| `PmwExtra3` | nvarchar(5) | Ja | — | — |
| `PmwExtra4` | nvarchar(5) | Ja | — | — |
| `PmwExtra5` | int | Nee | ((0)) | — |
| `PmwExtra6` | int | Nee | ((0)) | — |
| `PmwExtra7` | int | Nee | ((0)) | — |
| `PmwExtra8` | nvarchar(5) | Ja | — | — |
| `PmwExtra9` | nvarchar(5) | Ja | — | — |
| `PmwFreqStartDate` | date | Ja | — | — |
| `PmwFrqCode` | smallint | Nee | ((0)) | — |
| `PmwFrqId` | nvarchar(3) | Ja | — | — |
| `PmwGroupPmwId` | nvarchar(5) | Ja | — | — |
| `PmwHierarchy` | smallint | Nee | ((0)) | — |
| `PmwHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmwImpId` | nvarchar(11) | Ja | — | — |
| `PmwIsBulk` | smallint | Nee | ((0)) | — |
| `PmwJpId` | nvarchar(11) | Ja | — | — |
| `PmwLastJobsGeneratedDate` | datetimeoffset(7) | Ja | — | — |
| `PmwLastRunDate` | datetimeoffset(7) | Ja | — | — |
| `PmwLastRunStatus` | nvarchar(max) | Ja | — | — |
| `PmwLastRunSuccess` | smallint | Nee | ((0)) | — |
| `PmwLastRunSuccessDate` | datetimeoffset(7) | Ja | — | — |
| `PmwMaintNec` | smallint | Nee | ((0)) | — |
| `PmwManualNextMaintDate` | date | Ja | — | — |
| `PmwManualNextMaintDateDate` | datetimeoffset(7) | Ja | — | — |
| `PmwManualNextMaintDateEmpId` | nvarchar(9) | Ja | — | — |
| `PmwMarginAfterQuantity` | smallint | Nee | ((0)) | — |
| `PmwMarginAfterTimuId` | nvarchar(11) | Ja | — | — |
| `PmwMarginBeforeQuantity` | smallint | Nee | ((0)) | — |
| `PmwMarginBeforeTimuId` | nvarchar(11) | Ja | — | — |
| `PmwMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwMeterEqmId` | nvarchar(24) | Ja | — | — |
| `PmwMntcId` | nvarchar(5) | Ja | — | — |
| `PmwNextRunDate` | datetimeoffset(7) | Ja | — | — |
| `PmwParentPeriodicActivity` | smallint | Nee | ((0)) | — |
| `PmwPrfId` | nvarchar(50) | Ja | — | — |
| `PmwPrfmspMspId` | nvarchar(70) | Ja | — | — |
| `PmwPrfmspPrfId` | nvarchar(50) | Ja | — | — |
| `PmwPriId` | nvarchar(4) | Ja | — | — |
| `PmwProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PmwPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmwResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSitId` | nvarchar(8) | Ja | — | — |
| `PmwSkcId` | nvarchar(9) | Ja | — | — |
| `PmwSpcId` | nvarchar(40) | Ja | — | — |
| `PmwStartDate` | date | Ja | — | — |
| `PmwStartDayId` | nvarchar(3) | Ja | — | — |
| `PmwStartState` | decimal(21,0) | Nee | ((0)) | — |
| `PmwState` | decimal(21,0) | Nee | ((0)) | — |
| `PmwStateNextExecution` | decimal(21,0) | Nee | ((0)) | — |
| `PmwStateStartDate` | date | Ja | — | — |
| `PmwSubExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSubMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSubPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSubResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSubTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwSvcId` | nvarchar(9) | Ja | — | — |
| `PmwTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmwTransferNextTime` | smallint | Nee | ((0)) | — |
| `PmwUrgId` | nvarchar(11) | Ja | — | — |
| `PmwVdrId` | nvarchar(6) | Ja | — | — |
| `PmwWeek` | int | Nee | ((0)) | — |
| `PmwWoId` | nvarchar(9) | Ja | — | — |
| `PmwWotId` | nvarchar(6) | Ja | — | — |
| `PmwTotalCalc` | decimal(21,5) | Nee | — | — |
| `PmwReopenedAutomatically` | smallint | Nee | ((0)) | — |
| `PmwExecutionDays` | int | Nee | ((0)) | — |
| `PmwUseExecutionPercentage` | smallint | Nee | ((1)) | — |
| `PmwExecutionPercentage` | int | Nee | ((0)) | — |
| `PmwDeviateFromMntc` | smallint | Nee | ((0)) | — |
| `PmwStopRelated` | smallint | Nee | ((0)) | — |
| `PmwStateEmpId` | nvarchar(9) | Ja | — | — |
| `PmwStateDate` | datetimeoffset(7) | Ja | — | — |