Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBGRPBOOK


                            AMBGRPBOOK FILE

                           Book Group Detail

This file maintains the name and sequence number of each book in a book group.


REFERENCED BY

AM210     AM180     AM185     AM190     AM195     AM214
AM266     AM282     AM320     AM501     AM88.2    AMBK.1
AMDL.1

UPDATED BY

AM10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGB-BOOK-GROUP         Alpha 12                                  AM10.1
Element: Book Group    Primary key field. This is the name of
                       the book group.


AGB-BOOK               Alpha 10                                  AM10.1  AM180
Element: Book          Primary key field. This field contains    AM185   AM190
                       the name of a book in the book group.     AM195   AM266
                       Books are used by assets for calculating  AM282
                       depreciation, replacement cost, and
                       insurance values, and for reporting.


AGB-SEQ-NBR            Numeric 4                                 AM10.1
Element: Sequence NumbeThis is an automatically assigned
                       sequence number, on which the sort order
                       for the book group is based.


                         AMBGRPBOOK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGBSET1   BOOK                                                   AM10.1
          BOOK-GROUP

AGBSET2   BOOK-GROUP    KeyChange                                AM10.1  AM210
          SEQ-NBR
          BOOK

AGBSET3   BOOK-GROUP                                             AM10.1  AM180
          BOOK                                                   AM185   AM190
                                                                 AM195   AM214
                                                                 AM266   AM282
                                                                 AM320   AM501
                                                                 AM88.2  AMBK.1
                                                                 AMDL.1

                         AMBGRPBOOK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambook         AMBOOK       Required

                            AGB-BOOK          -> AMB-BOOK

Ambookgrp      AMBOOKGRP    Required

                            AGB-BOOK-GROUP    -> ABG-BOOK-GROUP