|
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 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) |
(SO_Price_Lists or SO_Discounts) |
Oracle to Siebel Integration |
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 to Siebel Integration |
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 to Siebel Integration |
Organization Id |
|
INTEGRATION_ID (multiple column values are concatenated to make the Integration Id unique) |
|
