Item Statuses (ICIS_IM09)

The Item Statuses (ibis_icis.im09) view allows you to define status' which will be applied to products in the Products (ici1.im13) table. The item status code is used to identify a group of similar products. For example, if you have products you want to sell at a discount, you can set up an item status code of C for clearance and assign this code to all clearance items.

The item status code is displayed in Product Price Lists (ibis_im18), Future Product Price Lists (ibis_im21) and in Products (ici1.im13).

The item status code is used in conjunction with Order Discount Limits (ibis_oe04). Depending on the item status and order type, OE04 indicates the reference price list that should be used to determine the effective discount. Depending on the limits set in OE04, the sales order may be flagged for a pricing hold or a pricing review for discount in excess of these limits. The effective discount is reported by item status on the Order Pricing Hold Management (ibis_oe62) window.

For example, an item status of C is assigned to all clearance items. OE04 identifies the reference price list for items with an item status of C is Reduced to Clear. In IM18, the Reduced to Clear prices are 50% off the master price list. Items sold with an item status of C for 50% off will not be flagged with an excessive discount.

The following list defines every field available in the item status (icis) table in alphabetical order:

  • Company - the company field is available when you create a new record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the creation process only. Once the record is created, the company to which the record is associated displays in the General section (at the top of the view).

  • Created On - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created By - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Item Status - enter an item status code. You can enter a maximum of 10 alpha-numeric characters in this field.

  • Item Status Description - enter a description of the item status. You can enter a maximum of 30 alpha-numeric characters in this field.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.