BUSCHN

This table contains business channel information.

Column Descriptions:

NameTypeDescription
BUSCHN_IDINTEGER NOT NULLGenerated Primary Key. The default values are:
  • -1 = Web Channel
  • -2 = Physical Store
  • -3 = Kiosk
  • -4 = Telesales
  • -5 = B2B External
  • -6 = HTTP device
NAMECHAR (16) NOT NULLThe internal name of the channel. Valid values are as follows:
  • Web Channel
  • Physical Store
  • Kiosk
  • Telesales
  • B2B External
  • HTTP Device
STATECHAR (1) NOT NULLDetermines whether the channel is enabled or disabled for the site. Valid values are as follows:
  • E=enabled
  • D=disabled
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BUSCHN_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1166BUSCHN_IDBUSCHNDESCBUSCHN_IDCascade
F_1176BUSCHN_IDORDERSBUSCHN_IDCascade
R_3463BUSCHN_IDORCOMMENTBUSCHN_IDCascade