title: "ProcessFunctionCostYear (table)" category: reference tags: [table, processfunctioncostyear, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ProcessFunctionCostYear
Schema: dba
Aantal kolommen: 86
Zie ook de entity-pagina: ../entities/ProcessFunctionCostYear
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PrfcyPrfId |
nvarchar(50) | Nee | — | — |
PrfcyContext |
bigint | Nee | ((0)) | — |
PrfcyRecStatus |
int | Nee | ((0)) | — |
PrfcyCompId |
nvarchar(6) | Nee | — | — |
PrfcyCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
PrfcyExported |
smallint | Nee | ((0)) | — |
PrfcyRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PrfcyYear1 |
smallint | Nee | ((0)) | — |
PrfcyYear10 |
smallint | Nee | ((0)) | — |
PrfcyYear11 |
smallint | Nee | ((0)) | — |
PrfcyYear12 |
smallint | Nee | ((0)) | — |
PrfcyYear13 |
smallint | Nee | ((0)) | — |
PrfcyYear14 |
smallint | Nee | ((0)) | — |
PrfcyYear15 |
smallint | Nee | ((0)) | — |
PrfcyYear16 |
smallint | Nee | ((0)) | — |
PrfcyYear17 |
smallint | Nee | ((0)) | — |
PrfcyYear18 |
smallint | Nee | ((0)) | — |
PrfcyYear19 |
smallint | Nee | ((0)) | — |
PrfcyYear2 |
smallint | Nee | ((0)) | — |
PrfcyYear20 |
smallint | Nee | ((0)) | — |
PrfcyYear21 |
smallint | Nee | ((0)) | — |
PrfcyYear22 |
smallint | Nee | ((0)) | — |
PrfcyYear23 |
smallint | Nee | ((0)) | — |
PrfcyYear24 |
smallint | Nee | ((0)) | — |
PrfcyYear25 |
smallint | Nee | ((0)) | — |
PrfcyYear26 |
smallint | Nee | ((0)) | — |
PrfcyYear27 |
smallint | Nee | ((0)) | — |
PrfcyYear28 |
smallint | Nee | ((0)) | — |
PrfcyYear29 |
smallint | Nee | ((0)) | — |
PrfcyYear3 |
smallint | Nee | ((0)) | — |
PrfcyYear30 |
smallint | Nee | ((0)) | — |
PrfcyYear31 |
smallint | Nee | ((0)) | — |
PrfcyYear32 |
smallint | Nee | ((0)) | — |
PrfcyYear33 |
smallint | Nee | ((0)) | — |
PrfcyYear34 |
smallint | Nee | ((0)) | — |
PrfcyYear35 |
smallint | Nee | ((0)) | — |
PrfcyYear36 |
smallint | Nee | ((0)) | — |
PrfcyYear37 |
smallint | Nee | ((0)) | — |
PrfcyYear38 |
smallint | Nee | ((0)) | — |
PrfcyYear39 |
smallint | Nee | ((0)) | — |
PrfcyYear4 |
smallint | Nee | ((0)) | — |
PrfcyYear40 |
smallint | Nee | ((0)) | — |
PrfcyYear5 |
smallint | Nee | ((0)) | — |
PrfcyYear6 |
smallint | Nee | ((0)) | — |
PrfcyYear7 |
smallint | Nee | ((0)) | — |
PrfcyYear8 |
smallint | Nee | ((0)) | — |
PrfcyYear9 |
smallint | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
PrfcyPrfId← TRGI_ProcessFunctionPrfcyCompId← TRGI_ProcessFunctionPrfcyCostYear1← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear10← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear11← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear12← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear13← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear14← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear15← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear16← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear17← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear18← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear19← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear2← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear20← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear21← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear22← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear23← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear24← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear25← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear26← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear27← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear28← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear29← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear3← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear30← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear31← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear32← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear33← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear34← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear35← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear36← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear37← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear38← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear39← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear4← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear40← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear5← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear6← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear7← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear8← TRGU_Company, TRGU_ProcessFunctionPrfcyCostYear9← TRGU_Company, TRGU_ProcessFunctionPrfcyYear1← TRGU_ProcessFunctionPrfcyYear10← TRGU_ProcessFunctionPrfcyYear11← TRGU_ProcessFunctionPrfcyYear12← TRGU_ProcessFunctionPrfcyYear13← TRGU_ProcessFunctionPrfcyYear14← TRGU_ProcessFunctionPrfcyYear15← TRGU_ProcessFunctionPrfcyYear16← TRGU_ProcessFunctionPrfcyYear17← TRGU_ProcessFunctionPrfcyYear18← TRGU_ProcessFunctionPrfcyYear19← TRGU_ProcessFunctionPrfcyYear2← TRGU_ProcessFunctionPrfcyYear20← TRGU_ProcessFunctionPrfcyYear21← TRGU_ProcessFunctionPrfcyYear22← TRGU_ProcessFunctionPrfcyYear23← TRGU_ProcessFunctionPrfcyYear24← TRGU_ProcessFunctionPrfcyYear25← TRGU_ProcessFunctionPrfcyYear26← TRGU_ProcessFunctionPrfcyYear27← TRGU_ProcessFunctionPrfcyYear28← TRGU_ProcessFunctionPrfcyYear29← TRGU_ProcessFunctionPrfcyYear3← TRGU_ProcessFunctionPrfcyYear30← TRGU_ProcessFunctionPrfcyYear31← TRGU_ProcessFunctionPrfcyYear32← TRGU_ProcessFunctionPrfcyYear33← TRGU_ProcessFunctionPrfcyYear34← TRGU_ProcessFunctionPrfcyYear35← TRGU_ProcessFunctionPrfcyYear36← TRGU_ProcessFunctionPrfcyYear37← TRGU_ProcessFunctionPrfcyYear38← TRGU_ProcessFunctionPrfcyYear39← TRGU_ProcessFunctionPrfcyYear4← TRGU_ProcessFunctionPrfcyYear40← TRGU_ProcessFunctionPrfcyYear5← TRGU_ProcessFunctionPrfcyYear6← TRGU_ProcessFunctionPrfcyYear7← TRGU_ProcessFunctionPrfcyYear8← TRGU_ProcessFunctionPrfcyYear9← TRGU_ProcessFunction
Brondatabewerken
- DB-schema —
lookup_table_schema("ProcessFunctionCostYear")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ProcessFunctionCostYear")· ../entities/ProcessFunctionCostYear Properties, contexts, statussen. Bron:Entities.xml.