Bewerken: CrmHourCat

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `CrmhcCrmId` | nvarchar(6) | Nee | — | — |
| `CrmhcHtcId` | nvarchar(5) | Nee | — | — |
| `CrmhcContext` | bigint | Nee | ((0)) | — |
| `CrmhcRecStatus` | int | Nee | ((0)) | — |
| `CrmhcCompId` | nvarchar(6) | Nee | — | — |
| `CrmhcDataProvider` | nvarchar(50) | Ja | — | — |
| `CrmhcExported` | smallint | Nee | ((0)) | — |
| `CrmhcExternalId` | nvarchar(50) | Ja | — | — |
| `CrmhcExternalStatus` | nvarchar(50) | Ja | — | — |
| `CrmhcExtra1` | nvarchar(15) | Ja | — | — |
| `CrmhcExtra2` | nvarchar(15) | Ja | — | — |
| `CrmhcExtra3` | smallint | Nee | ((0)) | — |
| `CrmhcExtra4` | smallint | Nee | ((0)) | — |
| `CrmhcExtra5` | int | Nee | ((0)) | — |
| `CrmhcExtTariff` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcIntTariff` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `CrmhcRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `CrmhcStdTariff` | smallint | Nee | ((0)) | — |
| `CrmhcTariff` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcTransferNextTime` | smallint | Nee | ((0)) | — |
| `CrmhcTariff1` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcTariff2` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcTariff3` | decimal(21,5) | Nee | ((0)) | — |
| `CrmhcTariff4` | decimal(21,5) | Nee | ((0)) | — |