title: "BudgetPeriod" category: reference tags: [entity, budget-period, datamodel] source: Entities.xml date: 2026-04-17 status: published
BudgetPeriod
Type: Entity Properties: 37 Contexts: 10 Statussen: 7
DB-schema:
lookup_table_schema("BudgetPeriod")· ../tables/BudgetPeriod
Contextsbewerken
- 0: Standaard (
BudgetPeriodContext.None) - 1: Jaar (
BudgetPeriodContext.Year) - 2: Kwartaal (
BudgetPeriodContext.Quarter) - 4: Maand (
BudgetPeriodContext.Month) - 8: Kostensoort jaar (
BudgetPeriodContext.CostTypeYear) - 16: Kostensoort kwartaal (
BudgetPeriodContext.CostTypeQuarter) - 32: Kostensoort maand (
BudgetPeriodContext.CostTypeMonth) - 64: Jaarmutatie (
BudgetPeriodContext.YearMutation) - 128: Kwartaalmutatie (
BudgetPeriodContext.QuarterMutation) - 256: Maandmutatie (
BudgetPeriodContext.MonthMutation)
Statussenbewerken
- -1: Trash (
BudgetPeriodStatus.Trash) - 0: None (
BudgetPeriodStatus.None) - 1: Aangemaakt (
BudgetPeriodStatus.Created) - 2: Aangevraagd (
BudgetPeriodStatus.Requested) - 4: Afgewezen (
BudgetPeriodStatus.Rejected) - 8: Goedgekeurd (
BudgetPeriodStatus.Approved) - 16: Automatisch toegevoegd (
BudgetPeriodStatus.AutomaticallyAdded)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | BDGPID | 12 | false | |
| Budget | CompanyMoney | BDGPBUDGET | false | 0 | |
| BudgetMutation | CompanyMoney | BDGPBUDGETMUTATION | false | 0 | |
| BudgetRemaining | CompanyMoney | BDGPBUDREMAIN | false | 0 | |
| Context | Context | BDGPCONTEXT | false | 1 | |
| Cost | CompanyMoney | BDGPCOST | false | 0 | |
| CostCenter | CostCenter | BDGPCCRID | true | ||
| CostType | CostType | BDGPCSTTID | true | ||
| Exported | Boolean | BDGPEXPORTED | false | 0 | |
| IsBudgetMutation | Boolean | BDGPISBUDGETMUTATION | false | ||
| Month | Int32 | BDGPMONTH | false | 0 | |
| PartOfBudgetPeriod | BudgetPeriod | BDGPPARTOFBDGPID | true | ||
| PartOfBudgetPeriodForBudgetMutation | BudgetPeriod | BDGPPARTOFBDGPIDFORMUTATION | true | ||
| PartOfBudgetPeriodForCostType | BudgetPeriod | BDGPPARTOFBDGPIDFORCSTT | true | ||
| PartOfBudgetPeriodForCostTypeBudgetMutation | BudgetPeriod | BDGPPARTOFBDGPIDFORCSTTMUT | true | ||
| PartOfYearBudgetPeriod | BudgetPeriod | BDGPPARTOFYEARBDGPID | true | ||
| PercentageUsed | Decimal | BDGPPERCENTAGEUSED | false | ||
| Period | UltimoString | BDGPPERIOD | 40 | true | |
| Quarter | Int32 | BDGPQUARTER | false | 0 | |
| RecordCreateDate | DateTime? | BDGPRECCREATEDATE | true | SYSDATETIME | |
| RemarkText | UltimoString | BDGPREMARKTEXT | true | ||
| SplitForCostType | Boolean | BDGPSPLITFORCOSTTYPE | false | 0 | |
| StartDate | Date | BDGPSTARTDATE | false | ||
| Status | Status | BDGPRECSTATUS | false | 1 | |
| StatusApprovedDate | DateTime? | BDGPAPPROVEDDATE | true | ||
| StatusApprovedEmployee | Employee | BDGPAPPROVEDEMPID | true | ||
| StatusAutomaticallyAddedDate | DateTime? | BDGPAUTADDDATE | true | ||
| StatusAutomaticallyAddedEmployee | Employee | BDGPAUTADDEMPID | true | ||
| StatusCreatedDate | DateTime? | BDGPCREATEDDATE | true | SYSDATETIME | |
| StatusCreatedEmployee | Employee | BDGPCREATEDEMPID | true | USERID | |
| StatusRejectedDate | DateTime? | BDGPREJECTEDDATE | true | ||
| StatusRejectedEmployee | Employee | BDGPREJECTEDEMPID | true | ||
| StatusRequestedDate | DateTime? | BDGPREQUESTEDDATE | true | ||
| StatusRequestedEmployee | Employee | BDGPREQUESTEDEMPID | true | ||
| SystemCompany | Company | BDGPCOMPID | false | ||
| TotalBudget | CompanyMoney | BDGPTOTALBUDGET | false | 0 | |
| Year | Int32 | BDGPYEAR | false | 0 |
Brondatabewerken
- Entity-definitie —
lookup_entity("BudgetPeriod")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("BudgetPeriod")· ../tables/BudgetPeriod DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="BudgetPeriod")Before/After Save events voor BudgetPeriod. Bron:workflows.xml.