The file_pri_strategy_ds.csv file is generic and therefore does not support any source Pricing system-specific features.
Each row of this file will supplement existing E-Business Suite Sales Channels that are extracted using the following SQL:
SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'SALES_CHANNEL' AND VIEW_APPLICATION_ID = 660 AND LANGUAGE = '<Base Language>'
The granularity of this file is each Sales Channel Lookup code that has been created in the E-Business Suite Application.
| Column Name | Data Type | Sample Data | Description |
|---|---|---|---|
|
INTEGRATION_ID |
VARCHAR2(80) |
ALUMNI_VISIT |
The INTEGRATION_ID for this file will be the Sales Channel Code that is, FND_LOOKUP_VALUES.LOOKUP_CODE. |
|
STRATEGY_NUM |
VARCHAR2(30) |
PRODUCT_GL_PLAN_NAME |
Not available. |
|
PRODUCT_GL_PLAN_NAME |
VARCHAR2(200) |
PRICE_LIST_NAME |
Not available. |
|
PRICE_LIST_NAME |
VARCHAR2(100) |
Corporate Price List |
Not available. |
|
DEAL_GL_PLAN_NAME |
VARCHAR2(200) |
Standard Deal Policies |
Not available. |
|
PRI_SEGMENT_NAME |
VARCHAR2(200) |
Industrial – Retain/Harvest |
Not available. |
|
VERSION |
NUMBER(10) |
1 |
Not available. |
|
COMPETITOR_NAME |
VARCHAR2(200) |
Name |
Not available. |
|
AUX1_CHANGED_ON_DT |
VARCHAR2(19) |
Not available. |
This column should be populated in case of an Incremental load which should effect a type 2 change for a Sales Channel. |