title: "ArticleSiteVendor" category: reference tags: [entity, article-site-vendor, datamodel] source: Entities.xml date: 2026-04-17 status: published
ArticleSiteVendor
Type: Entity Properties: 28 Contexts: 1 Statussen: 2
DB-schema:
lookup_table_schema("ArticleSiteVendor")· ../tables/ArticleSiteVendor
Contextsbewerken
- 0: Standaard (
ArticleSiteVendorContext.None)
Statussenbewerken
- -1: Trash (
ArticleSiteVendorStatus.Trash) - 0: None (
ArticleSiteVendorStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id.ArticleSite | ArticleSite | ARTSVARTID, ARTSVSITID | false | , | |
| Id.Vendor | Vendor | ARTSVVDRID | false | ||
| ArticleUnitPrice | TransactionMoney | ARTSVARTUNTPR | false | 0 | |
| ArticleUnitPriceDate | Date? | ARTSVARTUNTPRDATE | true | ||
| Context | Context | ARTSVCONTEXT | false | ||
| Currency | Currency | ARTSVCURID | false | ||
| DataProvider | UltimoString | ARTSVDATAPROVIDER | 50 | true | |
| Discount | Decimal | ARTSVDISCOUNT | false | ||
| Exported | Boolean | ARTSVEXPORTED | false | ||
| ExternalId | UltimoString | ARTSVEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | ARTSVEXTERNALSTATUS | 50 | true | |
| Extra1 | UltimoString | ARTSVEXTRA1 | 15 | true | |
| Extra2 | UltimoString | ARTSVEXTRA2 | 15 | true | |
| Extra3 | Int16 | ARTSVEXTRA3 | false | ||
| Extra4 | Int32 | ARTSVEXTRA4 | false | 0 | |
| LeadTime | Int32 | ARTSVLEADTIME | false | ||
| MinimumPurchaseQuantity | Decimal | ARTSVMINPURCHQTY | false | 1 | |
| Preference | Boolean | ARTSVPREFERENCE | false | 0 | |
| ProviderMutationDate | DateTime? | ARTSVPROVIDERMUTDATE | true | ||
| PurchaseCode | UltimoString | ARTSVPURCHCODE | 60 | true | |
| PurchaseQuantityCeilSignificant | Decimal | ARTSVPURCHQTYCEILSIGNIFIC | false | ||
| QuantityPurchaseUnit | Decimal | ARTSVQTYPURCHUNT | false | 1 | |
| RecordChangeDate | DateTime? | ARTSVRECCHANGEDATE | true | ||
| RecordCreateDate | DateTime? | ARTSVRECCREATEDATE | true | SYSDATETIME | |
| Status | Status | ARTSVRECSTATUS | false | ||
| SystemCompany | Company | ARTSVCOMPID | false | ||
| TransferNextTime | Boolean | ARTSVTRANSFERNEXTTIME | false | 0 | |
| UnitDescription | UltimoString | ARTSVUNTDESCR | 9 | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("ArticleSiteVendor")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("ArticleSiteVendor")· ../tables/ArticleSiteVendor DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="ArticleSiteVendor")Before/After Save events voor ArticleSiteVendor. Bron:workflows.xml.