Company

Tools company 0000 is excluded from the company dimension.

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

Table	Description
tccom000	Implemented Software Components
tccom130	Addresses
tccom139	Cities by Country
tcemm100	Time Zones
tcemm170	Companies
tcgen000	Generic Parameters
tcmcs000	MCS Parameters
tcmcs001	Units
tcmcs002	Currencies
tcmcs010	Countries
tcmcs143	States/Provinces
tfgld004	Financial Companies

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Base Unit Area	tcmcs000.care
Base Unit Area Desc	tcmcs001.dsca
Base Unit Length	tcmcs000.clen
Base Unit Length Desc	tcmcs001.dsca
Base Unit Piece	tcgen000.cpie
Base Unit Piece Desc	tcmcs001.dsca
Base Unit Time	tcmcs000.ctim
Base Unit Time Desc	tcmcs001.dsca
Base Unit Volume	tcmcs000.cvol
Base Unit Volume Desc	tcmcs001.dsca
Base Unit Weight	tcmcs000.cwei
Base Unit Weight Desc	tcmcs001.dsca
City	tccom130.ccit
City Desc	tccom139.dsca
Company	tccom000.ncmp
Company Desc	tcemm170.desc
Company ID Desc	tccom000.ncmp + tcemm170.desc
Company Type	tcemm170.ctyp
Company Type Filter	tcemm170.ctyp
Company Type Sort	tcemm170.ctyp
Country	tccom130.ccty
Country Desc	tcmcs010.dsca
EU Member State	tcmcs010.meec
EU Member State Filter	tcmcs010.meec
EU Member State Sort	tcmcs010.meec
GPS Latitude	tccom130.glat
GPS Location	Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Company Desc.
GPS Longitude	tccom130.glon
ISO Country Code Alpha-2	tcmcs010.ict2
Job Shop by Site	tccom000.jspm
Job Shop by Site Filter	tccom000.jspm
Job Shop by Site Sort	tccom000.jspm
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 tccom000.cadr.