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 |