Address

The Address dimension is available in the Default Subject Area, but not in the Custom Subject Areas. It is only used as parent for role-playing dimensions.

This table shows the tables from which fields are retrieved for the dimension:

Table	Description
tccom130	Addresses
tccom139	Cities by Country
tcemm100	Time Zones
tcmcs010	Countries
tcmcs143	States/Provinces

This table shows the attribute mapping for the dimension:

Attribute	Mapping	Note
Address	tccom130.cadr	1
Address ID Name	tccom130.cadr + tccom130.nama	1
Address Name	tccom130.nama	1
City	tccom130.ccit	2
City 2	tccom130.namf
City Desc	tccom139.dsca	2
Company	Logical company of tccom130
Country	tccom130.ccty	2
Country Desc	tcmcs010.dsca	2
EU Member State	tcmcs010.meec	2
EU Member State Filter	tcmcs010.meec	2
EU Member State Sort	tcmcs010.meec	2
Fax	tccom130.tefx
GPS Latitude	tccom130.glat	2
GPS Location	Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Ship-to Address Name.	2
GPS Longitude	tccom130.glon	2
House Number	tccom130.hono
ISO Country Code Alpha-2	tcmcs010.ict2	2
Name 2	tccom130.namb
Pobox Number	tccom130.pobn
Postal Code	tccom130.pstc
State/Province	tcmcs010.ict2	2
State Province Desc	tcmcs010.ict2	2
Street	tccom130.namc
Street 2	tccom130.namd
Telephone	tccom130.telp
Telex	tccom130.telx
Time Zone	tcemm100.timz	2
Time Zone Code	tccom130.tzid	2
Time Zone Desc	tcemm100.dsca	2
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields

(1) Address dimensions all have mentioned attributes. The only difference is that the attributes Address, and Address Name have been replaced by dimension specific attributes. For example, the Buy-from Address dimension has attributes Buy-from Address and Buy from Address Name.

(2) Dimensions that refer to an address, such as Buy-from BP, include a limited set of address attributes.