Item

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

Alphanumeric, 12 positions; required.

Clr Size Wdth (SKU codes)

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

Alphanumeric, three 4-position fields; 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 (in user date 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 selected, the At currency price field enables 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 Using Alternate Currency Pricing for an overview and required setup.

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

Included only if the Tax Included in Price (E70) system control value is selected.

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.

Included only if the Tax Included in Price (E70) system control value is selected.

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

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

Included only if the Use Alternate Currency Pricing (H89) system control value is selected. 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 table to determine if the currency uses decimals for alternate currency pricing. If the currency has Decimalized currency selected, the system includes decimals when converting to the currency; if the field is unselected, 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 indicates 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 indicates: Offers with multiple currency codes selected.

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

See Using Alternate Currency Pricing for an overview and required setup.

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

Sale item

Indicates whether the item is on sale in this offer.

Valid values are:

• selected = this item is on sale

• unselected = this item is not on sale

If the Exclude Sale Item When Prorating Discounts (I65) system control value is selected, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. See the system control value for more information.

Freight

The freight amount to be charged for this item. Multiplied by the quantity ordered. Used only if the Freight method for the source code is By Item or Flat Rt/Item.

Numeric, 6 positions with a 2-place decimal; 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.

Hidden freight is also known as “theoretical” or “buried” freight.

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

S/H (Special handling)

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

• selected = This item is eligible for special handling.

• unselected = This item is not eligible for special handling.

If this field is selected 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 selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is selected: 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 selecting Special Handling for the item.

See Special Handling Overview for more information.

Volume discount

Determines whether you can apply discounts to the item for large order quantities.

• selected = This item is eligible for volume discount.

• unselected = This item is not eligible for volume discount.

See Item Volume Discounting.

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 selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is selected: 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 selecting Special Handling for 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) system control value is unselected.

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

G/W flag (Gift wrap flag)

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

• selected = The item can be gift wrapped.

• unselected = The item cannot be gift wrapped.

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

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:

• Feature = This is a feature item.

• Option = This is an optional item.

Optional.

Pickup/new

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

Valid values are:

• Pickup = This is a pickup item.

• New = This is a new item.

Optional.

Warranty

Defines whether the item in this offer is a warranty item.

Valid values are:

• selected = 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.

• unselected = 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.

Required reason code

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. When you specify an add reason code for an item, there is a record of the add reason code stored in an order line history record, available for review at the Display Order Line History Screen.

Valid values are:

• selected = 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 Enter Add Reason Window opens when an operator adds this item to an order in order entry or order maintenance.

• unselected = 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.

Note: When the item is added automatically to an order through the order API, the add reason code is not required. For example, an item might be added to an order automatically if it is set up as a free gift by source code.

Offers

The offers where the item/SKU should be updated.

If the Default Active Offers (J07) system control value is selected 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 table. See Working with Offers (WOFR).

Alphanumeric, twenty 3 position fields; required.

Create if record does not exist

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

• selected = Create the record.

• unselected (default) = Do not create the record.

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