title: "Article" category: reference tags: [entity, article, datamodel] source: Entities.xml date: 2026-04-17 status: published

Article

Type: Entity Properties: 104 Contexts: 7 Statussen: 2

Zie ook het handgeschreven artikel: article

DB-schema: lookup_table_schema("Article") · ../tables/Article

Contextsbewerken

Statussenbewerken

Propertiesbewerken

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

Brondatabewerken