Item

Your item code. Enter a valid item code to advance to the Change Item screen for that item. If you enter a partial item code, you advance to the Work with Items Screen.

Alphanumeric, 12 positions; optional.

Clr Size Wdth

The SKU elements. You can enter any portion of the item's elements along with the item code. If you enter just a SKU element (e.g., blue), the system displays every item in the table, not just blue items.

Alphanumeric, three 4-position fields; optional.

Description

The description of the item.

Note: You can search for an item based on a partial description, even if the item description exceeds the length of the field displayed on the screen, and your search entry is toward the end of the description. For example, if the item description is CHICKEN RECIPE WEIGHT MANAGEMENT DRY FOOD FOR ADULT AND SENIOR INDOOR CATS, you can still search by entering CATS, even if that word is not displayed.

Alphanumeric, 120 positions; optional.

Department

The long SKU Department to which the item belongs.

Numeric, 4 positions; optional.

Buyer

A Buyer is a person who is authorized to make purchases for your company.

Alphanumeric, 3 positions; optional.

Class

An item Item Class code is a grouping of similar items.

Alphanumeric, 3 positions; optional.

Vendor (Vendor number)

A Vendor defines the supplier of an item.

Numeric, 7 positions; optional.

Reference #

Represents the retail reference or alternate product number. You can use this value to cross-reference an item/SKU to an external system.

If you enter a valid reference number for a non-SKU’ed item, you advance to the Change Item screen for that item.

If you enter a valid reference number for an item that contains SKUs, you advance to the Change SKU with Overrides screen.

If more than one item or SKU is associated with the reference number you entered, you advance to the Select SKU for Reference Number pop-up window, where you can select the item or SKU you wish to work with.

The retail reference number is set to the same value as the item code when you create items through Importing Enterprise Foundation Data through Omnichannel Cloud Data Service (OCDS), and the number should not be changed.

This number is also used for the Integration with the Sales Audit Module of the Oracle Retail Merchandising Foundation Cloud Service.

Numeric, 15 positions; optional.

Item

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

The system assigns an item number if the Auto assign item # system control value is selected; however, you can override this value.

Alphanumeric, 12 positions; required.

Description

A user-defined description of the item.

Note:

• Not all screens or reports will display the full description if it exceeds the available space for this field.

• Not all extracts and imports will support a description that exceeds 40 positions.

Alphanumeric, 120 positions; required.

Second language description

Not currently implemented.

Alphanumeric, 40 positions; optional.

SKUs (Stock keeping unit)

Indicates whether the item is available in various styles, such as color, size, etc.

Valid values are:

• selected = This item has SKUs associated with it.

• unselected = There are no SKUs associated with this item.

See Creating Items Screen Flow for information on how this setting controls screen flow when you are creating an item.

SKU group (Stock keeping unit group)

A code that represents a group of common characteristics of a SKU item. You can use SKU groups to facilitate data entry when you use the SKU Generator; see Using the SKU Generator (ESKG).

The following are examples of SKU groups:

• SKU Group 001 lists the colors in which an umbrella is available (such as Pink, Mint, Ltbl, Yelw, Ivry, Lvnd).

• SKU Group 002 lists the sizes in which sheets are available (such as King, Qn, Full, and Twn).

If you assign a SKU group to an item, it defaults when you use the SKU generator and is display-only. You can also specify a SKU group when you are using the SKU generator.

SKU Group codes are defined in the SKU Group table; see Working with SKU Groups (WISG).

Numeric, 3 positions; optional.

Deflt cost (Default cost)

The standard cost of the item.

Unlike the Cost field on the second Create/Change/Display Item or SKU (with Overrides) screens, this field is not updated by the system through average costing or landed cost updating.

Note: The Display Cost in Inventory (A38) secured feature controls the display of this field at the Change Item screen and Display Item screen.

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

Vendor

A user-defined code that represents the vendor or supplier of an item. Validated against the Vendor table. Used to:

• Generate vendor items. The system uses this information as the default when you use the SKU Generator; however, you can override it.

• Generate drop ship pick slips or purchase orders.

• Sort and print on various reports.

Vendor codes are defined in and validated against the Vendor table; see Working with Vendors (WVEN).

Numeric, 7 positions; optional.

Buyer

A user-defined code that represents a person who is authorized to make purchases for your company. Used primarily for reporting purposes, and does not default on purchase orders.

Buyer codes are defined in and validated against the Buyer table; see Working with Buyers (WBUY).

Alphanumeric, 3 positions; optional.

Drop ship

Indicates whether you ship the item from your warehouse, or have your vendor ship it to the customer directly.

Valid values are:

• selected = When a customer orders the item, you order the item from your vendor and the vendor ships it directly to your customer.

• unselected (default) = You ship the item from your warehouse.

If you select this flag and try to create a set item (Kit type of S), an error message indicates:

Item drop ship and kit type fields are mutually exclusive. Kit type can not be equal to "S" for a drop ship item.

Drop ship items are not eligible for zone reservation. If you select this flag and try to assign a Zone reservation code to an item, an error message indicates:

SKU not eligible for zone reservation code.

You identify a drop ship item at the item level, even if the item is SKU’ed.

Note: For drop ship items, the system tries to reserve the total amount of the customer order from inventory; however, if it can't reserve the entire amount, it generates drop ship pick slips or POs when you run drop ship processing. See Processing Drop Ship Orders by Batch (MDSB).

Mfg vendor (Manufacturing vendor)

The vendor who manufactured the item. Used primarily for informational and query purposes.

Numeric, 7 positions; optional.

Exclude FPO (Exclude flexible payment option)

Determines whether this item is excluded from deferred and installment payment plans.

Valid values are:

• selected = Exclude this item from deferred and installment payment plans. Any order containing an excluded item cannot have a pay plan applied to it; instead, an error message indicates:

Order is not eligible for deferred/installment billing plan.

• unselected = Do not exclude this item from deferred and installment payment plans.

See Deferred/Installment Billing Overview.

Membership

Indicates that the item represents a membership program, which you can use to generate periodic orders to a customer.

Valid values are:

• selected = This is a membership item

• unselected = This is not a membership item

When you add a membership item in order entry, the system displays a pop-up window for you to select the membership program in which to enroll the customer.

Simplify creating a membership: You can use the same code for the item number and the membership ID. When you enter this item code in order entry, it defaults to the membership program field in the pop-up window.

Note: If you process orders through the web storefront, the membership item and program ID must be the same.

If the membership includes a discount: You should unselect the Discountable field for the membership item, or the price of the membership itself will be discounted.

You should select the Non/inv flag for a membership item.

L/S dept (Long SKU department)

A code used to group items into departments for reporting purposes. Long SKU departments are defined in and validated against the Long SKU Department table; see Working with Long SKU Departments (WLSD).

Required if the Use Retail Integration (H26) system control value or Require L/S Department (I92) system control value is selected.

When you upload items into Order Management System, you can identify the item using a combination of long SKU department, long SKU class, long SKU style, long SKU vendor, long SKU color, long SKU size, and long SKU width; see Retail Integration (External System into Order Management System) Overview and Setup.

Secured Feature

If you do not have authority under the Maintain Long SKU Values in MITM (B05) secured feature, you can not enter or change this value.

Numeric, 4 positions; required if system control value is selected.

L/S class (Long SKU class)

A code you can use to group items into classes for reporting purposes. Long SKU classes are defined in and validated against the Long SKU Class table; see Working with Long SKU Classes (WLSC).

Required if the Use Retail Integration (H26) system control value or Require L/S Class (I93) system control value is selected.

Retail Integration (external system to Order Management System)

If the Use Retail Integration (H26) system control value is selected, long SKU classes are linked to long SKU departments and are called retail classes. Retail classes are department specific whereas regular long SKU classes are unique and remain constant across departments. For this reason, when the Use Retail Integration (H26) system control value is selected, you can only enter a retail class that is assigned to the long SKU department in this field. If you enter a long SKU class that is not linked to the long SKU department, the system does not let you proceed and displays an error message: L/S Class (xxxx) was not found in L/S Department (xx).

Since retail classes are department specific, if you prompt in this field before entering a long SKU department, an error message indicates: L/S Department required to prompt on L/S Class.

Retail classes are defined in and validated against the Retail Class table; see the Work with Retail Class Screen.

Note: When the Use Retail Integration (H26) system control value is selected, the system populates and validates against the Retail Class table instead of the Long SKU Class table; therefore, you cannot access Working with Long SKU Classes (WLSC).

Secured Feature

If you do not have authority under the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Numeric, 4 positions; required if system control value is selected.

