SCH_EPP_MAPPINGS
SCH_EPP_MAPPINGS table stores the mapping between the source attributes in the External Purchase Prices Interface and attributes defined in the Oracle Cloud for Requisitioning Business Unit, Purchasing Category, Supplier Site and Unit of Measure.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SCH_EPP_MAPPINGS_PK |
MAPPING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MAPPING_ID | NUMBER | 18 | Yes | External Purchase Prices Mapping Unique identifier. | |
| ACTIVE_FLAG | VARCHAR2 | 1 | Flag that indicates if the mapping record is active. Valid values are 'Y' and 'N'. | ||
| MAPPING_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of Mapping defined. Valid values are ORA_SCH_EPP_SUPLR_SITE_MAPPING, ORA_SCH_EPP_REQ_BU_MAPPING, ORA_SCH_EPP_UOM_MAPPING, ORA_SCH_EPP_PUR_CAT_MAPPING. | ||
| SOURCE_SYSTEM | VARCHAR2 | 60 | Indicates the source system for which mapping is defined. | ||
| MAPPING_SOURCE_CHAR1 | VARCHAR2 | 700 | Indicates the mapping source required to be set up for External Purchase Prices . Based on the mapping type code stores values like source organization, manufacturer part number, source supplier and source unit of measure. | ||
| MAPPING_SOURCE_CHAR2 | VARCHAR2 | 700 | Indicates the mapping source required to be set up for External Purchase Prices. | ||
| MAPPING_SOURCE_CHAR3 | VARCHAR2 | 700 | Indicates the mapping source required to be set up for External Purchase Prices. | ||
| MAPPING_SOURCE_CHAR4 | VARCHAR2 | 700 | Indicates the mapping source required to be set up for External Purchase Prices. | ||
| MAPPING_SOURCE_CHAR5 | VARCHAR2 | 700 | Indicates the mapping source required to be set up for External Purchase Prices. | ||
| MAPPING_SOURCE_NUM1 | NUMBER | Indicates the mapping source required to be set up for External Purchase Prices . Based on the mapping type code stores values like procurement business unit and quantity of each. | |||
| MAPPING_SOURCE_NUM2 | NUMBER | Indicates the mapping source required to be set up for External Purchase Prices. | |||
| MAPPING_SOURCE_NUM3 | NUMBER | Indicates the mapping source required to be set up for External Purchase Prices. | |||
| MAPPING_SOURCE_NUM4 | NUMBER | Indicates the mapping source required to be set up for External Purchase Prices. | |||
| MAPPING_SOURCE_NUM5 | NUMBER | Indicates the mapping source required to be set up for External Purchase Prices. | |||
| MAPPING_VAL_CHAR1 | VARCHAR2 | 700 | Indicates the mapping values required to be set up for External Purchase Prices like UOM code. | ||
| MAPPING_VAL_CHAR2 | VARCHAR2 | 700 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_CHAR3 | VARCHAR2 | 700 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_CHAR4 | VARCHAR2 | 700 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_CHAR5 | VARCHAR2 | 700 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_NUM1 | NUMBER | 18 | Indicates the mapping values required to be set up for External Purchase Prices like purchasing category ID or supplier ID. | ||
| MAPPING_VAL_NUM2 | NUMBER | 18 | Indicates the mapping values required to be set up for External Purchase Prices like supplier site ID. | ||
| MAPPING_VAL_NUM3 | NUMBER | 18 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_NUM4 | NUMBER | 18 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| MAPPING_VAL_NUM5 | NUMBER | 18 | Indicates the mapping values required to be set up for External Purchase Prices. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SCH_EPP_MAPPINGS_N1 | Non Unique | Default | MAPPING_TYPE_CODE |
| SCH_EPP_MAPPINGS_N2 | Non Unique | Default | MAPPING_SOURCE_CHAR1, MAPPING_SOURCE_NUM1 |
| SCH_EPP_MAPPINGS_U1 | Unique | Default | MAPPING_ID |