Entity Definition

Logical Name : Address
Physical Name : LO_ADS

A place or location designated by a postal authority for the delivery and pickup of mail. In ARTS Address is one of several ways to contact a person or organization (i.e. a Party)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AddressID (PK) A unique system allocated identifier for the Address. ID_ADS Identity integer
AddressLine1 The first line of the address, normally the street number and name. A1_ADS Address varchar(80)
AddressLine2 The second line of an address, normally the Flat or Building Suite number. A2_ADS Address varchar(80)
AddressLine3 The third line of the address. A3_ADS Address varchar(80)
AddressLine4 The fourth line of the address. A4_ADS Address varchar(80)
City The city, town or village component of the address CI_CNCT City varchar(30)
Territory The County, State, Province, Territory etc component of the address ST_CNCT State char(2)
GeographicSegmentID (FK) Token ID for a GeographicSegment which is used to categorize customers based on where they live, shop and work. ID_GEO_SGMT Identity integer GeographicSegment(CO_GEO_SGMT)
ISO_3166-2CountrySubDivisionID (FK) Token ID assigned to uniquely identify all country-primary subdivision instances. This token is non-signifcant and should be automatically generated. ID_ISO_3166_2_CY_SBDVN Identity integer ISO3166-2CountrySubdivision(CO_ISO3166_2_PRMRY_SBDVN)
PostalCodeID (FK) A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. ID_PSTL_CD Identity integer PostalCodeReference(LU_PSTL_CD_RFC)


Parent Entity Verb Phrase Child Entity
GeographicSegment is referenced by Address
ISO3166-2CountrySubdivision validates Address
PostalCodeReference defines postal area for Address
Address was supplied or used as RestrictionValidationModifier
Address is preferred address for RetailTransactionDeliveryPreference
Address is captured from PartyIdentification
Address is a PartyContactMethod
Address is used in TenderLineItemCustomerVerification
Address is used at GeophysicalLocationAddress
Address is set via CustomerOrderControlTransactionLineItem
Address is destination for SendCheckTenderLineItem
Address is used by SiteContactMethod

Logical Views containing Address

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02315 - Retail Transaction - Customer Order
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02336 - Retail Transaction - Tender - Authorization View
Logical 02340 - Retail Transaction - Shipping View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 05100 - Taxation - Rules View
Logical 05200 - Taxation - Retail Transaction 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 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View
Logical 10100 - Enterprise - Locations Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 11100 - Worker - Macro View