WebSphere Commerce database table: BUSCHN

Advanced orders This table contains business channel information.


Column Description(s):
Column NameColumn TypeDescription
BUSCHN_ID INTEGER NOT NULL Generated Primary Key.
NAME CHAR(16) NOT NULL The internal name of the channel. This can be: Web Channel, Physical Store, Kiosk, Telesales, B2B External
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031203310 BUSCHN_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1166 BUSCHN_ID BUSCHNDESC BUSCHN_ID Cascade
F_1176 BUSCHN_ID ORDERS BUSCHN_ID Cascade

Feedback