title: "ConfirmationRole (table)" category: reference tags: [table, confirmationrole, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ConfirmationRole
Schema: dba
Aantal kolommen: 28
Zie ook de entity-pagina: ../entities/ConfirmationRole
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
CfmrId |
nvarchar(5) | Nee | — | — |
CfmrDescr |
nvarchar(40) | Ja | — | — |
CfmrContext |
bigint | Nee | ((0)) | — |
CfmrRecStatus |
int | Nee | ((0)) | — |
CfmrAcceptanceStatement |
nvarchar(120) | Ja | — | — |
CfmrAllowChangeOtherRoles |
smallint | Nee | ((0)) | — |
CfmrConfirmStatement |
nvarchar(120) | Ja | — | — |
CfmrDataProvider |
nvarchar(50) | Ja | — | — |
CfmrExported |
smallint | Nee | ((0)) | — |
CfmrExternalId |
nvarchar(50) | Ja | — | — |
CfmrExternalStatus |
nvarchar(50) | Ja | — | — |
CfmrHolder |
smallint | Nee | ((0)) | — |
CfmrLastConfirmation |
smallint | Nee | ((0)) | — |
CfmrLotoStatementAddition |
nvarchar(120) | Ja | — | — |
CfmrOrder |
smallint | Nee | ((0)) | — |
CfmrProvider |
smallint | Nee | ((0)) | — |
CfmrProviderMutDate |
datetimeoffset(7) | Ja | — | — |
CfmrRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
CfmrRequester |
smallint | Nee | ((0)) | — |
CfmrRequiredForAccept |
smallint | Nee | ((0)) | — |
CfmrRequiredForPermit |
smallint | Nee | ((0)) | — |
CfmrRequiredForProlong |
smallint | Nee | ((0)) | — |
CfmrSignatureType |
smallint | Nee | ((0)) | — |
CfmrSignatureTypeForAccept |
int | Nee | ((0)) | — |
CfmrSignatureTypeForProlong |
int | Nee | ((0)) | — |
CfmrTransferNextTime |
smallint | Nee | ((0)) | — |
CfmrAddAutomatically |
smallint | Nee | ((0)) | — |
CfmrValidationMandatory |
smallint | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("ConfirmationRole")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ConfirmationRole")· ../entities/ConfirmationRole Properties, contexts, statussen. Bron:Entities.xml.