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 |