title: "CostCenter (table)" category: reference tags: [table, costcenter, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.CostCenter
Schema: dba
Aantal kolommen: 71
Zie ook de entity-pagina: ../entities/CostCenter
Kolommenbewerken
| 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 | — | — |
Computed columnsbewerken
CcrBudRemainAY—(CONVERT([decimal](21,5),[CcrBudgetAY]-[CcrCostAY]))CcrBudRemainBY—(CONVERT([decimal](21,5),[CcrBudgetBY]-[CcrCostBY]))CcrBudRemainLY—(CONVERT([decimal](21,5),[CcrBudgetLY]-[CcrCostLY]))CcrBudRemainNY—(CONVERT([decimal](21,5),[CcrBudgetNY]-[CcrCostNY]))CcrTotBudgetAY—(CONVERT([decimal](21,5),[CcrChildBudgetAY]+[CcrBudgetAY]))CcrTotBudgetBY—(CONVERT([decimal](21,5),[CcrSumChldBudgetBY]+[CcrBudgetBY]))CcrTotBudgetLY—(CONVERT([decimal](21,5),[CcrSumChldBudgetLY]+[CcrBudgetLY]))CcrTotBudgetNY—(CONVERT([decimal](21,5),[CcrSumChldBudgetNY]+[CcrBudgetNY]))CcrTotBudRemainAY—(CONVERT([decimal](21,5),([CcrBudgetAY]-[CcrCostAY])+[CcrChildBudRemainAY]))CcrTotBudRemainBY—(CONVERT([decimal](21,5),(([CcrBudgetBY]-[CcrCostBY])+[CcrSumChldBudgetBY])-[CcrSumChldCostBY]))CcrTotBudRemainLY—(CONVERT([decimal](21,5),(([CcrBudgetLY]-[CcrCostLY])+[CcrSumChldBudgetLY])-[CcrSumChldCostLY]))CcrTotBudRemainNY—(CONVERT([decimal](21,5),(([CcrBudgetNY]-[CcrCostNY])+[CcrSumChldBudgetNY])-[CcrSumChldCostNY]))CcrTotCostAY—(CONVERT([decimal](21,5),[CcrChildCostAY]+[CcrCostAY]))CcrTotCostBY—(CONVERT([decimal](21,5),[CcrSumChldCostBY]+[CcrCostBY]))CcrTotCostLY—(CONVERT([decimal](21,5),[CcrSumChldCostLY]+[CcrCostLY]))CcrTotCostNY—(CONVERT([decimal](21,5),[CcrSumChldCostNY]+[CcrCostNY]))
Trigger-gevulde kolommenbewerken
CcrRecStatus← TRGU_COSTCENTERCcrBudgetAY← TRSD_BUDGETPERIOD, TRSM_BUDGETPERIODCcrBudgetBY← TRGU_UmmGlobals, TRSD_BUDGETPERIOD, TRSM_BUDGETPERIODCcrBudgetLY← TRGU_UmmGlobals, TRSD_BUDGETPERIOD, TRSM_BUDGETPERIODCcrBudgetNY← TRGU_UmmGlobals, TRSD_BUDGETPERIOD, TRSM_BUDGETPERIODCcrCostAY← TRSD_COST, TRSM_COSTCcrCostBY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTCcrCostLY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTCcrCostNY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTCcrSumChldBudgetBY← TRGU_UmmGlobalsCcrSumChldBudgetLY← TRGU_UmmGlobalsCcrSumChldBudgetNY← TRGU_UmmGlobalsCcrSumChldCostBY← TRGU_UmmGlobalsCcrSumChldCostLY← TRGU_UmmGlobalsCcrSumChldCostNY← TRGU_UmmGlobals
Brondatabewerken
- DB-schema —
lookup_table_schema("CostCenter")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("CostCenter")· ../entities/CostCenter Properties, contexts, statussen. Bron:Entities.xml.