EGO_STYLE_VARIANT_ATTR_VS_INTF
This table contains value sets for all variant attributes given a style.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| INTERFACE_TABLE_UNIQUE_ID | NUMBER | 18 | Attribute indicating the unique identifer of the row in the import | |
| BATCH_ID | NUMBER | 18 | A unique identifier of an item batch. | |
| TRANSACTION_ID | NUMBER | 18 | Attribute indicating the transaction identifier associated with the import | |
| PROCESS_STATUS | NUMBER | 18 | Attribute indicating the process status of the record in the import. | |
| PREPROCESS_THREAD_NUMBER | NUMBER | 18 | PreProcess Thread Number for interface processing | |
| ITEM_NUMBER | VARCHAR2 | 300 | Item Number of the item added to the Analysis. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Attribute indicating the intra batch matching of the source system cross reference | |
| SOURCE_SYSTEM_ID | NUMBER | 18 | An external system from which item and its information is being imported into product hub. | |
| SOURCE_SYSTEM_REFERENCE | VARCHAR2 | 255 | An item from the external system that is being imported into product hub. | |
| ATTRIBUTE_GROUP_CODE | VARCHAR2 | 320 | Internal name of the variant attribute group associated with the item. | |
| ATTRIBUTE_CODE | VARCHAR2 | 120 | Internal name of the variant attribute associated with the item. | |
| VALUE_SET_CODE | VARCHAR2 | 60 | Attribute indicating the code associated with the valueset. | |
| VALUE_SET_ID | NUMBER | 18 | Attribute indicating the numeric code associated with the valueset. | |
| ITEM_CATALOG_GROUP_ID | NUMBER | 18 | Provides metadata common to all items that share the category. For example, the item catalog category "Engine" describes attributes, functions and other characteristics common to several item numbers, such as Engine M10000 and Engine M20000. | |
| SEQUENCE | NUMBER | 9 | Attribute indicating the sequence of the ruleset | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | 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. | |
| BATCH_NUMBER | VARCHAR2 | 40 | Number of an update batch created for a rule set impact analysis. | |
| SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | Attribute indicating the source system code in the import | |
| LOAD_REQUEST_ID | NUMBER | 18 | Attribute indicating the request id associated with the import process. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| INTERFACE_DATA_TYPE | VARCHAR2 | 100 | Data type of record. Values-BATCH/SUPPLIER_STAGE/SPOKE_STAGE | |
| SUPPLIER_ID | NUMBER | 18 | Unique identifier for supplier in case of supplier stage record |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGO_STYLE_VAR_ATTR_INTF_N2 | Non Unique | Default | BATCH_ID, PROCESS_STATUS, NVL("ITEM_NUMBER", "TRANSACTION_ID") |
| EGO_STYLE_VAR_ATTR_VS_INTF_N1 | Non Unique | Default | BATCH_NUMBER |
| EGO_STYLE_VAR_ATTR_VS_INTF_U1 | Unique | Default | INTERFACE_TABLE_UNIQUE_ID |