Field

Description

Item

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

Alphanumeric, 12 positions; required.

Clr Size Wdth (SKU codes)

The item's unique characteristics, such as its color and size.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); required if SKU/offer records exist.

Effective date

The date the price or quantity break discount becomes valid. This date should be equal to or greater than the effective date of the offer. The customer receives this price when placing an order on this date or later, if the order is for a great enough quantity.

If you establish 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.

Example: If you establish effective dates of Feb. 20, and Mar. 31 and the customer places an order on April 1, the customer receives the price associated with the effective date of March 31.

Numeric, 6 positions (MMDDYY format); optional.

Price

The price at which you are selling the item in this offer, if no discounts are applied, and the order date is on or after the effective date. You can establish multiple effective dates and prices for the same item/offer. See Work with Item Prices Screen (Quantity Price Breaks by Offer).

Alternate currency pricing: If the Use Alternate Currency Pricing (H89) system control value is set to Y, the Alt cur prc (Alternate 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 you are selling the item in this offer to associate customers. The system uses the associate price when the Associate field on the order is set to Y and the customer places the order on or after 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-inclusive (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 cur prc (Alternate 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 one or more of the offers 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.

All of the offers you select must be associated with the same currency code, or an error message displays: Offers with multiple currency codes selected.

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 #

The primary page number where the item appears in the offer. The system uses this assignment for reporting purposes, such as in the Offer Page Analysis Report (OPAR).

Numeric, 5 positions; optional.

Sale item

This value indicates whether the item 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 is on sale

N = this item 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

Projected units

The number of units of this item that you expect to sell in the offer. You enter this number manually; the system does not update this field. The system uses this number in forecasting reports, such as the Inventory Status & Projection Report (ISRP).

Numeric, 7 positions; optional.

Cost

The cost to include the item in the offer. The system uses this value 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.

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.

Sq. in (Square inch)

The square inches (not the percentage) that the item occupies on the page. The system uses this value to calculate the profitability of the item.

Numeric, 3 positions; optional.

Hidden freight

The system uses this value 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 pays freight. You can define a hidden freight value when the freight charge for the item is very high. You include the hidden freight charge in the item price so that the customer is not aware of the actual cost of shipping.

The system subtracts the hidden freight amount from the item/offer price when calculating gross profit and posting sales to the Sales Journal. Hidden freight posts to a separate G/L number, which you can define in the Division file. Hidden freight is also known as “theoretical” or “buried” freight.

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

S/H (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.

Volume discountable

This value determines whether you can apply discounts to the item for large order quantities.

Y (or blank) = This item is eligible for volume discount.

N = This item is not eligible for volume discount.

See Item Volume Discounting.

Alphanumeric, 1 position; optional.

S/H charge 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.

Price (Special handling price)

The price to charge for special handling of the item. The system multiplies this charge by the total unit quantity if the Evaluate Special Handling Charges by Order Line (D67) field in the System Control file is set to N.

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

Expected return %

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

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

G/W flag (Gift wrap flag)

This value indicates whether this item is eligible for gift wrapping in this offer. If the Gift Wrap Default (F07) system control value is set to Y, this field will default to Y; however, you can override this value.

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

N = The item cannot be gift wrapped.

Alphanumeric, 1 position; optional.

Price (Gift wrap price)

The price to charge for gift wrapping the item. The system multiplies the gift wrap price by the total unit quantity gift wrapped.

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

Feature/option

This value indicates whether the item 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 might be optional items.

Valid values are:

F = This is a feature item.

O = This is an optional item.

Alphanumeric, 1 position; optional.

Pickup/new

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

P = This is a pickup item.

N = This is a new item.

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 the 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.

Offers

The offers where the item/SKU should be updated.

If the Default Active Offers (J07) system control value is set to Y and you do not manually enter an offer in the Offer fields, the system defaults the 20 most recent active offers to the Offer fields for the entered item. The offers default to the Offer fields in descending Start date sequence.

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

Alphanumeric, twenty 3 position fields; required.

Create if record does not exist

This value controls whether to create the Item/offer or SKU/offer record automatically if it doesn't already exist.

Y = Create the record.

N (default) = Do not create the record.

Note: If this field is N and the Update all SKU offers for base item field is Y, the system creates SKU Price records only for those SKUs that are already associated with the offer.

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 SKU. The system does not create triggers for SKUs that are not included in the listed offer(s).

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.