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