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". The following two insert statements define the new business channel that can then be applied to an order and tracked.

  1. Use the following insert statement for BUSCHN:

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

  2. Use the following insert statement for BUSCHNDESC:
  3. Define the following: (BUSCHNDESC_ID, LANGUAGE_ID, DESCRIPTION, DISPLAYNAME) to be: (6, -1, 'Order taken at a trade show', 'Trade Show')

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

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.

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 Multichannel Sales Center business channel menu.

Feedback