Bewerken: ArticleSite

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtsArtId` | nvarchar(9) | Nee | — | — |
| `ArtsSitId` | nvarchar(8) | Nee | — | — |
| `ArtsContext` | bigint | Nee | ((0)) | — |
| `ArtsRecStatus` | int | Nee | ((0)) | — |
| `ArtsCompId` | nvarchar(6) | Nee | — | — |
| `ArtsDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtsExported` | smallint | Nee | ((0)) | — |
| `ArtsExternalId` | nvarchar(50) | Ja | — | — |
| `ArtsExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtsMaximum` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsPchlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsPchrlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtsPurch` | smallint | Nee | ((0)) | — |
| `ArtsPurchLevel` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtsRepQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsResQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsStock` | decimal(21,2) | Nee | ((0)) | — |
| `ArtsTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtsPurchasePrepQty` | decimal(21,2) | Nee | — | — |
| `ArtsStckStatCode` | nvarchar(2) | Nee | — | — |
| `ArtsVdrId` | nvarchar(6) | Ja | — | — |
| `ArtsHasPreferredVendor` | smallint | Nee | ((0)) | — |
| `ArtsPurchPrice` | decimal(21,5) | Nee | ((0)) | — |
| `ArtsPurchPrDate` | date | Ja | — | — |
| `ArtsVatId` | nvarchar(3) | Ja | — | — |
| `ArtsRseId` | nvarchar(5) | Ja | — | — |
| `ArtsIntRseId` | nvarchar(5) | Ja | — | — |
| `ArtsExtRseId` | nvarchar(5) | Ja | — | — |
| `ArtsAbcId` | nvarchar(9) | Ja | — | — |
| `ArtsOverwriteAbcCode` | smallint | Nee | ((0)) | — |
| `ArtsAbcCodeIdGenerated` | nvarchar(9) | Ja | — | — |