Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSCHANNEL


                             BSCHANNEL FILE

                                Channel

Defines the channels used by the channels viewer.

REFERENCED BY

BS10.1    BS10.2    BS19.1    BS19.2    BS99.1    BS99.2
BS99.3

UPDATED BY

BS00.1    BS00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCH-CHANNEL            Alpha 20                                  BS00.1  BS00.2
Element: Channel       The title of the channel.

BCH-STYLE              Alpha 20  (Lower Case)
Element: Style         This is the style used to define the
                       appearance of all reports in a channel.

BCH-DESCRIPTION        Alpha 50  (Lower Case)                    BS00.1  BS00.2
Element: Description   Room for a longer, more descriptive name  BS10.1  BS10.2
                       for the channel.                          BS19.1  BS19.2

BCH-CH-STATUS          Alpha 1                                   BS00.1  BS00.2
Element: Ch Status     Sets a channel's status to active or
                       inactive.
                       A = Active
                       I = Inactive

BCH-DATE               Numeric 8  (yyyymmdd)                     BS00.1  BS00.2
Element: Date          This field contains the system date
                       when this was created.

BCH-TIME               Numeric 6  (hhmmss)                       BS00.1  BS00.2
Element: Time

                         BSCHANNEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCHSET1   CHANNEL                                                BS00.1  BS00.2
                                                                 BS10.1  BS10.2
                                                                 BS19.1  BS19.2
                                                                 BS99.1  BS99.2
                                                                 BS99.3

BCHSET2   CHANNEL       KeyChange
          STYLE

BCHSET3   STYLE         KeyChange
          CHANNEL

                         BSCHANNEL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsfolder       BSFOLDER

                            BCH-CHANNEL    -> BFD-CHANNEL  (BFDSET2)
                                              BFD-FOLDER

Bsidchan       BSIDCHAN

                            BCH-CHANNEL    -> ICH-CHANNEL
                                              ICH-ID

Bsidchfld      BSIDCHFLD

                            BCH-CHANNEL    -> ICF-CHANNEL
                                              ICF-FOLDER
                                              ICF-ID

Bsidchfldi     BSIDCHFLDI

                            BCH-CHANNEL    -> FIF-CHANNEL
                                              FIF-FOLDER
                                              FIF-ID
                                              FIF-INFORMATION
                                              FIF-RULE-TAG