Class

A user-defined code that identifies a group of items. Item class codes are used to

• sort inventory,

• define information templates at the item class level,

• assign city/state restrictions, and

• assign customer class restrictions.

Validated against the Item Class table; see Working with Item Classes (WICL).

An item class is required if the Require Item Class in Work with Items (F06) system control value is selected. An error message indicates that you left this field blank:

Item class required.

Alphanumeric, 3 positions; required if the Require Item Class in Work with Items system control value is selected.

Unit/measure

A standard by which an item is sold. Typical units of measure include:

• EA = each

• IN = inches

• C12 = case of 12

Validated against the Unit of Measure table (see Working with Units of Measure (WUOM)) and defaults from the Default Item Unit of Measure (B33) system control value, if a value is specified.

Alphanumeric, 3 positions; required.

Kit type

Defines the type of kit or set functionality represented by this item.

Valid values:

• Set = A predefined group of items that is grouped together when it is picked and packed. A set may be comprised of items that are sold individually or only as part of the set. An item record must exist for each component item of the set.

• Finished good = Items that are assembled and stocked as a finished unit. These items may be comprised of items that are sold individually or of raw materials that are used only as components of a finished good. An item record must exist for each component item, so that you may track inventory and usage.

• Variable set = Customers can choose from a list of items to make up a variable set. For example, an offer says to choose any 2 slacks, 1 jacket, and 1 belt from this page for only $200.00. The Order Entry operator sees a screen listing the available items. You must define the pool of items. Typically, you present the items available in a variable set on the same page of the catalog.

• Blank = none of the above.

Kit items are not eligible for zone reservation. If you enter a value here and try to assign a Zone reservation code to an item, the system displays an error message:

SKU not eligible for zone reservation code.

See Working with Sets.

Optional.

Status

A code that represents an item's status, such as obsolete, discontinued, etc. This information is used for inventory reporting purposes; also, items that are assigned the Item Status for Suppressing Item During Item Selection (L21) at the item level are not listed at the Item Selection screen. See Working with Item Status (WIST) for background.

Alphanumeric, 1 position; optional.

Ship wgt. (Shipping weight)

The actual shipping weight of the item. The system can use this value to calculate carton weights and determine shipping charges if you:

• perform manual confirmation

• use cubing

• specify an alternate shipper based on minimum shipping weight

Also, the system uses the shipping weight defined for the item to create item weight records in the Download Extended Manifest table (FLMNDE) when you use a PC Manifest to confirm shipments.

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

Sell wgt. (Selling weight)

Used to calculate the freight charge on an item when the Freight method on the order is set to By Item or Flat Rt/Item.

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

Ship alone

Indicates how to ship this item.

Valid values are:

• Ship Alone = This item must ship by itself, and each unit prints on its own pick.

• Blank = This item can be shipped with other items.

• User Defined = A user-defined code for any special shipping requirements.

Optional.

Height

The height measurement for an item. The Height, Length, and Width values determine the cubic volume of an item. Can be entered in feet or centimeters, or any other measurement as long as it is consistent. Used in Suggest Location Placement (MSLO) when evaluating whether an item can be stored in a particular location.

Numeric, 3 positions; optional.

Length

The length measurement for an item. The Height, Length, and Width values determine the cubic volume of an item. Can be entered in feet or centimeters, or any other measurement as long as it is consistent. Used in Suggest Location Placement (MSLO) when evaluating whether an item can be stored in a particular location.

Numeric, 3 positions; optional.

Width

The width measurement for an item. The Height, Length, and Width values determine the cubic volume of an item. Can be entered in feet or centimeters, or any other measurement as long as it is consistent. Used in Suggest Location Placement (MSLO) when evaluating whether an item can be stored in a particular location.

Numeric, 3 positions; optional.

Cube factor

The cubic volume of the item. Controls the number of units of this item that can fit into a carton. The system will compare the cube factor against the Cube field value from the System Control table, which defines a default box size. See Setting Up Fulfillment Values.

Example: If the Cube field value in the System Control table is 100 and the Cube Factor for an item is 25, then 4 of this item can fit into one box.

Note: The Cube Factor is used to determine the number of pick slips generated.

Numeric, 3 positions; optional.

Sell qty (Sell quantity)

The selling quantity defines the required order quantity (or multiple of) for this item. For example, an item may be stocked in single units, but must be sold in quantities of 6 (or 12, or 18, etc.).

If an uneven amount is ordered during Order Entry, the system displays a message and forces the operator to enter a quantity which is a multiple of this number.

Numeric, 5 positions; optional.

Discountable

Determines whether certain discounts can be applied to the item. If this field is unselected, an item is not eligible for the discount percent at Order Entry or the discount percent defined for the source code or sold to customer’s customer price group; however, the item is eligible for all other discounts.

• selected = This item is discountable.

• unselected = This item is not discountable.

Non-discountable items are not included in the merchandise total for the purposes of evaluating whether the order qualifies for a promotional discount (set up through Working with Promotions (WPRO)) or dollar discount (set up through the Work with Offer Dollar Discounts Screen or the Work with Source Dollar Discounts Screen) if the discount requires an order minimum.

Non/inv (Non inventory)

Indicates whether inventory levels are maintained for the item. If selected, you can order this item, but the system never checks availability when reserving the item or generating a pick slip.

You must select this flag for a subscription item (Subscription = selected); these items will be express billed.

Pick slip preparation: The system:

• Does not create a pre-generated pick for a non-inventory item if all other items on the order are backordered; when one or more backordered items are available, the system creates a pre-generated pick for the non-inventory item as well as for the available item(s). Note: If you select the Affect inv (Affect inventory?) flag on the Work with Order Lines screen in order entry, the system will create a pre-generated pick for the non-inventory item; however, this change will effect a change in inventory totals for the non-inventory item during order entry and when you ship the order.

• Creates a pre-generated pick for a non-inventory item if all other items on the order are not selected for pick slip preparation; see Selecting Order Lines for Pick Slip Preparation.

Printing pick slips: The item will still be included on a pick slip, as long as the ship via on the order is not an express bill. If you specify a location for a non-inventory item, this location appears on the pick slip; however, the location is not included in the normal sort sequence.

• selected = This is a non-inventory item.

• unselected = This is a regular item that will be tracked.

Non-inventory items are not eligible for zone reservation. If you select this flag and try to assign a Zone reservation code to an item, the system displays the following error message: SKU not eligible for zone reservation code.

Oversize

Determines whether this item is considered an oversized item. Oversized items do not receive their own pick slip unless ship alone is indicated. This information is passed to TanData.

• selected = This is an oversized item.

• unselected = This is not an oversized item.

Hazard code

A user-defined code used to categorize an item as a hazardous material that requires special storage and/or handling. Validated against the Item Hazard table; see Working with Hazardous Item Codes (WHAZ). This information is passed to TanData.

Alphanumeric, 2 positions; optional.

Loc class (Location class)

A code that represents a location type, such as caged area, etc. Both items and locations may be assigned location classes. Items can only be stored in locations that have the same location class. Only items with the same location class will appear on the same pick slip.

Validated against the location class table; see Creating and Maintaining Location Classes (WLCL).

If the Allow Location Class Edit in Inventory Transaction (F86) system control value is selected, the system validates the location class defined for the item against the location class defined for the location during inventory transaction processing.

Alphanumeric, 2 positions; optional.

Pieces/case (Pieces per case)

The number of units that fit in a case. Used when suggesting location placement.

Numeric, 5 positions; optional.

L/S style (Long SKU style)

A user-defined field that you can use for tracking and queries. Long SKU style can also be defined in the SKU table but is not validated.

Required if the Use Retail Integration (H26) system control value is selected.

The system requires a unique long SKU style code if the Require L/S Style (I94) system control value is selected.

When you upload items into Order Management System, you can identify the item using a combination of long SKU department, long SKU class, long SKU style, long SKU vendor, long SKU color, long SKU size, and long SKU width; see Retail Integration (External System into Order Management System) Overview and Setup.

Secured Feature

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you can not enter or change this value.

Alphanumeric, 20 positions; required if system control value is selected.

L/S vendor (Long SKU vendor)

A user-defined field that you can use for tracking and queries. Long SKU vendors are defined in the SKU table but are not validated.

Secured Feature

If you do not have authority under the Maintain Long SKU Values in MITM (B05) secured feature, you can not enter or change this value.

Alphanumeric, 7 positions; optional.

Season

Defines the season associated with this item, such as spring.

Season codes are defined in and validated against the Season table; see Working with Season Codes (WSEA).

