Bewerken: Article

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id | UltimoString | ARTID | 9 | false |  |
| _ObjectProgresstatusHistories | List[ObjectProgressStatusHistory] | _OBJPRSHARTID |  | true |  |
| _ProgressStatus | ProgressStatus | _ARTPRSID |  | true |  |
| AbcCode | UltimoString | ARTABC | 2 | true |  |
| AbcCodeId | AbcCode | ARTABCID |  | true |  |
| AbcCodeIdGenerated | AbcCode | ARTABCCODEIDGENERATED |  | true |  |
| AddToBillOfMaterials | Boolean | ARTADDTOBILLOFMATERIALS |  | false | 0 |
| ApproveDate | DateTime? | ARTDATEAPPR |  | true |  |
| ArticleGroup | ArticleGroup | ARTAGID |  | true |  |
| ArticleManufacturerArticleCode | UltimoString | ARTMANUFARTID | 16 | true |  |
| ArticleWarehouses | List[ArticleWarehouse] | ARTWARTID |  | false |  |
| Category | UltimoString | ARTCATEGORY | 2 | true |  |
| ChargeRaiseExternal | Raise | ARTEXTRSEID |  | true |  |
| ChargeRaiseInternal | Raise | ARTINTRSEID |  | true |  |
| Context | Context | ARTCONTEXT |  | false | 1 |
| DataProvider | UltimoString | ARTDATAPROVIDER | 50 | true |  |
| Description | UltimoString | ARTDESCR | 200 | true |  |
| DeviateFromInventoryMethod | Boolean | ARTDEVIATEFROMINVMETHOD |  | false | 0 |
| Employee | Employee | ARTEMPID |  | true |  |
| EquipmentsIssue | Int32 | ARTEQMQTY |  | false | 0 |
| EquipmentSpareParts | List[EquipmentSparePart] | EQMSPARTID |  | false |  |
| EquipmentTypeSpareParts | List[EquipmentTypeSparePart] | EQMTSPARTID |  | false |  |
| Exported | Boolean | ARTEXPORTED |  | false |  |
| ExternalId | UltimoString | ARTEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | ARTEXTERNALSTATUS | 50 | true |  |
| Extra0 | Int16 | ARTEXTRA0 |  | false |  |
| Extra1 | Int16 | ARTEXTRA1 |  | false |  |
| Extra2 | Int16 | ARTEXTRA2 |  | false |  |
| Extra3 | Int32 | ARTEXTRA3 |  | false |  |
| Extra4 | Int32 | ARTEXTRA4 |  | false |  |
| Extra5 | UltimoString | ARTEXTRA5 | 5 | true |  |
| Extra6 | UltimoString | ARTEXTRA6 | 5 | true |  |
| Extra7 | UltimoString | ARTEXTRA7 | 5 | true |  |
| Fuel | Fuel | ARTFULID |  | true |  |
| ImageFile | UltimoString | ARTIMAGEFILE |  | true |  |
| InventoryMethod | InventoryMethod | ARTINVMID |  | true |  |
| Issues | Decimal | ARTSERVOUTBY |  | false |  |
| JobsIssue | Decimal | ARTJOBOUT |  | false |  |
| LastIssueDate | Date? | ARTOUTDATE |  | true |  |
| LeadTime | Int16 | ARTLEADTIME |  | false |  |
| Manufacturer | Vendor | ARTMANUFVDRID |  | true |  |
| MaximumStock | Decimal | ARTMAXIMUM |  | false |  |
| MeasurementPointCode | UltimoString | ARTMSPCODE | 70 | true |  |
| MinimumNumberOfDaysBetweenDeliveryAndExpiryDate | Int32 | ARTMINDYSBTWNDLVRANDEXPDATE |  | false | 0 |
| MinimumPurchaseQuantity | Decimal | ARTMINPURCHQTY |  | false |  |
| MinimumPurchaseUnit | Decimal | ARTMINPURCHUNT |  | false |  |
| MinimumStock | Decimal | ARTMINIMUM |  | false |  |
| MutationDate | DateTime? | ARTMUTDATE |  | true |  |
| NumberOfMutations | UltimoString | ARTSTOCKMUT | 2 | true |  |
| ObjectDefinitions | List[CadImportProfileObjectDefinition] | CIMPODARTID |  | true |  |
| ObjectDocuments | List[ObjectDocument] | OBJDOCARTID |  | true |  |
| ObjectFeatures | List[ObjectFeature] | OBJFARTID |  | true |  |
| OverwriteAbcCode | Boolean | ARTOVERWRITEABCCODE |  | false | 0 |
| PartOf | List[ArticleHierarchy] | ARTHYARTID |  | false |  |
| Parts | List[ArticleHierarchy] | ARTHYPARTOFARTID |  | false |  |
| PreferredVendor | ArticleVendor | ARTARTVARTID, ARTARTVVDRID |  | true | ,  |
| ProductDossier | ProductDossier | ARTPRDDID |  | true |  |
| ProductDossierAddedDate | DateTime? | ARTPRDDOSSIERADDEDDATE |  | true |  |
| ProductDossierAddedEmployee | Employee | ARTPRDDOSSIERADDEDEMPID |  | true |  |
| ProductDossierOutbound | ProductDossier | ARTPRDDOUTBOUNDID |  | true |  |
| ProductDossierOutboundDate | DateTime? | ARTPRDDOSSIEROUTBOUNDDATE |  | true |  |
| ProductDossierOutboundEmployee | Employee | ARTPRDDOSSIEROUTBOUNDEMPID |  | true |  |
| ProviderMutationDate | DateTime? | ARTPROVIDERMUTDATE |  | true |  |
| Purchase | Boolean | ARTPURCH |  | false | 0 |
| PurchaseLevel | Decimal | ARTPURCHLEVEL |  | false |  |
| PurchaseLinePreparationQuantity | Decimal | ARTPCHLPREPQUANTITY |  | false |  |
| PurchasePreparationQuantity | Decimal | ARTPURCHASEPREPQTY |  | false |  |
| PurchasePrice | CompanyMoney | ARTPURCHPRICE |  | false | 0 |
| PurchasePriceDate | Date? | ARTPURCHPRDATE |  | true |  |
| PurchaseQuantity | Decimal | ARTPURCHQTY |  | false |  |
| PurchaseRequestLinePreparationQuantity | Decimal | ARTPCHRLPREPQUANTITY |  | false |  |
| PurchaseText | UltimoString | ARTPURCHTEXT |  | true |  |
| Raise | Raise | ARTRSEID |  | true |  |
| RecordChangeDate | DateTime? | ARTRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | ARTRECCREATEDATE |  | true | SYSDATETIME |
| RegisterStock | Boolean | ARTREGISTERSTOCK |  | false | 1 |
| RepairQuantity | Decimal | ARTREPQTY |  | false |  |
| ReplacedByArticle | Article | ARTREPLACEDBYARTID |  | true |  |
| ReplacedByDate | DateTime? | ARTREPLACEDBYDATE |  | true |  |
| ReplacedByEmployee | Employee | ARTREPLACEDBYEMPID |  | true |  |
| ReplacedByRemarkText | UltimoString | ARTREPLACEDBYREMARKTEXT | 200 | true |  |
| ReservableObject | ReservableObject | ARTRESOID |  | true |  |
| ReservedQuantity | Decimal | ARTRESQTY |  | false |  |
| ServingOutUnitDescription | UltimoString | ARTSERVOUTUNT | 9 | true |  |
| ShowInWebShop | Boolean | ARTSHOWINWEBSHOP |  | false | 0 |
| Site | Site | ARTSITID |  | true |  |
| Status | Status | ARTRECSTATUS |  | false |  |
| Stock | Decimal | ARTSTOCK |  | false |  |
| StockStatusCode | UltimoString | ARTSTCKSTATCODE | 2 | false |  |
| SystemCompany | Company | ARTCOMPID |  | false |  |
| Text | UltimoString | ARTTEXT |  | true |  |
| TotalWarehouseIssue | Decimal | ARTWHSOUT |  | false |  |
| TransferNextTime | Boolean | ARTTRANSFERNEXTTIME |  | false |  |
| TypeNumber | UltimoString | ARTTYPENR | 40 | true |  |
| UnitDescription | UltimoString | ARTUNITDESCR | 200 | true |  |
| UseOwnInventoryMethod | Boolean | ARTUSEOWNINVENTORYMETHOD |  | false | 0 |
| Vat | Vat | ARTVATID |  | true |  |
| Vendor | Vendor | ARTVDRID |  | true |  |
| VendorPerSite | Boolean | ARTVDRPERSITE |  | false | 0 |
| Vendors | List[ArticleVendor] | ARTVARTID |  | false |  |
| Warehouse | Warehouse | ARTWHSID |  | true |  |
| WarehouseServeOutlines | List[WarehouseServeOutline] | WHSOLARTID |  | true |  |
| WarrantPeriod | Int32 | ARTWARRENTPERIOD |  | false |  |
| WarrantStartDate | DateTime? | ARTWARRENTSTARTDATE |  | true |  |