MSS_SUPPLIES

Details

Schema: FUSION
Object owner: MSS
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
MSS_SUPPLIES_PK	PLAN_ID, SUPPLY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
SUPPLY_ID	NUMBER		18	Yes	Refers to the external supply event.
SUPPLY_NUMBER	VARCHAR2	300		Yes	Indicates the supply order number.
SUPPLY_LINE_ITEM_NUMBER	VARCHAR2	150		Yes	Indicates the supply line-item number.
SUPPLY_HEADER_ID	NUMBER		18		Reference to the identifier for the source supply order.
SUPPLY_LINE_ID	NUMBER		18		Reference to the identifier for the source supply order line.
TRANSFER_ORDER_HEADER_ID	NUMBER		18		Reference to the transfer order header unique identifier.
FOLDER_PATH	VARCHAR2	300			Path to the folder where the supply order is located.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Refers to the inventory item of the line-item. Foreign key to MSS_INVENTORY_ITEMS.
QUANTITY	NUMBER			Yes	Quantity for the supply line-item.
SUPPLIER_NUMBER	VARCHAR2	240			Supplier (partner) number of the supply order.
SUPPLIER_NAME	VARCHAR2	300			Supplier name of the supply order.
ORIGIN_ADDRESS	VARCHAR2	240			Address of origin for the supply order (multiple lines).
SUPPLY_TYPE	VARCHAR2	30			Indicates the type of the supply order, e.g. 'Purchase Order', etc.
SUPPLY_STATUS	VARCHAR2	30		Yes	User defined status of the line-item: Approved\|OnHold.
REQUEST_DATE	TIMESTAMP			Yes	Request date of the supply line-item.
EARLIEST_DATE	TIMESTAMP				Earliest date of the supply line-item.
LATEST_DATE	TIMESTAMP				Latest date of the supply line-item.
SELECTED_DATE	TIMESTAMP				Engine-scheduled date of the line-item (solution).
REQUEST_DATE_OVERRIDE	TIMESTAMP				User-defined date used by the scheduling engine to replace both the REQUEST_DATE and EARLIEST_DATE values.
RESERVATIONS_FLAG	VARCHAR2	1			Flag that indicates that the supply order has reservations for this line-item: Y\|N.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of 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
MSS_SUPPLIES	mss_items	PLAN_ID, INVENTORY_ITEM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_SUPPLIES_N1	Non Unique	Default	PLAN_ID, INVENTORY_ITEM_ID
MSS_SUPPLIES_N2	Non Unique	Default	PLAN_ID, FOLDER_PATH
MSS_SUPPLIES_U1	Unique	Default	PLAN_ID, SUPPLY_ID
MSS_SUPPLIES_U2	Unique	Default	PLAN_ID, SUPPLY_NUMBER, SUPPLY_LINE_ITEM_NUMBER