1. Tables and Views for SCM
  2. MSC_ST_FS_WD_OP_MATERIALS_INT

MSC_ST_FS_WD_OP_MATERIALS_INT

This is an interface tables used during the collection run to store the Flow Schedule Component Demands.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SR_INSTANCE_CODE VARCHAR2 30 Source Instance code from which data is being populated.
FS_WD_HEADER_ID NUMBER 22 18 Yes The unique identifier of the record which represents the combination of work definition, item, and flow schedule completion date. Its value is an application generated unique id.
FS_WD_OP_MATERIAL_ID NUMBER 22 18 Yes The unique identifier for the exploded materials of a work definition. Its value is an application generated unique id.
ASSEMBLY_NAME VARCHAR2 1200 Name assigned to the assembly item.
COMPONENT_NAME VARCHAR2 1200 Name of the component of the assembly as defined in item structure or work definition.
ORGANIZATION_CODE VARCHAR2 72 This column indicates the organization code.
ASSEMBLY_ITEM_ID NUMBER 22 18 Assembly item identifier (item generating the demand for dependent demands).
ORGANIZATION_ID NUMBER 22 18 Yes The organization identifier that represents the manufacturing plant to which this operation material belongs.
INVENTORY_ITEM_ID NUMBER 22 18 The item identifier of the operation material.
QUANTITY_PER_PRODUCT NUMBER 22 Represents the quantity per assembly. This is the material quantity from the work definition operation material.
UOM_CODE VARCHAR2 3 Represents the unit of measure code of the specified quantity.
BASIS_TYPE NUMBER 22 Indicates whether the material quantity is fixed (i.e. quantity per lot produced) or variable (i.e. quantity per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE.
YIELD_FACTOR NUMBER This is the percentage of material quantity actually incorporated into the finished good.
SUPPLY_TYPE NUMBER 22 Reference of the supply type used for the work order operation material. Valid values exist in the lookup with lookup type = EGP_WIP_SUP_TYPE + lookup_type = ORA_WIE_WO_SUPPLY_TYPE.
ROUTING_SEQUENCE_ID NUMBER 22 18 Source application operational routing sequence identifier.
OPERATION_SEQ_NUMBER NUMBER 22 Yes Indicates the execution sequence of the operation.
WD_OPERATION_ID NUMBER 22 18 Represents the foreign key reference to the WIS_WD_OPERATIONS_B table for the work definition operation to which this material line is assigned.
WORK_DEFINITION_CODE VARCHAR2 120 Indicates the user defined work definition code.
WORK_DEFINITION_ID NUMBER 22 18 The unique identifier of a work definition. Its value is an application generated unique id.
OP_EFFECTIVE_FROM_DATE DATE Indicates the date from which this operation is effective.
PRODUCTION_LINE_ID NUMBER 22 18 The unique identifier of a production line. Its value is an application generated unique id.
DELETED_FLAG NUMBER 2 Yes/No flag indicates whether corresponding record in ODS will be deleted.
REFRESH_NUMBER NUMBER 22 18 Refresh identifier populated by the collection program.
ERROR_TEXT VARCHAR2 2000 This will describe the reason for the error if any.
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record.
PROCESS_FLAG NUMBER 2 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.
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.