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

Customer

Type: Entity Properties: 41 Contexts: 3 Statussen: 2

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

Contextsbewerken

0: Klant (CustomerContext.None)
1: Klant (CustomerContext.Client)
2: Eigenaar (CustomerContext.Owner)

Statussenbewerken

-1: Trash (CustomerStatus.Trash)
0: None (CustomerStatus.None)

Propertiesbewerken

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	CUSID	6	false
AddressLine1	UltimoString	CUSADDRESSLINE1	100	true
AddressLine2	UltimoString	CUSADDRESSLINE2	100	true
City	UltimoString	CUSCITY	40	true
Context	Context	CUSCONTEXT		false	1
CostCurrentYear	CompanyMoney	CUSCOSTBY		false	0
CostLastYear	CompanyMoney	CUSCOSTLY		false	0
Country	Country	CUSCNTRID		true	DefaultCountryId
DataProvider	UltimoString	CUSDATAPROVIDER	50	true
Description	UltimoString	CUSDESCR	200	true
EmailAddress	UltimoString	CUSEMAIL	80	true
Equipments	List[Equipment]	EQMCUSID		true
Exported	Boolean	CUSEXPORTED		false
ExternalId	UltimoString	CUSEXTERNALID	50	true
ExternalStatus	UltimoString	CUSEXTERNALSTATUS	50	true
FaxNumber	UltimoString	CUSFAX	25	true
InvoiceGroupByJob	Boolean	CUSINVOICEGROUPBYJOB		false	0
InvoiceOutPerServiceContract	Boolean	CUSINVOPERSVC		false	1
ObjectContacts	List[ObjectContact]	OBJCONCUSID		true
PhoneNumber	UltimoString	CUSPHONE	25	true
POBox	UltimoString	CUSPOBOX	36	true
POBoxCity	UltimoString	CUSPBCITY	40	true
POBoxCountry	Country	CUSPBCNTRID		true
POBoxProvinceStateRegion	UltimoString	CUSPBPROVINCESTATEREGION	40	true
POBoxZipCode	UltimoString	CUSPBZIPCODE	10	true
ProviderMutationDate	DateTime?	CUSPROVIDERMUTDATE		true
ProvinceStateRegion	UltimoString	CUSPROVINCESTATEREGION	40	true
ReceiveVehicleInspectionExpirationEmail	Boolean	CUSRECEIVEVEHINSPEXPEMAIL		false	1
RecordChangeDate	DateTime?	CUSRECCHANGEDATE		true
RecordCreateDate	DateTime?	CUSRECCREATEDATE		true	SYSDATETIME
ReservableObject	ReservableObject	CUSRESOID		true
Status	Status	CUSRECSTATUS		false
SystemCompany	Company	CUSCOMPID		false
TariffGroup	TariffGroup	CUSTRFGID		true
Text	UltimoString	CUSTEXT		true
TotalCost	CompanyMoney	CUSTOTCOST		false	0
TransferNextTime	Boolean	CUSTRANSFERNEXTTIME		false
Url	UltimoString	CUSURL	500	true
UseVat	Boolean	CUSUSEVAT		false	0
Vat	Vat	CUSVATID		true
ZipCode	UltimoString	CUSZIPCODE	10	true

Brondatabewerken

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