Chapter 31: Forerunner IF/SO Interface (EFOR, DFOR)
Purpose: CWDirect supports inventory forecasting through an interface with Forerunner IF/SO. Forerunner is a PC-based forecasting tool used for catalog management and reporting. You can populate the Forerunner Download files with information from CWDirect related to inventory forecasting for a specific offer or group of offers through the Extract Forerunner Data Screen (EFOR). You can then review the information in the Forerunner Download files through the Display Forerunner Files (DFOR) menu option.
Note: This chapter discusses CWDirect functionality only. See the Forerunner documentation for more information on the Forerunner product.
In this chapter:
• Forerunner Interface Overview
• Extract Forerunner Data Screen (EFOR)
• Select Offers for Forerunner Download Screen
• Display Forerunner Files (DFOR)
• Display Forerunner Extract Screen
• First Display Forerunner Product Screen
• Second Display Forerunner Product Screen
• Display Forerunner Promotion Screen
• First Display Forerunner SKU Promotion Screen
• Second Display Forerunner SKU Promotion Screen
Each time you submit the extract, the system clears the Forerunner Download files and repopulates them with current information for the selected offer(s).
The system populates information in Download Forerunner Data from the following CWDirect files to use in Forerunner forecasting:
• Item file
• SKU file
• Set file
• Item/SKU/Offer file
• Item/Warehouse file
• Buyer file
• Vendor file
• PO/Detail file
• Offer/Drop/Period file
Can you separate offer statistics for different offers on the same order? CWDirect tracks demand in the Offer/Drop Period file (FCODRP) at the order level or at the order detail level, depending on the setting of the Update offer/drop/ period at detail level field on the Create Offer Screen. If you set this field to Y for an offer, the system will track offer statistics for each order line, instead of combining all order statistics into the offer associated with the order header. Order line tracking allows you to separate statistics for different offers on the same order. For example, you may want to exclude demand statistics for a catalog insert which is a different offer from the catalog’s offer when you track demand for the catalog offer.
How does the system consolidate or separate offer statistics for an order? When updating the Offer/Drop/Period file, CWDirect consolidates all demand statistics into the offer associated with the order header, unless the offer entered for an order line is flagged to update offer/drop/period at the detail level.
Example: The offer associated with an order header (the offer associated with the source code on the order header) is 111. Total merchandise is $100.00.
• Order line 1: Offer 111, Update offer/drop/period at detail level = Y, Merchandise = $50.00
• Order line 2: Offer 222, Update offer/drop/period at detail level = Y, Merchandise = $25.00
• Order line 3: Offer 333, Update offer/drop/period at detail level = Y, Merchandise = $25.00
When you accept the order, the ORDER ASYNC updates the Offer/Drop/Period file with three records:
• Offer 111 for 1 order and $50.00
• Offer 222 for 1 order and $25.00
• Offer 333 for 1 order and $25.00
Example: The offer associated with an order header (the offer associated with the source code on the order header) is 111. Total merchandise is $100.00.
• Order line 1: Offer 111, Update offer/drop/period at detail level = Y, Merchandise = $50.00
• Order line 2: Offer 222, Update offer/drop/period at detail level = N, Merchandise = $25.00
• Order line 3: Offer 333, Update offer/drop/period at detail level = Y, Merchandise = $25.00
When you accept the order, the ORDER ASYNC updates the Offer/Drop/Period file with two records:
• Offer 111 for 1 order and $75.00 (includes offer 222 since detail record was not created)
• Offer 333 for 1 order and $25.00
Example: The offer associated with an order header (the offer associated with the source code on the order header) is 111. Total merchandise is $100.00.
• Order line 1: Offer 111, Update offer/drop/period at detail level = N, Merchandise = $50.00
• Order line 2: Offer 222, Update offer/drop/period at detail level = N, Merchandise = $25.00
• Order line 3: Offer 333, Update offer/drop/period at detail level = N, Merchandise = $25.00
When you accept the order, the ORDER ASYNC updates the Offer/Drop/Period file with one record:
• Offer 111 for 1 order and $100.00 (includes consolidated statistics for offers 111, 222 and 333, since no detail records were created)
How does the system track open and held purchase orders? The system includes up to 25 open and held purchase order detail lines in the PO# and PO quantity fields of the Forerunner Product file. When selecting purchase order detail lines to include, it first selects open purchase orders, then held purchase orders, and finally pending purchase orders. Purchase orders selected for inclusion in the file are listed in purchase order number sequence, regardless of status.
Extract Forerunner Data Screen (EFOR)
Purpose: Use the Extract Forerunner Data screen to submit a batch job that populates the Forerunner Data files with information from CWDirect files based on the selection criteria you enter.
How to display this screen: Enter EFOR in the Fast path field at the top of a menu or select Download Forerunner Data from a menu.
FCR0136 ENTER Extract Forerunner Data 3/07/03 13:10:14 EZK Mail Order
1. Product File Only
2. All Files For Last 1 Weeks
F3=Exit F7=Select Offers F9=Submit F12=Cancel |
Field |
Description |
All files for last ... weeks |
The number of weeks for which you want to extract data from CWDirect to use in Forerunner forecasting. You can select up to 52 weeks for the system to extract data from CWDirect. A message similar to the following displays when you enter more than 52 weeks:
# of weeks (62) to process cannot exceed 52.
For the purposes of the IF/SO interface, the week starts on Monday and ends on Sunday; you should have the First Day of a Forecasting Period (B99) system control value set to MON. Numeric, 3 positions; required. |
Step-by-step instructions:
1. Enter 1 in the selection field to extract data from CWDirect in order to update the Forerunner Product file only, or
2. Enter 2 in the selection field to extract data from CWDirect in order to update the Forerunner Product, Forerunner Promotion, and Forerunner SKU Promotion files.
3. Enter the number of weeks for which you want to extract data from CWDirect in the All Files for Last ... Weeks field. You can enter up to 52 weeks in this field.
4. If you selected option 2, press F7 to advance to the Select Offers for Forerunner Download Screen, where you select the offer(s) from which you wish to extract data in the Selected offers fields. If you selected option 2, you must select at least one offer. When you have completed your selection(s) at this screen, press F3 to return to the Extract Forerunner Data Screen (EFOR).
5. Press F9 to extract data from the CWDirect files.
6. If you confirm the extract, the system displays a message such as the following informing you the batch has been submitted: Job 370874/KAREN_L/FORERUNNER submitted to job queue QBATCH in library.
7. The system clears the Forerunner Download files and repopulates them with current data based on your selection criteria. You can review the information contained in the Forerunner data extract in Display Forerunner Files (DFOR).
Select Offers for Forerunner Download Screen
Purpose: Use this screen to select the offers to include in the Forerunner extract.
How to display this screen: Press F7 at the Extract Forerunner Data Screen (EFOR).
FCR0218 DISPLAY Select Offers for Forerunner Download 3/07/03 13:16:30 EZK Mail Order
Opt Offer Description Select
Type options, press Enter. 1=Select 4=Deselect
BCH SUMMER BEACH TOYS N BOG BOGUS OFFER N ISA FIRST OFFER FOR IS REPORT N ISB SECOND OFFER FOR IS REPORT N ISQ TEST FOR H91 NO ACTIVITY WK 1 N ISU TEST FOR H91 N OFF A BRAND NEW OFFER FOR 2001 N OFR ALL-PURPOSE OFFER N 279 FALL PREVIEW 1995 N
F3=Exit F7=Select/Deselect All F12=Cancel |
Field |
Description |
Offer |
An offer you use to present merchandise to your customers. The screen lists offers only if the current date is within the offer’s Begin (Begin date) and End (End date). Alphanumeric, 3 positions; optional. |
Description |
The Description of the offer. Alphanumeric, 30 positions; optional. |
Select |
Indicates whether the offer is currently selected for the Forerunner extract. Valid values are: Y = The offer is selected N = The offer is not selected Alphanumeric, 1 position; optional. |
Completing this screen:
• To select an offer: Enter 1 next to an offer.
• To deselect an offer: Enter 4 next to an offer.
• To select or deselect all offers: Press F7.
When you have completed your selection(s), press F3 or press F12 to return to the Extract Forerunner Data Screen (EFOR).
Note: If you press press F12 to return to the previous screen, your selections are not cleared. Make sure that the correct offers are selected before you exit the screen.
Display Forerunner Files (DFOR)
Purpose: Use this screen to review the information contained in the Forerunner Product, Promotion and SKU Promotion files. These files are populated each time you perform an extract through the Extract Forerunner Data Screen (EFOR).
Display Forerunner Extract Screen
How to display this screen: Enter DFOR in the Fast path field at the top of any menu or select Display Forerunner Files from a menu.
FCR0142 ENTER Display Forerunner Extract 1/14/99 11:10:17
Last extract date . . . . . . . . : 01/14/99 Last extract time . . . . . . . . : 15:47 Last company extracted . . . . . : company 555
Product records extracted . . . . : 283 Promotion records extracted . . . : 36 SKU Promotion records extracted . : 30
Type option, press Enter 5=Display
Display Product File Display Promotion File Display SKU Promotion File
F3=Exit F12=Cancel |
Field |
Description |
Last extract date |
The date when the last extract was performed. Numeric, 6 positions (MMDDYY format); display-only. |
Last extract time |
The time on which the last extract was performed. Numeric, 4 positions (HHMM format); display-only. |
Last company extract |
The company where the last extract was processed. Alphanumeric, 30 positions; display-only. |
Product records extracted |
The quantity of product records populated from CWDirect during the last extract. Numeric, 6 positions; display-only. |
Promotion records extracted |
The quantity of promotion records populated from CWDirect during the last extract. Numeric, 6 positions; display-only. |
SKU promotion extracted |
The quantity of SKU promotion records populated from CWDirect during the last extract. Numeric, 6 positions; display-only. |
Screen Option |
Procedure |
Display information in the Product file |
Enter 5 next to Display Product File to advance to the First Display Forerunner Product Screen. |
Display information in the Promotion file |
Enter 5 next to Display Promotion File to advance to the Display Forerunner Promotion Screen. |
Display information in the SKU Promotion file |
Enter 5 next to Display SKU Promotion File to advance to the First Display Forerunner SKU Promotion Screen. |
First Display Forerunner Product Screen
Purpose: Use this screen to review data contained in the Forerunner Product file.
About scanning: Scanning for an item on this screen works differently than on other screens in that entering the exact item name does not position you to that item. To scan most effectively, omit the last one or two characters of the item you want to review. For example, to display item BU001, enter just BU00.
Scanning on the Color or Size fields at this screen is not currently implemented.
How to display this screen: Enter 5 next to Display Product File on the Display Forerunner Extract Screen.
FCR0143 DISPLAY Display Forerunner Product 1/14/99 16:50:44
Opt Item Color Size Qty O/H Qty Rsv Qty B/O Price
Type options, press Enter. 5=Display
PULLOV87 BLUE XXXXXXXXX 0000100 0000007 0003600 PULLOV87 BRN XXXXXXXXX 0000001 0003600 PULLOV92 GREY XXXXXXXXX 0000001 0003600 PULLOV94 GRN XXXXXXXXX 0000100 0000005 0003600 PULLOV94 PURP XXXXXXXXX 0000100 0000003 0003600 PULLOV94 RED XXXXXXXXX 0000099 0000005 0003600 PULLOV98 WHTE XXXXXXXXX 0000002 0003600 PULLOV98 YELW XXXXXXXXX 0000100 0000007 0003600 PURP04 XXXX XXXXXXXXX 0000099 0001200 PURP0487X XXXX LRGE 0000100 0002900 PURP0487X XXXX SMLL 0000099 0002900 +
F3=Exit F12=Cancel |
Field |
Description |
Item |
A code representing an item. Alphanumeric, 13 positions; optional. |
Color |
The color of the item, derived from the first SKU element. This field is set to XXXX if the first SKU element is blank. If you use full SKU, the first four positions of the SKU displays in this field. Alphanumeric, 5 positions; optional. |
Size |
The size of the item, derived from the second SKU element. If the item has a third SKU element defined, the system displays this element after the size using a hyphen to separate the fields. This field is set to XXXXXXXXXX if the second and third SKU elements are both blank. If you use full SKU, the sixth through the eighth and the tenth through the fourteenth positions of the SKU display in this field, separated by a hyphen. If the item has a third SKU element but not a second SKU element, the third SKU element displays in the position of the second SKU element; there is no spacing in front of it. Alphanumeric, 10 positions; optional. |
Qty O/H (Quantity on hand) |
The number of units for this item across all locations in the warehouse. Numeric, 7 positions; display-only. |
Qty rsv (Quantity reserved) |
The number of units of the item reserved. Numeric, 7 positions; display-only. |
Qty B/O (Quantity on backorder) |
The quantity of this item currently backordered in the warehouse. Numeric, 7 positions; display-only. |
Price |
The SKU list price of the item. Numeric, 7 positions; display-only. |
For more information: See the Create Item Screen and Using Inventory Inquiry (DINI).
Screen Option |
Procedure |
Display item details |
Enter 5 next to an item to advance to the Second Display Forerunner Product Screen. |
Second Display Forerunner Product Screen
Purpose: Use this screen to review the details of an item in the Forerunner Product file.
How to display this screen: Enter 5 next to an item on the First Display Forerunner Product Screen.
FCR0144 DISPLAY Display Forerunner Product 1/14/99 16:56:11
Item . . . . . . . . . . . . : SK9 Color . . . . . . . . . . . : GREY Size . . . . . . . . . . . . : XXXXXXXXX
Description . . . . . . . . : SOFT SUEDE PURSE Cost . . . . . . . . . . . . : 0001000 Class . . . . . . . . . . . : 5555 Subclass . . . . . . . . . . : 5555 Vendor # . . . . . . . . . . : 0000101 Vendor name . . . . . . . . : US VENDOR On hand quantity . . . . . . : 0000300 Reserve quantity . . . . . . : 0000024 Backorder quantity . . . . . : Kit flag . . . . . . . . . . : 0 Dropship flag . . . . . . . : 0 Lead weeks . . . . . . . . . : 000 Purchase agent . . . . . . . : BTM Default price . . . . . . . : 0000000 Status . . . . . . . . . . . : U
F3=Exit F12=Cancel |
Field |
Description |
Item |
The item whose details you are reviewing. Alphanumeric, 13 positions; display-only. |
Color |
The color of the item, derived from the first SKU element. This field is set to XXXX if the first SKU element is blank. If you use full SKU, the first four positions of the SKU displays in this field. Alphanumeric, 5 positions; display-only. |
Size |
The size of the item, derived from the second SKU element. If the item has a third SKU element defined, the system displays this element after the size using a hyphen to separate the fields. This field is set to XXXXXXXXXX if the second and third SKU elements are both blank. If you use full SKU, the sixth through the eighth and the tenth through the fourteenth positions of the SKU display in this field, separated by a hyphen. If the item has a third SKU element but not a second SKU element, the third SKU element displays in the position of the second SKU element; there is no spacing in front of it. Alphanumeric, 10 positions; display-only. |
Description |
The description of the item and SKU you are reviewing. Item description: Alphanumeric, 30 positions; display-only. SKU description: Alphanumeric, 30 positions; display-only. |
Cost |
The cost of the item you are reviewing. Numeric, 7 positions; display-only. |
Class |
A code that identifies the item class for this item. This code is derived from the item’s L/S dept (Long SKU department), if any; otherwise, the class is derived from the Class. Alphanumeric, 4 positions; display-only. |
Subclass |
A code that identifies the subclass for this item. Derived from the item’s L/S class (Long SKU class). Alphanumeric, 4 positions; display-only. |
Vendor # (Vendor number) |
A code that identifies the supplier who sells you this item. Numeric, 7 positions; display-only. |
Vendor name |
The name of the vendor. Alphanumeric, 30 positions; display-only. |
On hand quantity (Quantity on hand) |
The number of units for this item across all locations in all allocatable warehouses. Note: Any quantities in pending putaway warehouses are specified in the PO quantity field of the Forerunner Product file, although this field is not displayed onscreen. See Pending Putaway Overview for more information on pending putaway warehouses. Numeric, 7 positions; display-only. |
Reserve quantity |
The number of units that are reserved. Numeric, 7 positions; display-only. |
Backorder quantity |
The quantity of this item currently backordered in the warehouse. Numeric, 7 positions; display-only. |
Kit flag |
A flag that identifies whether this item is a kit item. Valid values are: 0 = This item is not a kit item. 1 = This item is a kit item. Alphanumeric, 1 position; display-only. |
Dropship flag |
A flag that identifies whether this item is a drop ship item. Valid values are: 0 = This item is not a drop ship item. 1 = This item is a drop ship item. Alphanumeric, 1 position; display-only. |
Lead weeks |
The number of elapsed weeks from the time an order is placed to the time this item is fulfilled. This number is calculated by dividing the vendor item Lead days by seven, rounding up to the next whole number. The system uses the vendor item of the item’s primary vendor to determine the Lead days. Numeric, 3 positions; display-only. |
Purchase agent |
The name of the person who is authorized to make purchases for your company. Alphanumeric, 30 positions; display-only. |
Default price |
The SKU list price of this item. Numeric, 7 positions; display-only. |
Status |
A code that represents an item or SKU's status, such as discontinued. Alphanumeric, 1 position; display-only. |
For more information: See Performing Initial Item Entry (MITM) and Using Inventory Inquiry (DINI).
Display Forerunner Promotion Screen
Purpose: Use this screen to review data contained in the Forerunner Promotion file.
About scanning: Scanning for an offer on this screen works differently than on other screens in that entering the exact offer name does not position you to that item. To scan most effectively, omit the last character of the offer you want to review. For example, to display item B01, enter just B0.
Scanning on the Week date field at this screen is not currently implemented.
How to display this screen: Enter 5 next to the Display Promotion File on the Display Forerunner Extract Screen.
FCR0145 DISPLAY Display Forerunner Promotion 1/14/99 17:04:48
Code Description Week Date # Orders $ Ordered
A01 OFFER A01 - SPECIAL EDITION 01/04/99 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 01/11/99 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 10/26/98 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 11/02/98 0000011 000010596 A01 OFFER A01 - SPECIAL EDITION 11/09/98 0000010 000023040 A01 OFFER A01 - SPECIAL EDITION 11/16/98 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 11/23/98 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 11/30/98 0000003 000000240 A01 OFFER A01 - SPECIAL EDITION 12/07/98 0000003 000000160 A01 OFFER A01 - SPECIAL EDITION 12/14/98 0000002 000000120 A01 OFFER A01 - SPECIAL EDITION 12/21/98 0000000 000000000 A01 OFFER A01 - SPECIAL EDITION 12/28/98 0000045 000004770 BBQ BACKYARD SUMMER BARBEQUE IDEAS 01/04/99 0000000 000000000 BBQ BACKYARD SUMMER BARBEQUE IDEAS 01/11/99 0000000 000000000 +
F3=Exit F12=Cancel |
Field |
Description |
Code (Offer code) |
A code used to identify the catalog, space or television advertisement you use to accept orders. See Chapter 2: Working with Offers (WOFR). Numeric, 4 positions; optional. |
Description (Offer description) |
The description of the offer. Alphanumeric, 31 positions; optional. |
Week date |
The starting date of the week the system used to extract data from CWDirect files. For the purposes of the IF/SO interface, the week starts on Monday and ends on Sunday; you should have the First Day of a Forecasting Period (B99) system control value set to MON. Numeric, 9 positions (MM/DD/YY format); optional. |
# orders (Number of orders) |
The number of orders entered for a specific offer during the defined week. Numeric, 7 positions; display-only. |
$ ordered (Dollars ordered) |
The total dollars ordered for a specific offer during the defined week. Numeric, 9 positions; display-only. |
First Display Forerunner SKU Promotion Screen
Purpose: Use this screen to review data contained in the Forerunner SKU Promotion file.
About scanning: Scanning for an offer on this screen works differently than on other screens in that entering the exact offer name does not position you to that item. To scan most effectively, omit the last character of the offer you want to review. For example, to display item B01, enter just B0.
Scanning on the Item, Color, Size, or Week date fields at this screen is not currently implemented.
How to display this screen: Enter 5 next to Display SKU Promotion File on the Display Forerunner Extract Screen.
FCR0147 DISPLAY Display Forerunner SKU Promotion 1/14/99 17:08:03
Opt Code Item Color Size Week Date #Ordered $Ordered
Type options, press Enter. 5=Display
A01 GIZMO9 XXXX XXXXXXXXX 12/02/98 0000100 000001000 A01 ITE8 XXXX XXXXXXXXX 12/07/98 0000001 000000100 A01 ITE8 XXXX XXXXXXXXX 12/14/98 0000002 000000120 A01 ITE8 XXXX XXXXXXXXX 12/30/98 0000004 000000240 A01 ITE8 XXXX XXXXXXXXX 12/09/98 0000009 000000540 A01 ITE8 XXXX XXXXXXXXX 12/02/98 0000016 000000960 A01 ITE8 XXXX XXXXXXXXX 12/28/98 0000054 000003240 A01 SHI875H XXXX XXXXXXXXX 12/28/98 0000013 000000130 A01 SK5 BLUE SMLL-CAPC 12/02/98 0000003 000000090 A01 SK5 GREY XXXXXXXXX 12/28/98 0000015 000000450 A01 SNOR73 XXXX XXXXXXXXX 12/02/98 0000200 000002000 +
F3=Exit F12=Cancel |
Field |
Description |
Code (Offer code) |
The offer associated with this item. See Chapter 2: Working with Offers (WOFR). Numeric, 4 positions; optional. |
Item |
An item/SKU ordered during the last extract. Alphanumeric, 13 positions; optional. |
Color |
The color of the item, derived from the first SKU element. This field is set to XXXX if the first SKU element is blank. If you use full SKU, the first four positions of the SKU displays in this field. Alphanumeric, 5 positions; optional. |
Size |
The size of the item, derived from the second SKU element. If the item has a third SKU element defined, the system displays this element after the size using a hyphen to separate the fields. This field is set to XXXXXXXXXX if the second and third SKU elements are both blank. If you use full SKU, the sixth through the eighth and the tenth through the fourteenth positions of the SKU display in this field, separated by a hyphen. If the item has a third SKU element but not a second SKU element, the third SKU element displays in the position of the second SKU element; there is no spacing in front of it. Alphanumeric, 10 positions; optional. |
Week date |
The starting date of the week the system used to extract data from the CWDirect files. For the purposes of the IF/SO interface, the week starts on Monday and ends on Sunday; you should have the First Day of a Forecasting Period (B99) system control value set to MON. Numeric, 9 positions; display-only. |
# ordered (Quantity ordered) |
The quantity of the item ordered during the defined week. Numeric, 7 positions; display-only. |
$ ordered (Dollars ordered) |
The total dollars ordered of the item during the defined week. Numeric, 9 positions; display-only. |
Screen Option |
Procedure |
Review item details |
Enter 5 next to an item to advance to the Second Display Forerunner SKU Promotion Screen. |
Second Display Forerunner SKU Promotion Screen
Purpose: Use this screen to review the details of a specific item extracted from the Item/SKU/Offer file.
How to display this screen: Enter 5 next to an item on the First Display Forerunner SKU Promotion Screen.
FCR0148 DISPLAY Display Forerunner SKU Promotion 7/30/97 13:21:40
Promotion code . . . . . : 1 Item . . . . . . . . . . : TO7865 Color . . . . . . . . . : RED Size . . . . . . . . . . : MEDM-CAPC # Ordered . . . . . . . : 0000003 $ Ordered . . . . . . . : 000000237 # Returned . . . . . . . : 0000001 # Canceled . . . . . . . : 0000003 # Lost . . . . . . . . . :
Catalog price . . . . . : 0008000 Week date . . . . . . . : 07/30/97
Page percent . . . . . . : Page number . . . . . . : 00005 Kit flag . . . . . . . . : 0
F3=Exit F12=Cancel |
Field |
Description |
Promotion code |
The offer code associated with this item. See Chapter 2: Working with Offers (WOFR). Alphanumeric, 4 positions; display-only. |
Item |
The item whose details you are reviewing. Alphanumeric, 13 positions; display-only. |
Color |
The color of the item, derived from the first SKU element. This field is set to XXXX if the first SKU element is blank. If you use full SKU, the first four positions of the SKU displays in this field. Alphanumeric, 5 positions; display-only. |
Size |
The size of the item, derived from the second SKU element. If the item has a third SKU element defined, the system displays this element after the size using a hyphen to separate the fields. This field is set to XXXXXXXXXX if the second and third SKU elements are both blank. If you use full SKU, the sixth through the eighth and the tenth through the fourteenth positions of the SKU display in this field, separated by a hyphen. If the item has a third SKU element but not a second SKU element, the third SKU element displays in the position of the second SKU element; there is no spacing in front of it. Alphanumeric, 10 positions; display-only. |
# ordered (Quantity ordered) |
The number of units of this item ordered during the defined week. Numeric, 7 positions; display-only. |
$ ordered (Dollars ordered) |
The total dollars ordered of this item during the defined week. Numeric, 9 positions; display-only. |
# returned (Quantity returned) |
The number of units of this item returned during the defined week. Numeric, 7 positions; display-only. |
# canceled (Quantity canceled) |
The number of units of this item canceled during the defined week. Numeric, 7 positions; display-only. |
# lost (Quantity lost) |
The number of units of this item captured as a lost sale during the defined week. Numeric, 7 positions; display-only. |
Catalog price |
The selling price defined for this item in the offer. Numeric, 7 positions; display-only. |
Week date |
The starting date of the week used for the last extract. For the purposes of the IF/SO interface, the week starts on Monday and ends on Sunday; you should have the First Day of a Forecasting Period (B99) system control value set to MON. Numeric, 8 positions (MMDDYY format); display-only. |
Page percent |
The percentage that the item occupies on the catalog page. The system uses the value defined in the Square inches field for the item in the offer. If the item contains SKUs, the system uses the square inches defined for the SKU/Offer. The square inches field is 5 positions with a 2-place decimal. When you extract the value defined in the square inches field to Forerunner, the system rounds the value to 5 positions with a 1-place decimal. Example: The square inches for item ABC in offer B01 is 178.57. When you extract information for Forerunner, the system updates the Page percent field in the Forerunner SKU Promotion file with 178.6. Signed Numeric, 5 positions with a 1-place decimal; display-only. |
Page number |
The page number where the item appears in the catalog. Numeric, 5 positions; display-only. |
Kit flag |
A flag that identifies whether this item is a kit item. Valid values are: 0 = This item is not a kit item. 1 = This item is a kit item. Alphanumeric, 1 position; display-only. |
| Detailed Source Code Analysis Report (SSCA) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 32: Generating the Forecast*21 Interface (GFOR) |
MK03_09 CWDirect 18.0 August 2015 OTN