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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#AGB-BOOK-GROUP PKBOOK_GROUP | Alpha 12 | Primary key field. This is the name of the book group. | AM10.1 |
#AGB-BOOK PKBOOK | 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 SET2SEQ_NBR | Numeric 6 | This is an automatically assigned sequence number, on which the sort order for the book group is based. | AM10.1 |
Indexes (3)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AGBSET1 |
| Primary | AM10.1 | |
AGBSET2 |
| KeyChange | AM10.1, AM210 | |
AGBSET3 |
| AM10.1, AM180, AM185, AM190, AM195, AM214, AM266, AM282 +5 more |
Relations
One to one (2) — lookups and parents
Programs
Updated by (1)
- AM10.1 Book Group
Referenced by (13)
- AM180 Depreciation Calculation and Listing
- AM185 Insurance and Replacement Calculation
- AM190 Period Close
- AM195 Year End Close
- AM210 Book Group Listing
- AM214 Class Depreciation Rate Listing
- AM266 Continuing Property Records
- AM282 Class Depreciation Report
- AM320 Depreciation History Rebuild
- AM501 Depreciation History Balances
- AM88.2 Book Dimension Definition
- AMBK.1 OLAP Dimension Retrieval Format
- AMDL.1 OLAP Data Load