Lawson Insight Technical Documentation

                            LOGRPBKMRK FILE

REFERENCED BY

LO901

UPDATED BY

LO12.1    LO13.1    LO13.2    LO13.3    LO920     RD56.1
RD56.2    RD55.1    RD55.2    RD55.3    RD55.4    RD55.5
RD55.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GPP-GROUP              Alpha 20  (Lower Case)                    LO13.1  LO13.2
Element: Group                                                   LO13.3

GPP-BOOK-MARK          Numeric 15                                LO13.1  LO13.2
Element: Book Mark                                               LO13.3

GPP-ACCESS             Alpha 1                                   LO13.1  LO13.2
Element: Access        A = Allow                                 LO13.3
                       D = Deny

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

GPP-TIME               Numeric 6  (hhmmss)                       LO13.1  LO13.2
Element: Time                                                    LO13.3

                         LOGRPBKMRK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GPPSET1   GROUP                                                  LO13.1  LO13.2
          BOOK-MARK                                              LO13.3  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

GPPSET2   BOOK-MARK                                              LO12.1  LO13.3
          GROUP                                                  LO901   LO920

                         LOGRPBKMRK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lobkmark       LOBKMARK     Required

                            GPP-BOOK-MARK    -> LOB-BOOK-MARK

Sirdgrp        SIRDGRP      Required

                            GPP-GROUP        -> RDG-GROUP

                         LOGRPBKMRK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lousrbkmrk     LOUSRBKMRK   Delete Cascades

                            GPP-BOOK-MARK    -> USP-BOOK-MARK
                                                USP-WEB-USER