Work with Store Cross Reference (WSCR)
Purpose: Use this screen to set up cross-reference information between a store location and CWSerenade. 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-to-store 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 default to the order. See Ship-to-Store Orders and Store Pickup Orders for background.
• indicate the source code to default to a retail pickup or delivery order. See Retail Pickup or Delivery Orders for background.
• display a description of a CWSerenade warehouse at the Work with Order Broker Screen when it is assigned to fulfill a retail pickup or delivery order. See Retail Pickup or Delivery Orders for background.
• display a description of a CWSerenade warehouse at the Work with Order Broker Screen for a ship-to-store order. See Ship-to-Store Orders for background.
• provide default information for the integration with WinRetail. See WinRetail Integration Overview for more information.
• provide default information for your unique POSLog extract. See the Default Location for Sales Download (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-to-store, 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 Locate through a web service: see Importing Store Cross Reference Locations through Locate’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
• 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.
Field |
Description |
Store |
A code identifying an external store location. Can also act as a cross-reference to a CWSerenade warehouse. 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-to-store 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-to-store order. See the Order Broker Integration for a discussion. 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 Locate’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. |
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 WinRetail; see WinRetail Integration Overview.
• integration with the Order Broker; see the Order Broker Integration for background.
Note: You can also use the Importing Store Cross Reference Locations through Locate’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 CWSerenade warehouse. Used in certain integrations: • POSLog or WinRetail: Set the Default Location for Sales Download (K69) to the store number representing CWSerenade. • Locate : Set up a cross-reference for each store location to send retail pickup or delivery orders to CWSerenade, or where you will send ship-to-store or pickup orders from CWSerenade. Also, set up a cross-reference record for each CWSerenade warehouse that you integrate with Locate 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. |
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 or Delivery Orders. • display as the fulfilling location for the warehouse shipping a ship-to-store order. See Ship-to-Store 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-to-store order. See Ship-to-Store Orders for a discussion. • identify CWSerenade in your WinRetail or 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. |
The system associated with the store location in Locate. Used to identify the fulfilling location when sending a SubmitOrder request to Locate for a store pickup or ship-to-store order, and acts as an override to the System Name in Locate for Point of Sale (L09). If this field is: • blank, the System Name in Locate for Point of Sale (L09) is used instead • not a valid system code in Locate that is associated with the selected location, Locate cannot create the order, and returns an error Must be a valid system code associated with the fulfilling location in Locate. Used only for store pickup and ship-to-store orders. Note: You still need to complete the System Name in Locate for Point of Sale (L09) system control value, or you cannot create a ship-to-store 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 or to specify as part of the WinRetail integration. Numeric, 3 positions; optional. |
Employee ID |
The employee identification to pass to the POS system as part of a POSLog integration, or to pass to WinRetail. In the case of the WinRetail integration, the ID should be Serenade. 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 or the WinRetail integration. When you set up the cross reference for the WinRetail integration, this code should match the Sequence number of a WinRetail Reason with a Type of Price Override. 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 CWSerenade 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 WinRetail integration: Set to: • 1: L/S (Long SKU) Division • 2: L/S Department • 3: L/S Class • 4: Item Class Optional. |
Indicates whether the store location is available for selection as a destination for a ship-to-store order. Only store locations that have this field selected are listed at the Store Location Screen in order entry. See Ship-to-Store 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 |
|
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 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. |
|
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-to-store order. See Ship-to-Store 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-to-store order. See Ship-to-Store Orders for a discussion. Alphanumeric, 35 positions; required if you select the Ship to store flag; otherwise, optional. |
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-to-store order. See Ship-to-Store Orders for a discussion. Required only if the Ship to store 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 to store flag; otherwise, optional. |
|
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-to-store order. See Ship-to-Store 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 to store 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 to store flag; otherwise, optional. |
|
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-to-store order. See Ship-to-Store Orders for a discussion. If the Ship to store 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 to store flag; otherwise, optional. |
|
