title: "LTACostEstimates (table)" category: reference tags: [table, ltacostestimates, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.LTACostEstimates
Schema: dba
Aantal kolommen: 53
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
LtaceId |
nvarchar(9) | Nee | — | — |
LtaceContext |
bigint | Nee | ((0)) | — |
LtaceRecStatus |
int | Nee | ((0)) | — |
LtaceCompId |
nvarchar(6) | Nee | — | — |
LtaceDataProvider |
nvarchar(50) | Ja | — | — |
LtaceDate |
datetimeoffset(7) | Ja | — | — |
LtaceExported |
smallint | Nee | ((0)) | — |
LtaceExternalId |
nvarchar(50) | Ja | — | — |
LtaceExternalStatus |
nvarchar(50) | Ja | — | — |
LtaceLtaId |
nvarchar(10) | Ja | — | — |
LtaceProviderMutDate |
datetimeoffset(7) | Ja | — | — |
LtaceRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
LtaceTransferNextTime |
smallint | Nee | ((0)) | — |
LtaceYear1 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear10 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear11 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear12 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear13 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear14 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear15 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear16 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear17 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear18 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear19 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear2 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear20 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear21 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear22 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear23 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear24 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear25 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear26 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear27 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear28 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear29 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear3 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear30 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear31 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear32 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear33 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear34 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear35 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear36 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear37 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear38 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear39 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear4 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear40 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear5 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear6 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear7 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear8 |
decimal(21,5) | Nee | ((0)) | — |
LtaceYear9 |
decimal(21,5) | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("LTACostEstimates")Alle kolommen met types, triggers, computed. Bron:database-schema.json.