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

ArticleVendor

Type: Entity Properties: 27 Contexts: 1 Statussen: 2

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

Property	Type	Kolom	Width	Nullable	Default
Id.Article	Article	ARTVARTID		false
Id.Vendor	Vendor	ARTVVDRID		false
ArticleUnitPrice	TransactionMoney	ARTVARTUNTPR		false	0
ArticleUnitPriceDate	Date?	ARTVARTUNTPRDATE		true
Context	Context	ARTVCONTEXT		false
Currency	Currency	ARTVCURID		false
DataProvider	UltimoString	ARTVDATAPROVIDER	50	true
Discount	Decimal	ARTVDISCOUNT		false
Exported	Boolean	ARTVEXPORTED		false
ExternalId	UltimoString	ARTVEXTERNALID	50	true
ExternalStatus	UltimoString	ARTVEXTERNALSTATUS	50	true
Extra1	UltimoString	ARTVEXTRA1	15	true
Extra2	UltimoString	ARTVEXTRA2	15	true
Extra3	Int16	ARTVEXTRA3		false
Extra4	Int32	ARTVEXTRA4		false
LeadTime	Int32	ARTVLEADTIME		false
MinimumPurchaseQuantity	Decimal	ARTVMINPURCHQTY		false	1
Preference	Boolean	ARTVPREFERENCE		false	0
ProviderMutationDate	DateTime?	ARTVPROVIDERMUTDATE		true
PurchaseCode	UltimoString	ARTVPURCHCODE	60	true
PurchaseQuantityCeilSignificant	Decimal	ARTVPURCHQTYCEILSIGNIFIC		false
QuantityPurchaseUnit	Decimal	ARTVQTYPURCHUNT		false	1
RecordChangeDate	DateTime?	ARTVRECCHANGEDATE		true
RecordCreateDate	DateTime?	ARTVRECCREATEDATE		true	SYSDATETIME
Status	Status	ARTVRECSTATUS		false
TransferNextTime	Boolean	ARTVTRANSFERNEXTTIME		false	0
UnitDescription	UltimoString	ARTVUNTDESCR	9	true

Entity-definitie — lookup_entity("ArticleVendor") Model-perspectief (properties, contexts, statussen). Bron: Entities.xml.
DB-schema — lookup_table_schema("ArticleVendor") · ../tables/ArticleVendor DB-perspectief (triggers, computed, defaults). Bron: database-schema.json.
Workflows — find_workflows("", entity="ArticleVendor") Before/After Save events voor ArticleVendor. Bron: workflows.xml.