Bewerken: CraftsMan

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `CrmId` | nvarchar(6) | Nee | — | — |
| `CrmDescr1` | nvarchar(41) | Ja | — | — |
| `CrmContext` | bigint | Nee | ((1)) | — |
| `CrmRecStatus` | int | Nee | ((0)) | — |
| `CrmCmnt1` | nvarchar(41) | Ja | — | — |
| `CrmCmnt2` | nvarchar(41) | Ja | — | — |
| `CrmCmnt3` | nvarchar(41) | Ja | — | — |
| `CrmDataProvider` | nvarchar(50) | Ja | — | — |
| `CrmExported` | smallint | Nee | ((0)) | — |
| `CrmExternalId` | nvarchar(50) | Ja | — | — |
| `CrmExternalStatus` | nvarchar(50) | Ja | — | — |
| `CrmHours` | decimal(21,2) | Nee | ((0)) | — |
| `CrmProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `CrmRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `CrmSkcId` | nvarchar(9) | Ja | — | — |
| `CrmTariff1` | decimal(21,5) | Nee | ((0)) | — |
| `CrmTariff2` | decimal(21,5) | Nee | ((0)) | — |
| `CrmTariff3` | decimal(21,5) | Nee | ((0)) | — |
| `CrmTariff4` | decimal(21,5) | Nee | ((0)) | — |
| `CrmTransferNextTime` | smallint | Nee | ((0)) | — |