MSC_PLANNING_UOMS

This table is maintained by Snapshot. This table will be used to store the Mapping of the UOM Code to the Sequence generated ID used in the PDS UOM table column names

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_PLANNING_UOMS_PK	UOM_CODE, PLANNING_COLUMN_ID

Columns

Name	Datatype	Length	Not-null	Comments
UOM_CODE	VARCHAR2	3	Yes	UOM_CODE for the UOM
PLANNING_COLUMN_ID	NUMBER		Yes	PLANNING_COLUMN_ID Generated by sequence MSC_PLANNING_UOMS_S This id is used in the UOM column names in the Planning UOM Conversion Dynamic tables
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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_PLANNING_UOMS_U1	Unique	Default	UOM_CODE, PLANNING_COLUMN_ID