1. Tables and Views for SCM
  2. EGP_SYSTEM_ITEMS_TL_INTF

EGP_SYSTEM_ITEMS_TL_INTF

system items transalation interface table to import through batch import program.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Comments Status
INTERFACE_TABLE_UNIQUE_ID NUMBER 18 Attribute indicating the unique identifer of the row in the import Active
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface processing
TRANSACTION_ID NUMBER 18 Attribute indicating the transaction identifier associated with the import Active
TRANSACTION_TYPE VARCHAR2 10 This refers to Transaction Type for Item Supplier Site Organization Association Mass Update Active
BATCH_NUMBER VARCHAR2 40 Unique identifier of the batch that is used for item import. Active
BATCH_ID NUMBER 18 Unique identifier that groups items together in a single transaction. Active
PROCESS_STATUS NUMBER 18 Attribute indicating the process status of the record in the import. Active
THREAD_NUMBER NUMBER 18 Attribute indicating the thread number associated with the import Active
PHASE_NUMBER NUMBER 18 Each phase code represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. For example, the lifecycle phases for a computer component lifecycle might be: Concept, Design, Prototype, Program Active
SOURCE_SYSTEM_CODE VARCHAR2 30 Attribute indicating the source system code in the import Active
SOURCE_SYSTEM_ID NUMBER 18 An external system from which item and its information is being imported into product hub. Active
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. Active
ITEM_NUMBER VARCHAR2 700 Any part, material, product or service that is unique as compared with other items by nature of its attributes in product data hub. Active
ORGANIZATION_CODE VARCHAR2 18 Unique Identifier of the Organization Active
INVENTORY_ITEM_ID NUMBER 18 Attribute indicating the unique identifier of the item. Active
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. Active
LANGUAGE VARCHAR2 4 Indicates the code of the language into which the contents of the translatable columns are translated. Active
SOURCE_LANG VARCHAR2 4 Indicates the code of the language in which the contents of the translatable columns were originally created. Active
DESCRIPTION VARCHAR2 240 Statement, picture in words, or account that describes; descriptive representation. Active
LONG_DESCRIPTION VARCHAR2 4000 Statement, picture in words, or account that describes; descriptive representation. Active
HTML_LONG_DESCRIPTION CLOB Statement describing an item, formatted using hyper text tags. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name 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
LOAD_REQUEST_ID NUMBER 18 ESS Request Id for Loading data into interface tables
HAS_ERRORS NUMBER 1 This column stores if the record has any errors

Indexes

Index Uniqueness Tablespace Columns
EGP_SYSTEM_ITEMS_TL_INTF_N1 Non Unique Default TRANSACTION_ID
EGP_SYSTEM_ITEMS_TL_INTF_N2 Non Unique Default BATCH_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
EGP_SYSTEM_ITEMS_TL_INTF_N3 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE
EGP_SYSTEM_ITEMS_TL_INTF_N4 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, THREAD_NUMBER, PHASE_NUMBER
EGP_SYSTEM_ITEMS_TL_INTF_N5 Non Unique Default BATCH_ID, TRANSACTION_ID
EGP_SYSTEM_ITEMS_TL_INTF_N6 Non Unique Default BATCH_ID, PROCESS_STATUS, ORGANIZATION_ID, NVL("ITEM_NUMBER", "TRANSACTION_ID")
EGP_SYSTEM_ITEMS_TL_INTF_N7 Non Unique Default LOAD_REQUEST_ID
EGP_SYSTEM_ITEMS_TL_INTF_U1 Unique Default INTERFACE_TABLE_UNIQUE_ID