Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSIDCHAN


                             BSIDCHAN FILE

                               ID Channel

The channels available to a given id.

UPDATED BY

BS99.1    BS00.1    BS00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICH-ID                 Alpha 20  (Lower Case)                    BS99.1
Element: Id

ICH-CHANNEL            Alpha 20                                  BS99.1
Element: Channel       The name of a channel. Channels are the
                       highest level grouping available for
                       Broadcasting System reports.

ICH-ORDER-OPT          Numeric 4                                 BS99.1
Element: Order Opt

ICH-SUBSCRIBE          Alpha 1                                   BS99.1
Element: Subscribe     N = No
                       Y = Yes

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

ICH-TIME               Numeric 6  (hhmmss)                       BS99.1
Element: Time

                         BSIDCHAN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICHSET1   ID                                                     BS99.1  BS99.2
          CHANNEL

ICHSET2   CHANNEL                                                BS00.1  BS00.2
          ID

ICHSET3   ID            KeyChange
          ORDER-OPT
          CHANNEL

                         BSIDCHAN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bschannel      BSCHANNEL    Not Required

                            ICH-CHANNEL    -> BCH-CHANNEL  (BCHSET1)

Sirdidhdr      SIRDIDHDR    Not Required

                            ICH-ID         -> IDH-ID

                         BSIDCHAN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsidchfld      BSIDCHFLD

                            ICH-ID         -> ICF-ID
                            ICH-CHANNEL    -> ICF-CHANNEL
                                              ICF-FOLDER