MSC_ITEM_CUSTOMERS
This table stores the Item, Organization, Customer Site and Demand class combinations read from Sales Orders and Forecast measures. This is a snapshot only table and not populated during collections.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_ITEM_CUSTOMERS_PK |
PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, CUSTOMER_SITE_ID, DEMAND_CLASS_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan Identifier | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Item Identifier | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
| CUSTOMER_ID | NUMBER | Customer Identifier | ||
| CUSTOMER_SITE_ID | NUMBER | Yes | Customer Site Identifier | |
| ZONE_ID | NUMBER | Zone Identifier | ||
| DEMAND_CLASS_ID | NUMBER | Yes | Demand Class Identifier | |
| 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. |
| REFRESH_NUMBER | NUMBER | Last refresh number | ||
| 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_ITEM_CUSTOMERS_U1 | Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, CUSTOMER_SITE_ID, DEMAND_CLASS_ID |