Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications R10.7 >

Price List Integration EAM Mappings

During Price List Integration, Oracle Price Lists, Discounts, and Price List Line Items are integrated into the Siebel Admin Price List business object. The EAM mapping for this integration is shown in Table 10 through Table 13.

Entity Mapping

Table 10. Product List Integration EAM Mapping
Siebel Business Component
Oracle Base Table
Oracle to Siebel Integration
Price List
SO_PRICE_LISTS
SIE_PRICE_LISTS_V
Internal Product
SO_PRICE_LIST_LINES
SIE_PRICE_LIST_LINES _V
Price List_Organization
 
 

Attribute Mapping

Table 11. Product List Integration Attribute Mapping (part 1)
Siebel Field (Price List)
Oracle Base Column
(SO_Price_Lists or SO_Discounts)
Oracle to Siebel Integration
(SIE_Price_Lists_V)
Integration Id
SO_PRICE_LISTS.PRICE_LIST_ ID || '-' || SO_DISCOUNTS.DISCOUNT_ID
 
(SO_DISCOUNTS.DISCOUNT_ ID is null for records from SO_PRICE_LISTS)
 
Name
SO_PRICE_LISTS.NAME || '-' ||
SO_DISCOUNTS.NAME
 
(SO_DISCOUNTS.NAME is null for records from SO_PRICE_LISTS)
NAME
(multiple column values are concatenated to make the name unique)
Description
SO_PRICE_LISTS.DESCRIPTION
Description
Start Date
If the record is from SO_DISCOUNTS
Greatest (SO_PRICE_LISTS.START_DATE_ACTIVE, SO_DISCOUNTS.END_DATE_ ACTIVE)
else
SO_PRICE_LISTS.START_DATE_ACTIVE
START_DATE_ACTIVE
(If null, default to 01/01/1980 00:00:00)
End Date
If the record is from SO_DISCOUNTS
Least (SO_PRICE_LISTS.END_DATE_ ACTIVE, SO_DISCOUNTS.END_DATE_ ACTIVE)
else
SO_PRICE_LISTS.END_DATE_ ACTIVE
END_DATE_ACTIVE
(If less than START_DATE_ACTIVE, default to START_DATE_ACTIVE)
Type
 
Default is the value PRICE LIST
Currency Code
SO_PRICE_LISTS.CURRENCY_ CODE
CURRENCY_CODE
Freight Terms
SO_PRICE_LISTS.FREIGHT_ TERMS_CODE
FREIGHT_TERMS_CODE (through eAI value map Oracle Freight)
Shipping Method
SO_PRICE_LISTS.SHIP_ METHOD_CODE
SHIP_METHOD_CODE (through eAI value map Oracle Ship Method Code)
Payment Integration Id
SO_PRICE_LISTS.TERMS_ID
SHIP_METHOD_CODE (through eAI value map Oracle Ship Method Code)

Table 12. Product List Integration Attribute Mapping (part 2)
Siebel Field (Price List)
Oracle Base Column
(SO_Price_List_Lines)
Oracle to Siebel Integration
(SIE_Price_List_Lines_V)
Integration Id
PRICE_LIST_LINE_ID || decode (SO_DISCOUNTS. DISCOUNT_ID, null, null,
('-' || SO_DISCOUNTS. DISCOUNT_ID)
INTEGRATION_ID (multiple column values are concatenated to make the Integration Id unique)
Price List Item Integration Id
INVENTORY_ITEM_ID
INVENTORY_ITEM_ID
Volume Discount
Decode (SO_DISCOUNT_ LINES.DISCOUNT_LINE_ID, NULL, NULL,
SO_DISCOUNTS. DISCOUNT_NAME || '-' || to_char (MTL_SYSTEM_ ITEMS.INVENTORY_ITEM_ID) || '-' || SO_DISCOUNT_ LINES.DISCOUNT_LINE_ID)
DISCOUNT_NAME
(multiple column values are concatenated to get the corresponding volume discount name, if any, for the price list line item)
List Price
LIST_PRICE
LIST_PRICE
List Price Type Code
 
Default the value STANDARD

Table 13. Product List Integration Attribute Mapping (part 3)
Siebel Field (Price_List_Organization)
Oracle Base Column
(SO_Price_List_Lines)
Oracle to Siebel Integration
(SIE_Price_List_Lines_V)
Organization Id
 
INTEGRATION_ID
(multiple column values are concatenated to make the Integration Id unique)


 Siebel Connector for Oracle Applications 
 Published: 18 April 2003