Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications R10.7 >
Product Integration EAM Mappings
This integration associates Oracle global master material items with the Siebel Internal Product business object. The EAM mapping for this integration is shown in Table 6 through Table 9.
Entity Mapping
Table 6. Product Integration EAM Mappings
Siebel Business Component
|
Oracle Base Table
|
Oracle to Siebel Integration
|
Internal Product
|
MTL_SYSTEM_ITEMS
|
SIE_PRODUCT_V
|
Internal Division
|
ORG_ORGANIZATION_ DEFINITIONS
|
SIE_PRODUCT_V
|
FS Inventory Location
|
ORG_ORGANIZATION_ DEFINITIONS
|
SIE_PRODUCT_V
|
Attribute Mapping
Table 7. Product Integration Attribute Mapping (part 1)
Siebel Field (Internal Product)
|
Oracle Base Column
(MTL_System_Items)
|
Oracle to Siebel Integration
(SIE_Product_V)
|
Integration Id
|
INVENTORY_ITEM_ ID
|
INVENTORY_ITEM_ID
|
Description
|
DESCRIPTION
|
DESCRIPTION
|
Orderable
|
CUSTOMER_ORDER_ ENABLED_FLAG
|
CUSTOMER_ORDER_ ENABLED_FLAG
|
Sales Product Flag
|
CUSTOMER_ORDER_ FLAG
|
CUSTOMER_ORDER_ FLAG
|
Sales Service Flag
|
SERVICE_ITEM_ FLAG
|
SERVICE_ITEM_FLAG
|
Unit of Measure
|
PRIMARY_UOM_ CODE
|
PRIMARY_UOM_CODE
(through eAI value map Oracle Unit of Measure)
|
Table 8. Product Integration Attribute Mapping (part 2)
Siebel Field (Internal Division)
|
Oracle Base Column
(ORG_ORGANIZATION _DEFINITIONS)
|
Oracle to Siebel Integration
(SIE_Product_V)
|
Integration Id
|
OPERATING_UNIT
|
OPERATING_UNIT
|
Default Shipping Org Int Id
|
MTL_SYSTEM_ITEMS. DEFAULT_SHIPPING _ORG
|
DEFAULT_SHIPPING_ ORG
|
Status
|
MTL_SYSTEM_ITEMS.
INVENTORY_ITEM_ STATUS_CODE
|
INVENTORY_ITEM_ STATUS_CODE
|
Table 9. Product Integration Attribute Mapping (part 3)
Siebel Field (FS Inventory Location)
|
Oracle Base Column
(ORG_ORGANIZATION _DEFINITIONS)
|
Oracle to Siebel Integration
(SIE_Product_V)
|
Integration Id
|
MTL_SYSTEM_ITEMS.ORGANIZATION_ID
|
ORGANIZATION_ID
|
