Bewerken: ArticleWarehouse

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtwArtId` | nvarchar(9) | Nee | — | — |
| `ArtwWhsId` | nvarchar(10) | Nee | — | — |
| `ArtwDescr` | nvarchar(200) | Ja | — | — |
| `ArtwContext` | bigint | Nee | ((0)) | — |
| `ArtwRecStatus` | int | Nee | ((0)) | — |
| `ArtwArtsArtId` | nvarchar(9) | Ja | — | — |
| `ArtwArtsSitId` | nvarchar(8) | Ja | — | — |
| `ArtwCompId` | nvarchar(6) | Nee | — | — |
| `ArtwDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtwExported` | smallint | Nee | ((0)) | — |
| `ArtwExternalId` | nvarchar(50) | Ja | — | — |
| `ArtwExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtwExtra1` | smallint | Nee | ((0)) | — |
| `ArtwExtra2` | smallint | Nee | ((0)) | — |
| `ArtwExtra3` | int | Nee | ((0)) | — |
| `ArtwExtra4` | int | Nee | ((0)) | — |
| `ArtwExtra5` | nvarchar(15) | Ja | — | — |
| `ArtwExtra6` | nvarchar(15) | Ja | — | — |
| `ArtwExtra7` | nvarchar(15) | Ja | — | — |
| `ArtwInPurch` | decimal(21,5) | Nee | ((0)) | — |
| `ArtwJobMat` | smallint | Nee | ((0)) | — |
| `ArtwMaximum` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwPchlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwPchrlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtwPurch` | smallint | Nee | ((1)) | — |
| `ArtwPurchLevel` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtwRepQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwResQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwSitId` | nvarchar(8) | Ja | — | — |
| `ArtwStock` | decimal(21,2) | Nee | ((0)) | — |
| `ArtwTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtwWebShop` | smallint | Nee | ((0)) | — |
| `ArtwPurchasePrepQty` | decimal(21,2) | Nee | — | — |
| `ArtwStckStatCode` | nvarchar(2) | Nee | — | — |