AMBGRPBOOK – Book Group Detail

System
Asset Management (AM)
Prefix
AGB
Primary key
BOOK, BOOK-GROUP
Fields
3
Updated by
1 program
Referenced by
13 programs

AMBGRPBOOK is the Book Group Detail table in Lawson Asset Management (prefix AGB). It is indexed by BOOK, BOOK-GROUP (AGBSET1); alternate indexes: AGBSET2 and AGBSET3. It is related 1:1 to AMBOOK and AMBOOKGRP. It is updated by AM10.1 and referenced by AM180, AM185, AM190, AM195, AM210, AM214, AM266, AM282 and 5 more. The table has 3 fields, 3 indexes and 2 documented relations.

About AMBGRPBOOK

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

Fields (3)

Column = COBOL field name without the AGB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AGB-BOOK-GROUP PK
BOOK_GROUP		Alpha 12Primary key field. This is the name of the book group.AM10.1
AGB-BOOK PK
BOOK		Alpha 10Primary 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
SEQ_NBR		Numeric 6This is an automatically assigned sequence number, on which the sort order for the book group is based.AM10.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AGBSET1BOOK, BOOK-GROUPPrimaryAM10.1
AGBSET2BOOK-GROUP, SEQ-NBR, BOOKKeyChangeAM10.1, AM210
AGBSET3BOOK-GROUP, BOOKAM10.1, AM180, AM185, AM190, AM195, AM214, AM266, AM282 +5 more

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmbookAMBOOKRequiredAGB-BOOK → AMB-BOOK
AmbookgrpAMBOOKGRPRequiredAGB-BOOK-GROUP → ABG-BOOK-GROUP

Programs

Updated by (1)

Referenced by (13)