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

Vendor

Type: Entity Properties: 64 Contexts: 4 Statussen: 2

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

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString VDRID 6 false
AddressLine1 UltimoString VDRADDRESSLINE1 100 true
AddressLine2 UltimoString VDRADDRESSLINE2 100 true
City UltimoString VDRCITY 40 true
Context Context VDRCONTEXT false 1
Country Country VDRCNTRID true DefaultCountryId
CreditNumber UltimoString VDRCREDID 9 true
Currency Currency VDRCURID false
DataProvider UltimoString VDRDATAPROVIDER 50 true
DeliveryTerms DeliveryTerms VDRDLVTID true
Description UltimoString VDRDESCR 200 true
Documents List[Document] DOCMANUFVDRID true
EmailAddress UltimoString VDREMAIL 80 true
Equipments List[Equipment] EQMVDRID true
Exported Boolean VDREXPORTED false
ExternalId UltimoString VDREXTERNALID 50 true
ExternalStatus UltimoString VDREXTERNALSTATUS 50 true
Extra1 Int16 VDREXTRA1 false
Extra2 Int32 VDREXTRA2 false
Extra3 Int32 VDREXTRA3 false
Extra4 UltimoString VDREXTRA4 5 true
Extra5 UltimoString VDREXTRA5 6 true
Extra6 UltimoString VDREXTRA6 40 true
Extra7 UltimoString VDREXTRA7 5 true
FailurePhone UltimoString VDRFAILPHONE 25 true
Fax UltimoString VDRFAX 25 true
Language Language VDRLNGID true
LastVendorRatingDate Date? VDRLASTVENDORRATINGDATE true
MailboxNumber UltimoString VDRMAILBOXNUMBER 60 true
ManageProcessFunctions List[ProcessFunction] PRFMANAGVDRID true
ManufacturedEquipments List[Equipment] EQMMANUFID true
ManufacturedProcessFunctions List[ProcessFunction] PRFMANUFID true
NextVendorRatingDate Date? VDRNEXTVENDORRATINGDATE true
ObjectContacts List[ObjectContact] OBJCONVDRID true
PaymentTerms PaymentTerms VDRPYMTID true
Phone UltimoString VDRPHONE 25 true
POBox UltimoString VDRPOBOX 36 true
POBoxCity UltimoString VDRPBCITY 40 true
POBoxCountry Country VDRPBCNTRID true
POBoxProvinceStateRegion UltimoString VDRPBPROVINCESTATEREGION 40 true
POBoxZipCode UltimoString VDRPBZIPCODE 10 true
ProcessFunctions List[ProcessFunction] PRFVDRID true
ProductUrlTemplate UltimoString VDRPRODUCTURLTEMPLATE 200 true
ProviderMutationDate DateTime? VDRPROVIDERMUTDATE true
ProvinceStateRegion UltimoString VDRPROVINCESTATEREGION 40 true
PurchaseContact Employee VDRPCHCONTACTEMPID true
RecordChangeDate DateTime? VDRRECCHANGEDATE true
RecordCreateDate DateTime? VDRRECCREATEDATE true SYSDATETIME
ReservableObject ReservableObject VDRRESOID true
SafetyDossiers List[SafetyDossier] SAFDVDRID true
Status Status VDRRECSTATUS false
TaxNumber Int32 VDRTAXNUMBER false 0
TaxSubNumber Int32 VDRTAXSUBNUMBER false 0
TelexNumber UltimoString VDRTELEX 16 true
Text UltimoString VDRTEXT true
TransferNextTime Boolean VDRTRANSFERNEXTTIME false
VendorRatingFrequency Int16 VDRVENDORRATINGFREQUENCY false 0
VendorRatingPeriodic Int16 VDRVENDORRATINGPERIODIC false 0
VendorRatingReason UltimoString VDRVENDORRATINGREASON 200 true
VendorRatingScore Int16 VDRVENDORRATINGSCORE false 0
VendorType VendorType VDRVDRTID true
Website UltimoString VDRWEBSITE 200 true
WorkSchedule WorkSchedule VDRWSID true 4
ZipCode UltimoString VDRZIPCODE 10 true

Brondatabewerken