BUSCHN

This table contains business channel information.


Column Descriptions:

Name Type Description
BUSCHN_ID INTEGER NOT NULL Generated Primary Key. The default values are:

  • -1 = Web Channel

  • -2 = Physical Store

  • -3 = Kiosk

  • -4 = Telesales

  • -5 = B2B External

  • -6 = HTTP device

NAME CHAR (16) NOT NULL The internal name of the channel. Valid values are as follows:

  • Web Channel

  • Physical Store

  • Kiosk

  • Telesales

  • B2B External

  • HTTP Device

STATE CHAR (1) NOT NULL Determines whether the channel is enabled or disabled for the site. Valid values are as follows:

  • E=enabled

  • D=disabled

OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> BUSCHN_ID Primary Key


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_1166 BUSCHN_ID BUSCHNDESC BUSCHN_ID Cascade
F_1176 BUSCHN_ID ORDERS BUSCHN_ID Cascade
R_3463 BUSCHN_ID ORCOMMENT BUSCHN_ID Cascade