Alphanumeric, 3 positions; optional.

Royalty

This flag indicates whether sales of the item require royalty payments to an author or owner, and is used for query and reporting purposes only. Valid values are:

• selected = This is a royalty item

• unselected = This is not a royalty item

Entity

A business unit within your company that is held accountable for sales performance; for example, mail order, retail, or e-commerce.

If the system control value Require Entity in Item File (G44) is selected, you must enter an entity code for each item you set up; entity codes for items and SKUs are defined at the item level. Informational only.

An order is associated with an entity through the source code on the order header; for the purposes of accounting, tracking order history, determining vendor response codes, and overriding system control values at the entity level, this source code entity will override any entity assigned to an item on the order. See Setting Up Order Entry Values, and Setting Up Customer Service Values, for information on the system control values that determine how you use entity for these purposes.

Entities are defined in an validated against the Entity table. See Working with Entities (WENT).

Alphanumeric, 3 positions; required if the Require Entity in Item Table system control value is selected.

Ship via

A code that represents the shipper that must be used when shipping this item.

When a customer orders the item, the system assigns this ship via code, but you or the system can override the ship via.

You can set up an additional shipping charge for the item delivered by this ship via using the Create Ship Via/Item Screen for the ship via. See Working with Ship Via Codes (WVIA).

Item Ship Via Override

If item ship via overrides exist for the item, the ship via you define must exist in the Item Ship Via Override table or an error message indicates: Invalid ship via for item.

Additionally, if you prompt on the Ship via field, the system displays the Work with Item Ship Via Overrides screen containing only those ship vias eligible to ship the item.

When a customer orders the item, the system assigns this ship via code, but you or the system can override the ship via to another eligible ship via, based on records in the Item Ship Via Override table.

If item ship via overrides do not exist for the item, you can define any valid ship via code in this field. See Working with Item Ship Via Overrides for more information on defining eligible shippers for an item.

Alphanumeric, 3 positions; optional.

L/S Subclass

A user-defined field that you can use for tracking and queries. Long SKU subclass can also be defined in the SKU table but is not validated.

Displayed and required only if the Use Retail Integration (H26) system control value is selected.

Secured Feature

If you do not have authority under the Maintain Long SKU Values in MITM (B05) secured feature, you can not enter or change this value.

Numeric, 4 positions; required.

Carton

The type of carton in which this item must be shipped.

If present, the carton ID is passed to TanData when confirming the item for shipment. This information is used to calculate best way shipping, which determines the lowest price to ship the carton.

Numeric, 2 positions; optional.

Avail thrshld (Item-level availability threshold)

Indicates when to trigger an automatic download of item availability information through the generic inventory API. The system creates a trigger record for an item when its available quantity breeches the threshold, and an integration layer process generates the Inventory Download XML Message (CWInventoryDownload) message to send inventory information to an external system. See Generic Inventory Download API for an overview of message generation rules and processing.

Availability threshold hierarchy: If you leave this field blank, the system checks the Availability threshold (item class-level); if there is no item class-level setting, the system checks the Quantity Available Threshold for Inventory Downloads (G36) system control value. See this system control value for a complete description of how the availability threshold hierarchy works.

Numeric, 5 positions; optional.

