Bewerken: Aoc

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `AocId` | nvarchar(11) | Nee | — | — |
| `AocDescr` | nvarchar(200) | Ja | — | — |
| `AocContext` | bigint | Nee | ((0)) | — |
| `AocRecStatus` | int | Nee | ((0)) | — |
| `AocDataProvider` | nvarchar(50) | Ja | — | — |
| `AocDevrId` | nvarchar(10) | Ja | — | — |
| `AocExpectedMaxDeprLife` | int | Nee | ((0)) | — |
| `AocExpectedMinDeprLife` | int | Nee | ((0)) | — |
| `AocExported` | smallint | Nee | ((0)) | — |
| `AocExternalId` | nvarchar(50) | Ja | — | — |
| `AocExternalStatus` | nvarchar(50) | Ja | — | — |
| `AocGroup` | nvarchar(2) | Ja | — | — |
| `AocLevel` | smallint | Nee | ((0)) | — |
| `AocMaingroup` | nvarchar(2) | Ja | — | — |
| `AocPartOfAocId` | nvarchar(11) | Ja | — | — |
| `AocProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `AocRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `AocReplacedByAocId` | nvarchar(11) | Ja | — | — |
| `AocReplacesAocId` | nvarchar(11) | Ja | — | — |
| `AocSubgroup` | nvarchar(2) | Ja | — | — |
| `AocTransferNextTime` | smallint | Nee | ((0)) | — |
| `AocValidEndDate` | datetimeoffset(7) | Ja | — | — |
| `AocValidFromDate` | date | Ja | — | — |