Bewerken: PmImprovementProposal

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmIPId` | nvarchar(9) | Nee | — | — |
| `PmIPContext` | bigint | Nee | ((0)) | — |
| `PmIPRecStatus` | int | Nee | ((0)) | — |
| `PmIPExported` | smallint | Nee | ((0)) | — |
| `PmIPRecCreateDate` | datetimeoffset(7) | Nee | (sysdatetimeoffset()) | — |
| `PmIPCrmId` | nvarchar(6) | Ja | — | — |
| `PmIPJpId` | nvarchar(11) | Ja | — | — |
| `PmIPPmjPmwId` | nvarchar(5) | Ja | — | — |
| `PmIPPmjId` | nvarchar(3) | Ja | — | — |
| `PmIPSuggestedNumberOfHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmIPCurrentNumberOfHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmIPMADPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `PmIPRemarkText` | nvarchar(max) | Ja | — | — |
| `PmIPToReviewDate` | datetimeoffset(7) | Ja | — | — |
| `PmIPApprovedDate` | datetimeoffset(7) | Ja | — | — |
| `PmIPRejectedDate` | datetimeoffset(7) | Ja | — | — |
| `PmIPCanceledDate` | datetimeoffset(7) | Ja | — | — |
| `PmIPToReviewEmpId` | nvarchar(9) | Ja | — | — |
| `PmIPApprovedEmpId` | nvarchar(9) | Ja | — | — |
| `PmIPRejectedEmpId` | nvarchar(9) | Ja | — | — |
| `PmIPCanceledEmpId` | nvarchar(9) | Ja | — | — |
| `PmIPAutomaticallyApproved` | smallint | Nee | ((0)) | — |