Define Alias Number

This document explains how you connect an alias number to an item. This number functions as an alternative identification of an item. An item can be connected to several alias numbers.

Outcome

An alias number is created and connected to an item.

An alias number is created as an alternative number to the item number. An alias number reflects a certain relation. For example, an alias can be the same as the supplier number.

The created alias number is saved in the MITMAS table and can be reviewed in 'Item. Connect Alias Number' (MMS025).

Before you start

An item must have been created in 'Item. Open' (MMS001).

Parameters to set

Program ID/Panel Field The field indicates …
(MMS025/B) Alias category

…the type of alias number.

The valid alternatives are:

01 = Popular number.

(the American equivalent to EAN). 02 = EAN (European Article Numbering) or UPC

03 = External database (not used by M3).

04 = Manufacturer's item number.

…05 =…Supplier's item number.

06 = Customer's item number

07 = Assortment

09 = EDI partner's item

Alias types 84-88 are only used in fashion and are automatically created from (MMS276).

84 - 87 = As defined in 'Alias Type. Open' (MMS024) and created when SKUs are created, based on the setup in 'Item Type. Connect Alias' (MWS043).

…88 = Style number - cannot be manually entered in (MMS025), always automatically created when the SKU is created. If it has not been created in table MITPOP, it can be created by re-running the create function in function program (MMS276).
02 = EAN (European Article Numbering) or UPC (MMS025/B) Alias Qualifier

...additional information about the alias category. Note: This should only be specified if alias type 02 or 03 is used. If alias category 02 (EAN number) is used, specify the type of EAN number as follows:

EA08 = EAN 8, an EAN number containing eight digits

EA13 = EAN 13, an EAN number containing 13 digits

DU14 = DUN14, a packaging variant of an EAN number.

UPC = UPC number.

If alias category 03 (external database) is used, you can define the qualifier ID as you wish. For other alias categories, the alias qualifier is not used.

(MMS025/B) Season

…the season and is used to connect styles to the time periods when they are valid.

Seasons can be used:

* In customer order entry to ensure that only items connected to a certain season are entered on an order.

* When simulating sales prices to calculate only those items for the season specified.

* As a statistics field in orders received statistics and sales statistics. The season entered in the project field on the order line.

(MMS025/B) Alias number

…the alias number, which is an alternative ID for an item. It can be defined so that an item has several alias numbers and can be searched in different ways.

This can be an EAN code or supplier's item number. Every alias number is connected to an alias type which regulates the information used as the alias.

The same alias number can be used for several items. Example:

When two different customers regularly order the same item, but each has its own item number for it, these two numbers can be entered as alias numbers for that item. The alias numbers can then be used during customer order entry.

When entered, the alias number is automatically changed to the correct item number.

(MMS025/B) Valid from

…the date the alias number becomes valid. The field is optional. If it is left blank, the alias number becomes valid as soon as it is entered.

(MMS025/E) Partner

…an external trade partner. The alias type determines the type of partner in question.

The table below shows the alias type and the resulting partner type

Alias Type Partner Type

02 Manufacturer

03 Manufacturer

04 Manufacturer

05 Supplier

06 Customer

08 Customer

(MMS025/E) Sequence number

...the sequence number, which regulates the order in which items are displayed when a popular number is used. This number is optional and can be defined in any way.

The sequence number is used during full-screen entry of customer order lines in (OIS101).

(MMS025/E) Quantity …the included quantity to be proposed for this alias number during customer order entry.
(MMS025/E) Alternate U/M

The field indicates the U/M of the alias number.

If the alias number is a DUN14 number (type 02 and qualifier DU14), the alternate U/M entered will be proposed as the sales U/M when entering customer orders.

If the alias type is 1=Popular number, an alternative U/M must be entered in combination with a quantity. If the quantity is 0, the basic U/M is used.

In all other cases, the item's basic U/M will be used.

Follow these steps

  1. Start 'Item. Connect Alias Number' (MMS025).
  2. On the B panel, select an sorting order in accordance with the alias types you are about to create. Note that new entries cannot be made for sorting orders 1 - 5.

    These alternative sorting orders are available:

    FOR ALL ALIAS TYPES

    1 = Alias type, qualifier, item number, alias

    number

    2 = Alias number, alias type, qualifier, item

    number

    3 = Alias type, qualifier, alias number, item

    number

    4 = Item number, alias type, qualifier, alias

    number

    5 = Season, alias number, alias type, item number

    FOR ALIAS TYPE 01 - POPULAR NUMBER

    11 = Item number, popular number

    12 = Popular number, sequence number, item number.

    FOR ALIAS TYPE 02 - EAN NUMBER

    21 = Item number, qualifier, manufacturer, from

    date, EAN number

    22 = Qualifier, EAN number, manufacturer, from

    date, item number

    23 = EAN number, qualifier, manufacturer, from

    date, item number.

    FOR ALIAS TYPE 03 - REFERENCE TO EXTERNAL DATABASE

    31 = Qualifier, item number, reference number,

    manufacturer, from date

    32 = Qualifier, reference number, manufacturer,

    from date, item number.

    FOR ALIAS TYPE 04 - MANUFACTURER'S ITEM NUMBER

    41 = Item number, manufacturer's item number,

    manufacturer, from date

    42 = Manufacturer's item number, manufacturer,

    from date, item number.

    FOR ALIAS TYPE 09 - EDI PARTNER'S ITEM NUMBER

    91 = Item number, EDI partner's item number, EDI

    partner, from date

    92 = EDI partner's item number, EDI partner, from

    date, item number.

  3. Specify the 'Alias Category' field and the 'Alias Number' field and click New or Option 1.
    Note: The alias categories 84-88 are used in the fashion industry and cannot be manually created in (MMS025). The aliases are automatically created at SKU creation in (MMS276) based on the alias categories connected to the item type in (MWS043).
  4. On the next panel, specify the necessary data. Which panel is next depends on the alias type selected. (See parameter descriptions.)
Related topics