Bewerken: ArticleSiteVendor

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtsvArtId` | nvarchar(9) | Nee | — | — |
| `ArtsvSitId` | nvarchar(8) | Nee | — | — |
| `ArtsvVdrId` | nvarchar(6) | Nee | — | — |
| `ArtsvContext` | bigint | Nee | ((0)) | — |
| `ArtsvRecStatus` | int | Nee | ((0)) | — |
| `ArtsvArtUntPr` | decimal(21,5) | Nee | ((0)) | — |
| `ArtsvArtUntPrDate` | date | Ja | — | — |
| `ArtsvCompId` | nvarchar(6) | Nee | — | — |
| `ArtsvCurId` | nvarchar(5) | Nee | — | — |
| `ArtsvDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtsvDiscount` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsvExported` | smallint | Nee | ((0)) | — |
| `ArtsvExternalId` | nvarchar(50) | Ja | — | — |
| `ArtsvExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtsvExtra1` | nvarchar(15) | Ja | — | — |
| `ArtsvExtra2` | nvarchar(15) | Ja | — | — |
| `ArtsvExtra3` | smallint | Nee | ((0)) | — |
| `ArtsvExtra4` | int | Nee | ((0)) | — |
| `ArtsvLeadTime` | int | Nee | ((0)) | — |
| `ArtsvMinPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsvPreference` | smallint | Nee | ((0)) | — |
| `ArtsvProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtsvPurchCode` | nvarchar(60) | Ja | — | — |
| `ArtsvPurchQtyCeilSignific` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsvQtyPurchUnt` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsvRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtsvTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtsvUntDescr` | nvarchar(9) | Ja | — | — |