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

UPDATED BY

AM10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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


AGB-SEQ-NBR          Numeric 4                                   AM10.1
Sequence Number      This 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

                         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