Adding business channels

To define additional business channels, create an insert statement in the BUSCHN and BUSCHNDESC tables. For example, to track the number of items sold from a particular trade show, you can create a new business channel called "Trade Show".

About this task

The following two insert statements define the new business channel that can then be applied to an order and tracked.

Procedure

  1. Use the following insert statement for BUSCHN:

    Define the following: (BUSCHN_ID, NAME, STATE) to be: (6, 'Trade Show', 'E')

    insert into BUSCHN (BUSCHN_ID,NAME,STATE) values (6,'Trade Show','E')

  2. Use the following insert statement for BUSCHNDESC:

    Define the following: (BUSCHNDESC_ID, LANGUAGE_ID, DESCRIPTION, DISPLAYNAME) to be: (6, -1, 'Order taken at a trade show', 'Trade Show')

    insert into BUSCHNDESC (BUSCHNDESC_ID,LANGUAGE_ID,DESCRIPTION,DISPLAYNAME) values (6,-1,'Order taken at a trade show','Trade Show')

Results

This procedure will generate an additional menu item named Trade Show that can be selected when an order is submitted.

  • In BUSCHN, BUSCHN_ID is a unique key that identifies the business channel.

The NAME is a set of characters that identify the name of the business channel.

The STATE of 'E' indicates that the business channel should be Enabled.

  • For BUSCHNDESC, the BUSCHN_ID is a unique key that identifies the business channel. It must be exactly the same as the ID used in the BUSCHN insert statement.

The LANGUAGE_ID of -1 is maps to English. The Language table lists the full language mappings.

The DESCRIPTION is a description of the business channel that is being added.

The DISPLAYNAME is the name that will be displayed in the IBM Sales Center business channel menu.