Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSINFODTL


                             BSINFODTL FILE

                           Information Detail

Defines the name for each burst of the report.

REFERENCED BY

BS90.1    BS99.3

UPDATED BY

BS30.1    BS30.2    BS39.1    BS39.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IFR-INFORMATION        Alpha 20  (Lower Case)                    BS30.1  BS30.2
Element: Information                                             BS39.1  BS39.2

IFR-RULE-TAG           Alpha 15                                  BS30.1  BS39.1
Element: Rule Tag

IFR-RULE-ORDER         Numeric 4                                 BS30.1  BS39.1
Element: Rule Order

IFR-GROUP              Alpha 20  (Lower Case)                    BS30.1  BS39.1
Element: Group

IFR-DESCRIPTION        Alpha 50  (Lower Case)
Element: Description   This field contains the description.

IFR-INFO-STATUS        Alpha 1                                   BS30.1  BS39.1
Element: Info Status   A = Active
                       I = Inactive

IFR-COMBINE-RULE       Alpha 1                                   BS30.1  BS39.1
Element: Combine Rule  N = No
                       Y = Yes

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

IFR-TIME               Numeric 6  (hhmmss)                       BS30.1  BS39.1
Element: Time

IFR-SH-INFO-DESC       Derived
Element: Sh Info Desc

                         BSINFODTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IFRSET1   INFORMATION                                            BS30.1  BS30.2
          RULE-TAG                                               BS39.1  BS39.2
                                                                 BS90.1  BS99.3

IFRSET2   RULE-TAG      KeyChange
          RULE-ORDER
          INFORMATION

IFRSET3   INFORMATION   KeyChange
          RULE-TAG
          RULE-ORDER

IFRSET4   GROUP         KeyChange
          INFORMATION
          RULE-TAG

IFRSET5   INFORMATION   KeyChange
          RULE-ORDER
          RULE-TAG

                         BSINFODTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsgroup        BSGROUP      Not Required

                            IFR-GROUP          -> GRP-GROUP  (GRPSET1)

Bsinfohdr      BSINFOHDR    Not Required

                            IFR-INFORMATION    -> INF-INFORMATION

Bsrulehdr      BSRULEHDR    Not Required

                            IFR-RULE-TAG       -> RLH-RULE-TAG

                         BSINFODTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bspublish      BSPUBLISH

                            IFR-INFORMATION    -> PUB-INFORMATION
                            IFR-RULE-TAG       -> PUB-RULE-TAG
                                                  PUB-RUN-SEQ
                                                  PUB-PUBLISH

Bssubscr       BSSUBSCR

                            IFR-GROUP          -> SUB-GROUP
                                                  SUB-ID