Financial 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
Accounting Department tfgld004.acdp
Accounting Department Desc tcmcs065.dsca
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 Type tcemm170.ctyp
Company Type Filter tcemm170.ctyp
Company Type Sort tcemm170.ctyp
Country tccom130.ccty
Country Desc tcmcs010.dsca
Data Warehouse Currency tcgen000.dcur
Data Warehouse Currency Desc tcmcs002.dsca
EU Member State tcmcs010.meec
EU Member State Filter tcmcs010.meec
EU Member State Sort tcmcs010.meec
Financial Company tccom000.ncmp
Financial Company ID Desc tccom000.ncmp + tcemm170.desc
Financial Company Desc tcemm170.desc
GPS Latitude tccom130.glat
GPS Location Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Company Desc
GPS Longitude tccom130.glon
Group Company tfgld004.gcmp
ISO Country Code Alpha-2 tcmcs010.ict2
Local Currency tcemm170.fcua
Local Currency Desc tcmcs002.dsca
Reference Currency tcemm170.lcur
Reference Currency Desc tcmcs002.dsca
Reporting Currency 1 tcemm170.fcub
Reporting Currency 1 Desc tcmcs002.dsca
Reporting Currency 2 tcemm170.fcuc
Reporting Currency 2 Desc tcmcs002.dsca
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.