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

Address

Type: Entity Properties: 25 Contexts: 2 Statussen: 2

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

Property	Type	Kolom	Width	Nullable	Default
Id	UltimoString	ADRID	9	false
AddressLine1	UltimoString	ADRADDRESSLINE1	100	true
AddressLine2	UltimoString	ADRADDRESSLINE2	100	true
City	UltimoString	ADRCITY	40	true
Context	Context	ADRCONTEXT		false	1
Country	Country	ADRCNTRID		true
DataProvider	UltimoString	ADRDATAPROVIDER	50	true
Description	UltimoString	ADRDESCR	255	true
Exported	Boolean	ADREXPORTED		false
ExternalId	UltimoString	ADREXTERNALID	50	true
ExternalStatus	UltimoString	ADREXTERNALSTATUS	50	true
GeocodeX	Decimal	ADRGEOCODEX		false
GeocodeY	Decimal	ADRGEOCODEY		false
HouseLetter	UltimoString	ADRHOUSELETTER	1	true
HouseNumber	UltimoString	ADRHOUSENUMBER	30	true
HouseNumberDesignation	UltimoString	ADRHOUSENUMBERDESIGNATION	2	true	NA
HouseNumberSuffix	UltimoString	ADRHOUSENUMBERSUFFIX	10	true
Location	UltimoString	ADRLOCATION	60	true
ProviderMutationDate	DateTime?	ADRPROVIDERMUTDATE		true
ProvinceStateRegion	UltimoString	ADRPROVINCESTATEREGION	40	true
RecordCreateDate	DateTime?	ADRRECCREATEDATE		true	SYSDATETIME
Status	Status	ADRRECSTATUS		false
Street	UltimoString	ADRSTREET	80	true
TransferNextTime	Boolean	ADRTRANSFERNEXTTIME		false	0
ZipCode	UltimoString	ADRZIPCODE	10	true

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