EGI_IO_MAP_B_
This table stores the Mapping header level information.
Details
-
Schema: FUSION
-
Object owner: EGI
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
EGI_IO_MAP_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, MAPPING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MAPPING_ID | NUMBER | 18 | Yes | Unique identifier of the import map mapping. | |
DEFAULT_FLAG | VARCHAR2 | 1 | Identifies if the import format is the default import format of an item class. | ||
TYPE | VARCHAR2 | 2 | Type of the mapping, import map or import format. | ||
MAPPING_CODE | VARCHAR2 | 80 | The internal name of the import map. | ||
OBJECT_NAME | VARCHAR2 | 30 | Name of the object being imported. | ||
GENERIC_MAP_FLAG | VARCHAR2 | 1 | Identifies if the import map is visible to all suppliers. | ||
ITEM_CLASS_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. | ||
ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether an import map is active. | ||
INCLUDE_REQUIRED_ATTRIBUTES | VARCHAR2 | 1 | Identifies if required attributes are to be included to an import format. | ||
FILE_TYPE | VARCHAR2 | 30 | The type or extension of the source file that contains the data being imported. | ||
FILE_SELECTION | VARCHAR2 | 30 | A choice to select a specific file, or to select from a list of recently used files. | ||
ENCODING_TYPE | VARCHAR2 | 30 | File encoding format that is applied for the import activity. | ||
DATE_FORMAT | VARCHAR2 | 30 | Date format that is applied for the import activity. | ||
DATA_DELIMETER | VARCHAR2 | 30 | Delimiter used in the data file uploaded to the import map. | ||
DELIMITER | VARCHAR2 | 20 | Delimiter used in the data file uploaded to the import map. | ||
DELIMITER_VALUE | VARCHAR2 | 20 | Delimiter used to concatenate different segments when configured item numbers are created. | ||
TIMESTAMP_FORMAT | VARCHAR2 | 30 | Time stamp format applied for import activity | ||
UPLOAD_FROM | VARCHAR2 | 7 | The location of the source file. | ||
PARENT_MAPPING_ID | NUMBER | 18 | Unique identifier of the source import map. | ||
INT_EXT_FLAG | VARCHAR2 | 1 | Identifies if the usage of an object is external or internal. For example an external user, such as a supplier, can view an external import format but not an internal import format. | ||
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. | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | User performing edit of the import map. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGI_IO_MAP_BN1_ | Non Unique | Default | MAPPING_ID |
EGI_IO_MAP_B_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, MAPPING_ID |
EGI_IO_MAP_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, MAPPING_CODE, TYPE |