Item

The code and description of the item for which you are generating SKUs.

Alphanumeric, 12 positions (item code) 30 positions (description); display-only.

SKU group

If you have assigned the item to a SKU group in the Item file, the group appears here and is display-only; the associated SKU elements appear on the screen. Otherwise, you can enter a valid SKU group to default the related SKU elements.

Note: Enter the SKU group before entering any SKU values, or the system will clear your SKU value entries when it defaults the values from the SKU group.

SKU groups are defined in and validated against the SKU Group file; see Working with SKU Groups (WISG).

Numeric, 3 positions; optional or display-only.

Drop ship

The setting of the drop ship flag for the SKUs you wish to create.

You can flag an item as drop ship at the item level and SKU level. The setting at the SKU level overrides the setting at the item level. If the setting at the SKU level is blank, the system uses the setting at the item level.

Valid values:

Y = Drop ship SKU. When a customer orders the SKU, you order the SKU from your vendor and the vendor ships it directly to your customer. You can only flag a SKU as drop ship if the Drop ship flag at the item level is Y.

N = Non-drop ship SKU. You ship the SKU from your warehouse.You can flag a SKU as non-drop ship if the Drop ship flag at the item level is Y, N or blank.

Blank = The drop ship setting has not been defined at the SKU level; instead, the system uses the drop ship setting defined at the item level to determine if the SKU is a drop ship item.

Drop ship reservation: 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 drip ship processing. See Processing Drop Ship Orders by Batch (MDSB).

Alphanumeric, 1 position; optional.

SKU default cost

The cost of the SKU. The default cost you entered when you created the item defaults here, but you can override it here or for individual SKUs. Overriding the cost here does not update the default cost for the item.

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

Original retail price

The original price of the item at the retail store.

Enter the original retail price of the item if you are using retail price change processing. Retail price change processing allows you to keep merchandise prices in CWDirect in sync with merchandise prices at your retail store.

If you leave this field blank, the system updates this field with the retail price defined for the first retail price change record associated with this item that you upload into the RI Price Change History Detail; see Retail Price Change Update Process.

See RI Overview.

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

List price

The price at which manufacturers recommend retailers sell a product.

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.

The STS Sales Interface uses this field to identify the STS subcode for price. See System Operations Using the STS Sales Interface (WSTS).

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

Create vendor items

Defines whether you want to create vendor items. Valid values are:

Y = Create vendor items for each SKU you create. The vendor item code defaults on the Work with SKU Generator Screen as described below under Item.

• If the Default SKU generator vendor item system control value is set to Y: The system defaults the SKU information to the vendor item code field. Typically, you would default this information if your company's SKU codes are the same as your vendor's SKU codes. Having the system create the vendor item codes can save you data entry. You can override the vendor item codes if necessary.

• If the Default SKU generator vendor item system control value is set to N: You will need to edit the vendor item codes for the SKUs so that they are each unique, or the system will display an error message.

N = Do not create vendor items. The vendor item information is display-only on the Work with SKU Generator Screen. You should not complete any of the vendor-related fields described below.

blank = You can enter the vendor item code on the Work with SKU Generator screen. Any other vendor information you complete on the current screen defaults on the Work with SKU Generator Screen, but you can override it.

See Working with Vendor Items (WVNI).

Alphanumeric, 1 position; optional.

Vendor

The code used to identify the vendor. Vendor codes are defined in and validated against the Vendor file. The vendor you assigned to the item, if any, defaults. Enter a vendor code only if you are creating vendor items.

See Working with Vendors (WVEN).

Numeric, 7 positions; optional (required if you are creating vendor items).

Vendor name

The name of the vendor.

Alphanumeric, 30 positions; display-only.

Item

The vendor's item code. The same item code will be used for all the SKUs you create, unless you change the vendor item code on the Work with SKU Generator Screen. If the Default SKU Generator Vendor Item (C61) system control value is set to Y, and you enter an item here, the system appends the SKU information to your entry in this field to compose the vendor item code.

Alphanumeric, 20 positions; optional.

Desc (Description)

The vendor's description of the item.

Alphanumeric, 30 positions; optional (required if creating vendor items).

Price

The vendor's price for the item. When you enter a purchase order, this price defaults.

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

Lead days

The number of days it takes a vendor to deliver this item when you place a purchase order. The system adds the lead days to the current date to determine the due date for an item on a purchase order.

Numeric, 3 positions; optional.

U/M (Unit of measure)

A standard by which a vendor's item is sold. Typical units of measure include:

EA - each

IN - inch

C12 - case of 12

Unit of measure is defined in and validated against the Unit of Measure file. See Working with Units of Measure (WUOM).

