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)
|