title: "Company (table)" category: reference tags: [table, company, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Company
Schema: dba
Aantal kolommen: 16
Zie ook de entity-pagina: ../entities/Company
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
CompId |
nvarchar(6) | Nee | — | — |
CompDescr |
nvarchar(50) | Ja | — | — |
CompContext |
bigint | Nee | ((0)) | — |
CompRecStatus |
int | Nee | ((0)) | — |
CompCurId |
nvarchar(5) | Nee | — | — |
CompExported |
smallint | Nee | ((0)) | — |
CompIndexLongTermAssetPercentage |
decimal(21,2) | Nee | — | — |
CompIndexPercentage |
decimal(21,2) | Nee | — | — |
CompIndexReplacementPlanning |
decimal(21,2) | Nee | — | — |
CompStartLtapSpaceYearPlan |
smallint | Nee | ((0)) | — |
CompStartSpacePlanYear |
smallint | Nee | ((0)) | — |
CompDataProvider |
nvarchar(50) | Ja | — | — |
CompProviderMutDate |
datetimeoffset(7) | Ja | — | — |
CompTransferNextTime |
smallint | Nee | ((0)) | — |
CompExternalId |
nvarchar(50) | Ja | — | — |
CompExternalStatus |
nvarchar(50) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("Company")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Company")· ../entities/Company Properties, contexts, statussen. Bron:Entities.xml.