title: "ServContract (table)" category: reference tags: [table, servcontract, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ServContract
Schema: dba
Aantal kolommen: 85
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
SvcId |
nvarchar(9) | Nee | — | — |
SvcDescr1 |
nvarchar(200) | Ja | — | — |
SvcContext |
bigint | Nee | ((1)) | — |
SvcRecStatus |
int | Nee | ((0)) | — |
SvcActEmpId |
nvarchar(9) | Ja | — | — |
SvcActiveDate |
datetimeoffset(7) | Ja | — | — |
SvcArticleDiscountPercentage |
decimal(21,2) | Nee | ((0)) | — |
SvcCcrId |
nvarchar(9) | Ja | — | — |
SvcChangeDate |
datetimeoffset(7) | Ja | — | — |
SvcCmnt1 |
nvarchar(41) | Ja | — | — |
SvcCmnt2 |
nvarchar(41) | Ja | — | — |
SvcCommences |
date | Ja | — | — |
SvcCompId |
nvarchar(6) | Nee | — | — |
SvcContractAssessmentFrequency |
smallint | Nee | ((0)) | — |
SvcContractAssessmentPeriodic |
smallint | Nee | ((0)) | — |
SvcContractAssessmentReason |
nvarchar(200) | Ja | — | — |
SvcContractAssessmentScore |
smallint | Nee | ((0)) | — |
SvcCorrespondenceAddress |
smallint | Nee | ((0)) | — |
SvcCost1 |
decimal(21,5) | Nee | ((0)) | — |
SvcCost2 |
decimal(21,5) | Nee | ((0)) | — |
SvcCreateDate |
datetimeoffset(7) | Ja | — | — |
SvcCusId |
nvarchar(6) | Ja | — | — |
SvcDataProvider |
nvarchar(50) | Ja | — | — |
SvcDateVisit |
date | Ja | — | — |
SvcDepId |
nvarchar(11) | Ja | — | — |
SvcEndDate |
date | Ja | — | — |
SvcExcess |
decimal(21,5) | Nee | ((0)) | — |
SvcExpires |
date | Ja | — | — |
SvcExported |
smallint | Nee | ((0)) | — |
SvcExternalId |
nvarchar(50) | Ja | — | — |
SvcExternalStatus |
nvarchar(50) | Ja | — | — |
SvcExtra1 |
smallint | Nee | ((0)) | — |
SvcExtra2 |
int | Nee | ((0)) | — |
SvcExtra3 |
int | Nee | ((0)) | — |
SvcExtra4 |
nvarchar(5) | Ja | — | — |
SvcExtra5 |
nvarchar(5) | Ja | — | — |
SvcExtra6 |
nvarchar(5) | Ja | — | — |
SvcExtra7 |
nvarchar(5) | Ja | — | — |
SvcExtra8 |
nvarchar(5) | Ja | — | — |
SvcFileId |
nvarchar(41) | Ja | — | — |
SvcImpId |
nvarchar(11) | Ja | — | — |
SvcInsuredValue |
decimal(21,5) | Nee | ((0)) | — |
SvcInvoiced |
decimal(21,5) | Nee | ((0)) | — |
SvcInvoicedLY |
decimal(21,5) | Nee | ((0)) | — |
SvcJobContext |
bigint | Nee | ((0)) | — |
SvcLastContractAssessmentDate |
date | Ja | — | — |
SvcManagDepId |
nvarchar(11) | Ja | — | — |
SvcManagEmpId |
nvarchar(9) | Ja | — | — |
SvcNextContractAssessmentDate |
date | Ja | — | — |
SvcNrOfVisits |
int | Nee | ((0)) | — |
SvcOtherPartyTerminateFrqCnt |
int | Nee | ((0)) | — |
SvcOurPartyTerminateFrqCount |
int | Nee | ((0)) | — |
SvcOwnerEmpId |
nvarchar(9) | Ja | — | — |
SvcPayerCusId |
nvarchar(6) | Ja | — | — |
SvcPayerEmpId |
nvarchar(9) | Ja | — | — |
SvcPolicyFee |
decimal(21,5) | Nee | ((0)) | — |
SvcProviderMutDate |
datetimeoffset(7) | Ja | — | — |
SvcPurchCommit |
decimal(21,5) | Nee | ((0)) | — |
SvcPurchCommitLY |
decimal(21,5) | Nee | ((0)) | — |
SvcPymmId |
nvarchar(3) | Ja | — | — |
SvcPymtId |
nvarchar(5) | Ja | — | — |
SvcRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
SvcRenewalTermFrqCount |
int | Nee | ((0)) | — |
SvcRenewalTermFrqId |
nvarchar(3) | Ja | — | — |
SvcSetCost1 |
smallint | Nee | ((0)) | — |
SvcSilentProlong |
smallint | Nee | ((0)) | — |
SvcSitId |
nvarchar(8) | Ja | — | — |
SvcSpcId |
nvarchar(40) | Ja | — | — |
SvcStartDate |
date | Ja | — | — |
SvcSvcfId |
nvarchar(5) | Ja | — | — |
SvcSvctId |
nvarchar(5) | Ja | — | — |
SvcTermWarning |
int | Nee | ((0)) | — |
SvcText |
nvarchar(max) | Ja | — | — |
SvcText1 |
nvarchar(max) | Ja | — | — |
SvcToExpire |
smallint | Nee | ((0)) | — |
SvcTotalInvoiced |
decimal(21,5) | Nee | ((0)) | — |
SvcTotalInvoicedQty |
decimal(21,2) | Nee | ((0)) | — |
SvcTotalPurchCommit |
decimal(21,5) | Nee | ((0)) | — |
SvcTotalPurchCommitQty |
decimal(21,2) | Nee | ((0)) | — |
SvcTotalPurchContract |
decimal(21,5) | Nee | ((0)) | — |
SvcTotalPurchContractQty |
decimal(21,2) | Nee | ((0)) | — |
SvcTransferNextTime |
smallint | Nee | ((0)) | — |
SvcVdrId |
nvarchar(6) | Ja | — | — |
SvcFileExtension |
nvarchar(5) | Nee | — | — |
SVCTEXT_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
SvcFileExtension—(N'.html')SVCTEXT_FT—(case when [SVCTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([SVCTEXT],(5))=N'<html' then [SVCTEXT] else N'<html lang="nl">'+[SVCTEXT] end) end)
Trigger-gevulde kolommenbewerken
SvcCost1← TRGU_ServContract, TRSD_OBJECTSERVCONTRACT, TRSM_OBJECTSERVCONTRACTSvcInvoiced← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTSvcInvoicedLY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTSvcPurchCommit← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTSvcPurchCommitLY← TRGU_UmmGlobals, TRSD_COST, TRSM_COSTSvcSetCost1← TRGU_ServContractSvcTotalInvoiced← TRSD_COST, TRSM_COSTSvcTotalPurchCommit← TRSD_COST, TRSM_COSTSvcTotalPurchContract← TRSD_SERVCONTRACTLINE, TRSM_SERVCONTRACTLINESvcTotalPurchContractQty← TRSD_SERVCONTRACTLINE, TRSM_SERVCONTRACTLINE
Brondatabewerken
- DB-schema —
lookup_table_schema("ServContract")Alle kolommen met types, triggers, computed. Bron:database-schema.json.