Entity Definition

Logical Name : EmailAddress
Physical Name : LO_EML_ADS

An electronic mail address.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EmailAddressID (PK) A unique system assigned identifier for an electronic address for sending messages. ID_EM_ADS Identity integer
EmailAddressLocalPart The local-part portion is a domain-dependent string. In addresses, it is simply interpreted on the particular host as a name of a particular mailbox. EM_ADS_LOC_PRT EmailAddress varchar(253)
EmailAddressDomainPart The domain portion identifies the point to which the mail is delivered. In the dot-atom form, this is interpreted as an Internet domain name (either a host name or a mail exchanger name) as described in [RFC1034], [RFC1035], and [RFC1123]. In the domain-literal form, the domain is interpreted as the literal Internet address of the particular host. In both cases, how addressing is used and how messages are transported to a particular host is covered in separate documents, such as [RFC5321]. EM_ADS_DMN_PRT EmailAddress varchar(253)


Parent Entity Verb Phrase Child Entity
EmailAddress is contact for RetailTransactionDeliveryPreference
EmailAddress isa PartyContactMethod
EmailAddress is used by SiteContactMethod

Logical Views containing EmailAddress

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02340 - Retail Transaction - Shipping View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10100 - Enterprise - Locations Macro View
Logical 11100 - Worker - Macro View