EGP_ITEM_CATEGORIES

Details

Schema: FUSION
Object owner: EGP
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
EGP_ITEM_CATEGORIES_INTER_PK	INTERFACE_TABLE_UNIQUE_ID

Columns

Name	Datatype	Length	Precision	Comments
INTERFACE_TABLE_UNIQUE_ID	NUMBER		18	Interface Table Unique Identifier for item categories interface rows
BATCH_ID	NUMBER		18	Unique identifier that groups items together in a single transaction.
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.
PREPROCESS_THREAD_NUMBER	NUMBER		18	PreProcess Thread Number for interface processing
THREAD_NUMBER	NUMBER		18	Attribute indicating the thread number associated with the import
PROCESS_STATUS	NUMBER			Attribute indicating the process status of the record in the import.
INVENTORY_ITEM_ID	NUMBER		18	Unique identifier for an item being assigned to the catalog.
ORGANIZATION_ID	NUMBER		18	A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
CATEGORY_SET_ID	NUMBER		18	Collection of items grouped into categories
CATEGORY_ID	NUMBER		18	Category belonging to the Item Catalog
TRANSACTION_ID	NUMBER		18	Attribute indicating the transaction identifier associated with the import
LAST_UPDATE_DATE	TIMESTAMP			Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Who column: indicates the user who last updated 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.
REQUEST_ID	NUMBER		18	Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CATEGORY_SET_NAME	VARCHAR2	30		Catalog from which categories can be shared from
CATEGORY_NAME	VARCHAR2	250		Translatable name of the category.
ORGANIZATION_CODE	VARCHAR2	18		This refers to Organization code
ITEM_NUMBER	VARCHAR2	300		User friendly identifier of the item being assigned to the catalog.
TRANSACTION_TYPE	VARCHAR2	10		This refers to Transaction Type for Item Supplier Site Organization Association Mass Update
OLD_CATEGORY_ID	NUMBER		18	Unique identifier of the old category to which the item is assigned. Used while moving the assignment from one category to another.
OLD_CATEGORY_NAME	VARCHAR2	250		Name of the old category to which the item is assigned. Used while moving the assignment from one category to another.
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		Unique identifier of the spoke item that an item is related to. In a related item relationship, an item can be related to another item. This string represents the target item in the relationship.
CHANGE_ID	NUMBER		18	A unique identifier of a change order.
CHANGE_LINE_ID	NUMBER		18	A unique identifier of a line in the change order.
JOB_DEFINITION_NAME	VARCHAR2	100		Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900		Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
BATCH_NUMBER	VARCHAR2	40		Unique identifier of the batch that is used for item import.
SOURCE_SYSTEM_CODE	VARCHAR2	30		Attribute indicating the source system code in the import.
LOAD_REQUEST_ID	NUMBER		18	Identifier of the ESS request that was used to load this interface row.
INTERFACE_DATA_TYPE	VARCHAR2	100		Data type of record. Values-BATCH/SUPPLIER_STAGE/SPOKE_STAGE
CATEGORY_CODE	VARCHAR2	820		Unique identifier of the category to which the item shoud be assigned. This can be used when a category name is not unique within a given catalog.
OLD_CATEGORY_CODE	VARCHAR2	820		Unique code of the category from which the item should be removed and moved to the category specified in the CATEGORY_CODE column of this interface row.
SUPPLIER_ID	NUMBER		18	Unique identifier for supplier in case of supplier stage record
START_DATE	DATE			Date when the item association begins. The start date cannot be specified for functional area catalogs, except for the catalog assigned to service logistics functional area.
END_DATE	DATE			Date when the item association ends. The end date cannot be specified for functional area catalogs, except for the catalog assigned to service logistics functional area.
HAS_ERRORS	NUMBER		1	This column stores if the record has any errors

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGP_ITEM_CATEGORIES_INTERFACE	egp_item_cat_assignments	INVENTORY_ITEM_ID, ORGANIZATION_ID, CATEGORY_SET_ID, CATEGORY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGP_ITEM_CATEGORIES_INTER_PK	Unique	Default	INTERFACE_TABLE_UNIQUE_ID
EGP_ITEM_CATS_INTERFACE_N1	Non Unique	Default	BATCH_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, PREPROCESS_THREAD_NUMBER
EGP_ITEM_CATS_INTERFACE_N2	Non Unique	Default	BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE
EGP_ITEM_CATS_INTERFACE_N3	Non Unique	Default	BATCH_ID, PREPROCESS_THREAD_NUMBER, TRANSACTION_ID
EGP_ITEM_CATS_INTERFACE_N4	Non Unique	Default	BATCH_NUMBER
EGP_ITEM_CATS_INTERFACE_N5	Non Unique	Default	BATCH_ID, PROCESS_STATUS, THREAD_NUMBER
EGP_ITEM_CATS_INTERFACE_N7	Non Unique	Default	LOAD_REQUEST_ID
EGP_ITEM_CAT_INTERFACE_N6	Non Unique	Default	BATCH_ID, PROCESS_STATUS, ORGANIZATION_ID, NVL("ITEM_NUMBER", "TRANSACTION_ID")