MSC_ST_WD_COMP_SUBS

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
MSC_ST_WD_COMP_SUBS_INT_PK	ORGANIZATION_CODE, WORK_DEFINITION_CODE, ASSEMBLY_NAME, OPERATION_SEQ_NUM, EFFECTIVITY_DATE, INVENTORY_ITEM_NAME, SUB_ITEM_NAME, REFRESH_NUMBER, PROCESS_FLAG, SR_INSTANCE_CODE, DELETED_FLAG

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COMPONENT_SEQUENCE_ID	NUMBER		18		Reference to the Item Structure component.
SR_COMP_SUBSTITUTE_ID	NUMBER				The identifier for Source Component Substitute
RETRY_COUNT	NUMBER				Number of times this record was retried in retry cycles
ORGANIZATION_CODE	VARCHAR2	18		Yes	The Identifier for organization code
SUBSTITUTE_ITEM_ID	NUMBER		18		Substitute item identifier of the BOM component.
USAGE_QUANTITY	NUMBER				This value indicates the quantity used.
ORGANIZATION_ID	NUMBER		18		The identifier of the organization for the BOM component
PRIORITY	NUMBER				Priority of the substitute specified for the component in the BOM.
DELETED_FLAG	NUMBER			Yes	Flag indicating whether this is a deleted 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.
SR_INSTANCE_ID	NUMBER		18		Identifier of the source system from where the data is collected.
REFRESH_NUMBER	NUMBER		18	Yes	Refresh identifier populated by the collection program.
BILL_SEQUENCE_ID	NUMBER				Bill of material unique identifier
ASSEMBLY_NAME	VARCHAR2	300		Yes	Name assigned to the assembly item
SR_INSTANCE_CODE	VARCHAR2	30		Yes	The value indicates the source system code from where the data is collected.
EFFECTIVITY_DATE	DATE			Yes	Date of effectivity for this component
ERROR_CODE	VARCHAR2	150			Error code for functional validation errors in the record
OPERATION_SEQ_NUM	NUMBER			Yes	The operation sequence number of this component
SUB_ITEM_NAME	VARCHAR2	300		Yes	Substitute item name of the Bom component.
WORK_DEFINITION_CODE	VARCHAR2	30		Yes	The work definition code related to the component
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	80			Name of the bill for alternate bills
INVENTORY_ITEM_NAME	VARCHAR2	300		Yes	The inventory item name of the component
ROUNDING_DIRECTION	NUMBER				This helps in enforcing the interger requirements.
ERROR_TEXT	VARCHAR2	2000			Error text for functional validation errors in the record
PROCESS_FLAG	NUMBER		2	Yes	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.
LOAD_REQUEST_ID	NUMBER				Loads the request id of job that inserts the data.
CONFIG_ITEM_FLAG	NUMBER		1		Flag to Indicate that the item is a configured Item.
FIND_NUMBER	NUMBER				This is analogous to Operation sequence number in Product Information Management Cloud. When a same component is assigned to an assembly multiple times with same effectivity, Find Number value is used to uniquely identify each occurrence of the component.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSC_ST_WD_COMP_SUBS_INT_U1	Unique	Default	ORGANIZATION_CODE, WORK_DEFINITION_CODE, ASSEMBLY_NAME, OPERATION_SEQ_NUM, EFFECTIVITY_DATE, INVENTORY_ITEM_NAME, SUB_ITEM_NAME, REFRESH_NUMBER, PROCESS_FLAG, SR_INSTANCE_CODE, DELETED_FLAG	Obsolete