Bookshelf v7.5: Discount Integration EAM Mappings

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 Base Table	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 Base Column (SO_DISCOUNT_LIINES)	Oracle to Siebel Integration (SIE_DISCOUNT_LINES_V)
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