Bewerken: ArticleSiteHistory

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtshArtId` | nvarchar(9) | Nee | — | — |
| `ArtshSitId` | nvarchar(8) | Nee | — | — |
| `ArtshPeriod` | nvarchar(9) | Nee | — | — |
| `ArtshContext` | bigint | Nee | ((0)) | — |
| `ArtshRecStatus` | int | Nee | ((0)) | — |
| `ArtshDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtshDemQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshExported` | smallint | Nee | ((0)) | — |
| `ArtshExternalId` | nvarchar(50) | Ja | — | — |
| `ArtshExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtshExtra1` | decimal(21,0) | Nee | ((0)) | — |
| `ArtshExtra2` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshExtra3` | decimal(21,0) | Nee | ((0)) | — |
| `ArtshInvQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtshPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshRcvQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtshTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtshWhsMutInQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtshWhsMutOutQty` | decimal(21,2) | Nee | ((0)) | — |