MSS_RESERVATIONS
This table stores the inventory item reservations between supplies and demands.
Details
-
Schema: FUSION
-
Object owner: MSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSS_RESERVATIONS_PK |
PLAN_ID, RESERVATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | Identifier of the Production Scheduling plan. | |
| RESERVATION_ID | NUMBER | 18 | Yes | Unique identifier of reservations. | |
| RESERVATION_NAME | VARCHAR2 | 300 | User defined name of the reservation. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Refers to the inventory item of the reservation. Foreign key to MSS_INVENTORY_ITEMS. | |
| QUANTITY | NUMBER | Yes | Reserved quantity for the inventory item. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number of lot controlled reserved item. | ||
| ITEM_SERIAL_NUMBER | VARCHAR2 | 240 | Serial number of the item of the reservation. | ||
| SUPPLY_TYPE | VARCHAR2 | 12 | Yes | Type of the supply record for the reservation: On Hand|Supply Event|Work Order. | |
| DEMAND_TYPE | VARCHAR2 | 12 | Yes | Type of the demand record for the reservation: Demand Event|Work Order. | |
| SUPPLY_SOURCE_TYPE_ID | NUMBER | 18 | Indicates supply source of reservation. | ||
| DEMAND_SOURCE_TYPE_ID | NUMBER | 18 | Indicates demand source for which reservation is made. | ||
| SUPPLY_RECORD_ID | NUMBER | 18 | Refers to the supply record for the reservation. Soft foreign key to MSS_SUPPLIES or MSS_WORK_ORDERS, depending on the supply type. | ||
| DEMAND_RECORD_ID | NUMBER | 18 | Yes | Refers to the demand record for the reservation. Soft foreign key to MSS_DEMANDS or MSS_WORK_ORDERS, depending on the demand type. | |
| RESOURCE_SEQ_NUMBER | NUMBER | Resource sequence number of the work order operation. | |||
| 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_RESERVATIONS | mss_items | PLAN_ID, INVENTORY_ITEM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSS_RESERVATIONS_N1 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, SUPPLY_TYPE, DEMAND_TYPE |
| MSS_RESERVATIONS_U1 | Unique | Default | PLAN_ID, RESERVATION_ID |