Bewerken: Incident

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `IncId` | nvarchar(10) | Nee | — | — |
| `IncDescr` | nvarchar(200) | Ja | — | — |
| `IncContext` | bigint | Nee | ((0)) | — |
| `IncRecStatus` | int | Nee | ((0)) | — |
| `IncAInccId` | nvarchar(5) | Ja | — | — |
| `IncBInccId` | nvarchar(5) | Ja | — | — |
| `IncCausedBy` | smallint | Nee | ((0)) | — |
| `IncCity` | nvarchar(100) | Ja | — | — |
| `IncCompId` | nvarchar(6) | Nee | — | — |
| `IncCostCalcCargoDamage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCalcLoss` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCalcObjectDamage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCalcReplacementVehicle` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCalcThirdPartySettlement` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCalcTowingAndSalvage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostCargoDamage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostLoss` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostObjectDamage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostReplacementVehicle` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostSourceDamage` | smallint | Nee | ((0)) | — |
| `IncCostThirdPartySettlement` | decimal(21,5) | Nee | ((0)) | — |
| `IncCostTowingAndSalvage` | decimal(21,5) | Nee | ((0)) | — |
| `IncCountry` | nvarchar(100) | Ja | — | — |
| `IncDate` | datetimeoffset(7) | Ja | — | — |
| `IncEmpId` | nvarchar(9) | Ja | — | — |
| `IncEqmId` | nvarchar(24) | Ja | — | — |
| `IncExported` | smallint | Nee | ((0)) | — |
| `IncExternal` | decimal(21,5) | Nee | ((0)) | — |
| `IncExternalCalc` | decimal(21,5) | Nee | ((0)) | — |
| `IncImageFile1` | nvarchar(max) | Ja | — | — |
| `IncImageFile2` | nvarchar(max) | Ja | — | — |
| `IncImageFile3` | nvarchar(max) | Ja | — | — |
| `IncImageFile4` | nvarchar(max) | Ja | — | — |
| `IncImageFile5` | nvarchar(max) | Ja | — | — |
| `IncImageFile6` | nvarchar(max) | Ja | — | — |
| `IncImageFile7` | nvarchar(max) | Ja | — | — |
| `IncImageFile8` | nvarchar(max) | Ja | — | — |
| `IncInctId` | nvarchar(5) | Ja | — | — |
| `IncInvolvedEmpId` | nvarchar(9) | Ja | — | — |
| `IncInvolvedParty` | nvarchar(max) | Ja | — | — |
| `IncRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `IncRedress` | decimal(21,5) | Nee | ((0)) | — |
| `IncRedressCalc` | decimal(21,5) | Nee | ((0)) | — |
| `IncRepayment` | decimal(21,5) | Nee | ((0)) | — |
| `IncRepaymentCalc` | decimal(21,5) | Nee | ((0)) | — |
| `IncReportDate` | datetimeoffset(7) | Ja | — | — |
| `IncReportEmpId` | nvarchar(9) | Ja | — | — |
| `IncSitId` | nvarchar(8) | Ja | — | — |
| `IncStreet` | nvarchar(100) | Ja | — | — |
| `IncText1` | nvarchar(max) | Ja | — | — |
| `IncText2` | nvarchar(max) | Ja | — | — |
| `IncText3` | nvarchar(max) | Ja | — | — |
| `IncCost` | decimal(20,5) | Nee | — | — |
| `IncCostCalc` | decimal(20,5) | Nee | — | — |
| `IncReturn` | decimal(21,5) | Nee | — | — |
| `IncReturnCalc` | decimal(20,5) | Nee | — | — |
| `IncDataProvider` | nvarchar(50) | Ja | — | — |
| `IncProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `IncTransferNextTime` | smallint | Nee | ((0)) | — |
| `IncExternalId` | nvarchar(50) | Ja | — | — |
| `IncExternalStatus` | nvarchar(50) | Ja | — | — |