Performing Initial Item Entry (MITM)
Items are units of inventory that are defined to the system by item codes. The item code consists of the code itself and, optionally, a SKU, which allows you to define the item further by characteristics such as color, size, etc.
You can use the Work with Items/SKUs function not only to work with the item and/or SKU, but also supporting information such as item codes, offer and warehouse, and item keywords. See Working with Existing Items (MITM) for an overview.
Copying items: Copying items allows you to:
- Copy item information from one item to a new item in the same company using the Copy Item Window.
- Add, change or delete item information, for an item with the same item number as the copied item, in one or more shared companies using the Copy Item to Company Window.
See Copying Items for an overview.
In this topic:
- Select Items Screen
- Creating Items Screen Flow
- Creating Non-SKU’ed Items Screen Flow
- Creating SKU'ed Items Screen Flow
- Create Item Screen
- Create Item (Base Information) Screen
- Create Item Offer Screen
- Create SKU 1 of 2 (With Overrides) Screen
- Create SKU 2 of 2 (With Overrides) Screen
- Create SKU Offer Screen
Select Items Screen
Purpose: Use this screen to select an item to work with or review. You can also select an item directly by entering a valid item code in the Item field.
How to display this screen: Enter MITM in the Fast path field at the top of any menu or select Work with Items/SKUs from a menu.
Field | Description |
---|---|
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. |
Screen Option | Procedure |
---|---|
Create an item |
Select Create to advance to the Create Item Screen. |
Advance to a menu option related to item maintenance |
Select Supporting Files to advance to the Item Support File Maintenance window. Options at this window are:
|
Creating Items Screen Flow
Purpose: Select Create at the Select Items Screen or the Work with Items Screen to add an item.
The screen flow varies, depending on whether you are creating a non-SKU’ed item or SKU’ed item.
Additionally, the Item Creation Values (J08) umbrella system control value includes values that control the screen flow when you are creating an item.
Creating Non-SKU’ed Items Screen Flow
Deselect the SKUs field on the Create Item Screen to create a non-SKU’ed item. The system automatically advances you through the following screens to create a non-SKU’ed item.
- Create Item Screen
- Create Item (Base Information) Screen
- Create Vendor Item Screen (only if the Auto Advance to Vendor Item Create (E78) system control value is selected)
- First Work with Keywords for Item Screen (only if the Create Keywords at Item Entry (F78) system control value is selected)
- Create Item Offer Screen (only if the Auto Advance to Item Offer (J05) system control value is selected)
Once you have completed creating the item, the system returns you to the Create Item Screen where you can create another item.
Non-SKU’ed item screen flow:
Creating SKU'ed Items Screen Flow
Select the SKUs field on the Create Item Screen to create a SKU’ed item. The system automatically advances you through the following screens to create a SKU’ed item.
# | Step |
---|---|
1. |
|
2. |
First Work with Keywords for Item Screen (only if the Create Keywords at Item Entry (F78) system control value is selected) |
3. |
Create Item Offer Screen (only if the Auto Advance to Item Offer (J05) system control value is selected) |
4. |
Depending on whether you are using the SKU Generator:
|
6. |
Depending on whether you are using the SKU Generator:
|
7. |
Depending on whether you are using the SKU Generator:
|
Once you have completed creating the item and SKU, you return to the:
- Create SKU 1 of 2 (With Overrides) Screen if you are not using the SKU Generator, where you can create another SKU.
- Create Item Screen if you are using the SKU Generator, where you can create another item.
SKU’ed item screen flow:
Create Item Screen
How to display this screen: Select Create at the Select Items Screen or the Work with Items Screen.
Field | Description |
---|---|
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.
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:
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:
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 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, 13 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:
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:
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:
Order is not eligible for deferred/installment billing plan.
|
Membership |
Indicates that the item represents a membership program, which you can use to generate periodic orders to a customer. Valid values are:
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 deselect 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 Administration, 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 Administration) 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 Administration)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).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
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:
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:
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:
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:
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.
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. However, non-inventory items sell out when flagged with a S/O control (Soldout control) code. You must select this flag for a subscription item (Subscription = selected); these items will be express billed. Pick slip preparation: The system:
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.
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.
|
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 Administration, 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 Administration) Overview and Setup. Secured FeatureIf 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 FeatureIf 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:
|
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 OverrideIf 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 FeatureIf 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. For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). 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 Administration)When you upload item information into Order Administration, 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:
Valid values: Selected (default) = Include this item when you use a stored procedure to send item and inventory information to Order Orchestration; also, the item is eligible to be sent to Order Orchestration 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 Orchestration; also, the item is not eligible to be sent to Order Orchestration on brokered backorders or ship-for-pickup orders. Note: When you upload items into Order Administration, 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.
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:
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 Administration on an order subject to VAT. See the Invoice Download XML Message (CWInvoiceOut) in the Order Administration Web Services Guide on My Oracle Support (2953017.1) 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. Alphanumeric, 10 positions (each field); optional. |
External info |
Indicates if the item is 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 Administration. For example, the item number in Order Administration may represent a high-level item category, such as “front wheel bearing.” When you enter the item in Order Administration, 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 Administration. If the product number matches an item number in Order Administration, 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. |
Completing this screen: If you are creating a SKU'ed item, you advance to the Create Item Offer Screen. If you are creating a non-SKU'ed item, you advance to the Create Item (Base Information) Screen.
Create Item (Base Information) Screen
Purpose: Use this screen to create SKU level information for a non-SKU’ed item.
How to display this screen: Complete the Create Item Screen with the SKUs field unselected.
Field | Description |
---|---|
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. 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.The system does not calculate the cost automatically. However, you can update the standard cost with the landed cost (primary vendor item price + vendor additional charges) through:
Numeric, 13 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:
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 Orchestration: If you use the Order Orchestration Integration, the system submits the order line to Order Orchestration for fulfillment even if the line exceeds the reserve quantity limit, provided the line is eligible based on the Rules for Submitting Backorders to Order Orchestration. 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. 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:
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). |
Active PO |
Indicates whether this is an active purchase order item for which you can accept orders before you expect to have inventory to fulfill. The OCDSFA and pre-order periodic functions, which are part of the Enterprise Order Integration (Future Receipts and Active PO/Pre-Order Processing), set this flag and handle updates and orders for active purchase order items that are fulfilled through the integration with Order Orchestration. Possible settings:
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
If the Tax Included in Price (E70) system control value is selected:
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). |
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. See How Hidden Tax is Calculated by Percentage for more information. Included only if the Tax Included in Price (E70) system control value is selected Numeric, 13 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. See How Hidden Tax is Calculated by Percentage for more information. 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.
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:
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:
If you identify an item as a subscription item,
|
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, 13 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, 13 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). For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). 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, 13 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:
|
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. |
Completing this screen: You advance to the Create Vendor Item Screen if the Auto Advance to Vendor Item Create (E78) system control value is selected; otherwise, you advance to the Create Item Offer Screen.
Create Item Offer Screen
Purpose: Use this screen to assign an offer to an item.
How to display this screen:
- You advance to this screen automatically when you create a SKU’d or non-SKU’d item if the Auto Advance to Item Offer (J05) system control value is selected; see Creating Items Screen Flow.
- Select Create at the Work with Item Offers Screen.
Field | Description |
---|---|
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 Administration. 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 Administration returns to normal processing. 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. 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). Numeric, 13 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, 13 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, 13 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. FIncluded only if the Tax Included in Price (E70) system control value is selected. Numeric, 13 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.).
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:
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, 13 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:
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.
|
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, 13 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, 13 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, 13 positions with a 2-place decimal; optional. |
Sale item |
Indicates whether the item is on sale. Valid values are:
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.
|
Coupon discount $ (Coupon discount dollars) |
Represents the amount that is subtracted from the price when the item/SKU is ordered from this offer. Numeric, 13 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:
Optional. |
Column pricing |
Determines whether this item is 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:
Optional. |
Warranty |
Defines whether the item in this offer is a warranty item. Valid values are:
|
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:
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. |
Completing this screen: If you advanced to this screen through initial item creation, you return to the Create Item Screen.
Select Exit at this screen if you do not want to create an item/offer.
Create SKU 1 of 2 (With Overrides) Screen
Purpose: Use this screen to create a SKU for a SKU’d item.
How to display this screen:
- You advance to this screen automatically when you create a SKU’d item if the Auto Advance to SKU Create (B34) system control value is selected and the Auto Advance to SKU Generator (J06) system control value is unselected. See Creating SKU'ed Items Screen Flow.
- Select Create at the Work with SKUs Screen.
Completing this screen: Select OK to advance to the Create SKU 2 of 2 (With Overrides) Screen. This screen contains additional SKU attributes, including those related to long SKU and physical dimensions.
After you create a SKU, the system returns you to this screen, allowing you to create another SKU. You can select Exit when you have finished creating all SKUs.
You can also select Exit if you wish to create a SKU’ed item without creating the individual SKUs at this time.
Field | Description |
---|---|
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:
|
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:
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:
If the Unconditional Suppression of Backorder Card (F19)Enterprise Order Integration (Future Receipts and Active PO/Pre-Order Processing) 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. |
Active PO |
Indicates whether this is an active purchase order item for which you can accept orders before you expect to have inventory to fulfill. The OCDSFA and pre-order periodic functions, which are part of the , set this flag and handle updates and orders for active purchase order items that are fulfilled through the integration with Order Orchestration. Possible settings:
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:
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, 13 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. See How Hidden Tax is Calculated by Percentage for more information. 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.
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:
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:
If you identify an item as a subscription item, you must
|
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, 13 positions with a 2-place decimal; optional. |
List price |
The system uses this price:
Numeric, 13 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). For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). 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, 13 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:
|
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. |
Create SKU 2 of 2 (With Overrides) Screen
Purpose: Use this screen to enter additional information for a SKU.
The values you enter in the "override" section of the screen override the values you entered for the base item. If you leave any of these fields blank and you have entered values at the base item level, the system uses the base item values. For example, if you leave height, length, and width blank and there is a height, length, or width defined at the base item level, the system uses the values at the base item level.
How to display this screen: Select OK at the Create SKU 1 of 2 (With Overrides) Screen.
Completing this screen: When you select OK at this screen, the system:
- If the Auto Advance to Vendor Item Create (E78) system control value is selected, automatically advances you to the Create Vendor Item Screen.
- If the Auto Advance to Vendor Item Create (E78) system control value is unselected, creates the SKU after validating your entries and highlighting any errors, if necessary.
After you create a SKU, the system returns you to the Create SKU 1 of 2 (With Overrides) Screen, allowing you to create another SKU. You can select Exit when you have finished creating all SKUs.
Field | Description |
---|---|
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 Administration)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).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 FeatureIf 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 FeatureIf 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 FeatureIf 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. Numeric, 13 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:
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. |
Screen Option | Procedure |
---|---|
Return to the Create SKU 1 of 2 (With Overrides) Screen |
Press Page Up. |
Advance to a menu option related to item maintenance |
Select Supporting Files to advance to the Item Support File Maintenance window. Options at this window are:
|
Display SKU offer information |
Select Offers to advance to the Work with SKU Offers Screen. |
Display base item information |
Select Item base info to advance to the Display Base Item Information Pop-up window. See Create Item (Base Information) Screen for field descriptions. |
Display comments |
Select Comments to advance to the Display SKU Comments screen. See Work with Item/SKU Comments Screen for field descriptions. |
Create SKU Offer Screen
Purpose: Use this screen to assign an offer to a SKU.
How to display this screen: Select Create at the Work with SKU Offers Screen.
Field | Description |
---|---|
Offer (Offer code) |
The code for the offer (catalog) in which the item/SKU appears. Validated against the Offer table. See DWorking 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). Numeric, 13 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, 13 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, 13 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, 13 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.).
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:
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, 13 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:
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.
|
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, 13 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, 13 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, 13 positions with a 2-place decimal; optional. |
Sale item |
Indicates whether the item is on sale. Valid values are:
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.
See Item Volume Discounting |
Coupon discount $ |
Represents the amount that is subtracted from the price when the SKU is ordered from this offer. Numeric, 13 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:
Optional. |
Column pricing |
Determines whether this item/SKU is 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:
Optional. |
Warranty |
Defines whether the item/SKU in this offer is a warranty item. Valid values are:
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:
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. |
Item Volume Discounting
How volume discounting works: If the Volume discount field is selected at the Create Item Offer Screen, Create SKU Offer Screen, or another screen that allows you to set up an item/offer or SKU/offer, and if the Item Volume Discount (B29) system control value is selected, the system will:
- total the number of units ordered of volume- discountable items
- check the quantity break price table in the SKU/offer for the discount price for each discountable item
For example, the system calculates the volume discount for items A123 and C123, as if the customer purchased 12 units of each item.
Item | Order qty | Volume discount | Regular price/unit | Merchandise total (regular price) | Volume discount price/unit | Merchandise total (with volume discount) |
---|---|---|---|---|---|---|
A123 |
* 4 |
Y |
$10.00 |
$40.00 |
$7.00 |
$28.00 |
B123 |
6 |
N |
$5.00 |
$30.00 |
N/A |
$30.00 |
C123 |
* 8 |
Y |
$20.00 |
$160.00 |
$15.00 |
$120.00 |
Total: |
Total: |
Total: |
Total: |
$230.00 |
Total: |
$178.00 |