title: "BudgetPeriod (table)" category: reference tags: [table, budgetperiod, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.BudgetPeriod
Schema: dba
Aantal kolommen: 37
Zie ook de entity-pagina: ../entities/BudgetPeriod
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BdgpId |
nvarchar(12) | Nee | — | — |
BdgpContext |
bigint | Nee | ((0)) | — |
BdgpRecStatus |
int | Nee | ((0)) | — |
BdgpApprovedDate |
datetimeoffset(7) | Ja | — | — |
BdgpApprovedEmpId |
nvarchar(9) | Ja | — | — |
BdgpBudget |
decimal(21,5) | Nee | ((0)) | — |
BdgpBudgetMutation |
decimal(21,5) | Nee | ((0)) | — |
BdgpCcrId |
nvarchar(9) | Ja | — | — |
BdgpCompId |
nvarchar(6) | Nee | — | — |
BdgpCost |
decimal(21,5) | Nee | ((0)) | — |
BdgpCreatedDate |
datetimeoffset(7) | Ja | — | — |
BdgpCreatedEmpId |
nvarchar(9) | Ja | — | — |
BdgpCsttId |
nvarchar(9) | Ja | — | — |
BdgpExported |
smallint | Nee | ((0)) | — |
BdgpMonth |
int | Nee | ((0)) | — |
BdgpPartOfBdgpId |
nvarchar(12) | Ja | — | — |
BdgpPartOfBdgpIdForCstt |
nvarchar(12) | Ja | — | — |
BdgpPartOfBdgpIdForCsttMut |
nvarchar(12) | Ja | — | — |
BdgpPartOfBdgpIdForMutation |
nvarchar(12) | Ja | — | — |
BdgpPartOfYearBdgpId |
nvarchar(12) | Ja | — | — |
BdgpPeriod |
nvarchar(40) | Ja | — | — |
BdgpQuarter |
int | Nee | ((0)) | — |
BdgpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BdgpRejectedDate |
datetimeoffset(7) | Ja | — | — |
BdgpRejectedEmpId |
nvarchar(9) | Ja | — | — |
BdgpRemarkText |
nvarchar(max) | Ja | — | — |
BdgpRequestedDate |
datetimeoffset(7) | Ja | — | — |
BdgpRequestedEmpId |
nvarchar(9) | Ja | — | — |
BdgpSplitForCostType |
smallint | Nee | ((0)) | — |
BdgpStartDate |
date | Nee | — | — |
BdgpYear |
int | Nee | ((0)) | — |
BdgpBudRemain |
decimal(21,5) | Nee | — | — |
BdgpIsBudgetMutation |
smallint | Nee | — | — |
BdgpPercentageUsed |
decimal(21,2) | Nee | — | — |
BdgpTotalBudget |
decimal(21,5) | Nee | — | — |
BdgpAutAddEmpId |
nvarchar(9) | Ja | — | — |
BdgpAutAddDate |
datetimeoffset(7) | Ja | — | — |
Computed columnsbewerken
BdgpBudRemain—(CONVERT([decimal](21,5),case when [BdgpContext]=(256) OR [BdgpContext]=(128) OR [BdgpContext]=(64) then (0) else ([BdgpBudget]+[BdgpBudgetMutation])-[BdgpCost] end))BdgpIsBudgetMutation—(CONVERT([smallint],case when [BdgpContext]=(256) OR [BdgpContext]=(128) OR [BdgpContext]=(64) then (1) else (0) end))BdgpPercentageUsed—(CONVERT([decimal](21,2),case when [BdgpContext]=(256) OR [BdgpContext]=(128) OR [BdgpContext]=(64) OR ([BdgpBudget]+[BdgpBudgetMutation])<=(0) then (0) else ([BdgpCost]/([BdgpBudget]+[BdgpBudgetMutation]))*(100) end))BdgpTotalBudget—(CONVERT([decimal](21,5),case when [BdgpContext]=(256) OR [BdgpContext]=(128) OR [BdgpContext]=(64) then (0) else [BdgpBudget]+[BdgpBudgetMutation] end))
Trigger-gevulde kolommenbewerken
BdgpRecStatus← TRGU_BUDGETPERIOD, TRGU_UmmGlobalsBdgpCost← TRSD_COST, TRSM_COST
Brondatabewerken
- DB-schema —
lookup_table_schema("BudgetPeriod")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("BudgetPeriod")· ../entities/BudgetPeriod Properties, contexts, statussen. Bron:Entities.xml.