Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications R11i >
Product Integration EAM Mappings
This integration associates orderable Oracle R11i global master material items with the Siebel Internal Product business object. The EAM mapping for this integration is shown Table 46 to Table 49.
Entity Mapping
Table 46. Product Integration EAM Mapping
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 47. 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 48. 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 49. 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
|