SCH_REC_PARAMETER_VALUES

This table stores values for the different parameter codes required to manage a recall notice for the respective entities such as Business Unit and Inventory Organization.

Details

• Schema: FUSION

• Object owner: SCH

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SCH_REC_PARAMETER_VALUES_PK	PARAMETER_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PARAMETER_VALUE_ID	NUMBER		18	Yes	Recall Parameter value unique identifier.
PARAMETER_ID	NUMBER		18		Recall Parameter unique identifier.
PARAMETER_VALUE_CODE1	VARCHAR2	60			Indicates the parameter values required to be set up for Product Recall Management. This value code is intended to store the prefix of recall notice number for the parameter 'Recall Notice Document Number Sequencing', product traceability grouping value for the parameter 'Product Traceability Grouping' and subinventory for the parameter 'Recall Subinventory and Stock Locator'.
PARAMETER_VALUE_CODE2	VARCHAR2	60			Indicates the parameter values required to be set up for Product Recall Management. This value code is intended to store recall notice number for the parameter 'Recall Notice Document Number Sequencing', stock locator for the parameter 'Recall Subinventory and Stock Locator'.
PARAMETER_VALUE_CODE3	VARCHAR2	60			Indicates the parameter values required to be set up for Product Recall Management. This value code is intended to store the suffix of recall notice number for the parameter 'Recall Notice Document Number Sequencing'.
PARAMETER_VALUE_CODE4	VARCHAR2	60			Indicates the parameter values required to be set up for Product Recall Management. This value code indicates whether the pick subinventory is required during recall count through the mobile application for the parameter 'Recall Subinventories'.
BUSINESS_UNIT_ID	NUMBER		18		Business Unit unique identifier for which the parameter value is set.
INVENTORY_ORGANIZATION_ID	NUMBER		18		Inventory Organization unique identifier for which the parameter value is set.Also for Item validation Organization Parameter , it stores the Item Organization value for a business unit.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.	Obsolete
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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_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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
SCH_REC_PARAMETER_VALUES	sch_rec_parameters_b	PARAMETER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
SCH_REC_PARAMETER_VALUES_N1	Non Unique	Default	PARAMETER_ID
SCH_REC_PARAMETER_VALUES_U1	Unique	Default	PARAMETER_VALUE_ID