Bewerken: CadImportLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `CimlId` | nvarchar(10) | Nee | — | — |
| `CimlDescr` | nvarchar(200) | Ja | — | — |
| `CimlContext` | bigint | Nee | ((0)) | — |
| `CimlRecStatus` | int | Nee | ((0)) | — |
| `CimlArtId` | nvarchar(9) | Ja | — | — |
| `CimlBimGuid` | nvarchar(50) | Ja | — | — |
| `CimlBldfBldpBldId` | nvarchar(11) | Ja | — | — |
| `CimlBldfBldpId` | nvarchar(11) | Ja | — | — |
| `CimlBldfId` | nvarchar(23) | Ja | — | — |
| `CimlBldId` | nvarchar(11) | Ja | — | — |
| `CimlBldpBldId` | nvarchar(11) | Ja | — | — |
| `CimlBldpId` | nvarchar(11) | Ja | — | — |
| `CimlCadHandle` | decimal(20,0) | Nee | ((0)) | — |
| `CimlCadIdHandle` | decimal(20,0) | Nee | ((0)) | — |
| `CimlCimrId` | nvarchar(6) | Ja | — | — |
| `CimlCompId` | nvarchar(6) | Nee | — | — |
| `CimlCoordinateX` | decimal(21,2) | Nee | ((0)) | — |
| `CimlCoordinateY` | decimal(21,2) | Nee | ((0)) | — |
| `CimlCount` | int | Nee | ((0)) | — |
| `CimlDataProvider` | nvarchar(50) | Ja | — | — |
| `CimlEqmId` | nvarchar(24) | Ja | — | — |
| `CimlExported` | smallint | Nee | ((0)) | — |
| `CimlExternalId` | nvarchar(50) | Ja | — | — |
| `CimlExternalStatus` | nvarchar(50) | Ja | — | — |
| `CimlFtrId` | nvarchar(6) | Ja | — | — |
| `CimlImportedBldCode` | nvarchar(11) | Ja | — | — |
| `CimlImportedBldfCode` | nvarchar(23) | Ja | — | — |
| `CimlImportedBldpCode` | nvarchar(11) | Ja | — | — |
| `CimlImportedFloorName` | nvarchar(200) | Ja | — | — |
| `CimlImportedFloorNetArea` | decimal(15,2) | Nee | ((0)) | — |
| `CimlImportedObjCode` | nvarchar(30) | Ja | — | — |
| `CimlImportedSpcCode` | nvarchar(40) | Ja | — | — |
| `CimlNewSpcCode` | nvarchar(40) | Ja | — | — |
| `CimlPrfId` | nvarchar(50) | Ja | — | — |
| `CimlProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `CimlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `CimlSpcId` | nvarchar(40) | Ja | — | — |
| `CimlTargetContext` | nvarchar(80) | Ja | — | — |
| `CimlTargetEntity` | nvarchar(100) | Ja | — | — |
| `CimlTargetEqmtId` | nvarchar(9) | Ja | — | — |
| `CimlTargetMatchProp` | nvarchar(100) | Ja | — | — |
| `CimlTargetStatus` | nvarchar(80) | Ja | — | — |
| `CimlTransferNextTime` | smallint | Nee | ((0)) | — |