Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSSUBSCR


                             BSSUBSCR FILE

                               Subscriber

UPDATED BY

BS70.1    BS99.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SUB-GROUP              Alpha 20  (Lower Case)                    BS70.1  BS99.4
Element: Group

SUB-ID                 Alpha 20  (Lower Case)                    BS70.1  BS99.4
Element: Id

SUB-SUBSCRIBE          Alpha 1                                   BS70.1  BS99.4
Element: Subscribe     N = No
                       Y = Yes

SUB-SUBSCRIBE-TYPE     Alpha 1                                   BS70.1  BS99.4
Element: Subscribe TypeA = Add
                       E = Exclude

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

SUB-TIME               Numeric 6  (hhmmss)                       BS99.4
Element: Time

                         BSSUBSCR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SUBSET1   GROUP                                                  BS70.1  BS99.4
          ID

SUBSET2   ID
          GROUP

                         BSSUBSCR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsgroup        BSGROUP      Not Required

                            SUB-GROUP    -> GRP-GROUP  (GRPSET1)

Sirdidhdr      SIRDIDHDR    Not Required

                            SUB-ID       -> IDH-ID

                         BSSUBSCR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsinfodtl      BSINFODTL

                            SUB-GROUP    -> IFR-GROUP
                                            IFR-INFORMATION
                                            IFR-RULE-TAG

Bslistgrp      BSLISTGRP

                            SUB-ID       -> LGR-ID
                                            LGR-GROUP
                                            LGR-LIST