DW_NS_ManufacturingRoutingRoutingStep_D
This table contains list of all set of operations involved in a particular routing.
Details
Module:
Key Columns
manufacturingrouting, operationsequence
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| manufacturingrouting | NUMBER | 38 | 0 | True | DW_NS_ManufacturingRouting_D | id | |
| operationsequence | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| lagamount | NUMBER | 38 | 0 | Lag Amount | |||
| lagtype | VARCHAR2 | 32 | Lag Type | DW_NS_LagType_D | key | ||
| lagunits | VARCHAR2 | 64 | Lag Units | ||||
| manufacturingcosttemplate | NUMBER | 38 | 0 | Manufacturing Cost Template | DW_NS_ManufacturingCostTemplate_D | id | |
| manufacturingworkcenter | NUMBER | 38 | 0 | Manufacturing Work Center | DW_NS_entityGroup_D | id | |
| operationname | VARCHAR2 | 256 | Operation Name | ||||
| runrate | NUMBER | Run Rate (Min/Unit) | |||||
| setuptime | NUMBER | Setup Time (Min) |