Alphanumeric, 3 positions; optional.

Duty (Duty percent)

The percentage of duty or tariff charges applicable to foreign orders.

Update vendor item additional charge: The system creates an additional charge for each vendor item, using the first purchase order additional charge code whose type is D (duty). If there is no duty additional charge code defined in your company, the system creates a blank additional charge for the vendor item. See Working With PO Additional Charges (WPAC), and Working with Vendor Items (WVNI).

Calculate receiving cost: When you enter or receive purchase orders, the system uses this percentage to calculate the amount of duty that applies to the item. This duty percentage will not be visible when you review the purchase order in purchase order inquiry; however, it will be added to the last purchase cost in the SKU file and the cost that passes to A/P if you use A/P-PO matching; also, it will be factored into the average cost and weighted average FIFO cost in the SKU file. See Warehousing Purchase Order Receiving Overview.

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

Color/style/size (SKU elements)

Use these three levels to define the elements to create the various SKU combinations. You can enter up to 30 different elements for each type. If the item is assigned to a SKU group, or if you entered a SKU group at this screen, the SKUs for the group default; however, you can override these defaults.

SKU elements are validated against the SKU Element 1, 2, and 3 files (fast paths = WSK1, WSK2, WSK3). If you enter a SKU element that has not been created, the following error message displays:

SKU Element (xxxx) does not exist.

See Working with SKU Elements (WSK1, WSK2, WSK3).

Note: No error message displays if you enter the same SKU element value more than once; however, the system still creates the SKU combinations normally, without duplicates.

Alphanumeric, thirty 4-position fields for each element; required.

Item

The code and description of the item.

Alphanumeric, 12 positions (item code) 30 positions (description); display-only.

Vendor

The numeric code that identifies the supplier of an item.

Numeric, 7 positions; display-only.

Default cost

The default cost of the item from the previous screen.

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

Create vendor items

This field displays regardless of your entry in the Create vendor items field on the previous screen. Valid values are:

Y = Create vendor items.

N = Do not create vendor items. The related fields are not enterable.

blank = The vendor item-related fields are enterable on the screen.

Note: The system does not create the vendor items when you accept your entries.

Your entry on the previous screen defaults. Enter a new value to change whether the vendor item-related fields are enterable.

Alphanumeric, 1 position; optional.

Vendor item

The vendor's item code. Your entry at the SKU Generator Screen (Entering SKU Information) defaults.

If the Default SKU generator vendor item system control value is set to Y: The SKU information appears after the defaulted vendor item code. The SKU information appears by itself if you didn't enter a vendor item at the SKU Generator Screen (Entering SKU Information).

If the Default SKU generator vendor item system control value is set to N or is blank: This field is blank if you are not creating vendor items, or if you did not enter a vendor item code at the SKU Generator Screen (Entering SKU Information).

Alphanumeric, 20 positions; optional.

Description

The vendor's description of the item, defaulted from the SKU Generator Screen (Entering SKU Information). You can override this information.

Alphanumeric, 30 positions; optional.

Price

The vendor's price for the item, defaulted from the SKU Generator Screen (Entering SKU Information). You can override this information.

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

L/D (Lead days)

The number of days it takes a vendor to deliver this item when it is ordered through a purchase order. This value is added to the current date to determine the due date on a purchase order detail line.

This value defaults from the SKU Generator Screen (Entering SKU Information). You can override this information.

Numeric, 3 positions; optional.

U/M (Unit of measure)

A standard by which a vendor's item is sold. Typical units of measure include:

EA - each

IN - inch

C12 - case of 12

Unit of measure is validated against the Unit of Measure file.

This value defaults from the SKU Generator Screen (Entering SKU Information). You can override this information.

Alphanumeric, 3 positions; optional.

Duty (Duty percent)

The percentage of duty or tariff charges applicable to foreign orders. You can override this information.

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

SKU description

The SKU description.

Alphanumeric, 40 positions; optional.

SKU

The specific SKU elements.

Alphanumeric, three 4-position fields; display-only.

