Loading the Item File for Emory Worldwide (LEIF)

Purpose: The Emory Item file transmits information to Emory Worldwide (a remote Order Entry service). You can create a menu option and add this program to a periodic process that runs nightly.

In this topic:

Load Emory Item File Screen

Creating the Item File

Emory Item File

Load Emory Item File Screen

Purpose: Use this screen to identify the offer for which you want to send Emory Worldwide (a remote Order Entry service) updated item and pricing information, prior to the catalog drop.

How to display this screen: Enter LEIF in the Fast path field at the top of any menu screen or select the Load Emory Item File option from the menu.

INR0929 ENTER Load Emory Item File 8/21/95 16:46:28

Mail Order Company

Offer . . . . . . . . .

F3=Exit F12=Cancel

Field

Description

Offer

The code for the catalog, space or television advertisement from which you accept orders.

Enter the code for the offer for which you want to send updated item and pricing information to Emory Worldwide.

Offer codes are defined in and validated against the Offer file. See Marketing Working with Offers (WOFR).

Alphanumeric, 3 positions; required.

Creating the Item File

Purpose: Select the Load Emory Item File option and specify the offer you want to use. This option builds a file containing all items in the offer plus their current prices. This is necessary because Emory Worldwide requires up-to-date information for their remote Order Entry.

The ITEMFILE job is submitted and program INR0928 runs when you use this option. This program creates the file INEIF on disk in library CWMPDTA that contains all items in the specified offer plus their current prices.

Emory Worldwide retrieves this file to obtain the most up-to-date item information for the offer they are taking orders for.

On-demand: Follow these steps to create a menu option for this program, if needed. This allows you to create the item file for Emory on-demand.

1. Select Setting Up Menu Options (WOPT).

2. Press F6.

3. Enter LEIF in the Option field, Load Emory Item File in the Description field, P (program) in the Type field, INR0929 in the Program name field, N in the Authority parameter field, Y in the Company parameter field, INV in the Appl area field, and All in the Appl group field.

During periodic process: To add this program to a periodic process that runs nightly:

1. Select Working with Periodic Functions (WPER).

2. Press F6 to create a periodic function.

3. Enter EM_ITEM (or any descriptive name) in the Function field, Load Emory Item File in the Description field, Y in the Company parameter field, All in the Appl area field, and INR0928 in the Program name field.

4. Select Working with Periodic Processes (WPPR).

5. Enter 7 next to the periodic process you want to add this job to, such as a daily periodic process.

6. Enter the sequence number (which specifies when you want this job to run during the periodic process) in the Seq# field, enter the name of the periodic function (specified in Step #3) in the Function field, and enter Y in the Select field (so that the job runs each time the periodic process runs).

Emory Item File

Field

Description

Company

A code that identifies your company, which is a single, isolated set of files and data. A company is an organization of financial information, inventory, and customers that is completely separate from another company.

Company codes are defined in and validated against the Company file; see Installation Setting Up Companies (WCMP).

Numeric, 3 positions.

Offer

The code for the catalog, space or television advertisement from which you accept orders. The items included in this file all belong to this offer.

Offer codes are defined in and validated against the Offer file; see Marketing Working with Offers (WOFR).

Alphanumeric, 3 positions.

Source

A code to identify a segment of your customer base, which is also used to analyze sales. The source code determines the method by which freight and pricing are calculated on an order.

Source codes are defined in and validated against the Source Code file; see Marketing Working with Source Codes (WSRC).

Alphanumeric, 9 positions.

Page/Letter

The page on which this item is advertised in this offer and the letter used to identify the item on the page. For example, 10A indicates that the item is shown as item A on page 10 of the catalog. The page/letter combination is sometimes entered instead of an item number in Order Entry. The Page/Letter field in the System Control file determines whether the page/letter code is used.

Page/letter codes are assigned to an item in the Item/Offer file; see Merchandising Assigning Items/SKUs to Offers.

Alphanumeric, 6 positions.

Item

A code for a unit of inventory. Item codes are defined in and validated against the Item file.

To facilitate loading remote orders from an Order Entry service, the page/letter code or alias item code is loaded to the Item field, if available. Also, a record will be written to this file for each page/letter cross-reference for an item in the offer, if multiple page/letter assignments exist for a single item.

Alphanumeric, 12 positions.

SKU

A code to identify the style of an item, such as its color, size, etc.

Alphanumeric, 14-positions.

Item Description

The description associated with the item, as defined in the Item file.

Alphanumeric, 40 positions.

SKU Status

The status of the item in your inventory, as defined in the Status field in the Item file. Typical status codes are ' ' (item is active), discontinued, damaged, etc.

Status codes are defined in and validated against the Item Status file.

Alphanumeric, 1 position.

Alias

The "dummy" item number under which the item is advertised in the offer, if you place the same item in multiple places in a single offer. You may use alias item numbers to determine whether item placement in an offer affects sales of the item.

Alias item numbers are defined in and validated against the Item/ Offer file.

Alphanumeric, 12 positions.

Offer Price

The selling price of the item in the Offer, as defined in the Price field in the Item/Offer file. This price appears for the item during Order Entry (if using the Offer Price pricing method), but may be overridden.

Numeric, 7 positions with a 2-place decimal.

Offer Effective Date

The date on which the item is sold in this offer at this price, as defined in the Effective date field in the Item/Offer file.

Numeric, 7 positions (CYYMMDD format).

Source Price

The price at which this item is sold to a specific segment receiving the catalog.

Source prices are defined in the Special Source Price file.

Numeric, 7 positions with a 2-place decimal.

SO03_04 CWDirect 18.0.x 2018 OTN