Machine

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

Table Description
tcemm050 Site
tcmcs065 Department
tirou002 Machine

This table shows the attribute mapping for the dimension:

Attribute Mapping
Basic Day Capacity tirou002.mdcp
Company Logical company of tirou002
Desired Queue tirou002.dque
Machine tirou002.mcno
Machine ID Desc tirou002.mcno + tirou002.dsca
Machine Desc tirou002.dsca
Site tirou002.site
Site Desc tcemm050.desc
Unknown 1 for null records, else 0
Week Capacity tirou002.mccp
Work Center tirou002.cwoc
Work Center Desc tcmcs065.dsca
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields