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.

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: POSLog: Set the Default Location for ORCE Integration (K69) t to the store number representing Order Administration. Order Orchestration: Set up a cross-reference for each store location to send retail pickup or delivery orders to Order Administration, or where you will send ship-for-pickup or pickup orders from Order Administration. Also, set up a cross-reference record for each Order Administration warehouse that you integrate with Order Orchestration if you would like to display the related description at the Work with Order Broker Screen. 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: display in Working with Order Broker (WOBR) as the name of the store assigned to fulfill a brokered backorder. See Brokered Backorders for a discussion. display as the fulfilling location for the warehouse assigned to fulfill a retail pickup or delivery order. See Retail Pickup (including Ship-for-Pickup) or Delivery Orders. display as the fulfilling location for the warehouse shipping a ship-for-pickup order. See Ship-for-Pickup Orders. default 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 Ship-for-Pickup Orders for a discussion. identify Order Administration in your POSLog integration. include in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut). 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. Selected = The store location is active. Unselected = The store location is not 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: blank, the Name in OROB for Point of Sale (L09) is used instead not a valid system code in Order Orchestration that is associated with the selected location, Order Orchestration cannot create the order, and returns an error 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: L/S (Long SKU) Division L/S Department L/S Class Item Class Item Category 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: the first Address line a valid Country code a valid State for the Country if state is required for the country a Postal code that starts with a valid SCF for the State if postal code is required for the country 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: If the order did originate in Order Administration: Use the Order Broker Source Code (K93), if specified; otherwise, if this system control value is blank, Use the source code, if any, specified for the store cross reference record for the originating location, which is based on the Originating Location to Pass to OROB (M32) system control value; otherwise, Use the source code passed in the fulfillments response message from Order Orchestration, which would be from the originating order. If the order did not originate in Order Administration: Use the source code, if any, passed in the fulfillments response message from Order Orchestration; otherwise, Use the source code, if any, specified for the store cross reference record for the originating location; otherwise, Use the Order Broker Source Code (K93), if specified; otherwise, if this system control value is blank, The order is created in error status because of the missing source code. 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.