AMACCTGRP – Asset Account Group

System
Asset Management (AM)
Prefix
AAG
Primary key
COMPANY, ACCT-GRP
Fields
3
Updated by
274 programs
Referenced by
38 programs

AMACCTGRP is the Asset Account Group table in Lawson Asset Management (prefix AAG). It is indexed by COMPANY, ACCT-GRP (AAGSET1); alternate indexes: AAGSET2. It is related 1:1 to AMCONTROL and GLSYSTEM and 1:M to AMACCOUNT, AMACCTGPAU, AMASSET, AMASSETADJ and AMASSETTRF. It is updated by AC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 and 266 more and referenced by AC10.1, AC10.3, AC56.1, AC560, AC71.1, AM06.1, AM06.2, AM06.3 and 30 more. The table has 3 fields, 2 indexes and 10 documented relations.

About AMACCTGRP

The Account Group file stores account group records that represent the general ledger accounts to use to create journal entries when assets are processed (added, adjusted, transferred, and disposed of). Each account group record has one or more associated records in the Account file, which identify specific general ledger accounts for the account group.

Fields (3)

Column = COBOL field name without the AAG- 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
#AAG-COMPANY PK
COMPANY		Numeric 4This is the general ledger company number for the account group. It is used for posting journal entries when assets are processed.AC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +52 more (list truncated in source)
#AAG-ACCT-GRP PK
ACCT_GRP		Alpha 10This is the user-defined account group, identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).AC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +52 more (list truncated in source)
#AAG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The user-defined description of the account group.AC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +52 more (list truncated in source)

Indexes (2)

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
AAGSET1
  1. COMPANY
  2. ACCT-GRP
PrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)
AAGSET2
  1. ACCT-GRP
  2. COMPANY
KeyChangeAC160, AM115, AM117, AM12.1, AM12.2, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmcontrolAMCONTROLNot Required
AAG-COMPANY→CTL-COMPANY
GlsystemGLSYSTEMRequired
AAG-COMPANY→GLS-COMPANY

One to many (8) — child tables

RelationTableRulesConditionField map
AmaccountAMACCOUNTDelete Cascades
AAG-COMPANY→AAC-COMPANY
AAG-ACCT-GRP→AAC-ACCT-GRP
Spaces→AAC-ASSET-TYPE
Spaces→AAC-SUB-TYPE
—→AAC-ACCT-TYPE
—→AAC-ASSET-EVENT
AmacctgpauAMACCTGPAU
AAG-COMPANY→AGD-COMPANY
AAG-ACCT-GRP→AGD-ACCT-GRP
—→AGD-ACTION
—→AGD-DATE
—→AGD-TIME
—→AGD-UNIQUE-I-D
Amasset1AMASSET
1→AST-STATUS
AAG-COMPANY→AST-COMPANY
—→AST-DSP-ASSET
—→AST-ASSET
Amasset2AMASSET
2→AST-STATUS
AAG-COMPANY→AST-COMPANY
—→AST-DSP-ASSET
—→AST-ASSET
Amasset3AMASSET
3→AST-STATUS
AAG-COMPANY→AST-COMPANY
—→AST-DSP-ASSET
—→AST-ASSET
AmassetadjAMASSETADJ
AAG-COMPANY→ASA-COMPANY
—→ASA-ASSET
—→ASA-PROCESS-SEQ
AmassetdspAMASSET
9→AST-STATUS
AAG-COMPANY→AST-COMPANY
—→AST-DSP-ASSET
—→AST-ASSET
AmassettrfAMASSETTRF
AAG-COMPANY→ATF-COMPANY
—→ATF-ASSET
—→ATF-PROCESS-SEQ

Programs

Updated by (274)

Referenced by (38)