Sort seq. (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.

This field is required if the Require Sort Sequence Number in the SKU File (F23) system control value is set to Y.

The system automatically assigns a SKU sort sequence number if the Auto Assign Sort Sequence Number During SKU Generation (F24) system control value is set to Y. If this system control value is set to Y, this field does not display.

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

Cost

The cost of the SKU, defaulted from the Item file. You can override this value.

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

Delete

Defines whether you wish to delete this SKU. Valid values are:

Y = Delete this SKU.

N (or blank) = Do not delete this SKU; the SKU generator should create it.

This field defaults to Y if you are using a SKU group, and you flagged the SKU combination for exclusion. See Working with SKU Groups (WISG).

Alphanumeric, 1 position; optional.

L/S class (Long SKU class)

A code you can assign to SKUs for tracking and reporting purposes. The long SKU class you assigned to the base item defaults.

If the Use Retail Integration (H26) system control value is set to Y, 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 set to Y, you can only enter a retail class in this field that is assigned to the long SKU department of the base item. If you enter a long SKU class that is not linked to the long SKU department, the system will not let you proceed and displays the following error message:

L/S Class (xxxx) was not found in L/S Department (xx).

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

Long SKU classes are defined in and validated against the Long SKU Class file; see Working with Long SKU Classes (WLSC).

Note: When the Use Retail Integration (H26) system control value is set to Y, you can not access the Work with Long SKU Class menu option or the WLSC fast path.

Numeric, 5 positions; optional.

L/S vendor (Long SKU vendor)

A code you can assign to SKUs for tracking and reporting purposes. The long SKU vendor you assigned to the item defaults.

Long SKU vendor codes are defined in the SKU file but are not validated in CWDirect.

Alphanumeric, 7 positions; optional.

L/S style (Long SKU style)

A code you can assign to SKUs for tracking and reporting purposes. Long SKU style is also used by external systems to identify the item.

If the Default SKU Generator L/S Style (J04) system control value is set to Y, the SKU generator automatically creates a Long SKU style for each SKU.

• If a long SKU style code is defined for the base item, the system creates a long SKU style code for each SKU using the base long SKU style code + SKU code.

• If a long SKU style code is not defined for the base item, the system creates a long SKU style code for each SKU using the item code + SKU code.

Note: The Long SKU style field is 20 positions. If the generated long SKU style code is greater than 20 positions, the system will truncate the value to 20 positions.

If the Default SKU Generator L/S Style (J04) system control value is set to N and the Require L/S Style (I94) system control value is set to N, the system defaults the long sku style code defined for the base item to this field.

This field is required if the Require L/S Style (I94) system control value is set to Y: L/S Style Required. Additionally, the system validates that the value you enter is not assigned to another item or SKU: L/S Style is a duplicate.

Long SKU style codes are defined in the SKU file but are not validated in CWDirect.

Numeric, 20 positions; optional.

Original retail price

The original price of the SKU at the retail store.

Enter the original retail price of the SKU if you are using retail integration (external system to CWDirect) price change processing. Retail price change processing allows you to keep merchandise prices at your retail store in sync with merchandise prices in CWDirect.

If you leave this field blank, the system updates this field with the retail price defined for the first retail price change record associated with this SKU that you upload into the RI Price Change History Detail and RI Price Change History Summary files; see Retail Price Change Update Process.

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

List price

The price at which manufacturers recommend retailers sell a product.

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.

The STS Sales Interface uses this field to identify the STS subcode for price. See Using the STS Sales Interface (WSTS).

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

Drop ship

The setting of the drop ship flag for the SKU you wish to create.

You can flag an item as drop ship at the item level and SKU level. The setting at the SKU level overrides the setting at the item level. If the setting at the SKU level is blank, the system uses the setting at the item level.

Valid values:

Y = Drop ship SKU. When a customer orders the SKU, you order the SKU from your vendor and the vendor ships it directly to your customer. You can only flag a SKU as drop ship if the Drop ship flag at the item level is Y.

N = Non-drop ship SKU. You ship the SKU from your warehouse.You can flag a SKU as non-drop ship if the Drop ship flag at the item level is Y, N or blank.

Blank = The drop ship setting has not been defined at the SKU level; instead, the system uses the drop ship setting defined at the item level to determine if the SKU is a drop ship item.

Drop ship reservation: 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 drip ship processing. See Processing Drop Ship Orders by Batch (MDSB).

Alphanumeric, 1 position; optional.

Item

The code and description of the base item for which you are creating SKUs.

Alphanumeric, 12 positions (item code) 30 positions (description); display-only.

U/M (Unit of measure)

A standard by which a vendor's item is sold. Typical units of measure include:

EA - each

IN - inch

C12 - case of 12

If you leave this field blank, the unit of measure defined for the base item defaults for the SKUs.

Unit of measure is validated against the Unit of Measure file. See Working with Units of Measure (WUOM).

Alphanumeric, 3 positions; optional.

Itm category (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. See Working with Item Category Codes (WITG).

Numeric, 4 positions; optional.

Compatibility

A code assigned to an item or SKU which you can use in the Item Relationships function to display a list of other compatible items.

Example:

Item PC1 represents an IBM PC. You can assign a compatibility code of 01 (IBM Products) to this item and to other IBM items such as printers, tape drives, etc.

Numeric, 3 positions; optional.

Prep code

A code used to indicate any special preparation or handling required for the SKU. This field is informational only.

Prep codes are defined in and validated against the Prep Code file. See Working with Prep Codes (WPRC).

Alphanumeric, 2 positions; optional.

Return/vendor

This field indicates whether the SKU can be returned; informational only.

Valid values are:

Y = This SKU is returnable.

N = This SKU is not returnable.

Alphanumeric, 1 position; required.

Country of origin

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

Country codes are defined in and validated against the Country file; see Customer Service Setting Up the Country File (WCTY).

Alphanumeric, 3 positions; optional.

S/O control (Soldout control)

This code, defined in the Soldout Control file, indicates when the item is considered sold out. An item can be sold out:

• immediately

• when the available quantity equals zero

• when the available quantity plus any quantity due on purchase orders equals zero.

If you have specified a Default Soldout Control Code (D72) it defaults here, but you can override it.

If the Disregard Soldout Controls for Non-Allocatable Warehouses (J27) system control value is set to Y, 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 Customer Service Working with Soldout Controls (WSLD) for more information on working with soldout controls.

Alphanumeric, 2 positions; optional.

Sup B/O card (Suppress backorder card)

This field indicates whether to produce a backorder card for the SKUs. 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:

Y = Suppress normal backorder card generation for this item.

N or blank = Do not suppress normal backorder card generation.

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

Alphanumeric, 1 position; optional.

Zone reservation code

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

Zone reservation coded items/SKUs will not be reserved during order entry; instead they will be assigned a backorder status of Z (Zoned reservation), and will be reserved during pick generation using the batch reservation function, at an optimal time for shipping.

Zone reservation logic requires:

• The item/SKU must be assigned a zone reservation code. For SKU’ed items, the zone reservation code must be assigned at the SKU level.

• 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, using either the postal ZIP code of the ship to address, or the SCF (Sectional Center Facility) code of the ship to address. The SCF code consists of the first three digits of the ZIP code.

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

See Fulfillment Creating and Maintaining Geographic Zones (WGZN).

Drop ship items: Drop ship items are not eligible for zone reservation. If a SKU is flagged as drop ship and you try to assign a zone reservation code to the SKUs you are generating, the system displays the following error message: SKU not eligible for zone reservation code.

Alphanumeric, 4 positions; optional.

Warehouse

A code that represents the warehouse where you will keep the SKU. The default warehouse defined in the System Control file defaults.

Warehouse codes are validated against the Warehouse file. See Warehousing Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; required.

Whs max (Warehouse maximum)

The recommended maximum quantity of the SKU to keep in the warehouse. The Replenish Warehouses program uses this value.

Numeric, 7 positions; optional.

Whs min (Warehouse minimum)

The recommended minimum quantity of the SKU to keep in the warehouse. The Replenish Warehouses program uses this value.

Numeric, 7 positions; optional.

Allocation freeze

Indicates whether reservations can be performed against the SKU in the specified warehouse.

Y = The SKU is on hold for item reservation. All other inventory transactions are allowed.

N or blank = The SKU is not on hold for item reservation.

Alphanumeric, 1 position; required.

Protected Quantity

An amount of inventory that is not reserved automatically for this SKU. You can reserve the protected quantity through Working with Interactive Reservation (MIRV) only, as in the case of large wholesale orders or preferred mail order customers. Protected quantity is included in on-hand quantity.

Numeric, 7 positions; optional.

Reorder qty (Reorder quantity)

The quantity of this SKU that should be ordered when the on-hand quantity reaches the minimum defined in the Min Qty field. The Replenish Warehouses program uses this value.

Numeric, 7 positions; optional.

Location

The default location in the warehouse where the item is kept. This location is sometimes referred to as the “primary primary.”The “primary primary” location is stored in the Primary loc (Primary location) field in the SKU file.

Alphanumeric, 7 positions; optional.

Loc max (Location maximum)

The maximum quantity of the item to keep in this location. Replenish Primary Locations uses this value.

Numeric, 7 positions; optional.

Loc min (Location maximum)

The minimum quantity of the item to keep in this location. Replenish Primary Locations uses this value.

Numeric, 7 positions; optional.

Freeze flag

This field indicates whether to generate pick slips and process replenishment requests for this item location. Valid values are:

Y = This item location is available for pick slips and replenishment requests.

N or blank = This item location is not available for pick slips and replenishment requests

Alphanumeric, 1 position; optional (required if you specify a location).

Restrict

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

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

N or blank = The operator can accept an order for this item/SKU.

Alphanumeric, 1 position; optional.