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 AM266
AM282 AM320 AM88.2 AMBK.1 AMDL.1
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 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
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 AM266
AM282 AM320
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
|
