Site

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

Table	Description
tccom130	Addresses
tccom139	Cities by Country
tcemm050	Sites
tcemm100	Time Zones
tcemm135	Clusters
tcemm170	Companies
tcmcs003	Warehouses
tcmcs010	Countries
tcmcs143	States/Provinces

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Administrative Only	tcemm050.admo
Administrative Only Filter	tcemm050.admo
Administrative Only Sort	tcemm050.admo
City	tccom130.ccit
City Desc	tccom139.dsca
Company	Logical company of tcemm050
Country	tccom130.ccty
Country Desc	tcmcs010.dsca
Default Warehouse	tcemm050.cwar
Default Warehouse Desc	tcmcs003.dsca
EU Member State	tcmcs010.meec
EU Member State Filter	tcmcs010.meec
EU Member State Sort	tcmcs010.meec
External Site	tcemm050.xsit
External Site Filter	tcemm050.xsit
External Site Sort	tcemm050.xsit
GPS Latitude	tccom130.glat
GPS Location	Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Site Desc.
GPS Longitude	tccom130.glon
ISO Country Code Alpha-2	tcmcs010.ict2
Logistic Company	tcemm050.lcmp
Logistic Company Desc	tcemm170.desc
Parent Site	tcemm050.psit
Parent Site Desc	tcemm050.desc
Planning Cluster	tcemm050.clus
Planning Cluster Desc	tcemm135.desc
Site	tcemm050.site
Site Desc	tcemm050.desc
Site ID Desc	tcemm050.site + tcemm050.desc
Site Status	tcemm050.stat
Site Status Filter	tcemm050.stat
Site Status Sort	tcemm050.stat
State/Province	tccom130.cste
State Province Desc	tcmcs143.dsca
Time Zone	tcemm100.timz
Time Zone Code	tccom130.tzid
Time Zone Desc	tcemm100.dsca
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields

Address fields are included for tcemm050.cadr.