MSC_SCP_HISTORY_EXT
Table to store the information about the SCP Sales History data extraction for IoT
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_SCP_HISTORY_EXT_PK |
PLANID, PRODUCTITEMID, PRODUCTITEMORGANIZATIONID, CUSTOMERSITEID, DEMANDCLASSIDENTIFIER, SALESDATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLANID | NUMBER | 18 | Yes | This column stores the unique plan id. This column name should be read as PLAN_ID | |
| PRODUCTITEMID | NUMBER | 18 | Yes | This column stores the unique item id. This column name should be read as PRODUCT_ITEM_ID | |
| PRODUCTITEMORGANIZATIONID | NUMBER | 18 | Yes | This column stores the unique organization id. This column name should be read as PRODUCT_ITEM_ORGANIZATION_ID | |
| CUSTOMERSITEID | NUMBER | 18 | Yes | This column stores the unique customer site id. This column name should be read as CUSTOMER_SITE_ID | |
| DEMANDCLASSIDENTIFIER | NUMBER | 18 | Yes | This column stores the unique demand class id. This column name should be read as DEMAND_CLASS_IDENTIFIER | |
| SALESDATE | DATE | Yes | This column stores the History sales date. This column name should be read as SALES_DATE | ||
| TARGETVAR1 | NUMBER | Column to store target variable 1. This Column should be read as TARGET_VAR_1 | |||
| TARGETVAR2 | NUMBER | Column to store target variable 2. This Column should be read as TARGET_VAR_2 | |||
| TARGETVAR3 | NUMBER | Column to store target variable 3. This Column should be read as TARGET_VAR_3 | |||
| TARGETVAR4 | NUMBER | Column to store target variable 4. This Column should be read as TARGET_VAR_4 | |||
| TARGETVAR5 | NUMBER | Column to store target variable 5. This Column should be read as TARGET_VAR_5 | |||
| TARGETVAR6 | NUMBER | Column to store target variable 6. This Column should be read as TARGET_VAR_6 | |||
| TARGETVAR7 | NUMBER | Column to store target variable 7. This Column should be read as TARGET_VAR_7 | |||
| TARGETVAR8 | NUMBER | Column to store target variable 8. This Column should be read as TARGET_VAR_8 | |||
| TARGETVAR9 | NUMBER | Column to store target variable 9. This Column should be read as TARGET_VAR_9 | |||
| TARGETVAR10 | NUMBER | Column to store target variable 10. This Column should be read as TARGET_VAR_10 | |||
| OTHERNUM1 | NUMBER | Column to store numerical attribute 1. This column name should be read as OTHER_NUM_1 | |||
| OTHERNUM2 | NUMBER | Column to store numerical attribute 2. This column name should be read as OTHER_NUM_2 | |||
| OTHERNUM3 | NUMBER | Column to store numerical attribute 3. This column name should be read as OTHER_NUM_3 | |||
| OTHERNUM4 | NUMBER | Column to store numerical attribute 4. This column name should be read as OTHER_NUM_4 | |||
| OTHERNUM5 | NUMBER | Column to store numerical attribute 5. This column name should be read as OTHER_NUM_5 | |||
| OTHERNUM6 | NUMBER | Column to store numerical attribute 6. This column name should be read as OTHER_NUM_6 | |||
| OTHERNUM7 | NUMBER | Column to store numerical attribute 7. This column name should be read as OTHER_NUM_7 | |||
| OTHERNUM8 | NUMBER | Column to store numerical attribute 8. This column name should be read as OTHER_NUM_8 | |||
| OTHERNUM9 | NUMBER | Column to store numerical attribute 9. This column name should be read as OTHER_NUM_9 | |||
| OTHERNUM10 | NUMBER | Column to store numerical attribute 10. This column name should be read as OTHER_NUM_10 | |||
| OTHERNUM11 | NUMBER | Column to store numerical attribute 11. This column name should be read as OTHER_NUM_11 | |||
| OTHERNUM12 | NUMBER | Column to store numerical attribute 12. This column name should be read as OTHER_NUM_12 | |||
| OTHERNUM13 | NUMBER | Column to store numerical attribute 13. This column name should be read as OTHER_NUM_13 | |||
| OTHERNUM14 | NUMBER | Column to store numerical attribute 14. This column name should be read as OTHER_NUM_14 | |||
| OTHERNUM15 | NUMBER | Column to store numerical attribute 15. This column name should be read as OTHER_NUM_15 | |||
| OTHERNUM16 | NUMBER | Column to store numerical attribute 16. This column name should be read as OTHER_NUM_16 | |||
| OTHERNUM17 | NUMBER | Column to store numerical attribute 17. This column name should be read as OTHER_NUM_17 | |||
| OTHERNUM18 | NUMBER | Column to store numerical attribute 18. This column name should be read as OTHER_NUM_18 | |||
| OTHERNUM19 | NUMBER | Column to store numerical attribute 19. This column name should be read as OTHER_NUM_19 | |||
| OTHERNUM20 | NUMBER | Column to store numerical attribute 20. This column name should be read as OTHER_NUM_20 | |||
| OTHERNUM21 | NUMBER | Column to store numerical attribute 21. This column name should be read as OTHER_NUM_21 | |||
| OTHERNUM22 | NUMBER | Column to store numerical attribute 22. This column name should be read as OTHER_NUM_22 | |||
| OTHERNUM23 | NUMBER | Column to store numerical attribute 23. This column name should be read as OTHER_NUM_23 | |||
| OTHERNUM24 | NUMBER | Column to store numerical attribute 24. This column name should be read as OTHER_NUM_24 | |||
| OTHERNUM25 | NUMBER | Column to store numerical attribute 25. This column name should be read as OTHER_NUM_25 | |||
| OTHERNUM26 | NUMBER | Column to store numerical attribute 26. This column name should be read as OTHER_NUM_26 | |||
| OTHERNUM27 | NUMBER | Column to store numerical attribute 27. This column name should be read as OTHER_NUM_27 | |||
| OTHERNUM28 | NUMBER | Column to store numerical attribute 28. This column name should be read as OTHER_NUM_28 | |||
| OTHERNUM29 | NUMBER | Column to store numerical attribute 29. This column name should be read as OTHER_NUM_29 | |||
| OTHERNUM30 | NUMBER | Column to store numerical attribute 30. This column name should be read as OTHER_NUM_30 | |||
| OTHERNUM31 | NUMBER | Column to store numerical attribute 31. This column name should be read as OTHER_NUM_31 | |||
| OTHERNUM32 | NUMBER | Column to store numerical attribute 32. This column name should be read as OTHER_NUM_32 | |||
| OTHERNUM33 | NUMBER | Column to store numerical attribute 33. This column name should be read as OTHER_NUM_33 | |||
| OTHERNUM34 | NUMBER | Column to store numerical attribute 34. This column name should be read as OTHER_NUM_34 | |||
| OTHERNUM35 | NUMBER | Column to store numerical attribute 35. This column name should be read as OTHER_NUM_35 | |||
| OTHERNUM36 | NUMBER | Column to store numerical attribute 36. This column name should be read as OTHER_NUM_36 | |||
| OTHERNUM37 | NUMBER | Column to store numerical attribute 37. This column name should be read as OTHER_NUM_37 | |||
| OTHERNUM38 | NUMBER | Column to store numerical attribute 38. This column name should be read as OTHER_NUM_38 | |||
| OTHERNUM39 | NUMBER | Column to store numerical attribute 39. This column name should be read as OTHER_NUM_39 | |||
| OTHERNUM40 | NUMBER | Column to store numerical attribute 40. This column name should be read as OTHER_NUM_40 | |||
| OTHERNUM41 | NUMBER | Column to store numerical attribute 41. This column name should be read as OTHER_NUM_41 | |||
| OTHERNUM42 | NUMBER | Column to store numerical attribute 42. This column name should be read as OTHER_NUM_42 | |||
| OTHERNUM43 | NUMBER | Column to store numerical attribute 43. This column name should be read as OTHER_NUM_43 | |||
| OTHERNUM44 | NUMBER | Column to store numerical attribute 44. This column name should be read as OTHER_NUM_44 | |||
| OTHERNUM45 | NUMBER | Column to store numerical attribute 45. This column name should be read as OTHER_NUM_45 | |||
| OTHERNUM46 | NUMBER | Column to store numerical attribute 46. This column name should be read as OTHER_NUM_46 | |||
| OTHERNUM47 | NUMBER | Column to store numerical attribute 47. This column name should be read as OTHER_NUM_47 | |||
| OTHERNUM48 | NUMBER | Column to store numerical attribute 48. This column name should be read as OTHER_NUM_48 | |||
| OTHERNUM49 | NUMBER | Column to store numerical attribute 49. This column name should be read as OTHER_NUM_49 | |||
| OTHERNUM50 | NUMBER | Column to store numerical attribute 50. This column name should be read as OTHER_NUM_50 | |||
| OTHERNUM51 | NUMBER | Column to store numerical attribute 51. This column name should be read as OTHER_NUM_51 | |||
| OTHERNUM52 | NUMBER | Column to store numerical attribute 52. This column name should be read as OTHER_NUM_52 | |||
| OTHERNUM53 | NUMBER | Column to store numerical attribute 53. This column name should be read as OTHER_NUM_53 | |||
| OTHERNUM54 | NUMBER | Column to store numerical attribute 54. This column name should be read as OTHER_NUM_54 | |||
| OTHERNUM55 | NUMBER | Column to store numerical attribute 55. This column name should be read as OTHER_NUM_55 | |||
| OTHERNUM56 | NUMBER | Column to store numerical attribute 56. This column name should be read as OTHER_NUM_56 | |||
| OTHERNUM57 | NUMBER | Column to store numerical attribute 57. This column name should be read as OTHER_NUM_57 | |||
| OTHERNUM58 | NUMBER | Column to store numerical attribute 58. This column name should be read as OTHER_NUM_58 | |||
| OTHERNUM59 | NUMBER | Column to store numerical attribute 59. This column name should be read as OTHER_NUM_59 | |||
| OTHERNUM60 | NUMBER | Column to store numerical attribute 60. This column name should be read as OTHER_NUM_60 | |||
| OTHERNUM61 | NUMBER | Column to store numerical attribute 61. This column name should be read as OTHER_NUM_61 | |||
| OTHERNUM62 | NUMBER | Column to store numerical attribute 62. This column name should be read as OTHER_NUM_62 | |||
| OTHERNUM63 | NUMBER | Column to store numerical attribute 63. This column name should be read as OTHER_NUM_63 | |||
| OTHERNUM64 | NUMBER | Column to store numerical attribute 64. This column name should be read as OTHER_NUM_64 | |||
| OTHERNUM65 | NUMBER | Column to store numerical attribute 65. This column name should be read as OTHER_NUM_65 | |||
| OTHERNUM66 | NUMBER | Column to store numerical attribute 66. This column name should be read as OTHER_NUM_66 | |||
| OTHERNUM67 | NUMBER | Column to store numerical attribute 67. This column name should be read as OTHER_NUM_67 | |||
| OTHERNUM68 | NUMBER | Column to store numerical attribute 68. This column name should be read as OTHER_NUM_68 | |||
| OTHERNUM69 | NUMBER | Column to store numerical attribute 69. This column name should be read as OTHER_NUM_69 | |||
| OTHERNUM70 | NUMBER | Column to store numerical attribute 70. This column name should be read as OTHER_NUM_70 | |||
| OTHERNUM71 | NUMBER | Column to store numerical attribute 71. This column name should be read as OTHER_NUM_71 | |||
| OTHERNUM72 | NUMBER | Column to store numerical attribute 72. This column name should be read as OTHER_NUM_72 | |||
| OTHERNUM73 | NUMBER | Column to store numerical attribute 73. This column name should be read as OTHER_NUM_73 | |||
| OTHERNUM74 | NUMBER | Column to store numerical attribute 74. This column name should be read as OTHER_NUM_74 | |||
| OTHERNUM75 | NUMBER | Column to store numerical attribute 75. This column name should be read as OTHER_NUM_75 | |||
| OTHERNUM76 | NUMBER | Column to store numerical attribute 76. This column name should be read as OTHER_NUM_76 | |||
| OTHERNUM77 | NUMBER | Column to store numerical attribute 77. This column name should be read as OTHER_NUM_77 | |||
| OTHERNUM78 | NUMBER | Column to store numerical attribute 78. This column name should be read as OTHER_NUM_78 | |||
| OTHERNUM79 | NUMBER | Column to store numerical attribute 79. This column name should be read as OTHER_NUM_79 | |||
| OTHERNUM80 | NUMBER | Column to store numerical attribute 80. This column name should be read as OTHER_NUM_80 | |||
| OTHERNUM81 | NUMBER | Column to store numerical attribute 81. This column name should be read as OTHER_NUM_81 | |||
| OTHERNUM82 | NUMBER | Column to store numerical attribute 82. This column name should be read as OTHER_NUM_82 | |||
| OTHERNUM83 | NUMBER | Column to store numerical attribute 83. This column name should be read as OTHER_NUM_83 | |||
| OTHERNUM84 | NUMBER | Column to store numerical attribute 84. This column name should be read as OTHER_NUM_84 | |||
| OTHERNUM85 | NUMBER | Column to store numerical attribute 85. This column name should be read as OTHER_NUM_85 | |||
| OTHERNUM86 | NUMBER | Column to store numerical attribute 86. This column name should be read as OTHER_NUM_86 | |||
| OTHERNUM87 | NUMBER | Column to store numerical attribute 87. This column name should be read as OTHER_NUM_87 | |||
| OTHERNUM88 | NUMBER | Column to store numerical attribute 88. This column name should be read as OTHER_NUM_88 | |||
| OTHERNUM89 | NUMBER | Column to store numerical attribute 89. This column name should be read as OTHER_NUM_89 | |||
| OTHERNUM90 | NUMBER | Column to store numerical attribute 90. This column name should be read as OTHER_NUM_90 | |||
| OTHERNUM91 | NUMBER | Column to store numerical attribute 91. This column name should be read as OTHER_NUM_91 | |||
| OTHERNUM92 | NUMBER | Column to store numerical attribute 92. This column name should be read as OTHER_NUM_92 | |||
| OTHERNUM93 | NUMBER | Column to store numerical attribute 93. This column name should be read as OTHER_NUM_93 | |||
| OTHERNUM94 | NUMBER | Column to store numerical attribute 94. This column name should be read as OTHER_NUM_94 | |||
| OTHERNUM95 | NUMBER | Column to store numerical attribute 95. This column name should be read as OTHER_NUM_95 | |||
| OTHERNUM96 | NUMBER | Column to store numerical attribute 96. This column name should be read as OTHER_NUM_96 | |||
| OTHERNUM97 | NUMBER | Column to store numerical attribute 97. This column name should be read as OTHER_NUM_97 | |||
| OTHERNUM98 | NUMBER | Column to store numerical attribute 98. This column name should be read as OTHER_NUM_98 | |||
| OTHERNUM99 | NUMBER | Column to store numerical attribute 99. This column name should be read as OTHER_NUM_99 | |||
| OTHERNUM100 | NUMBER | Column to store numerical attribute 100. This column name should be read as OTHER_NUM_100 | |||
| 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SCP_HISTORY_EXT_U1 | Unique | Default | PLANID, PRODUCTITEMID, PRODUCTITEMORGANIZATIONID, CUSTOMERSITEID, DEMANDCLASSIDENTIFIER, SALESDATE |