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