Production Operation
When a record is deleted in LN, a record with deleted = 1 is stored in the dimension. Records are not removed from the dimension. A production operation that is not yet completed and is deleted in LN is hidden in the degenerate dimension in Birst. Completed operations that are deleted when archiving orders are not hidden and remain available for analysis.
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tisfc010 | Production Order Operations |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Ready to Start Date | tisfc010.ardt |
| Actual Start Date | tisfc010.asdt |
| Company | tisfc010_compnr |
| Completion Date | tisfc010.cmdt |
| Move Start Date | tisfc010.fidt |
| Operation | tisfc010.opno |
| Planned Finish Date | tisfc010.pfdt |
| Planned Start Date | tisfc010.psdt |
| Production Order | tisfc010.pdno |
| Queue Start Date | tisfc010.esdt |
| Queue Start Next Operation | tisfc010.mvrd |
| Remainder Start Date | tisfc010.rsdt |
| Setup and Run Next Operation | tisfc010.lfdt |
| Setup Run Start Date | tisfc010.prdt |
| Transport Date From | tisfc010.trdf |
| Transport Date To | tisfc010.trdt |
| Transport Date To Next Operation | tisfc010.trno |
| Unknown | 1 for null records, else 0 |
| Wait Start Date | tisfc010.prrd |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |