AMBGRPBOOK

Book Group Detail

This file maintains the name and sequence number of each book in a book group.
UPDATED BY
AM10.1 AM210 AM180 AM185 AM190 AM195
AM214 AM266 AM282 AM320 AM501 AM88.2
AMBK.1 AMDL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGB-BOOK-GROUP
Element: Book Group
Alpha 12
Primary key field. This is the name of the book group.
AM10.1
AGB-BOOK
Element: Book
Alpha 10
Primary key field. This field contains the name of a book in the book group. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.
AM10.1 AM180
AM185 AM190
AM195 AM266
AM282
AGB-SEQ-NBR
Element: Sequence Number
Numeric 6
This is an automatically assigned sequence number, on which the sort order for the book group is based.
AM10.1


AMBGRPBOOK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGBSET1 BOOK
BOOK-GROUP
AM10.1
AGBSET2 BOOK-GROUP
SEQ-NBR
BOOK
KeyChange
AM10.1 AM210
AGBSET3 BOOK-GROUP
BOOK
AM10.1 AM180
AM185 AM190
AM195 AM214
AM266 AM282
AM320 AM501
AM88.2 AMBK.1
AMDL.1


AMBGRPBOOK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ambook AMBOOK Required
AGB-BOOK->AMB-BOOK
Ambookgrp AMBOOKGRP Required
AGB-BOOK-GROUP->ABG-BOOK-GROUP


File created: Wed Jun 08 20:47:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.