Production Order Detail
This table shows the tables from which fields are retrieved for the dimension:
Table | Description |
---|---|
tcmcs005 | Reasons |
tcmcs145 | Routing Groups |
tirou101 | Routing Codes by Item |
tisfc001 | Production Orders |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Backflush Hours | tisfc001.bfhr |
Backflush Hours Filter | tisfc001.bfhr |
Backflush Hours Sort | tisfc001.bfhr |
Backflush Materials | tisfc001.bfep |
Backflush Materials Filter | tisfc001.bfep |
Backflush Materials Sort | tisfc001.bfep |
Bad Order | Bad Quantity > 0 (Quantity Scrapped + Quantity Rejected + Quantity Quarantined > |
Engineering Item Revision | tisfc001.revi |
Lot Code | tisfc001.clot |
Moving Method Next Operations | tisfc001.mmno |
Moving Method Next Operations Filter | tisfc001.mmno |
Moving Method Next Operations Sort | tisfc001.mmno |
Moving Method Previous Operations | tisfc001.mmpo |
Moving Method Previous Operations Filter | tisfc001.mmpo |
Moving Method Previous Operations Sort | tisfc001.mmpo |
Operations Present | tisfc001.oprp |
Operations Present Filter | tisfc001.oprp |
Operations Present Sort | tisfc001.oprp |
Order Status | tisfc001.osta |
Order Status Filter | tisfc001.osta |
Order Status Sort | tisfc001.osta |
Planning Method | tisfc001.cpla |
Planning Method Filter | tisfc001.cpla |
Planning Method Sort | tisfc001.cpla |
Priority | tisfc001.prcd |
Reject Reason | tisfc001.reco |
Reject Reason Desc | tcmcs005.dsca |
Rework Order | tisfc001.rwko |
Rework Order Filter | tisfc001.rwko |
Rework Order Sort | tisfc001.rwko |
Rework Type | tisfc001.rwtp |
Rework Type Filter | tisfc001.rwtp |
Rework Type Sort | tisfc001.rwtp |
Routing | tisfc001.opro |
Routing Desc | tirou101.dsca |
Routing Group | tisfc001.rgrp |
Routing Group Desc | tcmcs145.dsca |