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.