Bewerken: BudgetPeriod

Sectie: Kolommen

Reden:

## Kolommen

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