Field

Description

Update SKUs

Indicates whether to update the SKU information.

Y = Update the SKUs. You advance to the Create SKU Offers Screen when you press Enter so you can enter different information at the SKU level.

N = Do not update the SKUs.

Alphanumeric, 1 position; required.

Generate item out triggers

Indicates whether to create an outbound interface transaction trigger for each item and SKU whose 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 item. 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 its SKU.

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

This field defaults to its previous 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 that represents a new unit of inventory. Validated against the Item file.

Alphanumeric, 12 positions; required.

Offer

The offer you would like to include the item/SKU in. Validated against the Offer file.

Alphanumeric, 3 positions; required.

Effective date

The date the price or quantity break discount becomes valid. This date should be on or after the effective date of the offer.

If there are multiple effective dates for the same item/offer, the system uses the price associated with the effective date closest to, but not greater than, the order date. For example, if there are effective dates of Feb. 20, and Mar. 31 and the customer placed an order on April 1, the customer receives the price associated with the effective date of March 31.

Numeric, 6 positions (MMDDYY format); optional.

Sub page

This field is informational only. You can use this field to call an external program that creates an item alias outside of CWDirect. The system provides a “hook” to the program when a user defines a sub page code and completes this screen or the Create Item Offer Screen in Work with Item/SKUs (fast path = MITM). Once the program completes, CWDirect returns to normal processing. See System Operations Chapter 28: Working with User Exit Point (WUEP) for more information on user exit points.

Alphanumeric, 5 positions; optional.

Price

The price at which the item will be sold in this offer, if no discounts are applied and the order date is on or after the effective date. Multiple effective dates and prices can be established for the same item/offer.

Alternate currency pricing: If the Use Alternate Currency Pricing (H89) system control value is set to Y, the Alt currency price field displays allowing you to enter the price of the item in the offer in the alternate (foreign) currency.

• If you enter the alternate price for the item, the system updates the Price field with the local price, using the conversion rate defined for the offer.

• If you enter the local price for the item, the system updates the Alternate currency price field with the alternate price, using the conversion rate defined for the offer.

• If you enter both an alternate price and local price for the item, the system uses the alternate price you defined and updates the Price field (local price) using the conversion rate defined for the offer.

See Customer Service Chapter 12: Using Alternate Currency Pricing for an overview and required set up.

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

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 and the order date is equal to or greater than the effective date.

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

Tax inclusive price

The price at which the item will be sold in this offer on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y.

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

Tax incl assoc price (Tax-inclusive associate price)

The price at which the item will be sold to associate customers on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y.

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

Alt currency price

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

This field displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y. You cannot enter any other item/offer amounts in the alternate currency; all other amounts display in the local currency.

• If you enter the alternate price for the item, the system updates the Price field with the local price, using the conversion rate defined for the offer.

• If you enter the local price for the item, the system updates the Alternate currency price field with the alternate price, using the conversion rate defined for the offer.

• If you enter both an alternate price and local price for the item, the system uses the alternate price you defined and updates the Price field (local price) using the conversion rate defined for the offer.

Decimalized currency? The system looks at the Currency file to determine if the currency uses decimals for alternate currency pricing. If the currency has Decimalized currency set to Y, the system includes decimals when converting to the currency; if the field is set to N, the system rounds to the nearest whole unit of currency. See Decimalized Currency? for conversion calculations and examples.

If the offer is not associated with a currency code, indicating the offer is in the local currency, an error message displays if you enter a price in the Alternate currency price field: No conversion rate for offer.

Note: The alternate currency price is not stored in any file in CWDirect; the system displays the alternate price based on the local price defined in the Price field in the Item Price file and the conversion rate defined for the offer.

See Customer Service Chapter 12: Using Alternate Currency Pricing for an overview and required set up.

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

Page number

The primary page number where the item appears in the offer (catalog). This assignment is used for reporting purposes, such as in an offer/page analysis.

Numeric, 5 positions; optional.

Curve code

A curve 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.

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%

35.0 = 35.00%

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

Actual return %

The actual return percentage for the item in the offer.

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 (or blank) = 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. Use the Evaluate Special Handling Charges by Order Line (D67) field in the System Control file whether to add the price just once for each order line, or to multiply the special handling price by the unit quantity on the order.

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 type 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 you offer gift wrapping for this item in this offer. This field defaults to Y if the Gift Wrap Default (F07) system control value is set to Y; however, you can override this default.

Y (or blank) = This item can be gift wrapped.

N = This item cannot be gift wrapped.

Alphanumeric, 1 position; optional.

G/W price (Gift wrap price)

The price you are charging to gift wrap this item. The G/W field must be set to Y to indicate that this item is eligible for gift wrap. The gift wrap price is multiplied by the unit quantity on the order line to arrive at the total gift wrap charge for the order line.

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

Freight

