CSO_MU_MAPPING
This table used as a Staging table for Mass Update.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSO_MU_MAPPING_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_ID | VARCHAR2 | 32 | Yes | Auto generated Record Id. | |
| DATE_ADDED | TIMESTAMP | Yes | The date article was added. | ||
| DATE_MODIFIED | TIMESTAMP | Yes | The date article was last modified. | ||
| UNIQUE_KEY | VARCHAR2 | 200 | Yes | Uniquely identifies across all MassUpdates, all BUs, all ProductGroups,ProductItems,Categories,UserGroups using IDs of source ProductGroups, Product Items, Categories, UserGroups. | |
| MU_REQUEST_ID | VARCHAR2 | 32 | Yes | RECORD_ID of Mass Update Request. For the common Mass Update, this will be MU_COMMON. | |
| SRC_MU_REQUEST_ID | VARCHAR2 | 32 | RECORD_ID of Source Mass Update Request from which this mapping was copied or for which this was created. | ||
| OBJECT_TYPE | NUMBER | 2 | Yes | ENUM: Category, ProductGroup, ProductItem, UserGroup. | |
| REMOVE_FROM_ARTICLES | NUMBER | 1 | Boolean: 1=True, 0=False, NULL=False. | ||
| BUSINESS_UNIT_ORG_ID | NUMBER | 18 | Yes | Target Business Unit. | |
| MAPPING_SOURCE_TYPE | NUMBER | 1 | Yes | ENUM: 0=MU_REQUEST, 1=MU_COMMON. | |
| ARTICLE_COUNT | NUMBER | 5 | Yes | Count of Articles which have this Product or Category or UserGroup in this MassUpdate. | |
| MAPPED | NUMBER | 1 | Boolean: 1=True, 0=False, NULL=False. | ||
| SRC_UNIQUE_KEY | VARCHAR2 | 64 | Unique Key which identifies the Source ProductGroup or ProductItem or Category or UserGroup. | ||
| SRC_CATEGORY_ID | NUMBER | 18 | CategoryID from FA. | ||
| SRC_USER_GROUP_ID | VARCHAR2 | 32 | Primary Key of CSO_TAG table. | ||
| SRC_PRODUCT_UNIQUE_KEY | VARCHAR2 | 64 | Natural (flattened) Unique Key of Source ProductItem or ProductGroup (null otherwise). | ||
| SRC_PRODUCT_GROUP_ID | NUMBER | 18 | Source ProductGroupId from FA. | ||
| SRC_ORGANIZATION_ID | NUMBER | 18 | Source OrganizationId from FA. | ||
| SRC_INVENTORY_ITEM_ID | NUMBER | 18 | Source Product InventoryItemId from FA. | ||
| SRC_STRIPE_CODE | VARCHAR2 | 30 | Stripe Code of Category. | ||
| SRC_BUSINESS_UNIT_ORG_ID | NUMBER | 18 | BU of the existing Source ProductGroup or ProductItem or Category Or UserGroup. | ||
| SRC_NAME | VARCHAR2 | 4000 | Name of the Source ProductGroup or ProductItem or Category or UserGroup. | ||
| SRC_NOT_FOUND | NUMBER | 1 | Boolean: 1=True, 0=False, NULL=False. | ||
| TGT_UNIQUE_KEY | VARCHAR2 | 64 | Unique Key which identifies ProductGroup or ProductItem or Category or UserGroup. | ||
| TGT_CATEGORY_ID | NUMBER | 18 | Category from FA. | ||
| TGT_USER_GROUP_ID | VARCHAR2 | 32 | Primary Key of CSO_TAG table. | ||
| TGT_PRODUCT_UNIQUE_KEY | VARCHAR2 | 64 | Natural (flattened) Unique Key of ProductItem or ProductGroup (null otherwise). | ||
| TGT_PRODUCT_GROUP_ID | NUMBER | 18 | ProductGroupId from FA. | ||
| TGT_ORGANIZATION_ID | NUMBER | 18 | OrganizationId from FA. | ||
| TGT_INVENTORY_ITEM_ID | NUMBER | 18 | Product InventoryItemId from FA. | ||
| TGT_STRIPE_CODE | VARCHAR2 | 30 | Stripe Code of Category. | ||
| TGT_BUSINESS_UNIT_ORG_ID | NUMBER | 18 | BU of the target ProductGroup or ProductItem or Category Or UserGroup. | ||
| TGT_NAME | VARCHAR2 | 4000 | Name of the Target ProductGroup or ProductItem or Category or UserGroup. | ||
| TGT_NOT_FOUND | NUMBER | 1 | Boolean: 1=True, 0=False, NULL=False. | ||
| MAPPED_BY_USER_ID | NUMBER | 18 | Yes | PARTY_ID of the User (RECORD_ID of KM User) who created the mapping (multiple users can work on the mapping of a single MassUpdate over several days). | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_MU_MAPPING_N1 | Non Unique | Default | UNIQUE_KEY |
| CSO_MU_MAPPING_PK | Unique | Default | RECORD_ID |
| CSO_MU_MAPPING_U1 | Unique | Default | MU_REQUEST_ID, BUSINESS_UNIT_ORG_ID, SRC_UNIQUE_KEY |