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:
|
| OPTCOUNTER | SMALLINT | 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 |