Fields on Customer Purchase History
Purpose: The following information displays on the Customer Purchase History page.
• Customer Purchase History List Tab
• Customer Purchase History List Page Title
For more information:
• Customer Purchase History List for an overview of the Customer Purchase History List page.
• Customer Purchase History List Options for step-by-step instructions on the actions you can perform on the Customer Purchase History List page.
Customer Purchase History List Tab
The customer’s name displays in the page tab for the Customer Purchase History List page. If the customer does not have a last name, the first ten positions of the company name displays as the tab title.
Customer Purchase History List Page Title
The title and the tab of the Customer Purchase History List page contains the following:
• If a customer last name exists, the title of the page displays the customer’s name in first name, last name display.
• If a customer name does not exist, the title of the page displays the customer’s company name.
• The Customer Number is in parentheses.
• The Customer Since date follows the customer name and number. This is the signup date from Oracle Retail Customer Engagement.
The customer information panel below the page title displays the following fields:
• On the left-hand side:
• Customer Name or Company Name
• The Customer Number is in parentheses following the customer name
• Customer Since date
• Customer Class (displayed only if the Require Customer Class in OE, WCAT, and WCST (H85) system control value is selected, regardless of whether a customer class is assigned to the customer)
• On the right-hand side:
• Customer Name, including Prefix and Suffix, if specified, and or Company Name, followed by Customer Address
• If a customer name and company name are defined, the company name displays below the customer name.
• If a company name is defined without a sold-to customer name, the company name displays in place of the sold-to customer name.
• Phone Number (unlabeled field below the Customer Address): The Phone field displays in Contact Center only if it is selected for display in the Work with Contact Center (WWCC) menu option. If more than one phone number is defined for the customer, the system uses the following hierarchy to display the phone number:
• day time phone number
• mobile phone number
• evening phone number
• Email Address (unlabeled field below the Phone Number): This field displays only if an email address is defined for the customer.
• Opt-In Status (unlabeled field below the Email Address): This field displays only if an email address is defined for the customer.
Tiles to the right of the customer information panel provide the following information:
• Purchases (Total Orders). This tile includes a link to the Lifetime to Date Totals.
• Lifetime Value. The default Currency Code is indicated below this total.
• Return Rate (Item Return Rate)
Note: Unlike the purchase history information displayed below, the summary tiles display information only from Order Management System.
Note: The remaining information on this page is from Customer Engagement, and may include information on orders that do not exist in Order Management System. Also, totals may not be consistent with the totals from Order Management System.
Currency code: From the Base System Currency defined in Customer Engagement. In parentheses next to the Lifetime to Date title.
The following totals are calculated in Customer Engagement based on the Transaction History records for the customer.
Sales:
• The total Extended Price of all items sold to the customer to date.
• Number of items: The total number of items sold to the customer to date.
Returns:
• The total Extended Price of all items returned by the customer to date.
• Number of items: The total number of items returned by the customer to date.
Net:
• The total Extended Price minus the total price of Returned Items to date.
• The total Number of Items minus the number of Returned items to date.
Currency code: From the Base System Currency defined in Customer Engagement. In parentheses next to the Lifetime to Date title.
The following totals are calculated in Customer Engagement based on the Transaction History records for the customer.
Sales:
• The total Extended Price of all items sold to the customer year to date.
• Number of items: The total number of units sold to the customer year to date.
Returns:
• The total Extended Price of all items returned by the customer year to date.
• Number of items: The total number of units returned by the customer year to date.
Net:
• The total Extended Price minus the total price of Returned Items year to date.
• The total Number of Items minus the number of Returned items year to date.
Purchase History Details Table
The Purchase History Details table displays all items that the customer has purchased or returned. This information is from the Transaction History records in Customer Engagement. For each customer purchase history record, the system displays the following fields.
Note: The Items table does not include items on open or canceled order lines.
• Purchase Date: The date when the item was shipped or sold, or when it was returned.
• Item/SKU: The item/SKU code from Order Management System, if any; otherwise, the item/SKU code passed from Customer Engagement is displayed.
• Description: The item or SKU code from Order Management System, if any; otherwise, the description is Store Only Product (AB1234), where AB1234 is the item/SKU code passed from Customer Engagement.
• Quantity: The quantity of the item that was shipped or sold, or the quantity that was returned. The quantity is negative for a return.
• Extended Price: The quantity of the item that was shipped or sold, or the quantity that was returned, times the single-unit price, as passed from Customer Engagement. When the entry is for a return, the extended price is a negative number.
If the order uses a different currency, Customer Engagement passes the currency and the exchange rate used, so that the extended price displayed is converted into the default currency using the information passed by Customer Engagement; however, the foreign currency is not indicated next to the Extended Price.
• Channel: Possible channels are:
• Call Center: Indicates that the store ID passed from Customer Engagement matches the Default Location for ORCE Integration (K69) system control value and the response from Customer Engagement specifies a channel of CATALOG.
• Web: Indicates that the store ID passed from Customer Engagement matches the Default Location for ORCE Integration (K69) system control value and the response from Customer Engagement specifies a channel of ECOMM.
• Store: Indicates that the store ID does not match the criteria for displaying a channel of Call Center Web. Displayed as Store - A1234, where A1234 is the store code.
• Transaction ID: The number identifying the sale or return in Customer Engagement. When the order exists in Order Management System, this is the invoice number.
• Order: The Order Management System order number, if any. Note:
• The order number is blank if the order did not originate in Order Management System and was not fulfilled through Order Management System. For example, the order number is blank if the order originated in Xstore and was fulfilled through Order Broker, and not assigned to Order Management System for fulfilling.
• An order line might be listed twice for the same order if the order originated in Order Management System, was submitted to Order Broker for fulfilling location assignment, and then was assigned to Order Management System, creating a fulfilling order for the originating order.
• If the order number is indicated, it is a link to the Order Summary page.
• Transaction Type: Set to Sale if the item was shipped or sold; otherwise, set to Return.
________________________________
Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
Legal Notices