MSC_ST_WD_OPERATIONS_INT
This table stores WD operations records from which we load to ODS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORGANIZATION_CODE | VARCHAR2 | 18 | Organization code in the Planning System. | ||
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | This value indicates code of the work definition. | ||
| OPERATION_SEQ_NUMBER | NUMBER | Indicates the sequence of this operation within the work definition. | |||
| EFFECTIVITY_DATE | DATE | Indicate the date from when this operation is effective | |||
| WORK_DEFINITION_ID | NUMBER | This value indicates identifier of the work definition. | |||
| OPERATION_DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the work definition operation. | ||
| DISABLE_DATE | DATE | Effective end date of the work definition operation. | |||
| OPTION_DEPENDENT_FLAG | VARCHAR2 | 1 | This value indicates Option Dependent Flag. | ||
| WORK_CENTER_CODE | VARCHAR2 | 30 | Work center code assigned to the work definition operation. | ||
| YIELD | NUMBER | This value indicates the Yield specified for the operation in resource demand. | |||
| OPERATION_TYPE | NUMBER | This column indicates the Operation Type. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| 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. | ||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | |||
| ERROR_TEXT | VARCHAR2 | 2000 | Error text for functional validation errors in the record | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |||
| DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record | |||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | ||
| ASSEMBLY_NAME | VARCHAR2 | 300 | Name assigned to the assembly item | ||
| NET_PLANNING_PERCENT | NUMBER | Cumulative planning percents derived from the operation network. | |||
| CONFIG_ITEM_FLAG | NUMBER | 1 | Flag to Indicate that the item is a configured Item. | ||
| OSP_ITEM_ID | NUMBER | 18 | Inventory item identifier of the Outside processing item. | ||
| OSP_OPERATION_TYPE | NUMBER | Operation type of the outside processing item. | |||
| OPERATION_COST | NUMBER | This value indicates Outside Processing operation cost. | |||
| SUPPLIER_ID | NUMBER | 18 | This value indicates the Supplier identifier in the planning system. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | This value indicates the Supplier site identifier. | ||
| LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the assembly being manufactured. | |||
| SR_WD_OPERATION_ID | NUMBER | This indicates the manufacturing side identifier of work definition operation. | |||
| SUPPLIER_NAME | VARCHAR2 | 360 | Name of Supplier for Outside Processing operation | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | 240 | Supplier site code for Outside Processing operation | ||
| MINIMUM_TRANSFER_QUANTITY | NUMBER | This value indicates minimum transfer quantity for the corresponding routing of this operation. | |||
| AUTO_TRANSACT_FLAG | NUMBER | 1 | Indicates whether both resources and materials are automatically charged based on the supply type or the charge type setups for the operation. If the supply type is Operation Pull, the component level issue transactions will happen when the operation is completed. If the supply type is Assembly Pull, the component level issue transactions will happen at the assembly completion event. Resource transactions are automatically done when the quantity is moved outside the operation. Valid values are 1 and 2. | ||
| LINE_OP_SEQ_NUMBER | NUMBER | Indicates the production line operation sequence number. |