MSC_ST_ITEM_SUBSTITUTES

The staging table used by the collection program to validate and process data for table MSC_ITEM_SUBSTITUTES.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Not-null	Comments
SR_INSTANCE_ID	NUMBER			Source application instance identifier
LOWER_ITEM_ID	NUMBER			Item identifier generated by the collection program
HIGHER_ITEM_ID	NUMBER			Item identifier generated by the collection program
HIGHEST_ITEM_ID	NUMBER			Item identifier generated by the collection program
CUSTOMER_ID	NUMBER			Unique Partner identifier generated by the collection program
CUSTOMER_SITE_ID	NUMBER			Customer site unique identifier
EFFECTIVE_DATE	DATE			Effective date of Item relationship
DISABLE_DATE	DATE			Disable date of Item relationship
RELATIONSHIP_TYPE	NUMBER			This value indicates the Type of the Item relationship.
RECIPROCAL_FLAG	NUMBER			This value indicates the Reciprocal Flag.
SUBSTITUTION_SET	VARCHAR2	50		Substitution set name used to define Item relationship
PARTIAL_FULFILLMENT_FLAG	NUMBER			Partial fulfillment flag indicating whether partial substitution is allowed.
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.
LAST_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to 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.
RELATED_ITEM_NAME	VARCHAR2	300		Substitute Item Name of the primary item in the substitution relationship.
ITEM_NAME	VARCHAR2	300		Identifies the inventory item name
CUSTOMER_NAME	VARCHAR2	360		Party name assigned to the customer
CUSTOMER_SITE_CODE	VARCHAR2	30		Unique code associated to the customer site
SR_INSTANCE_CODE	VARCHAR2	30		Source Instance code from which data is being populated.
MESSAGE_ID	NUMBER			This value indicates the message identifier for the record.
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
DATA_SOURCE_TYPE	VARCHAR2	15		Source Type indicating the source of data
ST_TRANSACTION_ID	NUMBER			This value indicates the staging transaction identifier.
ERROR_TEXT	VARCHAR2	2000		This will describe the reason for the error if any.
BATCH_ID	NUMBER			Batch identifier generated during processing
DELETED_FLAG	NUMBER			Flag indicating whether this is a deleted record
COMPANY_NAME	VARCHAR2	250		Party name with which the company is registered.
ORGANIZATION_ID	NUMBER			Organization Identifier, foreign key to msc_parameters
ORGANIZATION_CODE	VARCHAR2	18		Unique code assigned to the Organization
REFRESH_NUMBER	NUMBER			Refresh identifier populated by the collection progam
RETRY_COUNT	NUMBER			Number of retries to process failed records.
ERROR_CODE	VARCHAR2	150		Error code for functional validation errors in the record
CUST_ACCOUNT_NUMBER	VARCHAR2	30		Account number associated to the customer
PARTY_SITE_NUMBER	VARCHAR2	30		Unique party site number generated on the source system for the trading partner site.
LOAD_REQUEST_ID	NUMBER			It Stores the Request ID of Job that loaded the data.
PLANNING_ENABLED_FLAG	NUMBER			Flag to specify if the related item is enabled for planning. Valid values are 1(Yes), 2(No)
ORG_INDEPENDENT_FLAG	NUMBER			Indicates whether the item substitution is controlled at Master level (1) or Organization level (2)
RELATIONSHIP_DESC	VARCHAR2	240		Description of Item Relationship
RANK	NUMBER			This value indicates the Rank of the item relationship.