title: "Cost (table)" category: reference tags: [table, cost, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Cost
Schema: dba
Aantal kolommen: 56
Zie ook de entity-pagina: ../entities/Cost
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
CstContext |
bigint | Nee | ((0)) | — |
CstRecStatus |
int | Nee | ((0)) | — |
CstAccId |
nvarchar(11) | Ja | — | — |
CstActiveDate |
datetimeoffset(7) | Ja | — | — |
CstActiveEmpId |
nvarchar(9) | Ja | — | — |
CstBdgpId |
nvarchar(12) | Ja | — | — |
CstBdgpIdForCstt |
nvarchar(12) | Ja | — | — |
CstBookDate |
date | Ja | — | — |
CstCcrId |
nvarchar(9) | Ja | — | — |
CstCompId |
nvarchar(6) | Nee | — | — |
CstCreatedDate |
datetimeoffset(7) | Ja | — | — |
CstCreatedEmpId |
nvarchar(9) | Ja | — | — |
CstCsttId |
nvarchar(9) | Ja | — | — |
CstCusId |
nvarchar(6) | Ja | — | — |
CstDate |
date | Ja | — | — |
CstDepId |
nvarchar(11) | Ja | — | — |
CstEqmId |
nvarchar(24) | Ja | — | — |
CstExpiredDate |
datetimeoffset(7) | Ja | — | — |
CstExpiredEmpId |
nvarchar(9) | Ja | — | — |
CstExported |
smallint | Nee | ((0)) | — |
CstExtCost |
decimal(21,5) | Nee | ((0)) | — |
CstHours |
decimal(21,2) | Nee | ((0)) | — |
CstInvCost |
decimal(21,5) | Nee | ((0)) | — |
CstInvId |
nvarchar(9) | Ja | — | — |
CstInvlLineId |
nvarchar(4) | Ja | — | — |
CstJobeJobId |
nvarchar(12) | Ja | — | — |
CstJobeLineId |
nvarchar(9) | Ja | — | — |
CstJobId |
nvarchar(12) | Ja | — | — |
CstJobtJobId |
nvarchar(12) | Ja | — | — |
CstJobtLineId |
nvarchar(9) | Ja | — | — |
CstJobwlJobId |
nvarchar(12) | Ja | — | — |
CstJobwlLineId |
nvarchar(9) | Ja | — | — |
CstJobwlWeek |
int | Ja | — | — |
CstLabCost |
decimal(21,5) | Nee | ((0)) | — |
CstMembId |
nvarchar(9) | Ja | — | — |
CstMemblLineId |
nvarchar(9) | Ja | — | — |
CstMemorandumCost |
decimal(21,5) | Nee | ((0)) | — |
CstPchId |
nvarchar(10) | Ja | — | — |
CstPchlId |
nvarchar(4) | Ja | — | — |
CstPrfId |
nvarchar(50) | Ja | — | — |
CstPrjId |
nvarchar(6) | Ja | — | — |
CstPurchCost |
decimal(21,5) | Nee | ((0)) | — |
CstRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
CstSitId |
nvarchar(8) | Ja | — | — |
CstSkcId |
nvarchar(9) | Ja | — | — |
CstSvcId |
nvarchar(9) | Ja | — | — |
CstTlsCost |
decimal(21,5) | Nee | ((0)) | — |
CstWhsoCost |
decimal(21,5) | Nee | ((0)) | — |
CstWhsoId |
nvarchar(9) | Ja | — | — |
CstCalculatedCost |
decimal(21,5) | Nee | — | — |
CstId |
uniqueidentifier | Nee | — | — |
CstDataProvider |
nvarchar(50) | Ja | — | — |
CstProviderMutDate |
datetimeoffset(7) | Ja | — | — |
CstTransferNextTime |
smallint | Nee | ((0)) | — |
CstExternalId |
nvarchar(50) | Ja | — | — |
CstExternalStatus |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
CstCalculatedCost—(CONVERT([decimal](21,5),((((([cstextcost]+[cstinvcost])+[cstlabcost])+[cstmemorandumcost])+[cstpurchcost])+[csttlscost])+[cstwhsocost]))
Trigger-gevulde kolommenbewerken
CstRecStatus← TRGU_UmmGlobals
Brondatabewerken
- DB-schema —
lookup_table_schema("Cost")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Cost")· ../entities/Cost Properties, contexts, statussen. Bron:Entities.xml.