Field

Description

Generate item out triggers

Indicates whether to create an outbound interface transaction trigger for each item and SKU whose offer information is updated when you complete this screen. The system creates a trigger with a file type of SKU, indicating to generate an outbound item XML message for the SKU’s. See Generic Item Download API for more information on the outbound XML message. Valid values are:

Y = Create a trigger to create an outbound item XML message (CWItemOut) for each updated item and SKU.

N = Do not create the triggers for the outbound item XML message.

This field defaults to the setting from the last time you used this menu option. If there is no stored setting, the default is Y. See Working with Default Options (WDFT) for information on how the system stores defaults.

Note: This field is displayed only if the Create Generic Item Download Trigger Records (I15) system control value is set to Y.

Alphanumeric, 1 position; required.

Item

A user-defined code the represents a unit of inventory.

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

Alphanumeric, 12 positions; optional.

SKU

The unique characteristics of an item, such as color, style, or size.

Alphanumeric, 14 positions; optional

Ofr

The code for the catalog, space, or advertisement in which you sell merchandise. See Marketing Chapter 2: Working with Offers (WOFR).

Alphanumeric, 3 positions; optional.

Description

The description of the item.

Alphanumeric, 40 positions; display-only

Field

Description

Item

The code and description of the item for which you are uploading item/SKU offer information.

Item code: Alphanumeric, 12 positions; display-only.

Item description: Alphanumeric, 40 positions; display-only.

SKU

The code and description for the SKU of the item for which you are uploading item/SKU offer information.

SKU code: Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.

SKU description: Alphanumeric, 40 positions; display-only.

Offer

The code and description of the offer for which you are uploading item/SKU offer information. See Marketing Chapter 2: Working with Offers (WOFR).

Offer code: Alphanumeric, 3 positions; display-only.

Offer description: Alphanumeric, 30 positions; display-only.

Action code

This code identifies whether the item/offer upload is a change to an existing item/offer in CWDirect or a new item/offer in CWDirect.

Valid values are:

A = This item/offer upload creates a new item/offer in CWDirect.

C = This item/offer upload changes an existing item/offer in CWDirect.

Important: When you are uploading multiple SKU/offer records, the Action code for the item/offer should be blank for all but the first SKU/offer you create. If you set the Action code for the item/offer to A or C for multiple SKU/offer upload records and you also use the Generic Item Download API, system performance during the upload process can become slow to the point of preventing access to normal functions.

Alphanumeric, 1 position; optional.

Effective date

The date the price becomes valid.

This date should be equal to or greater than the start date of the offer, and equal to or less than the stop date of the offer. If you leave this field blank, the effective date of the offer defaults.

Numeric, 6 positions (MMDDYY); optional.

Price

The price at which the item will be sold in this offer, if no discounts are applied, and the order date is equal to or greater than the effective date.

You can establish multiple effective dates and prices for the same item/offer.

Numeric, 7 positions with a 2-place decimal; optional.

Associate price

The price at which the item will be sold in this offer to associate customers. Associate price is used when the Associate field on the order is set to Y (yes) and the order date is equal to or greater than the effective date.

Numeric, 7 positions with a 2-place decimal; optional.

Page number

The primary page number on which the item appears in the offer. This assignment is used for reporting purposes, such as in the Offer Page Analysis Report (OPAR).

Numeric, 5 positions; optional.

Curve code

A code that represents the item's expected selling pattern in this offer. This code is used by the forecasting system for inventory projection and analysis reporting. Validated against the Projection Curve file. See Marketing Chapter 26: Working with Projection Curves (WCRV).

Numeric, 3 positions; optional.

Expected return %

The percentage of returns you expect to receive for the item/offer. This field is used for forecasting projections and other reports (such as the inventory status and projection report).

Example:

3.5 = 3.50%

Numeric, 5 positions with a 2-place decimal; optional.

Special handling

This value indicates whether this item is eligible for any type of special handling in this offer (such as, monogramming, hemming, etc.).

Y = This item is eligible for special handling.

N (default) = This item is not eligible for special handling.

If this field is set to Y and there is a default special handling code defined (see below), OR if you specify special handling for an item in order entry, you advance to the Work with Special Handling Screen or the Work with Custom Special Handling Screen; however, if the special handling code’s:

• Suppress S/H window field is set to Y: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is set to Y: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by entering 8 next to the item.

See Special Handling Overview for more information.

Alphanumeric, 1 position; optional.

S/H price (Special handling price)

The price to charge the customer for special handling. You can specify in the Evaluate Special Handling Charges by Order Line (D67) system control value whether to add the price just once for each order line, or multiply the special handling price by the item quantity for the line.

An error message similar to the following displays if you define a special handling price and the Special handling field is set to N:

Special handling price not allowed when not eligible.

The following message displays if you enter a special handling price and you defined a custom special handling code in the Special handling code field:

Special handling charge not allowed with custom format code.

Numeric, 7 positions with a 2-place decimal; optional.

S/H code (Special handling code)

The additional charge code associated with the type of special handling you are offering for the item.

The system validates that the additional charge code is defined as special handling, with a Type of standard or custom; the system handles each type in a different way. See Special Handling Overview for more information.

If you enter a special handling code here, you will advance to the Work with Special Handling Screen or Work with Custom Special Handling Screen automatically in order entry; however, if the special handling code’s:

