Work with Store Cross Reference (WSCR)

Purpose: Use this screen to set up cross-reference information between a store location and Order Management System. 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 Management System 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 Management System 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

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 Broker through a web service: see Importing Store Cross Reference Locations through Order Broker’s Discovery Web Service for more information. Using this option, you can create records, but cannot update them.

In this chapter:

Work with Store Cross Reference Screen

Create Store Cross Reference Screen

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 a Order Management System 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 Broker 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 Broker’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; otherwise, select No.

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 the Order Broker; see the Order Broker Integration for background.

Note: You can also use the Importing Store Cross Reference Locations through Order Broker’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 a Order Management System warehouse. Used in certain integrations:

POSLog: Set the Default Location for ORCE Integration (K69) to the store number representing Order Management System.

Order Broker: Set up a cross-reference for each store location to send retail pickup or delivery orders to Order Management System, or where you will send ship-for-pickup or pickup orders from Order Management System. Also, set up a cross-reference record for each Order Management System warehouse that you integrate with Order Broker 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 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 Management System in your POSLog integration.

• include in the OriginatingStore element of the Outbound Email XML Message (CWEmailOut).

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 the Order Broker.

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.

System Code

The system associated with the store location in Order Broker. Used to identify the fulfilling location when sending a SubmitOrder request to Order Broker 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 Broker that is associated with the selected location, Order Broker cannot create the order, and returns an error

Your entry must be a valid system code associated with the fulfilling location in Order Broker 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 Management System 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 Broker.

Source Code

The source code to assign to retail pickup or delivery orders received from the Order Broker. The system uses this source code only if the fulfillment response message from the Order Broker does not specify a source code for the order; otherwise, if this field is blank and no source code was specified for the order, the system uses the Order Broker Source Code (K93) system control value. See the Retail Pickup (including Ship-for-Pickup) or Delivery Orders for an overview, and see the Order Broker Source Code (K93) for setup considerations.

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.

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 city to default to the City 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.

Alphanumeric, 25 positions; required if you select the Ship for Pickup flag; otherwise, 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.

WSCR OMSCS 19.0 December 2019 OHC