1. Tables and Views for SCM
  2. EGP_REF_DESGS_INTERFACE

EGP_REF_DESGS_INTERFACE

EGP_REF_DESGS_INTERFACE temporarily stores information about bill of material component reference designators. This table is shared by the Bills of Material and Engineering Change Order open interfaces. This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. The open interfaces will derive column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE, and the open interfaces will fill in the corresponding ORGANIZATION_ID for you. . Also, you can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID and ALTERNATE_BOM_DESIGNATOR instead of BILL_SEQUENCE_ID. The open interfaces will fill in the corresponding BILL_SEQUENCE_ID. . In addition, you can enter BILL_SEQUENCE_ID, COMPONENT_ITEM_ID, OPERATION_SEQ_NUM, and EFFECTIVITY_DATE instead of _ COMPONENT_SEQUENCE_ID. The open interfaces will fill in the corresponding COMPONENT_SEQUENCE_ID.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Comments Status
COMPONENT_REFERENCE_DESIGNATOR VARCHAR2 15 An optional identifier you can assign to a component on an item structure. For example, when the bill requires four of a component, you can assign four reference designators to that component, one for each usage. Active
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface processing
ITEM_TRANSACTION_ID NUMBER 18 Item Transaction Id of Parent Assembly Item
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
REF_DESIGNATOR_COMMENT VARCHAR2 240 Comments for the Reference Designator Active
CHANGE_NOTICE VARCHAR2 10 Engineering change order number Active
COMPONENT_SEQUENCE_ID NUMBER 18 Component unique identifier. Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B Active
ACD_TYPE NUMBER Add or delete code from an ECO. Values ADD/UPDATE/DELETE/HISTORY Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
BILL_SEQUENCE_ID NUMBER 18 Bill of material unique identifier Active
ASSEMBLY_ITEM_ID NUMBER 18 Inventory item identifier of the bill Active
ALTERNATE_BOM_DESIGNATOR VARCHAR2 80 Alternate designator code. Unique name given to a specific variation of a Structure type Active
ORGANIZATION_ID NUMBER 18 Organization Identifier of the current structure. Active
COMPONENT_ITEM_ID NUMBER 18 Item Identifier of the component item Active
OPERATION_SEQ_NUM NUMBER A number that orders component operations in a routing relative to each other. Active
EFFECTIVITY_DATE DATE Start Effective Date of the Reference Designator Active
ORGANIZATION_CODE VARCHAR2 18 Abbreviation of organization name Active
ASSEMBLY_ITEM_NUMBER VARCHAR2 820 Concatenated item segments of the bill Active
COMPONENT_ITEM_NUMBER VARCHAR2 820 Concatenated item segments of the component Active
TRANSACTION_ID NUMBER 18 Identifier used for tracking the transaction during import/data load process Active
PROCESS_STATUS NUMBER 18 Row Status for the Import and Data Load Jobs Active
NEW_DESIGNATOR VARCHAR2 15 Updated value for the old reference designator. Active
INTERFACE_ENTITY_TYPE VARCHAR2 4 Record used for Bill or ECO Open Interface: BILL, ECO Active
TRANSACTION_TYPE VARCHAR2 10 Type of action: CREATE, UPDATE or DELETE Active
BOM_REF_DESGS_IFCE_KEY VARCHAR2 30 User defined identifier for linking rows of the same business object Active
BOM_INVENTORY_COMPS_IFCE_KEY VARCHAR2 30 User defined identifier to link rows pertaining to the same business object Active
ENG_REVISED_ITEMS_IFCE_KEY VARCHAR2 30 User defined identifier to link rows pertaining to the same business object Active
ENG_CHANGES_IFCE_KEY VARCHAR2 30 User defined identifier to link rows pertaining to the same business object Active
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 240 Unit number at the beginning of the end item (or root item) unit number range during which a given record is available. Active
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 240 Original system that data for the current record has come from Active
NEW_REVISED_ITEM_REVISION VARCHAR2 3 New Revised Item Revision is one of the unique keys to identify a revised item of a change Active
RETURN_STATUS VARCHAR2 1 No longer used. Active
BATCH_ID NUMBER 18 A unique identifier of an item batch. Active
COMP_SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Component Source System Item Name Active
PARENT_SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Parent Structures Item Name in external system Active
CHANGE_ID NUMBER 18 Identifier of the change order through which this RD would be associated Active
CHANGE_TRANSACTION_TYPE VARCHAR2 10 Change Management Transaction Type for Change Orders Active
ASSEMBLY_ITEM_REVISION_CODE VARCHAR2 240 Revision code of the Assembly Item Active
ASSEMBLY_ITEM_REVISION_ID NUMBER 18 Revision id of the Assembly Item. 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
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program. Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request. Active
THREAD_NUMBER NUMBER 18 Thread Number for Interface processing Active
INTERFACE_TABLE_UNIQUE_ID NUMBER 18 Interface Table Unique Identifier for Reference Designator's interface rows. Active
COMPONENT_TRANSACTION_ID NUMBER 18 Transaction ID of the Component Item 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. Active
REF_DESIG_SEQUENCE_ID NUMBER 18 Reference Designator Sequence Id Active
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.
BATCH_NUMBER VARCHAR2 40 Unique identifier of the batch that is used for item import.
LOAD_REQUEST_ID NUMBER 18 Request Id of the Job which loads the data to interface tables
EFFECTIVITY_CONTROL NUMBER For internal use. Stores the effectivity_control of parent header.
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 Status
EGP_REF_DESGS_INTERFACE_N10 Non Unique Default LOAD_REQUEST_ID
EGP_REF_DESGS_INTERFACE_N2 Non Unique FUSION_TS_INTERFACE COMPONENT_SEQUENCE_ID, COMPONENT_REFERENCE_DESIGNATOR Active
EGP_REF_DESGS_INTERFACE_N3 Non Unique FUSION_TS_INTERFACE TRANSACTION_ID Active
EGP_REF_DESGS_INTERFACE_N4 Non Unique FUSION_TS_INTERFACE ASSEMBLY_ITEM_NUMBER, ORGANIZATION_ID, BOM_REF_DESGS_IFCE_KEY Active
EGP_REF_DESGS_INTERFACE_N5 Non Unique FUSION_TS_INTERFACE ASSEMBLY_ITEM_NUMBER, ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR Active
EGP_REF_DESGS_INTERFACE_N6 Non Unique FUSION_TS_INTERFACE ENG_CHANGES_IFCE_KEY Active
EGP_REF_DESGS_INTERFACE_N7 Non Unique FUSION_TS_INTERFACE PROCESS_STATUS, ORGANIZATION_ID, TRANSACTION_ID Active
EGP_REF_DESGS_INTERFACE_N8 Non Unique Default BATCH_NUMBER
EGP_REF_DESGS_INTERFACE_N9 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS