Bewerken: PmjExt

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmjePmwId` | nvarchar(5) | Nee | — | — |
| `PmjePmjId` | nvarchar(3) | Nee | — | — |
| `PmjeLineId` | nvarchar(9) | Nee | — | — |
| `PmjeDescr` | nvarchar(200) | Ja | — | — |
| `PmjeContext` | bigint | Nee | ((0)) | — |
| `PmjeRecStatus` | int | Nee | ((0)) | — |
| `PmjeCompId` | nvarchar(6) | Nee | — | — |
| `PmjeCost` | decimal(21,5) | Nee | ((0)) | — |
| `PmjeExported` | smallint | Nee | ((0)) | — |
| `PmjeExtId` | nvarchar(5) | Ja | — | — |
| `PmjeExtra1` | smallint | Nee | ((0)) | — |
| `PmjeExtra2` | decimal(21,2) | Nee | ((0)) | — |
| `PmjeExtra3` | nvarchar(5) | Ja | — | — |
| `PmjeQty` | decimal(21,2) | Nee | ((0)) | — |
| `PmjeRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmjeTariff` | decimal(21,5) | Nee | ((0)) | — |
| `PmjeUnit` | nvarchar(5) | Ja | — | — |
| `PmjeVatId` | nvarchar(3) | Ja | — | — |
| `PmjeVdrId` | nvarchar(6) | Ja | — | — |
| `PmjeDataProvider` | nvarchar(50) | Ja | — | — |
| `PmjeProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PmjeTransferNextTime` | smallint | Nee | ((0)) | — |
| `PmjeExternalId` | nvarchar(50) | Ja | — | — |
| `PmjeExternalStatus` | nvarchar(50) | Ja | — | — |