Bewerken: BudgetPeriod

Sectie: Properties

Reden:

## Properties

| 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 |