The freight amount to charge for this item. The value in this field is multiplied by the unit quantity on the order line to determine the freight charge for this item. Only used if the Freight by item or Flat Rate by item has been established in Freight method field for the Source Code file.

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, by item quantity, and by item source.

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 calculating gross profit and posting sales. The amount of freight is posted to a separate G/L number. Hidden freight is also know 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 represents the discount that is applied to the item for larger order quantities. See Chapter 29: Entering Additional Item Information.

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

Cost

Your 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), 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, 5 positions; optional.

Coupon discount

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

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

Coupon expiration date

The date the coupon is effective until (i.e., when it 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. For 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 warrant 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.

Field

Description

Item

A user-defined code that represents a new unit of inventory. Defaults from the previous screen.

Alphanumeric, 12 positions; display-only.

Offer

The offer in which you are presenting the SKU. Defaults from the previous screen.

Alphanumeric, 3 positions; display-only.

Colr Size Othr

The SKU code and description that is used to further define the item. Validated against the SKU Elements (1,2,3) files; see Chapter 40: Working with SKU Elements (WSK1, WSK2, WSK3).

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

Price

The price at which you are selling the item/SKU in this offer, if no discounts are applied, and the offer date is equal to or greater than the effective date. Multiple effective dates and prices can be established for the same item/offer. To establish multiple effective dates, see Work with Item Prices Screen (Quantity Price Breaks by Offer).

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

Page (Page number)

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

Numeric, 5 positions; optional.

Sal (Sale item)

This value defines whether the item/SKU is on sale in this offer. 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 item/SKU is on sale

N = this item/SKU is not on sale

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; optional.

Crv (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.

Return (Expected return percent)

The percentage returns you expect to receive for the item/offer. This field is used for forecasting projections and other reports (such as the Inventory Status & Projection Report (ISRP)).

Example:

3.5 = 3.50%

35.0 = 35.00%

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

SH? (Special handling)

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

Y= This item/SKU is eligible for special handling.

N (or blank) = This item/SKU 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, a pop-up window appears for you to enter special handling instructions.

Alphanumeric, 1 position; optional.

SH price (Special handling price)

The price that will be charged for special handling. Use the Evaluate Special Handling Charges by Order Line (D67) field in the System Control file to specify whether to add the price just once for each order line, or multiply the special handling price by the item quantity for the line.

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

S/H (Special handling code)

A code that represents the type of special handling that is required for this item/SKU. The special handling can be either standard or custom; the system handles each type in a different way. See Customer Service Chapter 3: Establishing Additional Charge Codes (WADC) and Chapter 9: Establishing Custom Special Handling Formats (WSHF).

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.

Alphanumeric, 2 positions; optional.

GW?(Gift wrap)

This value indicates whether this SKU is eligible for gift wrap. If the Gift Wrap Default (F07) field in the System Control file is set to Y, this field defaults to Y, although you can override it; otherwise, this field defaults to N.

Y (or blank) = The item/SKU can be gift wrapped.

N = In this offer, the item/SKU cannot be gift wrapped.

Alphanumeric, 1 position; optional.

GW price (Gift wrap price)

The price to charge in this offer to gift wrap this item/SKU. The G/W field must be set to Y or blank to indicate that this item/SKU is eligible for gift wrap. The gift wrap price is multiplied by the total unit that is gift wrapped.

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

Frt (Freight)

The freight amount to be charged for this item/SKU. The value in this field will be multiplied by the quantity ordered to determine the freight charge for this item. Only used if Freight by item or Flat Rate by item has been established in Freight method field for the Source Code file.

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

Hdn fr (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. Hidden freight is also known as "theoretical" or "buried" freight.

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

Cost

The cost to include the item/SKU in the offer. This value is used in square inch analyses and offer page analyses. This value is used in calculations to determine item contribution and profitability.

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

Inches (Square inches)

The number of square inches (not the percentage) this item/SKU occupies on the catalog page or in the offer. This value is used to calculate the profitability of the item/SKU on the page.

Numeric, 5 positions; optional.

Units (Projected units)

The number of units of this item/SKU that you expect to sell in an offer. This is a forecasting value that is entered manually; the system does not update this field. This number 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/SKU is considered a featured or optional item in a depiction in the offer. The featured item is the focus of the depiction; optional items are displayed less prominently. For example, in a depiction of a dress, the shoes and belt depicted may be the optional items.

Valid values are:

F = this is the featured item

O = this is an optional item

Alphanumeric, 1 position; optional.

Pickup/new

This value indicates whether the item has been carried over from a previous offer or you are presenting it for the first time in this catalog.

Valid values are:

P = this is a pickup item

N = this is a new item

Alphanumeric, 1 position; optional.

Tax Inclusive Price

The price at which the item/SKU will be sold in this offer on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y.

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

Asso. price (associate price)

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

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