EGP_CATEGORIES_INT
This table is used to import category records.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CATEGORY_ID | NUMBER | 18 | Category an item is assigned to when during new item creation | ||
| SUPPLIER_ENABLED_FLAG | VARCHAR2 | 1 | Attribute that controls if a category will be displayed as part of the Supplier Profile | ||
| CATEGORY_NAME | VARCHAR2 | 250 | Translatable name of the category. | ||
| DESCRIPTION | VARCHAR2 | 240 | Stores the descripton of the Category. | ||
| CATEGORY_CONTENT_CODE | VARCHAR2 | 30 | Attribute that indicates if the category contains only items, or items and categories | ||
| CATEGORY_CODE | VARCHAR2 | 820 | A unique identification assigned to an item class which can be easily associated with the UNSPC category. | ||
| START_DATE_ACTIVE | DATE | Date the category will become inactive | |||
| END_DATE_ACTIVE | DATE | Date the category will become inactive | |||
| PARENT_CATEGORY_ID | NUMBER | 18 | Category_Id of the parent record in the category hierarchy | ||
| PARENT_CATEGORY_CODE | VARCHAR2 | 820 | Code of the Parent Category record. | ||
| NEW_CATEGORY_CODE | VARCHAR2 | 820 | New Category Code if the Category Code is being updated | ||
| CATALOG_ID | NUMBER | 18 | Catalog Id of the Catalog, to which this Category belogs. | ||
| CATALOG_CODE | VARCHAR2 | 30 | Catalog Code of the Catalog, to which this Category belogs. | ||
| SOURCE_CATALOG_CODE | VARCHAR2 | 30 | In case of sharing of categories, this coulmn will be used to store source catalog code. | ||
| SOURCE_CATALOG_ID | NUMBER | 18 | In case of sharing of categories, this coulmn will be used to store source catalog id. | ||
| COPY_OPTIONS | VARCHAR2 | 50 | In case shraing of categories by copy, various options related to copy will stored. This option will decide whether the child categories and item categories assignments are to be copied as well along with the copy of category. | ||
| BATCH_NUMBER | VARCHAR2 | 40 | Unique identifier of the batch that is used for item import. | ||
| PREPROCESS_COMPLETION_STATUS | NUMBER | Preproces completion status of the interface row. | |||
| 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. | ||
| INTERFACE_TABLE_UNIQUE_ID | NUMBER | 18 | Interface table unique identifier | ||
| THREAD_NUMBER | NUMBER | 18 | Thread Number for interface processing | ||
| PREPROCESS_THREAD_NUMBER | NUMBER | 18 | PreProcess Thread Number for interface Processing. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | LOAD_REQUEST_ID is used in FBDI framework | ||
| BATCH_ID | NUMBER | 18 | Batch Identifier for Data Load. | ||
| TRANSACTION_TYPE | VARCHAR2 | 10 | Type of action: CREATE, UPDATE, or SYNC | ||
| PROCESS_STATUS | NUMBER | 18 | Row status of interface records | ||
| ERROR_MSG_CODE | VARCHAR2 | 50 | Stores the error code of the errors encountered during preprocess pahse of category import. | ||
| 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. | |
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment 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_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | 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. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_CATEGORIES_INT_N1 | Non Unique | Default | BATCH_ID, PROCESS_STATUS, THREAD_NUMBER, CATEGORY_CODE, PARENT_CATEGORY_ID |
| EGP_CATEGORIES_INT_N2 | Non Unique | Default | REQUEST_ID, TRANSACTION_TYPE, PROCESS_STATUS |
| EGP_CATEGORIES_INT_U1 | Unique | Default | INTERFACE_TABLE_UNIQUE_ID |