Bewerken: ArticleVendor

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtvArtId` | nvarchar(9) | Nee | — | — |
| `ArtvVdrId` | nvarchar(6) | Nee | — | — |
| `ArtvContext` | bigint | Nee | ((0)) | — |
| `ArtvRecStatus` | int | Nee | ((0)) | — |
| `ArtvArtUntPr` | decimal(21,5) | Nee | ((0)) | — |
| `ArtvArtUntPrDate` | date | Ja | — | — |
| `ArtvCurId` | nvarchar(5) | Nee | — | — |
| `ArtvDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtvDiscount` | decimal(21,2) | Nee | ((0)) | — |
| `ArtvExported` | smallint | Nee | ((0)) | — |
| `ArtvExternalId` | nvarchar(50) | Ja | — | — |
| `ArtvExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtvExtra1` | nvarchar(15) | Ja | — | — |
| `ArtvExtra2` | nvarchar(15) | Ja | — | — |
| `ArtvExtra3` | smallint | Nee | ((0)) | — |
| `ArtvExtra4` | int | Nee | ((0)) | — |
| `ArtvLeadTime` | int | Nee | ((0)) | — |
| `ArtvMinPurchQty` | decimal(21,2) | Nee | ((1)) | — |
| `ArtvPreference` | smallint | Nee | ((0)) | — |
| `ArtvProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtvPurchCode` | nvarchar(60) | Ja | — | — |
| `ArtvPurchQtyCeilSignific` | decimal(21,2) | Nee | ((0)) | — |
| `ArtvQtyPurchUnt` | decimal(21,2) | Nee | ((1)) | — |
| `ArtvRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtvTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtvUntDescr` | nvarchar(9) | Ja | — | — |