Work with Store Cross Reference (WSCR)
Purpose: Use this screen to set up cross-reference information between a store location and Order Administration. This information can be used to:
-
display a description of the store location assigned to fulfill a brokered backorder. See the Work with Order Broker Screen for an example, and see Brokered Backorders for background.
-
enable the customer to select a store location for pickup of a ship-for-pickup order at the Store Location Screen, or for a store pickup order at the Store Pickup Search Results Screen. When the customer selects the store, the store’s shipping address defaults to the order. See Ship-for-Pickup Orders and Store Pickup Orders for background.
-
indicate the source code to default to a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background.
-
display a description of an Order Administration warehouse at the Work with Order Broker Screen when it is assigned to fulfill a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders for background.
-
display a description of an Order Administration warehouse at the Work with Order Broker Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for background.
-
provide default information for your unique POSLog extract. See the Default Location for ORCE Integration (K69) system control value for more information.
-
provide the pickup location displayed in the store pickup notification email. See Store Pickup Confirmation Email Program (L48) for more information.
-
provide the store name, address, and phone number to include in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut) for:
-
a retail pickup, delivery, ship-for-pickup, or store pickup order; or,
-
for a sales rep’s Home store, if it is flagged as active, or for the Originating store from the Order Header table
-
For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).
Note:
The Store Cross Reference record is not used:
-
as part of the Merchandise Locator API.
-
to display store descriptions or addresses at the Store Pickup Search Results Screen, although the Store Cross Reference record defaults to the Order Ship To Address when you accept the order.
Other ways to create store cross references: You can also create records in the Store Cross Reference table by:
-
uploading them from an external system: see Store Upload for instructions. Using this option, you can also update existing records.
-
importing them from Order Orchestration through a web service: see Importing Store Cross Reference Locations through Order Orchestration’s Discovery Web Service for more information. Using this option, you can create records, but cannot update them.
In this topic:
Work with Store Cross Reference Screen
How to display this screen: Enter WSCR in the Fast path field at the top of any menu or select Work with Store Cross Reference from a menu.
When you first advance to this screen, stores display in ascending store code sequence.
Column sort: You can sort on any column on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.
Field | Description |
---|---|
Store |
A code identifying an external store location. Can also act as a cross-reference to an Order Administration warehouse. Enter a full or partial store code to display stores that begin with your entry. Alphanumeric, 10 positions. |
Description |
The description of the store location or warehouse. This description is displayed in Working with Order Broker (WOBR) as the name of the store assigned to fulfill a brokered backorder, or the description of the warehouse assigned to fulfill a retail pickup or delivery order or that is shipping a ship-for-pickup order; also, it defaults to the Company field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See the Order Orchestration Integration for a discussion. Enter a full or partial description to display stores that contain your entry. Alphanumeric, 40 positions. |
Option | Procedure |
---|---|
Create a store cross reference |
Select Create for a store cross reference to advance to the Create Store Cross Reference Screen. Note: You can also use the Importing Store Cross Reference Locations through Order Orchestration’s Discovery Web Service process or the Store Upload to create store cross reference records. |
Change a store cross reference |
Select Change for a store cross reference to advance to the Change Store Cross Reference screen. See the Create Store Cross Reference Screen for field descriptions. |
Display a store cross reference |
Select Display for a store cross reference to advance to the Display Store Cross Reference screen. You cannot change any information on this screen. See the Create Store Cross Reference Screen for field descriptions. |
Delete a store cross reference |
Select Delete for a store cross reference. At the Confirm Delete window, select Yes to delete the record; otherwis |
Create Store Cross Reference Screen
Purpose: Use this screen to enter store cross-reference information for:
-
transferring invoice data or sales transactions to your unique POSLog integration.
-
integration with Order Orchestration; see the Order Orchestration Integration for background.
Note:
You can also use the Importing Store Cross Reference Locations through Order Orchestration’s Discovery Web Service process or the Store Upload to create store cross reference records.
How to display this screen: Select Create at the Work with Store Cross Reference Screen.
Field | Description |
---|---|
Store # |
A code identifying an external store location. Can also act as a cross-reference to an Order Administration warehouse. Used in certain integrations:
Alphanumeric, 10 positions. Create screen: required. Change screen: display-only. |
Phone Number |
The phone number for the store. Included in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut); see the OriginatingStore in the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1) element for more information. Alphanumeric, 14 positions; optional. |
Description |
The description to:
For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). Note: If the description exceeds 30 positions, it is truncated at the Store Location Screen and at the Create One Time Ship To Address Screen. Also, any additional characters do not print on the pick slip and are not sent to Order Orchestration. Alphanumeric, 40 positions. Create screen: required. Change screen: optional. |
Active? |
Defines whether the store location is active.
The system validates that the store location is active when you define the store on the Work with Order Ship to Properties Screen in Order Entry or receive an order through the Generic Order Interface (Order API) that specifies a sales_rep_store location. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). |
System Code |
The system associated with the store location in Order Orchestration. Used to identify the fulfilling location when sending a SubmitOrder request to Order Orchestration for a store pickup or ship-for-pickup order, and acts as an override to the Name in OROB for Point of Sale (L09). If this field is:
Your entry must be a valid system code associated with the fulfilling location in Order Orchestration and the case must match exactly. Used only for store pickup and ship-for-pickup orders. Note: You still need to complete the Name in OROB for Point of Sale (L09) system control value, or you cannot create a ship-for-pickup order even if a valid system code is specified here. |
Register # |
The register number for transactions to pass to the point-of- sale (POS) system as part of a POSLog integration. Numeric, 3 positions; optional. |
Employee ID |
The employee identification to pass to the POS system as part of a POSLog integration. Alphanumeric, 12 positions; optional. |
Discount Code |
The discount code used to pass discount information for items to the POS system as part of a POSLog integration. Alphanumeric, 12 positions; optional. |
Price Override Code |
The price override reason code used as a cross reference as part of a POSLog integration. Not validated against the Price Override Reason Code table. Alphanumeric, 3 positions, optional. |
Item Hierarchy Level 1-4 |
Optionally, select the level of the item hierarchy in Order Administration that matches to the hierarchy level in an external system. Possible settings:
Optional. |
Ship for Pickup |
Indicates whether the store location is available for selection as a destination for a ship-for-pickup order. Only store locations that have this field selected are listed at the Store Location Screen in order entry. See Ship-for-Pickup Orders for an overview. If you select this field, the system validates that you enter:
Note: Select this field only for stores whose Ship For Pickup Receiving/Pickup Available setting is selected in Order Orchestration. |
Source Code |
The source code to assign to retail pickup or delivery orders received from Order Orchestration. Used as follows for orders created through the fulfillments response message based on whether the order originated in Order Administration:
See e Retail Pickup (including Ship-for-Pickup) or Delivery Orders for an overview. Your entry must be an existing source code. See Working with Source Codes (WSRC) for more information. Alphanumeric, 9 positions; optional. |
OriginatingStore element in the CWEmailOut message |
The following address fields, plus the Phone Number, are included in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut). See the OriginatingStore for more information. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). |
Address |
The address to default to the Address fields at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Alphanumeric, four 32-position fields; optional. |
City |
The address to default to the Address fields at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Alphanumeric, four 32-position fields; optional. |
State |
The state to default to the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Required only if the Ship for Pickup flag is selected, and if the Require state? flag is selected for the country (see Setting Up the Country Table (WCTY)). Alphanumeric, 2 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
Postal code |
The postal or zip code to default to the Postal code field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. Required only if the Require postal code? flag is selected for the country (see Setting Up the Country Table (WCTY)) and if the Ship for Pickup flag is selected for the store cross reference. If a postal code is required, it is validated against the Zip/City/State (Postal Code) table; see Setting Up the Zip/City/State (Postal Code) Table (WZIP). Alphanumeric, 10 positions; required if you select the Ship for Pickup flag; otherwise, optional. |
Country |
The country code to default to the Country field at the Create One Time Ship To Address Screen when you select this store location at the Store Location Screen for a ship-for-pickup order. See Ship-for-Pickup Orders for a discussion. If the Ship for Pickup flag is selected, you need to enter a valid country code. The Default Country for Customer Address (B17) defaults. Alphanumeric, 3 positions; required if you select the Ship for Pickup flag; otherwise, optional. |