• Suppress S/H window field is set to Y: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is set to Y: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by entering 8 next to the item.

See Special Handling Overview for more information.

Alphanumeric, 2 positions; optional.

Gift wrap

This value indicates whether gift wrapping is available for this item.

Y or blank = This item can be gift wrapped.

N = In this offer, gift wrapping is not available for this item.

Alphanumeric, 1 position; optional.

G/W price (Gift wrap price)

The price in this offer for gift wrapping the item. The G/W field must be set to Y to indicate that this item is eligible for gift wrap. The gift wrap price will be charged for each unit of this item that is gift wrapped.

Numeric, 7 positions with a 2-place decimal; optional.

Freight

The freight amount to be charged for this item. The value in this field will be multiplied by the quantity ordered. This value is used only if Freight by item or Flat Rate by item has been chosen as the Freight method for the source code.

Numeric, 6 positions with a 2-place decimal; optional.

Hidden freight

This value is used only with item level freight methods, such as: Flat rate by item, flat rate by item quantity, flat rate by item source, and by item.

Hidden freight represents the portion of the item's catalog price that is used for freight. You might define a hidden freight value when the freight charge to ship the item is very high. The hidden freight charge is included in the price of the item so the actual freight charge is not visible to the customer.

The hidden freight amount is subtracted from the catalog price of the item when gross profit is calculated and sales are posted. The amount of freight is posted to a separate G/L number, which is defined in the Division file. Hidden freight is also known as "theoretical" or "buried" freight.

Numeric, 6 positions with a 2-place decimal; optional.

Sale item

Indicates whether the item is on sale. This flag controls whether to generate a sale credit when the customer returns the item, based also on the payment method and the setting of the Generate Sale Credit for Orders with Sale Items (I64) system control value. Valid values are:

Y = This is a sale item.

N (default) = This is not a sale item.

If the Exclude Sale Item When Prorating Discounts (I65) system control value is set to Y, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. Also, if both this system control value and the Apply Loyalty at the End of Order (J35) system control value are set to Y, then sale items do not receive a loyalty discount. See these system control values for more information.

Alphanumeric, 1 position; required.

Volume discount

This value indicates whether this item is eligible for an end-of-order discount that will be applied when you accept the order during Order Entry.

Y = The item/SKU is eligible for the volume discount.

N or blank = The item/SKU is not eligible for the volume discount.

How Volume Discounting Works

If the Item Volume Discount is enabled, the system will:

• total the number of units ordered of volume-discountable items

• check the quantity break price table in the SKU/offer for the discount price for each discountable item

Example: the system calculates the volume discount for items A123 and C123, as if the customer purchased 12 units of each item.

Alphanumeric, 1 position; optional.

Cost

The cost to include the item in the offer. This value is used in square inch analyses and offer page analyses, such as the Offer Page Analysis Report (OPAR), and used in calculations to determine item contribution and profitability.

Numeric, 11 positions with a 4-place decimal; optional.

Square inches

The square inches (not the percentage) that the item occupies on the catalog page or in the offer.

This value is used to calculate the profitability of the item on the page.

Numeric, 3 positions; optional.

Coupon discount $ (Coupon discount dollars)

This value represents the amount that is subtracted from the price when the item/SKU is ordered from this offer.

Numeric, 7 positions with a 2-place decimal; optional.

Coupon expiration date

The date the coupon expires.

Numeric, 6 positions (MMDDYY format); optional.

Projected units

The number of units of this item that you expect to sell in the offer. You enter this forecasting value manually; the system does not update this field. This value is used for reporting purposes such as in the Inventory Status & Projection Report (ISRP).

Numeric, 7 positions; optional.

Feature/option

This value indicates whether the item is considered a featured or optional item in a depiction. A depiction is a photograph or drawing of several items within an offer. The featured item is the focus of the depiction; whereas, the optional items are less prominently displayed.

Example: If a dining room is depicted, the dining room set may be the featured item and the individual place settings, crystal, and centerpiece may be the optional items.

Valid values are:

F = Item is the featured item in the depiction.

O = Item is an optional item in the depiction.

Alphanumeric, 1 position; optional.

Pickup/new

This value indicates whether the item has been carried over from a previous offer or is new to your product offerings.

Valid values are:

P = Item is a pickup item, previously sold in another offer.

N = Item is a new addition in this offer.

Alphanumeric, 1 position; optional.

Warranty

This field defines whether the item in this offer is a warranty item.

Valid values are:

Y = The item in this offer is a warranty item. When an operator adds this item to an order in order entry or order maintenance, the system adds the item to the order at no charge.

N or blank = The item in this offer is not a warranty item.

If the Default Price Override Reason for Warranty Items (G01) system control value contains a price override reason code, the system defaults this code to the Price override code field, otherwise the operator must enter a code.

Alphanumeric, 1 position; optional.

Required reason code

This field defines whether an Order addition reason code is required when the item in this offer is added to an order in order entry or order maintenance.

Valid values are:

Y = The item in this offer requires an add reason code when the item is added to an order in order entry or order maintenance. The system displays the Enter Add Reason Window when an operator adds this item to an order in order entry or order maintenance.

N = The item is this offer does not require an add reason code when the item is added to an order in order entry or order maintenance.

Alphanumeric, 1 position; optional.