Bewerken: Article

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ArtId` | nvarchar(9) | Nee | — | — |
| `ArtDescr` | nvarchar(200) | Ja | — | — |
| `ArtContext` | bigint | Nee | ((1)) | — |
| `ArtRecStatus` | int | Nee | ((0)) | — |
| `ArtAbc` | nvarchar(2) | Ja | — | — |
| `ArtAgId` | nvarchar(9) | Ja | — | — |
| `ArtCategory` | nvarchar(2) | Ja | — | — |
| `ArtCompId` | nvarchar(6) | Nee | — | — |
| `ArtDataProvider` | nvarchar(50) | Ja | — | — |
| `ArtDateAppr` | datetimeoffset(7) | Ja | — | — |
| `ArtDeviateFromInvMethod` | smallint | Nee | ((0)) | — |
| `ArtEmpId` | nvarchar(9) | Ja | — | — |
| `ArtEqmQty` | int | Nee | ((0)) | — |
| `ArtExported` | smallint | Nee | ((0)) | — |
| `ArtExternalId` | nvarchar(50) | Ja | — | — |
| `ArtExternalStatus` | nvarchar(50) | Ja | — | — |
| `ArtExtra0` | smallint | Nee | ((0)) | — |
| `ArtExtra1` | smallint | Nee | ((0)) | — |
| `ArtExtra2` | smallint | Nee | ((0)) | — |
| `ArtExtra3` | int | Nee | ((0)) | — |
| `ArtExtra4` | int | Nee | ((0)) | — |
| `ArtExtra5` | nvarchar(5) | Ja | — | — |
| `ArtExtra6` | nvarchar(5) | Ja | — | — |
| `ArtExtra7` | nvarchar(5) | Ja | — | — |
| `ArtExtRseId` | nvarchar(5) | Ja | — | — |
| `ArtFulId` | nvarchar(5) | Ja | — | — |
| `ArtImageFile` | nvarchar(max) | Ja | — | — |
| `ArtIntRseId` | nvarchar(5) | Ja | — | — |
| `ArtInvmId` | nvarchar(5) | Ja | — | — |
| `ArtJobOut` | decimal(21,2) | Nee | ((0)) | — |
| `ArtLeadTime` | smallint | Nee | ((0)) | — |
| `ArtManufArtId` | nvarchar(16) | Ja | — | — |
| `ArtManufVdrId` | nvarchar(6) | Ja | — | — |
| `ArtMaximum` | decimal(21,2) | Nee | ((0)) | — |
| `ArtMinDysBtwnDlvrAndExpDate` | int | Nee | ((0)) | — |
| `ArtMinimum` | decimal(21,2) | Nee | ((0)) | — |
| `ArtMinPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtMinPurchUnt` | decimal(21,2) | Nee | ((0)) | — |
| `ArtMspCode` | nvarchar(70) | Ja | — | — |
| `ArtMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtOutDate` | date | Ja | — | — |
| `ArtPchlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtPchrlPrepQuantity` | decimal(21,2) | Nee | ((0)) | — |
| `ArtPrddId` | nvarchar(6) | Ja | — | — |
| `ArtPrdDossierAddedDate` | datetimeoffset(7) | Ja | — | — |
| `ArtPrdDossierAddedEmpId` | nvarchar(9) | Ja | — | — |
| `ArtPrdDossierOutboundDate` | datetimeoffset(7) | Ja | — | — |
| `ArtPrdDossierOutboundEmpId` | nvarchar(9) | Ja | — | — |
| `ArtPrddOutboundId` | nvarchar(6) | Ja | — | — |
| `ArtProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ArtPurch` | smallint | Nee | ((1)) | — |
| `ArtPurchLevel` | decimal(21,2) | Nee | ((0)) | — |
| `ArtPurchPrDate` | date | Ja | — | — |
| `ArtPurchPrice` | decimal(21,5) | Nee | ((0)) | — |
| `ArtPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtPurchText` | nvarchar(max) | Ja | — | — |
| `ArtRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ArtRegisterStock` | smallint | Nee | ((1)) | — |
| `ArtRepQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtResoId` | nvarchar(11) | Ja | — | — |
| `ArtResQty` | decimal(21,2) | Nee | ((0)) | — |
| `ArtRseId` | nvarchar(5) | Ja | — | — |
| `ArtServOutBY` | decimal(21,2) | Nee | ((0)) | — |
| `ArtServOutUnt` | nvarchar(9) | Ja | — | — |
| `ArtShowInWebShop` | smallint | Nee | ((0)) | — |
| `ArtSitId` | nvarchar(8) | Ja | — | — |
| `ArtStock` | decimal(21,2) | Nee | ((0)) | — |
| `ArtStockMut` | nvarchar(2) | Ja | — | — |
| `ArtText` | nvarchar(max) | Ja | — | — |
| `ArtTransferNextTime` | smallint | Nee | ((0)) | — |
| `ArtTypeNr` | nvarchar(40) | Ja | — | — |
| `ArtUnitDescr` | nvarchar(200) | Ja | — | — |
| `ArtUseOwnInventoryMethod` | smallint | Nee | ((0)) | — |
| `ArtVatId` | nvarchar(3) | Ja | — | — |
| `ArtVdrId` | nvarchar(6) | Ja | — | — |
| `ArtVdrPerSite` | smallint | Nee | ((0)) | — |
| `ArtWarrentPeriod` | int | Nee | ((0)) | — |
| `ArtWarrentStartDate` | datetimeoffset(7) | Ja | — | — |
| `ArtWhsId` | nvarchar(10) | Ja | — | — |
| `ArtWhsOut` | decimal(21,2) | Nee | ((0)) | — |
| `ArtPurchasePrepQty` | decimal(21,2) | Nee | — | — |
| `ArtStckStatCode` | nvarchar(2) | Nee | — | — |
| `ArtFileExtension` | nvarchar(5) | Nee | — | — |
| `ARTPURCHTEXT_FT` | varbinary(max) | Ja | — | — |
| `ARTTEXT_FT` | varbinary(max) | Ja | — | — |
| `ArtAddToBillOfMaterials` | smallint | Nee | ((0)) | — |
| `ArtReplacedByArtId` | nvarchar(9) | Ja | — | — |
| `ArtReplacedByDate` | datetimeoffset(7) | Ja | — | — |
| `ArtReplacedByRemarkText` | nvarchar(200) | Ja | — | — |
| `ArtReplacedByEmpId` | nvarchar(9) | Ja | — | — |
| `ArtAbcId` | nvarchar(9) | Ja | — | — |
| `ArtArtvArtId` | nvarchar(9) | Ja | — | — |
| `ArtArtvVdrId` | nvarchar(6) | Ja | — | — |
| `ArtOverwriteAbcCode` | smallint | Nee | ((0)) | — |
| `ArtAbcCodeIdGenerated` | nvarchar(9) | Ja | — | — |