|
Siebel Connector for Oracle Applications > Detailed Data Mappings > Entity Attribute Mappings for Oracle Applications R10.7 >
Discount Integration EAM Mappings
When Oracle Discounts are integrated into the Siebel application, active Oracle Discount Items and Price Breaks are mapped to the Siebel Admin Volume Discount business object. The EAM mappings associated with this integration are listed in Table 14 through Table 16. Entity Mapping
Table 14. Discount Integration EAM Mapping
Siebel Business Component |
|
Oracle to Siebel Integration |
Volume Discount |
SO_DISCOUNT_LINES |
SIE_DISCOUNT_ LINES_V |
Volume Discount Item |
SO_PRICE_BREAK_ LINES |
SIE_PRICE_BREAK_ LINES_V |
Attribute Mapping
Table 15. Discount Integration Attribute Mapping (part 1)
Siebel Field (Volume Discount) |
|
Oracle to Siebel Integration |
Integration Id |
DISCOUNT_LINE_ID |
INTEGRATION_ID |
Name |
SO_DISCOUNTS.NAME || '-' || to_char (MTL_SYSTEM_ITEMS. INVENTORY_ITEM_ID) || '-' || DISCOUNT_LINE_ID |
NAME (multiple column values are concatenated to make the name unique) |
Description |
SO_DISCOUNTS. DESCRIPTION || '-' || MTL_SYSTEM_ITEMS. SEGMENT1 || '-' || SO_PRICE_LISTS. NAME |
DESCRIPTION (multiple column values are concatenated to make the discount easily identifiable with the Oracle discount line item and price list) |
Start Date |
START_DATE_ACTIVE |
START_DATE_ACTIVE (If null, default to 01/01/1980 00:00:00) |
End Date |
END_DATE_ACTIVE |
END_DATE_ACTIVE (If less than START_DATE_ACTIVE, default to START_DATE_ ACTIVE) |
Table 16. Discount Integration Attribute Mapping (part 2)
Siebel Field (Volume Discount) |
Oracle Base Column (SO_PRICE_BREAK_LINES) |
Oracle to Siebel Integration (SIE_PRICE_BREAK_LINES_V) |
Integration Id |
DISCOUNT_LINE_ID || '-' || PRICE_BREAK_LINES_ LOW_RANGE |
INTEGRATION_ID |
Name |
'[' || PRICE_BREAK_LINES_ LOW_RANGE || '-' || PRICE_BREAK_LINES_ HIGH_RANGE || ']' || '-' || PERCENT || '%', |
NAME (multiple column values are concatenated, making the name unique and user friendly) |
Minimum Quantity |
PRICE_BREAK_LINES_ LOW_RANGE |
PRICE_BREAK_LINES_ LOW_RANGE |
Maximum Quantity |
PRICE_BREAK_LINES_ HIGH_RANGE |
PRICE_BREAK_LINES_ HIGH_RANGE |
Discount Percent |
PERCENT |
PERCENT |
|
