MSC_ST_ROUTING_INT
Table used as an interface while loading data from legacy sources though Web service
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | This value indicates the plan identifier for the record. | ||
| ROUTING_NAME | VARCHAR2 | 250 | Name of the routing or a work definition. | ||
| ASSEMBLY_NAME | VARCHAR2 | 300 | Name assigned to the assembly item | ||
| ROUTING_TYPE | NUMBER | This value indicates the routing type of the wd/routing record. | |||
| ORGANIZATION_CODE | VARCHAR2 | 7 | Organization id | ||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | ||
| ROUTING_COMMENT | VARCHAR2 | 960 | Comment for the routing or a work definition record. | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 40 | Name of the alternate routing. Null for primary routing | ||
| LINE_CODE | VARCHAR2 | 10 | This value indicates the Routing line defined for a Routing or work definition. | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the routing or a work definition. | ||
| CFM_ROUTING_FLAG | NUMBER | Flag to indicate whether the routing is continuos flow or traditional routing | |||
| CTP_FLAG | NUMBER | Flag to indicate whether capacity must be checked when item is ordered | |||
| ROUTING_QUANTITY | NUMBER | Quantity of the work definition or a routing. | |||
| BOM_NAME | VARCHAR2 | 250 | Bill of Material or Item structure name. | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | Name of the bill for alternate bills (null for the primary bill) . | ||
| DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record | |||
| FIRST_OPERATION_SEQ_CODE | VARCHAR2 | 10 | First operation sequence code of the network | ||
| LAST_OPERATION_SEQ_CODE | VARCHAR2 | 10 | LAST_OPERATION_SEQ_CODE | ||
| COMMON_ROUTING_NAME | VARCHAR2 | 250 | Name of the Routing or the Work definition that is common between parent and child | ||
| ITEM_PROCESS_COST | NUMBER | Identifies the inventory item process cost | |||
| OPERATION_SEQ_CODE | VARCHAR2 | 10 | This value indicates OPERATION_SEQ_CODE. | ||
| EFFECTIVITY_DATE | DATE | Indicate the date from when this routing is effective | |||
| DEPARTMENT_CODE | VARCHAR2 | 10 | Department code or the work centre of the resource. | ||
| OPTION_DEPENDENT_FLAG | NUMBER | This value indicates OPTION_DEPENDENT_FLAG. | |||
| OPERATION_DESCRIPTION | VARCHAR2 | 960 | OPERATION_DESCRIPTION | ||
| DISABLE_DATE | DATE | Disable date of the routing or a work definition. | |||
| FROM_UNIT_NUMBER | VARCHAR2 | 30 | Effective from this unit number | ||
| TO_UNIT_NUMBER | VARCHAR2 | 30 | To unit number specified in the routing or work definition. | ||
| OPERATION_TYPE | NUMBER | Indicate operation type: Process, Line, or Event. Events are not used here | |||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | |||
| YIELD | NUMBER | Process yield at this operation | |||
| OPERATION_LEAD_TIME_PERCENT | NUMBER | Indicates the amount of overlape its lead time has with the parent lead time | |||
| CUMULATIVE_YIELD | NUMBER | Cummulative process yield from the beginning of routing to this operation | |||
| REVERSE_CUMULATIVE_YIELD | NUMBER | Reverse cumulative yield of the resource requirement. | |||
| NET_PLANNING_PERCENT | NUMBER | Cummulative planning percents derived from the operation network | |||
| SETUP_DURATION | NUMBER | Duration of the set-up for the routing/work definition operation. | |||
| TEAR_DOWN_DURATION | NUMBER | Duration of the tear down for this operation | |||
| DURATION_UOM_CODE | VARCHAR2 | 3 | Unit of measure in which duration is entered for a Shift. | ||
| STANDARD_OPERATION_CODE | VARCHAR2 | 4 | Standard operation code of the routing or work definition. | ||
| RESOURCE_SEQ_CODE | VARCHAR2 | 10 | Resource sequence code from source application instance | ||
| RESOURCE_CODE | VARCHAR2 | 10 | Resource code from source application instance | ||
| ALTERNATE_NUMBER | NUMBER | Resources with the same number are simultaneous. Different numbers are represent alternatives between groups of resources | |||
| PRINCIPAL_FLAG | NUMBER | Flag to indicate whether the resource is the principal resource | |||
| BASIS_TYPE | NUMBER | Item(1), lot(2), resource units(3), resource value(4), total value(5), activity(6). | |||
| RESOURCE_USAGE | NUMBER | Alternate resource volume necessary for this operation resource | |||
| MAX_RESOURCE_UNITS | NUMBER | Maximum number of resource units consumed by this operation resource | |||
| RESOURCE_UNITS | NUMBER | Operation resource units (capacity). This can be fixed by the user and used as constraint | |||
| RESOURCE_TYPE | NUMBER | This value indicates the RESOURCE_TYPE. | |||
| RESOURCE_OFFSET_PERCENT | NUMBER | This value indicates the RESOURCE_OFFSET_PERCENT. | |||
| PROCESS_FLAG | NUMBER | 2 | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
| ERROR_TEXT | VARCHAR2 | 2000 | Error text during the validation | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code populated in validation | ||
| SETUP_ID | NUMBER | Setup type to be used for this resource. | |||
| DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of data | ||
| SR_INSTANCE_ID | NUMBER | 18 | Identifier of the source system from where the data is collected. | ||
| ORGANIZATION_ID | NUMBER | 18 | Organization_id | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Bill of material unique identifier | ||
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Item identifier of the assembly. | ||
| ROUTING_SEQUENCE_ID | NUMBER | 18 | Routing sequence identifier for the routing/work definition. | ||
| COMMON_ROUTING_SEQUENCE_ID | NUMBER | 18 | Common routing sequence identifier | ||
| RESOURCE_SEQ_NUM | NUMBER | This value indicates the Resource sequence number. | |||
| RESOURCE_ID | NUMBER | 18 | This value indicates the RESOURCE_ID. | ||
| OPERATION_SEQUENCE_ID | NUMBER | 18 | OPERATION_SEQUENCE_ID | ||
| DEPARTMENT_ID | NUMBER | 18 | Department identifier or the work centre of the resource. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number | |||
| STG_ERROR_CODE | VARCHAR2 | 2000 | Error code encountered during planning collections. | ||
| ROUTING_DELETED_FLAG | NUMBER | Indicates if this record is to delete the routing | |||
| ROUTING_OPR_DELETED_FLAG | NUMBER | Indicates if this record is to delete the routing Operation | |||
| ROUTING_OPR_RES_DELETED_FLAG | NUMBER | Indicates if this record is to delete the routing operation resource | |||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection progam | |||
| RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
| SCHEDULE_FLAG | NUMBER | Flag to determine the possibility of overlapping of this operation resource and operation resources in other operations |