title: "EquipmentCostYear (table)" category: reference tags: [table, equipmentcostyear, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.EquipmentCostYear
Schema: dba
Aantal kolommen: 86
Zie ook de entity-pagina: ../entities/EquipmentCostYear
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
EqmcyEqmId |
nvarchar(24) | Nee | — | — |
EqmcyContext |
bigint | Nee | ((0)) | — |
EqmcyRecStatus |
int | Nee | ((0)) | — |
EqmcyCompId |
nvarchar(6) | Nee | — | — |
EqmcyCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
EqmcyExported |
smallint | Nee | ((0)) | — |
EqmcyRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
EqmcyYear1 |
smallint | Nee | ((0)) | — |
EqmcyYear10 |
smallint | Nee | ((0)) | — |
EqmcyYear11 |
smallint | Nee | ((0)) | — |
EqmcyYear12 |
smallint | Nee | ((0)) | — |
EqmcyYear13 |
smallint | Nee | ((0)) | — |
EqmcyYear14 |
smallint | Nee | ((0)) | — |
EqmcyYear15 |
smallint | Nee | ((0)) | — |
EqmcyYear16 |
smallint | Nee | ((0)) | — |
EqmcyYear17 |
smallint | Nee | ((0)) | — |
EqmcyYear18 |
smallint | Nee | ((0)) | — |
EqmcyYear19 |
smallint | Nee | ((0)) | — |
EqmcyYear2 |
smallint | Nee | ((0)) | — |
EqmcyYear20 |
smallint | Nee | ((0)) | — |
EqmcyYear21 |
smallint | Nee | ((0)) | — |
EqmcyYear22 |
smallint | Nee | ((0)) | — |
EqmcyYear23 |
smallint | Nee | ((0)) | — |
EqmcyYear24 |
smallint | Nee | ((0)) | — |
EqmcyYear25 |
smallint | Nee | ((0)) | — |
EqmcyYear26 |
smallint | Nee | ((0)) | — |
EqmcyYear27 |
smallint | Nee | ((0)) | — |
EqmcyYear28 |
smallint | Nee | ((0)) | — |
EqmcyYear29 |
smallint | Nee | ((0)) | — |
EqmcyYear3 |
smallint | Nee | ((0)) | — |
EqmcyYear30 |
smallint | Nee | ((0)) | — |
EqmcyYear31 |
smallint | Nee | ((0)) | — |
EqmcyYear32 |
smallint | Nee | ((0)) | — |
EqmcyYear33 |
smallint | Nee | ((0)) | — |
EqmcyYear34 |
smallint | Nee | ((0)) | — |
EqmcyYear35 |
smallint | Nee | ((0)) | — |
EqmcyYear36 |
smallint | Nee | ((0)) | — |
EqmcyYear37 |
smallint | Nee | ((0)) | — |
EqmcyYear38 |
smallint | Nee | ((0)) | — |
EqmcyYear39 |
smallint | Nee | ((0)) | — |
EqmcyYear4 |
smallint | Nee | ((0)) | — |
EqmcyYear40 |
smallint | Nee | ((0)) | — |
EqmcyYear5 |
smallint | Nee | ((0)) | — |
EqmcyYear6 |
smallint | Nee | ((0)) | — |
EqmcyYear7 |
smallint | Nee | ((0)) | — |
EqmcyYear8 |
smallint | Nee | ((0)) | — |
EqmcyYear9 |
smallint | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("EquipmentCostYear")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("EquipmentCostYear")· ../entities/EquipmentCostYear Properties, contexts, statussen. Bron:Entities.xml.