AMBOOKGRP – Asset Book Group Header

System
Asset Management (AM)
Prefix
ABG
Primary key
BOOK-GROUP
Fields
3
Updated by
2 programs
Referenced by
10 programs

AMBOOKGRP is the Asset Book Group Header table in Lawson Asset Management (prefix ABG). It is indexed by BOOK-GROUP (ABGSET1). It is related 1:M to AMBGRPBOOK. It is updated by AM10.1 and AM88.2 and referenced by AM180, AM185, AM190, AM195, AM210, AM214, AM266, AM282 and 2 more. The table has 3 fields, 1 index and 1 documented relation.

About AMBOOKGRP

This file maintains the names of book groups. It contains a description and last sequence number used for each book group.

Fields (3)

Column = COBOL field name without the ABG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ABG-BOOK-GROUP PK
BOOK_GROUP		Alpha 12Primary key field. This is the name of the book group.AM10.1, AM88.2
#ABG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the book group description.AM10.1, AM88.2
#ABG-LST-SEQ-NBR
LST_SEQ_NBR		Numeric 4This is the last sequence number used for the book group.AM10.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ABGSET1
  1. BOOK-GROUP
PrimaryAM10.1, AM180, AM185, AM190, AM195, AM210, AM214, AM266 +4 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMBGRPBOOKAMBOOKGRP

One to many (1) — child tables

RelationTableRulesConditionField map
AmbgrpbookAMBGRPBOOK
ABG-BOOK-GROUP→AGB-BOOK-GROUP
—→AGB-SEQ-NBR
—→AGB-BOOK

Programs

Updated by (2)

Referenced by (10)