Bewerken: YearPlanScenario

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `YrpsYrpId` | nvarchar(9) | Nee | — | — |
| `YrpsLineId` | nvarchar(2) | Nee | — | — |
| `YrpsDescr` | nvarchar(200) | Ja | — | — |
| `YrpsContext` | bigint | Nee | ((0)) | — |
| `YrpsRecStatus` | int | Nee | ((0)) | — |
| `YrpsCompId` | nvarchar(6) | Nee | — | — |
| `YrpsDataProvider` | nvarchar(50) | Ja | — | — |
| `YrpsDefiniteDate` | date | Ja | — | — |
| `YrpsEmpId` | nvarchar(9) | Ja | — | — |
| `YrpsExported` | smallint | Nee | ((0)) | — |
| `YrpsExternalId` | nvarchar(50) | Ja | — | — |
| `YrpsExternalStatus` | nvarchar(50) | Ja | — | — |
| `YrpsIndexPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `YrpsLastEditorName` | nvarchar(200) | Ja | — | — |
| `YrpsLtapStartYearPriceLevel` | smallint | Nee | ((0)) | — |
| `YrpsProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `YrpsRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `YrpsStartYearPriceLevel` | smallint | Nee | ((0)) | — |
| `YrpsTransferNextTime` | smallint | Nee | ((1)) | — |