Bewerken: PmjRes

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmjrPmwId` | nvarchar(5) | Nee | — | — |
| `PmjrPmjId` | nvarchar(3) | Nee | — | — |
| `PmjrLineId` | nvarchar(9) | Nee | — | — |
| `PmjrContext` | bigint | Nee | ((0)) | — |
| `PmjrRecStatus` | int | Nee | ((0)) | — |
| `PmjrCompId` | nvarchar(6) | Nee | — | — |
| `PmjrCost` | decimal(21,5) | Nee | ((0)) | — |
| `PmjrCrmId` | nvarchar(6) | Ja | — | — |
| `PmjrExported` | smallint | Nee | ((0)) | — |
| `PmjrExtra1` | smallint | Nee | ((0)) | — |
| `PmjrExtra2` | int | Nee | ((0)) | — |
| `PmjrExtra3` | nvarchar(5) | Ja | — | — |
| `PmjrHours` | decimal(21,2) | Nee | ((0)) | — |
| `PmjrNextWeek` | smallint | Nee | ((0)) | — |
| `PmjrQty` | decimal(21,2) | Nee | ((0)) | — |
| `PmjrRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmjrTariff` | decimal(21,5) | Nee | ((0)) | — |
| `PmjrVatId` | nvarchar(3) | Ja | — | — |
| `PmjrDataProvider` | nvarchar(50) | Ja | — | — |
| `PmjrProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PmjrTransferNextTime` | smallint | Nee | ((0)) | — |
| `PmjrExternalId` | nvarchar(50) | Ja | — | — |
| `PmjrExternalStatus` | nvarchar(50) | Ja | — | — |
| `PmjrPmIPId` | nvarchar(9) | Ja | — | — |