Bewerken: ObjectConfirmationRole

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ObjCfmrId` | nvarchar(8) | Nee | — | — |
| `ObjCfmrDescr` | nvarchar(40) | Ja | — | — |
| `ObjCfmrContext` | bigint | Nee | ((0)) | — |
| `ObjCfmrRecStatus` | int | Nee | ((0)) | — |
| `ObjCfmrAcceptanceStatement` | nvarchar(120) | Ja | — | — |
| `ObjCfmrAddedAutomatically` | smallint | Nee | ((0)) | — |
| `ObjCfmrCfmrId` | nvarchar(5) | Ja | — | — |
| `ObjCfmrChgId` | nvarchar(6) | Ja | — | — |
| `ObjCfmrCompId` | nvarchar(6) | Nee | — | — |
| `ObjCfmrConfirmed` | smallint | Nee | ((0)) | — |
| `ObjCfmrConfirmedDate` | datetimeoffset(7) | Ja | — | — |
| `ObjCfmrConfirmedEmpId` | nvarchar(9) | Ja | — | — |
| `ObjcfmrConfirmedEmployeeName` | nvarchar(100) | Ja | — | — |
| `ObjCfmrConfirmStatement` | nvarchar(120) | Ja | — | — |
| `ObjCfmrDataProvider` | nvarchar(50) | Ja | — | — |
| `ObjCfmrDepId` | nvarchar(11) | Ja | — | — |
| `ObjCfmrEmpId` | nvarchar(9) | Ja | — | — |
| `ObjCfmrExported` | smallint | Nee | ((0)) | — |
| `ObjCfmrExternalId` | nvarchar(50) | Ja | — | — |
| `ObjCfmrExternalStatus` | nvarchar(50) | Ja | — | — |
| `ObjCfmrHolder` | smallint | Nee | ((0)) | — |
| `ObjCfmrLastConfirmation` | smallint | Nee | ((0)) | — |
| `ObjCfmrLotoStatmntAddition` | nvarchar(120) | Ja | — | — |
| `ObjCfmrOrder` | smallint | Nee | ((0)) | — |
| `ObjCfmrPermId` | nvarchar(6) | Ja | — | — |
| `ObjCfmrProlongedDate` | datetimeoffset(7) | Ja | — | — |
| `ObjCfmrProvider` | smallint | Nee | ((0)) | — |
| `ObjCfmrProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ObjCfmrRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ObjCfmrRequester` | smallint | Nee | ((0)) | — |
| `ObjCfmrRequiredForAccept` | smallint | Nee | ((0)) | — |
| `ObjCfmrRequiredForPermit` | smallint | Nee | ((0)) | — |
| `ObjCfmrRequiredForProlong` | smallint | Nee | ((0)) | — |
| `ObjcfmrSignatureFile` | nvarchar(max) | Ja | — | — |
| `ObjCfmrSignatureType` | smallint | Nee | ((0)) | — |
| `ObjCfmrTransferNextTime` | smallint | Nee | ((0)) | — |
| `ObjCfmrVdrId` | nvarchar(6) | Ja | — | — |
| `ObjCfmrExternalEmployeeName` | nvarchar(200) | Ja | — | — |
| `ObjCfmrRcaId` | nvarchar(6) | Ja | — | — |