title: "ObjectIncident (table)" category: reference tags: [table, objectincident, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ObjectIncident
Schema: dba
Aantal kolommen: 34
Zie ook de entity-pagina: ../entities/ObjectIncident
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ObjincId |
nvarchar(11) | Nee | — | — |
ObjincDescr |
nvarchar(200) | Ja | — | — |
ObjincContext |
bigint | Nee | ((0)) | — |
ObjincRecStatus |
int | Nee | ((0)) | — |
ObjincCompId |
nvarchar(6) | Nee | — | — |
ObjincCostCalcCargoDamage |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCalcLoss |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCalcObjectDamage |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCalcReplacementVehicle |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCalcThirdPartySettlement |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCalcTowingAndSalvage |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostCargoDamage |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostLoss |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostObjectDamage |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostReplacementVehicle |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostThirdPartySettlement |
decimal(21,5) | Nee | ((0)) | — |
ObjincCostTowingAndSalvage |
decimal(21,5) | Nee | ((0)) | — |
ObjincEmpId |
nvarchar(9) | Ja | — | — |
ObjincEqmId |
nvarchar(24) | Ja | — | — |
ObjincExported |
smallint | Nee | ((0)) | — |
ObjincIncId |
nvarchar(10) | Ja | — | — |
ObjincRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ObjincReference |
nvarchar(100) | Ja | — | — |
ObjincRepayment |
decimal(21,5) | Nee | ((0)) | — |
ObjincReportDate |
datetimeoffset(7) | Ja | — | — |
ObjincSvcId |
nvarchar(9) | Ja | — | — |
ObjincText |
nvarchar(max) | Ja | — | — |
ObjincCost |
decimal(20,5) | Nee | — | — |
ObjincCostCalc |
decimal(20,5) | Nee | — | — |
ObjincDataProvider |
nvarchar(50) | Ja | — | — |
ObjincProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ObjincTransferNextTime |
smallint | Nee | ((0)) | — |
ObjincExternalId |
nvarchar(50) | Ja | — | — |
ObjincExternalStatus |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
ObjincCost—(CONVERT([decimal](20,5),(((([ObjincCostObjectDamage]+[ObjincCostCargoDamage])+[ObjincCostTowingAndSalvage])+[ObjincCostThirdPartySettlement])+[ObjincCostReplacementVehicle])+[ObjincCostLoss]))ObjincCostCalc—(CONVERT([decimal](20,5),(((([ObjincCostCalcObjectDamage]+[ObjincCostCalcCargoDamage])+[ObjincCostCalcTowingAndSalvage])+[ObjincCostCalcThirdPartySettlement])+[ObjincCostCalcReplacementVehicle])+[ObjincCostCalcLoss]))
Trigger-gevulde kolommenbewerken
ObjincRecStatus← TRGU_Incident
Brondatabewerken
- DB-schema —
lookup_table_schema("ObjectIncident")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ObjectIncident")· ../entities/ObjectIncident Properties, contexts, statussen. Bron:Entities.xml.