Bewerken: PmJob

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmjPmwId` | nvarchar(5) | Nee | — | — |
| `PmjId` | nvarchar(3) | Nee | — | — |
| `PmjDescr` | nvarchar(200) | Ja | — | — |
| `PmjContext` | bigint | Nee | ((1)) | — |
| `PmjRecStatus` | int | Nee | ((0)) | — |
| `PmjActId` | nvarchar(5) | Ja | — | — |
| `PmjAllowDetailsBesideJobPlan` | smallint | Nee | ((0)) | — |
| `PmjApprvDate` | datetimeoffset(7) | Ja | — | — |
| `PmjApprvEmpId` | nvarchar(9) | Ja | — | — |
| `PmjCcrId` | nvarchar(9) | Ja | — | — |
| `PmjCompId` | nvarchar(6) | Nee | — | — |
| `PmjCopyText` | smallint | Nee | ((1)) | — |
| `PmjCrmId` | nvarchar(6) | Ja | — | — |
| `PmjCsttId` | nvarchar(9) | Ja | — | — |
| `PmjDataProvider` | nvarchar(50) | Ja | — | — |
| `PmjDelay` | decimal(21,2) | Nee | ((0)) | — |
| `PmjDepId` | nvarchar(11) | Ja | — | — |
| `PmjDocId` | nvarchar(11) | Ja | — | — |
| `PmjDowntimeRequired` | smallint | Nee | ((0)) | — |
| `PmjDurationCalc` | decimal(21,2) | Nee | ((0)) | — |
| `PmjEmpId` | nvarchar(9) | Ja | — | — |
| `PmjEqmId` | nvarchar(24) | Ja | — | — |
| `PmjExported` | smallint | Nee | ((0)) | — |
| `PmjExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjExternalId` | nvarchar(50) | Ja | — | — |
| `PmjExternalStatus` | nvarchar(50) | Ja | — | — |
| `PmjExtra1` | smallint | Nee | ((0)) | — |
| `PmjExtra10` | nvarchar(5) | Ja | — | — |
| `PmjExtra11` | nvarchar(5) | Ja | — | — |
| `PmjExtra12` | int | Nee | ((0)) | — |
| `PmjExtra2` | int | Nee | ((0)) | — |
| `PmjExtra3` | nvarchar(6) | Ja | — | — |
| `PmjExtra4` | nvarchar(5) | Ja | — | — |
| `PmjExtra5` | int | Nee | ((0)) | — |
| `PmjExtra6` | int | Nee | ((0)) | — |
| `PmjExtra7` | nvarchar(5) | Ja | — | — |
| `PmjExtra8` | nvarchar(5) | Ja | — | — |
| `PmjExtra9` | nvarchar(5) | Ja | — | — |
| `PmjFileId` | nvarchar(255) | Ja | — | — |
| `PmjFmanId` | nvarchar(5) | Ja | — | — |
| `PmjHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmjImpId` | nvarchar(11) | Ja | — | — |
| `PmjIspId` | nvarchar(11) | Ja | — | — |
| `PmjJpId` | nvarchar(11) | Ja | — | — |
| `PmjLotoApplicable` | smallint | Nee | ((0)) | — |
| `PmjMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiHours` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjMultiTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjNoPermit` | smallint | Nee | ((0)) | — |
| `PmJobConvertedDurationToHours` | smallint | Nee | ((1)) | — |
| `PmjPlanHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmjPrfId` | nvarchar(50) | Ja | — | — |
| `PmjPriId` | nvarchar(4) | Ja | — | — |
| `PmjProc` | nvarchar(41) | Ja | — | — |
| `PmjProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PmjPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmjRemarkSmallInt1` | smallint | Nee | ((0)) | — |
| `PmjRemarkSmallInt2` | smallint | Nee | ((0)) | — |
| `PmjRemarkSmallInt3` | smallint | Nee | ((0)) | — |
| `PmjResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSkcId` | nvarchar(9) | Ja | — | — |
| `PmjSpcId` | nvarchar(40) | Ja | — | — |
| `PmjStopRelated` | smallint | Nee | ((0)) | — |
| `PmjSubExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSubHours` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSubMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSubPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSubResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSubTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjSvcId` | nvarchar(9) | Ja | — | — |
| `PmjTemplatePermId` | nvarchar(6) | Ja | — | — |
| `PmjText` | nvarchar(max) | Ja | — | — |
| `PmjTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PmjTransferNextTime` | smallint | Nee | ((0)) | — |
| `PmjUrgId` | nvarchar(11) | Ja | — | — |
| `PmjUseStdJp` | smallint | Nee | ((0)) | — |
| `PmjUseWorkScheduleForPlanning` | smallint | Nee | ((1)) | — |
| `PmjVdrId` | nvarchar(6) | Ja | — | — |
| `PmjWotId` | nvarchar(6) | Ja | — | — |
| `PmjTotalCalc` | decimal(21,5) | Nee | — | — |
| `PmjReopenedAutomatically` | smallint | Nee | ((0)) | — |
| `PmjLtpId` | nvarchar(6) | Ja | — | — |