Tables Used by JD Edwards EnterpriseOne In-Memory Sales Advisor Solution
This table lists the tables used by JD Edwards EnterpriseOne In-Memory Sales Advisor in alphanumeric order:
|
Table |
Description |
|---|---|
|
Sales Advisor Constants (F42X000) |
Stores constants that you define to control the cross sell items, frequency items, order up-sell, order profit, and supply monitor features. |
|
Sales Advisor Included Document Types (F42X001) |
Contains the document types that the system includes in the associated sales advisor feature. |
|
Buying Frequency by Customer (F42X010) |
Stores frequent items bought by customers by month/year from the Sales Order Detail File (F4211) and Sales Order History File (F42119) tables. |
|
Line Advisor Work File (F42X010W) |
Contains the information for line advisor up-sell and preferred items, such as units of measure, prices, costs, profit margin, quantity available, line numbers, and free goods. |
|
Order Advisor Work File (F42X020W) |
Contains the information for cross sell and frequently bought item suggestions from the Sales Order Detail File (F4211) and Sales Order History File (F42119) tables. |
|
Order Upsell Item Group Totals Work File (F42X040W) |
Contains sales order quantity, weight, and amount totals by order reprice group. |
|
Order Upsell Item Group Opportunities WF (F42X041W) |
Contains information for the current break and discount, and opportunities (adjustment breaks and discounts that may apply) for each order reprice group contained in the sales order. |
|
Order Level Upsell Candidate Items (F42X050W) |
Contains the items that belong to the sales order classified by order reprice group and items from the Item Branch File table (F4102) that belong to the same reprice group as the items in the sales order. |
|
Supply Monitor Chart Work File (F42X060W) |
Contains the data for the supply monitor, such as the icon color, availability, and demand. |
|
Profitability Simulator Saved Scenarios (F42X201) |
Contains the filter field criteria saved for a given scenario. |
|
Profitability Simulator Saved Charts (F42X201B) |
Contains the filter fields and values for saved profit scenarios. |
|
Profitability Simulator Saved Data (F42X201C) |
Contains the data for saved simulation scenarios. |