MSC_ANALYTIC_ITEMS
MSC_ANALYTIC_ITEMS for OTBI reports for Value Chain Planning.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_ANALYTIC_ITEMS_PK |
PLAN_ID, HIERARCHY_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CATEGORY_SET_ID | NUMBER | 18 | Yes | This column is used to store category set identifier | |
| 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. | ||
| CATEGORY_SET_NAME | VARCHAR2 | 240 | Yes | This column is used to store category set name | |
| HIERARCHY_ID | NUMBER | Yes | This column is used to store hierarchy identifier | ||
| MEMBER1 | NUMBER | This column is used to store member details | |||
| NAME1 | VARCHAR2 | 240 | This column is used to store analytic item name | ||
| MEMBER2 | NUMBER | This column is used to store member details | |||
| NAME2 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER3 | NUMBER | This column is used to store member details | |||
| NAME3 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER4 | NUMBER | This column is used to store member details | |||
| NAME4 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER5 | NUMBER | This column is used to store member details | |||
| NAME5 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER6 | NUMBER | This column is used to store member details | |||
| NAME6 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER7 | NUMBER | This column is used to store member details | |||
| NAME7 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER8 | NUMBER | This column is used to store member details | |||
| NAME8 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER9 | NUMBER | This column is used to store member details | |||
| NAME9 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| MEMBER10 | NUMBER | This column is used to store member details | |||
| NAME10 | VARCHAR2 | 240 | This column is used to store analytic item name. | ||
| PLAN_ID | NUMBER | 18 | Yes | This column is used to store plan identifier | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This column is used to store inventory item identifier | |
| ITEM_NAME | VARCHAR2 | 300 | This column is used to store analytic item name | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column is used to store organization identifier | |
| DESCRIPTION | VARCHAR2 | 240 | This column is used to store description | ||
| UOM_CODE | VARCHAR2 | 20 | This column is used to store uom code | ||
| ABC_CLASS_NAME | VARCHAR2 | 240 | This column is used to store abc class name | ||
| FIXED_LEAD_TIME | NUMBER | This column is used to store fixed lead time | |||
| VARIABLE_LEAD_TIME | NUMBER | This column is used to store variable lead time | |||
| PREPROCESSING_LEAD_TIME | NUMBER | This column is used to store preprocessing lead time | |||
| POSTPROCESSING_LEAD_TIME | NUMBER | This column is used to store post processing lead time | |||
| CUM_MANUFACTURING_LEAD_TIME | NUMBER | 18 | This column is used to store cumulative manufacturing lead time | ||
| FIXED_DAYS_SUPPLY | NUMBER | This column is used to store fixed days supply | |||
| FIXED_ORDER_QUANTITY | NUMBER | This column is used to store fixed order quantity | |||
| FIXED_LOT_MULTIPLIER | NUMBER | This column is used to store fixed lot multiplier | |||
| MINIMUM_ORDER_QUANTITY | NUMBER | This column is used to store minimum order quantity | |||
| MAXIMUM_ORDER_QUANTITY | VARCHAR2 | 20 | This column is used to store maximum order quantity. | ||
| PLANNER_CODE | VARCHAR2 | 240 | This column is used to store planner code | ||
| BUYER_NAME | VARCHAR2 | 240 | This column is used to store buyer name | ||
| ORGANIZATION_CODE | VARCHAR2 | 240 | This column is used to store organization code | ||
| PLANNING_MAKE_BUY_CODE | VARCHAR2 | 20 | This column is used to store planning make buy code | ||
| CRITICAL_COMPONENT_FLAG | VARCHAR2 | 240 | This column is used to store critical component code | ||
| ATO_FORECAST_CONTROL | VARCHAR2 | 4000 | This column is used to store ato forecast control | ||
| SAFETY_STOCK_CODE | NUMBER | This column is used to store safety stock code | |||
| SAFETY_STOCK_PERCENT | NUMBER | This column is used to store safety stock percent | |||
| DEMAND_TIME_FENCE_DATE | DATE | This column is used to store demand time fence | |||
| PLANNING_TIME_FENCE_DATE | DATE | This column is used to store planning time fence | |||
| DEMAND_TIME_FENCE_DAYS | NUMBER | This column is used to store demand time fence days | |||
| PLANNING_TIME_FENCE_DAYS | NUMBER | This column is used to store planning time fence days | |||
| RELEASE_TIME_FENCE_DAYS | NUMBER | This column is used to store release time fence days | |||
| RELEASE_TIME_FENCE_CODE | VARCHAR2 | 240 | This column is used to store release time fence code | ||
| DEMAND_TIME_FENCE_CODE | VARCHAR2 | 240 | This column is used to store demand time fence code | ||
| PLANNING_TIME_FENCE_CODE | VARCHAR2 | 240 | This column is used to store planning time fence code | ||
| CARRYING_COST | NUMBER | This column is used to store carrying cost | |||
| SAFETY_STOCK_QUANTITY | NUMBER | This column is used to store safety stock quantity | |||
| SAFETY_STOCK_QUANTITY_OVERRIDE | NUMBER | This column is used to store safety stock quantity override | |||
| LIFE_CYCLE_PHASE | VARCHAR2 | 120 | This column stores life cycle phase | ||
| FULL_LEAD_TIME | NUMBER | This column is used to store full lead time | |||
| LIST_PRICE | NUMBER | This column is used to store list price | |||
| ITEM_COST_OVERRIDE | NUMBER | This column stores item cost override | |||
| ITEM_COST_UOM | VARCHAR2 | 240 | This column stores item cost uom | ||
| FORECAST_NAME | VARCHAR2 | 240 | This column is used to store forecast name | ||
| USE_UP_DATE | DATE | This column is used to store USE_UP_DATE | |||
| BASE_MODEL | VARCHAR2 | 240 | This column is used to store base model | ||
| BOM_ITEM_TYPE | VARCHAR2 | 240 | This column is used to store bom item type | ||
| MRP_PLANNING_CODE | VARCHAR2 | 240 | This column stores mrp planning code | ||
| NET_SELLING_PRICE | NUMBER | This column stores net selling price | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE1 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_ANALYTIC_ITEMS_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID | Obsolete |
| MSC_ANALYTIC_ITEMS_U2 | Unique | Default | PLAN_ID, CATEGORY_SET_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID | Obsolete |
| MSC_ANALYTIC_ITEMS_U3 | Unique | Default | PLAN_ID, HIERARCHY_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |