Bewerken: CostCenter

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `CcrId` | nvarchar(9) | Nee | — | — |
| `CcrDescr1` | nvarchar(100) | Ja | — | — |
| `CcrContext` | bigint | Nee | ((1)) | — |
| `CcrRecStatus` | int | Nee | ((1)) | — |
| `CcrActiveDate` | datetimeoffset(7) | Ja | — | — |
| `CcrActiveEmpId` | nvarchar(9) | Ja | — | — |
| `CcrAllowedPercExceeding` | smallint | Nee | ((0)) | — |
| `CcrBudgetAY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrBudgetBY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrBudgetLY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrBudgetNY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCadReportColor` | nvarchar(6) | Ja | — | — |
| `CcrCadReportPatternAngle` | int | Nee | ((0)) | — |
| `CcrCadReportPatternScale` | decimal(21,2) | Nee | ((0)) | — |
| `CcrChildBudgetAY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrChildBudRemainAY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrChildCostAY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCompId` | nvarchar(6) | Nee | — | — |
| `CcrConceptDate` | datetimeoffset(7) | Ja | — | — |
| `CcrConceptEmpId` | nvarchar(9) | Ja | — | — |
| `CcrCostAY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCostBY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCostLY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCostNY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrCrptpId` | nvarchar(4) | Ja | — | — |
| `CcrDataProvider` | nvarchar(50) | Ja | — | — |
| `CcrDescr2` | nvarchar(41) | Ja | — | — |
| `CcrDescr3` | nvarchar(41) | Ja | — | — |
| `CcrDescr4` | nvarchar(41) | Ja | — | — |
| `CcrEmpId` | nvarchar(9) | Ja | — | — |
| `CcrExpiredDate` | datetimeoffset(7) | Ja | — | — |
| `CcrExpiredEmpId` | nvarchar(9) | Ja | — | — |
| `CcrExported` | smallint | Nee | ((0)) | — |
| `CcrExternalId` | nvarchar(50) | Ja | — | — |
| `CcrExternalStatus` | nvarchar(50) | Ja | — | — |
| `CcrExtra1` | smallint | Nee | ((0)) | — |
| `CcrExtra2` | int | Nee | ((0)) | — |
| `CcrExtra3` | int | Nee | ((0)) | — |
| `CcrExtra4` | nvarchar(5) | Ja | — | — |
| `CcrExtra5` | nvarchar(5) | Ja | — | — |
| `CcrExtra6` | nvarchar(5) | Ja | — | — |
| `CcrPartOfCcrId` | nvarchar(9) | Ja | — | — |
| `CcrProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `CcrRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `CcrSumChldBudgetBY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldBudgetLY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldBudgetNY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldBudRemainBY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldBudRemainLY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldBudRemainNY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldCostBY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldCostLY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrSumChldCostNY` | decimal(21,5) | Nee | ((0)) | — |
| `CcrTransferNextTime` | smallint | Nee | ((0)) | — |
| `CcrTrfgId` | nvarchar(11) | Ja | — | — |
| `CcrBudRemainAY` | decimal(21,5) | Nee | — | — |
| `CcrBudRemainBY` | decimal(21,5) | Nee | — | — |
| `CcrBudRemainLY` | decimal(21,5) | Nee | — | — |
| `CcrBudRemainNY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudgetAY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudgetBY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudgetLY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudgetNY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudRemainAY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudRemainBY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudRemainLY` | decimal(21,5) | Nee | — | — |
| `CcrTotBudRemainNY` | decimal(21,5) | Nee | — | — |
| `CcrTotCostAY` | decimal(21,5) | Nee | — | — |
| `CcrTotCostBY` | decimal(21,5) | Nee | — | — |
| `CcrTotCostLY` | decimal(21,5) | Nee | — | — |
| `CcrTotCostNY` | decimal(21,5) | Nee | — | — |