Rtl style (Retail Style #)

A user-defined code used to identify the item.

Retail Integration (external system to Order Management System)

When you upload item information into Order Management System, you can identify the item using the retail style number; see Working with Retail Integration Item Upload (RIIU).

Alphanumeric, 20 positions; optional.

OROB eligible

Indicates whether to include this item when:

• sending item and inventory information from Order Management System to Order Broker through a stored procedure; however, this flag does not control whether to include the item through an API that uses an XML message, such as the Generic Item Download API or the Generic Inventory Download API.

• sending backordered order lines to the Order Broker for fulfillment. See Order Broker Integration for an overview, and see Rules for Submitting Backorders to the Order Broker for more rules that govern eligibility for the Order Broker.

• sending ship-for-pickup orders to the Order Broker. See Order Broker Integration for an overview, and see Ship-for-Pickup Orders for more details.

Valid values:

Selected (default) = Include this item when you use a stored procedure to send item and inventory information to Order Broker; also, the item is eligible to be sent to the Order Broker on brokered backorders or ship-for-pickup orders.

Unselected = Do not include this item when you use the stored procedure to send item and inventory information to Order Broker; also, the item is not eligible to be sent to the Order Broker on brokered backorders or ship-for-pickup orders.

Note: When you upload items into Order Management System, this flag is selected by default; see Working with Retail Integration Item Upload (RIIU). Also, when you copy an item from one company to another, the flag is selected in the destination company.

SVC type

A code that indicates the item is a stored value card, and whether the stored value card is a physical or virtual card.

• blank (default) = The item is not a stored value card.

• Physical = The item is a physical stored value card.

• Physical/Early Notify = The item is a physical stored value card and, as soon as the stored value card is processed through billing, the system sends an email notification to the recipient card holder on the order, notifying the customer that a stored value card has been purchased and is in the process of being delivered.

• Virtual = The item is a virtual (non-physical) stored value card.

See Creating a Stored Value Card Item for more information on setting up a stored value card item.

Optional.

Voucher Type

Indicates the usage for a stored value card. Valid values are:

• Single-Purpose: The stored value card is a voucher for one type of goods or service.

• Multi-Purpose or blank: The stored value card is not a single-purpose voucher.

You can select a voucher type only when the item is assigned an SVC Type.

Pass hidden tax for CWInvoiceOut message? This field is used to determine whether to calculate hidden tax and pass it in the Invoice Download XML Message (CWInvoiceOut) for redemptions or credits against a single-use voucher that was created and sold in Order Management System Cloud Service on an order subject to VAT. See the ipm_spv_hidden_tax_amt field in the Invoice Download XML Message (CWInvoiceOut) help topic for more information.

Note: This field is not updated through integrations such as the retail integration item upload or the import from Omnichannel Cloud Data Service (OCDS), or passed in web service messages such as the item download XML message (CWItemOut).

User fields

There are 4 user-definable fields. You can define these fields according to your organization's specific requirements.

The system defaults the Vendor user field 3 in Working with Vendors (WVEN) to the Item user field 3 field when you create or change an item and the program name INR1156 has been defined in the User function field for the CHGITEM and ADDITMSKU user exit points. See Working with User Exit/Edit Point (WUEP).

Alphanumeric, 10 positions (each field); optional.

External info

Indicates if the item is eligible for item retrieval from an external system.

• selected = The item is eligible for item retrieval from an external system.

• unselected = The item is not eligible for item retrieval from an external system.

Selecting this flag allows you to search for a product in an external system based on the item number entered in Order Management System. For example, the item number in Order Management System may represent a high-level item category, such as “front wheel bearing.” When you enter the item in Order Management System, the system calls the external system so that you can select the specific front wheel bearing that fits the year, make, and model of the car for which the customer is requesting the part. Once the specific product number is selected within the external system, the system returns the product number to Order Management System. If the product number matches an item number in Order Management System, the system adds the item to the order or positions you to the item number in item availability or inventory inquiry.

Last chg date (Last change date)

The date the item, SKU of this item, or vendor item was last created or changed.

Note: Included on the Display Item and Change Item screens only.

Numeric, 6 positions (HHMMSS format); display-only.

Sort sequence number

The sequence number used to determine the order in which SKUs sort.

You can use the sort sequence to display SKUs in a different order, such as by size, rather than alphanumerically by SKU code. See SKU Sort Sequence Numbers for an overview.

Required if the Require Sort Sequence Number in the SKU File (F23) system control value is selected.

Numeric, 5 positions; required if the Require Sort Sequence Number system control value is selected.

Cost

The cost of the item. When you use average inventory costing, the system calculates a new average cost automatically during Purchase Order Receiving and updates this field with the new calculated cost.

Note: The Display Cost in Inventory (A38) secured feature controls the display of this field at the Change Item (Base Information) and Display Item (Base Information) screens.

Average cost: The system uses the following calculation to determine the average cost:

(current on-hand x current average cost) + (quantity received x new purchase cost) / (quantity on-hand + quantity received) = new average cost

The new purchase cost represents the actual cost at which the item was purchased plus any overhead charges and additional item charges. See Purchase Order Receiving Overview.

For example:

current quantity on-hand = 185

current average cost = 25.00

quantity received = 25

new purchase cost = 28.75 (25.00 + 15% for commission)

(185 x 25.00) + (25 x 28.75) / (185 + 25) = 25.45 (new average cost)

Standard costing: The system does not calculate a standard average cost automatically. However, you can update the standard cost with the landed cost (primary vendor item price + vendor additional charges) through:

• Updating Standard Cost (MSCC) or the Update Standard Cost periodic function, or,

• Working with Vendor Items (WVNI) or the Work with Item/SKUs screen, available by selecting Vendor Item for an item or SKU at the Work with Items Screen. Only the vendor item cost associated with the item's primary vendor (appearing on the first Create/Change/Display Item screen) can update the item's standard cost.

FIFO costing: The cost stored here in the SKU table is updated similarly to the average cost, but is used only for reporting and inquiry, not for the actual costing of inventory transactions such as billing.

See the Costing Method (A25) system control value and FIFO Costing Overview.

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

Short SKU

(Display screen only)

A unique number that the system assigns to all items and SKUs. You can see this number only on display screens and not on any change or create screens. In Inventory Inquiry (DINI) see: Display SKU (Base Information) Screen (Non-SKU’ed Item) or Display SKU - 1 of 2 (With Overrides) Screen. In Work with Items (MITM) see: Display SKU (Base Information) screen or Display SKU screen.

When passing item/SKU information in the e-commerce interface, the system uses the short SKU number instead of the alphanumeric value in the SKU field. See Downloading E-Commerce Offer Files (EOFR).

Numeric, 7 positions; display-only.

Primary warehouse

A code that represents the primary warehouse where you keep the item. The Default Warehouse (A04) from the System Control table defaults here, but you can override it. Warehouse codes are defined in and validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; required.

Warehouse maximum

The item's recommended maximum number of units for the warehouse from the previous field.

Numeric, 7 positions; optional.

Warehouse minimum

The item's recommended minimum number of units for the warehouse defined previously.

Numeric, 7 positions; optional.

Primary location

A code that represents the primary location in the warehouse where you stock the item; sometimes referred to as the “primary primary.” The location code you enter here will default in inventory transactions, purchase order receiving, etc. Location codes are defined in and validated against the Location table. See Creating and Maintaining Locations (WLOC).

Typically, the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates:

Zone Aisle Shelf Bin

A 01 02 01

Note: When you assign a location code to a non-inventory item, the location code will print on the pick slip if you use one of the base pick slip printing programs; however, the non-inventory item will not be sorted correctly on the batch pull sheet.

Alphanumeric, 7 positions; optional.

Location maximum

The item's recommended maximum number of units to be stored in the primary pick location, from the previous field.

Numeric, 7 positions; optional.

Location minimum

The item's recommended minimum number of units to be stored in the primary pick location, from the Primary location field.

Numeric, 7 positions; optional.

Zone reservation code

A code assigned to weather-sensitive items such as plant stock to insure that the items will ship to different regions of the country within time windows suited to the regions.

Items processed through the zone reservation program will not be reserved during order entry; instead they will be assigned a backorder status of Z (Zoned reservation), and will be reserved or backordered during pick generation, at an optimal time for shipping.

Zone reservation processing requires:

• The item/SKU must be assigned a zone reservation code

• The offer associated with the order must be assigned a season code

• The shipping address for the order must be assigned to a geographic zone

• For each zone reservation code, you must define zone date windows for all geographic zones in the country

Note: Items specified as Drop ship items are not eligible for zone reservation codes.

See Shipping Zone Reservation Overview.

Alphanumeric, 4 positions; optional.

Reserve qty (Reserve quantity limit)

If the order quantity exceeds this amount, the system does not attempt to reserve the item when you enter the order, regardless of the setting of the Immediate Reservation (A64) system control value. You will need to use Working with Interactive Reservation (MIRV) to reserve the item on open orders.

Order Broker: If you use the Order Broker Integration, the system submits the order line to the Order Broker for fulfillment even if the line exceeds the reserve quantity limit, provided the line is eligible based on the Rules for Submitting Backorders to the Order Broker.

Numeric, 7 positions; optional.

Coordinate group

A code assigned to items to ensure that certain items ship together when ordered together. Items with the same coordinate group code will ship together through the same shipper.

The coordinate group number assigned to an item will default when a customer orders the item. You may override this assignment. During pick slip preparation, the system does not create a pre-generated pick until all of the coordinate grouped items on the order are eligible for pick slip preparation.

When you use Processing Auto Soldout Cancellations (MASO) to sellout an item, you have the option of placing all related coordinate grouped items on hold.

Numeric, 3 positions; optional.

Item category

A code assigned to the item to classify and group like items for use in the Item Relationships function. The Compatibility field should also be completed to fully use the Item Relationships function. Validated against the Item Category table; see Working with Item Category Codes (WITG).

Numeric, 4 positions; optional.

Compatibility

A user-defined code assigned to an item, You can enter this code in the Item Relationships function to review a list of other compatible items. For example, you might use a compatibility code to associate PC-compatible products.

Alphanumeric, 3 positions; optional.

2nd compatblty (Second compatibility)

A user-defined code assigned to the item.

If the second compatibility code for the item matches the code defined in the Second Compatibility Code used to Trigger SKU Blocking (K84) system control value, the system sends item and order information to an external system to determine whether the item/SKU is allowed on an order. See this system control value for more information.

Alphanumeric, 3 positions; optional.

Suppress backorder card

Indicates whether to produce a backorder card for the item. You might use this field to identify promotional items, free gifts, or catalogs, to prevent them from generating backorder cards or appearing on backorder lists.

Valid values are:

• selected = Suppress normal backorder card generation for this item.

• unselected = Do not suppress normal backorder card generation.

If the Unconditional Suppression of Backorder Card (F19) system control value is selected suppressed items will never appear on a backorder card. If this system control value is unselected, suppressed items will appear only on the first backorder card for the order, and only if an unsuppressed item triggers the backorder card when you use Generate Backorder Notices (GBOC).

Pre-order

Indicates whether this is a pre-order item for which you can accept orders before you expect to have inventory to fulfill. The OCDSFA and PREORDER periodic functions, which are part of the Enterprise Order Integration (Future Receipts and Pre-Order Processing), set this flag and handle updates and orders for pre-order items that are fulfilled through the integration with Order Broker. Possible settings:

• selected = This is a pre-order item, and orders will be submitted to Order Broker as inventory becomes available.

• unselected = This is not a pre-order item.

This flag is not displayed at item creation, and you cannot change its setting at a screen. Only the periodic functions mentioned above update this flag.

Display-only.

VAT exempt

Controls whether the item is exempt from VAT or conventional tax. Has a different effect depending on how the Tax Included in Price (E70) system control value is set.

If the Tax Included in Price (E70) system control value is selected

• selected = The item is exempt from both VAT and conventional tax. On orders subject to VAT, the customer pays the regular (tax-exclusive) price for the item.

• unselected = The item is subject to VAT and tax-inclusive pricing and/or conventional tax.

If the Tax Included in Price (E70) system control value is selected:

• selected = The item is exempt from tax only if there is a tax rate defined in the VAT % field for the customer's country.

• unselected = The item is subject to tax.

You can also define tax exemptions for an item in a particular U.S. state or Canadian province. See Working with GST Tax Exemption Status (MGTX) and Working with GST Tax Exemption Status (MGTX).

Hidden tax amt (Hidden tax amount)

The amount to include in the Hidden tax field for an item subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line.

You can define either a hidden tax amount or a percentage on this screen, but not both. If you do not define either, the item takes the VAT percentage defined for the customer's country.

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

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

Hidden tax pct (Hidden tax percentage)

The percentage to use when calculating hidden tax for an item subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line.

You can define either a hidden tax amount or a percentage on this screen, but not both. If you do not define either, the item takes the VAT percentage defined for the customer's country.

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

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

Restrict

Indicates whether this item can be ordered.

• selected = You cannot add this item to an order, and demand is not captured.

• unselected = You can add this item to an order, and demand is captured.

Note: If there were existing orders for this item before it became “restricted,” those orders are processed normally.

S/O control (Soldout control)

A code that represents how you determine when an item is sold out. If you leave this field blank, the item will never sellout automatically in Order Entry.

You define soldout control codes in the Soldout Control table with one of the three following statuses:

• Sellout the item immediately. (An item must be coded to sellout immediately in order to be picked up by Processing Auto Soldout Cancellations (MASO).)

• Sellout the item when the quantity available is zero, not including open purchase orders.

• Sellout the item when the quantity available is equal to zero, including open purchase orders.

See Working with Soldout Controls (WSLD) and Soldout Calculation.

You can define a Default Soldout Control Code (D72) to default automatically when you create items and SKUs; however, you can override this value. The system might also override the soldout control code when you use the Process Auto Soldouts function.

If the Disregard Soldout Controls for Non-Allocatable Warehouses (J27) system control value is selected, the system disregards soldout control rules for items reserved against a non-allocatable warehouse. If the item cannot be reserved, the system backorders the item in the non-allocatable warehouse. See this system control value for more information.

Alphanumeric, 2 positions; optional.

Subscription

Indicates whether the item is a subscription, such as a newsletter.

Valid values are:

• selected= Item is a subscription.

• unselected = Item is not a subscription.

If you identify an item as a subscription item,

• you must select the Non/inv (non- inventory) field to indicate that inventory levels are not maintained for the subscription item and that customer will be billed (the full price of the subscription) immediately through Express Billing.

• you must create a record for the subscription in the Item Subscriptions table to define the particulars of the subscription, such as the current issue number, length of subscription (number of intervals and number of days between issues).

See Working with Item Subscriptions (WISB).

Low price

The lowest recommended sale price for the item; however, the item can be sold at a lower price. No message displays in Order Entry if you go below this price.

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

List price

The system uses this price when you process item to item transfers (inventory transaction code = G). The list price of the source and target items must be identical, or the system will not allow you to process the transfer. If you are changing the quantity as part of the transfer, the system will confirm that the list price of the source item is the same as the list price of the target item based on the target item's quantity. For example, if the target item will constitute a set of three of the source item, the list price of the target item should be three times the list price of the source item.

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

Reference # (Reference number)

Represents the retail reference or alternate product number. You can use this value to cross-reference an item/SKU to an external system, such as through the Generic Inventory Transaction Upload or the Generic Order Interface (Order API).

The retail reference number is set to the same value as the item code when you create items through Importing Enterprise Foundation Data through Omnichannel Cloud Data Service (OCDS), and the number should not be changed.

This number is also used for the Integration with the Sales Audit Module of the Oracle Retail Merchandising Foundation Cloud Service.

Numeric, 15 positions; optional.

Orig retail $

The original price of the item at the retail store. Informational only.

Numeric, 7 positions with a 2-place decimal.

Projected returns

The number of units you expect to receive in returns for the item. The system uses this quantity when determining whether to sell out an item in order entry or maintenance if the item has a soldout control status of 2 (include on-order quantity in soldout calculation). The system backorders the projected return total plus the on-order quantity on unreceived purchase orders before selling out the item. For example, if you had 0 units on-hand, 10 units on an open purchase order, and entered 10 in this field, the system would backorder the first 20 units you entered in order entry, and sell out any units ordered after that.

Automatic field update: When a return is processed, the system automatically subtracts the number of units returned from the number you initially entered in the Projected returns field. The number in this field will never be less than 0, however. For example, if you initially entered 10 in the Projected returns field, and 11 units of this item are returned, the Projected returns field will show a value of 0 when the return is processed.

Note: Updating this field does not affect any orders already entered.

See Working with Soldout Controls (WSLD) for more information on working with soldout control codes and how they work with projected return quantities.

Numeric, 7 positions; optional.

Harmonize

A code that prints on customs documents for international shipments.

If you charge duty on international orders, you use this field to define the item's duty rate. The system compares this value with the duty rates defined for the country of the shipping address, and adds a duty charge to the order if it finds a match. See Setting Up the Country Table (WCTY) for more information on defining duty rates for a country.

You can also update the harmonize codes for multiple items quickly through the Update Harmonize Codes function; see Updating Harmonize Codes (UPHC).

Alphanumeric, 16 positions; optional.

Return/vendor

Indicates whether the item is eligible for return; informational only.

Valid values are:

• selected = The item is eligible for return

• unselected (default) = This item is not eligible for return

Country of origin

A code representing the country where the SKU originated. Used by the World Pack interface to determine duty for shipments to certain countries.

Country codes are defined in and validated against the Country table; see Setting Up the Country Table (WCTY).

Alphanumeric, 3 positions; optional.

L/S color (Long SKU color)

A code, typically used in a retail environment, that represents the color portion of the Long SKU code. Used for reporting purposes.

Numeric, 5 positions; optional.

L/S size (Long SKU size)

A code, typically used in a retail environment, that represents the size portion of the Long SKU code. Used for reporting purposes.

Numeric, 5 positions; optional.

L/S width (Long SKU width)

A code, typically used in a retail environment, that represents the width portion of the Long SKU code. Used for reporting purposes.

Numeric, 5 positions; optional.

User fields

There are 5 user-definable fields. You can define these fields according to your organization's specific requirements.

Alphanumeric, 10 positions (first 3 fields); 5 positions (last 2 fields); optional.

Offer (Offer code)

The code for the offer (catalog) in which the item appears. Validated against the Offer table. See Working with Offers (WOFR).

Alphanumeric, 3 positions; required.

Effective date

The date the price indicated becomes valid. This date should be on or later than the start date of the offer, and on or before the stop date of the offer. If you leave this field blank, the effective date of the offer defaults.

Numeric, 6 positions (in user date format); optional.

Sub page

Informational only. You can use this field to call an external program that creates an item alias outside of Order Management System. The system provides a “hook” to the program when you defines a sub page code on this screen or the Create Item/SKU Offer screen in Creating Item/SKU Offers (MISO). Once the program completes, Order Management System returns to normal processing. See Working with User Exit/Edit 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. You can establish multiple effective dates and prices for the same item/offer. If there are multiple effective dates and prices, the single-unit price with the latest date is displayed here, even if the date is in the future.

Note: Although you can enter a price in this field for a variable set item, the price is informational only; the system prices variable set items by the total price of the set’s components. See Entering Variable Set Information (WVST).

Alternate currency pricing: If the Use Alternate Currency Pricing (H89) system control value is selected, the Alt currency price field enables you to enter the price of the item 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.

The Price field on the Change Item Offer Screen is display-only if the Use Alternate Currency Pricing system control value is selected and a conversion rate is defined for the offer; if you want to update the item offer price you need to update the price in the Alternate currency price field.

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 the item will be sold in this offer to associate customers. Associate price is used when the Associate field on the order is selected (yes) and the order date is 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.

An error message indicates in order entry if an order is subject to VAT but no tax-inclusive price has been defined.

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.

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

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

Alt currency price

The price at which the item is sold in the alternate currency, if no discounts are applied, and the order date is on or after 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 the offer 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.

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.

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.

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 indicates that you defined a special handling price and the Special handling field is unselected:

Special handling price not allowed when not eligible.

If you specify a price here for a custom special handling code, it overrides any pricing defined for the custom special handling format; see Establishing Custom Special Handling Formats (WSHF).

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

Gift wrap

Indicates whether gift wrapping is available for this item. If the Gift Wrap Default (F07) system control value is selected, this field defaults to selected, although you can override it; otherwise, this field defaults to unselected.

• selected = This item can be gift wrapped.

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

G/W price (Gift wrap price)

The price in this offer for gift wrapping the item. The gift wrap field must be selected 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 amount here is multiplied by the quantity ordered. Used only if the Freight method field for the Source Code table is set to By Item or Flat Rt/Item.

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

Hidden freight

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.

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. Valid values are:

• selected = This is a sale item.

• unselected (default) = This is not a sale item.

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 when determining whether an order qualifies for a promotion. See the system control value for more information.

Volume discount

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

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

• unselected = The item/SKU is not eligible for the volume discount.

See Item Volume Discounting.

Coupon discount $ (Coupon discount dollars)

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 (in user date format); optional.

Feature/option

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:

• Feature = Item is the featured item in the depiction.

• Option = Item is an optional item in the depiction.

Optional.

Column pricing

Determines whether this item is eligible for column pricing discounts.

• selected = The item is eligible for column pricing discounts. You advance to an additional screen where you can define the effective date, quantity, price, associate price, and pricing column.

• unselected = The item is not eligible for column pricing discounts.

What is column pricing?

In customer maintenance, you can assign a customer to a pricing column. This means that the customer will be charged the column price, even if the customer does not order the number of units specified for the price break. If the customer orders more units than specified in the column assignment, the price break at the next level will be used on the order.

Example:

Quantity Price Assoc. Price Column

1 $100.00 $95.50 01

5 $ 90.00 $85.50 02

10 $ 80.00 $75.95 03

You can create as many price breaks as you like.

Pickup/new

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

Valid values are:

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

• New = Item is a new addition in this offer.

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

Clr/Size/Wdth

The SKU elements, such as color or size, that identify the item further.

Elements are defined in the System Control table and validated against the SKU Element (1,2,3) tables. An item does not require all 3 elements.

Alphanumeric, three 4-position fields; required.

Description (Unlabeled field to the right of the SKU field(s))

The description of the SKU element.

The system displays the SKU description in place of the SKU elements in order entry, order maintenance and standard and streamlined order inquiry if the Display SKU Description in place of SKU Element (F25) system control value is selected.

Alphanumeric, 40 positions; optional.

Second language description

Not currently implemented.

Alphanumeric, 40 positions; optional.

Sort sequence # (SKU sort sequence number)

The sequence number used to determine the order in which SKUs sort.

You can use the sort sequence to display SKUs in a different order, such as by size, rather than alphanumerically by SKU code. See SKU Sort Sequence Numbers for an overview.

Required if the Require Sort Sequence Number in the SKU File (F23) system control value is selected.

Numeric, 5 positions; required if the Require Sort Sequence Number system control value is selected.

Cost

The cost of the item. This cost defaults from the base item but may be overridden for the SKU being created.

Note: The Display Cost in Inventory (A38) secured feature controls the display of this field at the Change SKU 1 of 2 (With Overrides) and Create SKU 1 of 2 (With Overrides) screens.

Standard costing: The system does not calculate a new standard cost automatically. However, you can update the standard cost with the landed cost (primary vendor item price + vendor additional charges) through:

• Updating Standard Cost (MSCC) or the Update Standard Cost periodic function, or,

• Working with Vendor Items (WVNI) or the Work with Item/SKUs screen, available by selecting Vendor Item for an item or SKU at the Work with Items Screen. Only the vendor item cost associated with the item's primary vendor (appearing on the first Create/Change/Display Item screen) can update the item's standard cost.

Average costing: The system calculates a new average cost automatically during Purchase Order Receiving and updates this field with the new calculated cost.

The system uses the following calculation to determine the average cost:

(current on-hand x current average cost) + (quantity received x new purchase cost) / (quantity on-hand + quantity received) = new average cost

The new purchase cost represents the actual cost at which the item was purchased plus any overhead charges and additional item charges. See Purchase Order Receiving Overview.

For example:

current on-hand quantity = 185

current average cost = 25.00

quantity received = 25

new purchase cost = 28.75 (25.00 + 15% for commission)

(185 x 25.00) + (25 x 28.75) / (185 + 25) = 25.45 (new average cost)

FIFO costing: The cost stored here in the SKU table is updated similarly to the average cost, but is used only for reporting and inquiry, not for the actual costing of inventory transactions such as billing.

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

Short SKU

(Display screen only)

A unique number that the system assigns to all items and SKUs. You can see this number only on display screens, not on change or create screens. In Inventory Inquiry (DINI) see: Display SKU (Base Information) Screen (Non-SKU’ed Item) or Display SKU - 1 of 2 (With Overrides) Screen. In Work with Items (MITM) see: Display SKU (Base Information) screen or Display SKU screen.

When passing item/SKU information in the e-commerce interface, the system uses the short SKU number instead of the alphanumeric value in the SKU field. See Downloading E-Commerce Offer Files (EOFR).

Numeric, 7 positions; display-only.

Primary warehouse

A code that represents a warehouse where this item is stocked. The default warehouse code from the System Control table defaults here, but you can override it. Warehouse codes are defined in and validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; required.

Warehouse maximum

The SKU's recommended maximum number of units for the warehouse specified in the Warehouse field.

Numeric, 7 positions; optional.

Warehouse minimum

The SKU's recommended minimum number of units for the warehouse specified in the Warehouse field.

Numeric, 7 positions; optional.

Primary location

A code that represents an area within the warehouse that contains the item/SKU. Sometimes referred to as the “primary primary.” Validated against the Location table.

Typically, the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates:

Zone Aisle Shelf Bin

A 01 02 01

Note: When you assign a location code to a non-inventory item, the location code will print on the pick slip if you use one of the base pick slip printing programs; however, the non-inventory item will not be sorted correctly on the batch pull sheet.

Alphanumeric, 7 positions; optional.

Location maximum

The SKU's recommended maximum number of units to be stored in the primary pick location.

The primary pick location refers to the code in the Location field, displayed on this screen.

Numeric, 7 positions; optional.

Location minimum

The SKU's recommended minimum quantity to be stored in the primary pick location.

The primary pick location refers to the code in the Location field, displayed on this screen.

Numeric, 7 positions; optional.

Reserve qty. (SKU reserve limit exceed)

If the order quantity exceeds this amount, the system does not attempt to reserve the item when you enter the order, regardless of the setting of the Immediate Reservation (A64) system control value. You will need to use Working with Interactive Reservation (MIRV) to reserve the item on open orders.

Numeric, 7 positions; optional.

Zone reservation

A code assigned to weather-sensitive items/SKUs such as plant stock to insure that the items will ship to different regions of the country within time windows suited to the regions.

Items/SKUs processed through the zone reservation program will not be reserved during order entry; instead they will be reserved during pick generation, at an optimal time for shipping.

Zone reservation processing requires:

• The SKU must be assigned a zone reservation code

• The offer associated with the order must be assigned a season code

• The shipping address for the order must be assigned to a geographic zone

• For each zone reservation code, you must define zone date windows for all geographic zones in the country

Note: Items specified as Drop ship items are not eligible for zone reservation codes at the SKU level.

Note: If you have not set up the required values for zone reservation processing, a zone reservation coded item will follow standard order entry processing, except that if the item is backordered, it will not be reserved through the Evaluate Backorders process. You can reserve the item through Working with Interactive Reservation (MIRV).

See Shipping Zone Reservation Overview.

Alphanumeric, 4 positions; optional.

Coordinate group

A code that may be assigned to item/SKUs to ensure that certain item/SKUs ship together when ordered together. Item/SKUs with the same coordinate group code will ship together through the same shipper.

The coordinate group number assigned to an item/SKU will default in Order Entry when the item/SKU is ordered. You may override this assignment.

The system does not create a pre-generated pick for order lines that are assigned the same coordinate group number until all of the coordinate grouped lines are eligible for pick slip preparation.

When you use Processing Auto Soldout Cancellations (MASO) to sell out an item, you have the option of placing all related coordinate group items on hold.

Numeric, 3 positions; optional.

Item category

A code assigned to the SKU to classify and group like item/SKUs for use in the Item Relationships function. The Item Category is a level below the Item Class. For example, if the item class assignment is “Software Products,” the Item Category assignment might be “Word Processing Software” to subgroup and sort similar items. Validated against the Item Category table; see Working with Item Category Codes (WITG).

Numeric, 4 positions; optional.

Compatibility

A user-defined code assigned to an item/SKU. You can enter this code in the Item Relationships function to display a list of other compatible items or SKUs.

Example: You can assign a compatibility code of 01 to an IBM-compatible computer and to other items such as printers, network cards, etc.

Alphanumeric, 3 positions; optional.

2nd compatibility

Not currently implemented.

Alphanumeric, 3 positions; optional.

Sup B/O card (Suppress backorder card)

Indicates whether to produce a backorder card for the SKU. You might use this field to identify promotional items, free gifts, or catalogs, to prevent them from generating backorder cards or appearing on backorder lists.

Valid values are:

• Selected = Suppress normal backorder card generation for this item.

• Unselected = Do not suppress normal backorder card generation.

If the Unconditional Suppression of Backorder Card (F19) system control value is selected, suppressed SKUs will never appear on a backorder card. If this system control value is unselected, suppressed SKUs will appear only on the first backorder card for the order, and only if an unsuppressed item triggers the backorder card generation.

Pre-order

Indicates whether this is a pre-order item for which you can accept orders before you expect to have inventory to fulfill. The OCDSFA and PREORDER periodic functions, which are part of the Enterprise Order Integration (Future Receipts and Pre-Order Processing), set this flag and handle updates and orders for pre-order items that are fulfilled through the integration with Order Broker. Possible settings:

• selected = This is a pre-order item, and orders will be submitted to Order Broker as inventory becomes available.

• unselected = This is not a pre-order item.

This flag is unselected at item creation.

Display-only.

VAT exempt

Controls whether the SKU is exempt from VAT and tax-inclusive pricing. The SKU will still be subject to conventional tax, in which the tax amount accumulates in the Tax bucket, on any order subject to conventional tax rather than VAT.

Valid values are:

• Selected = This SKU is exempt form VAT and tax-inclusive pricing.

• Unselected = This SKU is subject to VAT and tax-inclusive pricing.

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

Hidden tax amt (Hidden tax amount)

The amount to include in the Hidden tax field for an item subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line.

You can define either a hidden tax amount or a percentage on this screen, but not both. If you do not define either, the SKU takes the VAT percentage defined for the customer's country.

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

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

Hidden tax pct (Hidden tax percentage)

The percentage to use when calculating hidden tax for an item subject to VAT. On orders subject to VAT and tax-inclusive pricing, tax does not accumulate in the Tax bucket for the order; instead, you charge a tax-inclusive price for items, and the tax is "hidden" on the order detail line.

You can define either a hidden tax amount or a percentage on this screen, but not both. If you do not define either, the SKU takes the VAT percentage defined for the customer's country.

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

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

Restrict

Indicates whether you can accept an order for this item/SKU in Order Entry and whether demand is captured.

• Selected = The operator cannot accept an order for this item/SKU.

• Unselected = The operator can accept an order for this item/SKU.

Note: If there were existing orders for this item before it became “restricted,” those orders are processed normally.

S/O control (Soldout control)

A code that represents how you determine when an item/SKU is soldout. If you leave this field blank, the item/SKU will never sellout automatically in Order Entry.

You define soldout control codes in the Soldout Control table with one of the three following statuses:

• Sellout the item/SKU immediately.

• Sellout the item/SKU when the quantity available is zero, not including open purchase orders.

• Sellout the item/SKU when the quantity available is equal to zero, including open purchase orders. (An item must be coded to sellout immediately in order to be picked up by Processing Auto Soldout Cancellations (MASO).)

You can define a Default Soldout Control Code (D72) in the System Control table to default automatically when you create items and SKUs; however, you can override this value.

See Working with Soldout Controls (WSLD).

If the Disregard Soldout Controls for Non-Allocatable Warehouses (J27) system control value is selected, the system disregards soldout control rules for items reserved against a non-allocatable warehouse. If the item cannot be reserved, the system backorders the item in the non-allocatable warehouse. See this system control value for more information.

Alphanumeric, 2 positions; optional.

Subscription

Indicates whether the item is a subscription item.

Valid values are:

• Selected = Item is a subscription item

• Unselected = Item is not a subscription item

If you identify an item as a subscription item, you must

• select the Non/inv (non- inventory) field to indicate that inventory levels are not maintained for the subscription item and that customer will be billed (the full price of the subscription) immediately through Express Billing.

• create a record for the subscription in the Item Subscriptions table to define the particulars of the subscription, such as the current issue number, length of subscription (number of intervals and number of days between issues).

See Working with Item Subscriptions (WISB).

Low price

The lowest recommended sale price for the item/SKU; however, the item/SKU can be sold at a lower price. No messages are displayed in Order Entry.

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

List price

The system uses this price:

• When you process item to item transfers (inventory transaction code = G). The list price of the source and target items must be identical, or the system will not allow you to process the transfer. If you are changing the quantity as part of the transfer, the system will confirm that the list price of the source item is the same as the list price of the target item based on the target item's quantity. For example, if the target item will constitute a set of three of the source item, the list price of the target item should be three times the list price of the source item.

• As the initial price of an item during customer price group line level pricing if the Price Type for the selected customer price group is Regular; see Working with Customer Price Groups (WCPG).

Numeric, 7 positions with a 2-place decimal; optional (required if you process an item to item transfer).

Reference # (Reference number)

Represents the retail reference or alternate product number. You can use this value to cross-reference an item/SKU to an external system, such as through the Generic Inventory Transaction Upload or the Generic Order Interface (Order API).

The retail reference number is set to the same value as the item code when you create items through Importing Enterprise Foundation Data through Omnichannel Cloud Data Service (OCDS), and the number should not be changed.

This number is also used for the Integration with the Sales Audit Module of the Oracle Retail Merchandising Foundation Cloud Service.

Numeric, 15 positions; optional.

Orig retail $

The original price of the item at the retail store.

The system uses this price as the initial price of an item during customer price group line level pricing if the Price Type for the selected customer price group is Original; see Working with Customer Price Groups (WCPG).

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

Projected returns

The number of units you expect to receive in returns for the item. The system uses this quantity when determining whether to sell out an item in order entry or maintenance if the item has a soldout control status of 2 (include on-order quantity in soldout calculation). The system backorders the projected return total plus the on-order quantity on unreceived purchase orders before selling out the item. For example, if you had 0 units on-hand, 10 units on an open purchase order, and entered 10 in this field, the system would backorder the first 20 units you entered in order entry, and sell out any units ordered after that.

Automatic field update: When a return is processed, the system automatically subtracts the number of units returned from the number you initially entered in the Projected returns field. The number in this field will never be less than 0, however. For example, if you initially entered 10 in this field, and 11 units of this item are returned, the Projected returns field will show a value of 0.

Note: Updating this field does not affect any orders already entered.

See Working with Soldout Controls (WSLD) for more information on working with soldout control codes and how they work with projected return quantities.

Numeric, 7 positions; optional.

Harmonize (Harmonize code)

A code that prints on customs documents for international shipments.

If you charge duty on international orders, you use this field to define the item's duty rate. The system compares this value with the duty rates defined for the country on the shipping address, and adds a duty charge to the order if it finds a match. See Setting Up the Country Table (WCTY) for more information on defining duty rates for a country.

You can also update the harmonize codes for multiple items quickly through the Update Harmonize Codes function; see Updating Harmonize Codes (UPHC).

Alphanumeric, 16 positions; optional.

Return/vendor

Indicates whether the item is eligible for return; informational only.

Valid values are:

• Selected = The item is eligible for return

• Unselected (default) = This item is not eligible for return

Prep code

A code used to indicate any special preparation or handling required for the SKU. Informational only.

Alphanumeric, 2 positions; optional.

Country of origin

A code representing the country where the SKU originated. Used by the World Pack interface to determine duty for shipments to certain countries.

Country codes are defined in and validated against the Country table; see Setting Up the Country Table (WCTY).

Alphanumeric, 3 positions; optional.

User fields

There are 5 user-definable fields. You can define these fields according to your organization's specific requirements.

Alphanumeric, 10 positions (first 3 fields) 5 positions (last 2 positions); optional.

Description (Unlabeled field to the right of the SKU field(s))

The description of the SKU element.

The system displays the SKU description in place of the SKU elements in order entry, order maintenance and standard and streamlined order inquiry if the Display SKU Description in place of SKU Element (F25) system control value is selected.

Alphanumeric, 40 positions; optional.

Second language description

Not currently implemented.

Alphanumeric, 40 positions; display-only.

L/S class (Long SKU class)

A code you can use to group items into classes for reporting purposes. If you defined a L/S class for the base item it defaults here, but you can override it. Long SKU classes are defined in and validated against the Long SKU Class table; see Working with Long SKU Classes (WLSC).

Retail Integration (external system to Order Management System)

If the Use Retail Integration (H26) system control value is selected, long SKU classes are linked to long SKU departments and are called retail classes. Retail classes are department specific whereas regular long SKU classes are unique and remain constant across departments. For this reason, when the Use Retail Integration (H26) system control value is selected, you can only enter a retail class in this field that is assigned to the base item’s long SKU department. If you enter a long SKU class that is not linked to the base item’s long SKU department, the system will not let you proceed and displays an error message: L/S Class (xxxx) was not found in L/S Department (xx).

Since retail classes are department specific, if you prompt (click on the arrow) in this field before entering a long SKU department, an error message indicates: L/S Department required to prompt on L/S Class.

Retail classes are defined in and validated against the Retail Class table; see the Work with Retail Class Screen for more information.

Note: When the Use Retail Integration (H26) system control value is selected, the system populates and validates against the Retail Class table instead of the Long SKU Class table; therefore, you cannot access Working with Long SKU Classes (WLSC).

Secured Feature

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Numeric, 4 positions; optional.

L/S vendor (Long SKU vendor)

A user-defined field that you can use for tracking and queries. If you defined a L/S vendor for the base item it defaults here, but you can override it. Long SKU vendors are defined in the SKU table, but are not validated.

Secured Feature

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Alphanumeric, 7 positions; optional.

L/S style (Long SKU style)

A user-defined field that you can use for tracking and queries. If you defined a L/S style for the base item it defaults here, but you can override it. Long SKU styles are defined the SKU table, but are not validated.

Required if the Require L/S Style (I94) system control value is selected. In addition, the system validates that the value you enter is not assigned to another item/SKU.

Secured Feature

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Alphanumeric, 20 positions; optional.

L/S color (Long SKU color)

A code, typically used in a retail environment, that represents the color portion of the Long SKU code. Used for reporting purposes.

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Numeric, 5 positions; optional.

L/S size (Long SKU size)

A code, typically used in a retail environment, that represents the size portion of the Long SKU code. Used for reporting purposes.

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Numeric, 5 positions; optional.

L/S width (Long SKU width)

A code, typically used in a retail environment, that represents the width portion of the Long SKU code. Used for reporting purposes.

If you do not have authority to the Maintain Long SKU Values in MITM (B05) secured feature, you cannot enter or change this value.

Numeric, 5 positions; optional.

L/S Subclass

A user-defined field that you can use for tracking and queries. Long SKU subclass can also be defined in the SKU table but is not validated.

Displayed only if the Use Retail Integration (H26) system control value is selected.

Secured Feature

If you do not have authority under the Maintain Long SKU Values in MITM (B05) secured feature, you can not enter or change this value.

Numeric, 4 positions; optional.

Carton

The type of carton in which this item must ship.

If a carton ID exists, the system passes this information to TanData when confirming the item for shipment. This information is used to calculate best way shipping, which determines the lowest price to ship the carton.

Numeric, 2 positions; optional.

Height

The height measurement for an item/SKU. The Height, Length, and Width values are used to determine the cubic volume of an item/SKU. You can enter the height in feet or centimeters, or any other measurement as long as it is consistent. Used in Suggest Location Placement (MSLO) when evaluating whether an item/SKU can be stored in a particular location.

Numeric, 3 positions; optional.

Length

The length measurement for an item/SKU. The Height, Length, and Width values are used to determine the cubic volume of an item/SKU. You can enter this value in feet or centimeters, or any other measurement as long as it is consistent. Suggest Location Placement (MSLO) uses this value when evaluating whether an item can be stored in a particular location.

Numeric, 5 positions; optional.

Width

The width measurement for an item/SKU. The Height, Length, and Width values are used to determine the cubic volume of an item/SKU. You can enter this value in feet or centimeters, or any other measurement as long as it is consistent. Suggest Location Placement (MSLO) uses this value when evaluating whether an item can be stored in a particular location.

Numeric, 5 positions; optional.

Ship weight

The actual shipping weight of the item/SKU. The system may use this value to calculate carton weights and to determine your shipping charges if you perform manual confirmation and use cubing.

The system uses the shipping weight of an item to create item weight records in the Download Extended Manifest table (FLMNDE) when you use a PC Manifest system to confirm shipments.

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

Sell weight

The system uses this value to calculate the freight charge on a SKU when the Freight method on the order is set to By Item or Flat Rt/Item.Overrides the selling weight, if any, defined at the base item level.

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

Last purchase cost

The cost of the item from the most recent purchase order, including any discounts, surcharges, or additional charges. The system uses this cost to determine:

• the unit price for a purchase order if there is no vendor item price.

• the cost to use for FIFO cost layers when you initially convert to FIFO costing; see FIFO Costing Overview.

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

Cube factor

The cubic volume of the SKU, which overrides the cubic volume defined at the base item level. Controls the number of units of this item that can fit into a carton. The system compares the cube factor against the Cube field from the System Control table, which defines a default box size. See Setting Up Fulfillment Values.

Example: If the Cube field value in the System Control table is 100 and the Cube factor for an item is 25, then 4 of this item can fit into one box. The Cube Factor determines the number of picks required to ship an order.

Numeric, 3 positions; optional.

Unit/measure

A standard by which an item/SKU is sold.

Typical units of measure include:

• EA = each

• IN = inches

• C12 = case of 12

Validated against the Unit of Measure table (see Working with Units of Measure (WUOM)) and will default from the Default Item Unit of Measure (B33) system control value, if a value is specified.

Alphanumeric, 3 positions; optional.

Status

A code that represents a SKU's status, such as obsolete, discontinued, sold out, etc. This information is used for inventory reporting purposes only. The status defined at the SKU level overrides the status defined at the base item level; however, even if the status matches the Item Status for Suppressing Item During Item Selection (L21), the SKU-level status does not prevent the Item Selection screen from displaying the item. See Working with Item Status (WIST).

Alphanumeric, 1 position; optional.

Offer (Offer code)

The code for the offer (catalog) in which the item/SKU appears. Validated against the Offer table. See Working with Offers (WOFR).

Alphanumeric, 3 positions; required (if other information is entered).

Effective date

The date the price becomes valid. This date should be on or after the start date of the offer, and on or before the stop date of the offer.

The Effective date and Price are stored in the SKU Price table rather than the SKU Offer table. If you do not specify an Effective date and Price when you create a SKU Offer record, the system automatically creates a SKU Price record using the single-unit price from the Item Price table with the latest Effective date. If the latest Effective date from the Item Offer table is in the future, then the SKU Price record also has this future Effective date.

Numeric, 6 positions (in user date format); optional.

Price

The price at which the SKU will sell in this offer if no discounts are applied, and the order date is on or after the Effective date. If you leave this field blank, the single-unit offer price with the latest Effective date defaults. You can specify multiple Effective dates and prices for an item or SKU in an 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 Alt 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.

The Price field on the Change Item Offer Screen is display-only if the Use Alternate Currency Pricing system control value is selected and a conversion rate is defined for the offer; if you want to update the item offer price you need to update the price in the Alternate currency price field.

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

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

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 selected (yes) and the order date is 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 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.

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

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 on or after 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 the offer is not associated with a currency code, indicating the offer is in the local currency, an error message indicates that you entered a price in the Alternate currency price field: No conversion rate for offer.

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.

Special handling

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

• selected = This SKU is eligible for special handling.

• unselected = This SKU 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 a SKU 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 SKU 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 SKU; however, you can still advance to the special handling screen by selecting Special Handling for the SKU.

See Special Handling Overview for more information.

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 indicates that you defined a special handling price and the Special handling field is unselected:

Special handling price not allowed when not eligible.

If you specify a price here for a custom special handling code, it overrides any pricing defined for the custom special handling format; see Establishing Custom Special Handling Formats (WSHF).

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

The system validates that the additional charge code has a special handling 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 selected: the system adds the special handling code and charge to the SKU 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 SKU; however, you can still advance to the special handling screen by selecting Special Handling for the SKU.

See Special Handling Overview for more information.

Alphanumeric, 2 positions; optional.

Gift wrap

Indicates whether this SKU is eligible for gift wrap. If the Gift Wrap Default (F07) system control value is selected, this field defaults to selected, although you can override it; otherwise, this field defaults to unselected.

• selected = The item/SKU can be gift wrapped.

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

G/W price (Gift wrap price)

The price for gift wrapping the item. The G/W field must be selected. The gift wrap price will be charged for each unit of this SKU that is gift wrapped.

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

Freight

The freight amount to be charged for this item/SKU. Multiplied by the quantity ordered to determine the freight charge for this item.Used only if the Freight method field for the Source Code table is set to By Item or Flat Rt/Item.

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

Hidden freight

Used only with item/SKU 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/SKU is very high. The hidden freight charge is included in the price of the item/SKU so the actual freight charge is not visible to the customer.

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.

Valid values are:

• selected = This is a sale item.

• unselected (default) = This is not a sale item.

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 when determining whether an order qualifies for a promotion. See the system control value for more information.

Volume discount

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

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

• unselected = The item/SKU is not eligible for the volume discount.

See Item Volume Discounting.

Coupon discount $

Represents the amount that is subtracted from the price when the SKU 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., the date it expires).

Numeric, 6 positions (in user date format); optional.

Feature/option

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:

• Feature = Item is the featured item in the depiction

• Option = Item is an optional item in the depiction

Optional.

Column pricing

Determines whether this item/SKU is eligible for column pricing discounts.

• selected = The item/SKU is eligible for column pricing discounts. You will advance to an additional screen where you may define the effective date, quantity, price, associate price, and pricing column.

• unselected = The item is not eligible for column pricing discounts.

What is column pricing?

In the Customer table, you may assign a customer to a pricing column. This means that the customer will be charged the column price, even if the customer does not order the number of units specified for the price break. If the customer orders more units than specified in the column assignment, the price break at the next level will be used on the order.

Example:

Quantity Price Assoc. Price Column

1 $100.00 $95.50 01

5 $ 90.00 $85.50 02

10 $ 80.00 $75.95 03

Pickup/new

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

Valid values are:

• Pickup = Item is a pickup item, previously sold in an offer

• New = Item is a new addition to your offer

Optional.

Warranty

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

Valid values are:

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

• unselected = The item/SKU 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.

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.