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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AAGSET1COMPANY, ACCT-GRPPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)
AAGSET2ACCT-GRP, COMPANYKeyChangeAC160, AM115, AM117, AM12.1, AM12.2, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmcontrolAMCONTROLNot RequiredAAG-COMPANY → CTL-COMPANY
GlsystemGLSYSTEMRequiredAAG-COMPANY → GLS-COMPANY

One to many (8) — child tables

RelationTableRulesConditionField map
AmaccountAMACCOUNTDelete CascadesAAG-COMPANY → AAC-COMPANY, AAG-ACCT-GRP → AAC-ACCT-GRP, Spaces → AAC-ASSET-TYPE, Spaces → AAC-SUB-TYPE, → AAC-ACCT-TYPE, → AAC-ASSET-EVENT
AmacctgpauAMACCTGPAUAAG-COMPANY → AGD-COMPANY, AAG-ACCT-GRP → AGD-ACCT-GRP, → AGD-ACTION, → AGD-DATE, → AGD-TIME, → AGD-UNIQUE-I-D
Amasset1AMASSET1 → AST-STATUS, AAG-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset2AMASSET2 → AST-STATUS, AAG-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset3AMASSET3 → AST-STATUS, AAG-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
AmassetadjAMASSETADJAAG-COMPANY → ASA-COMPANY, → ASA-ASSET, → ASA-PROCESS-SEQ
AmassetdspAMASSET9 → AST-STATUS, AAG-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
AmassettrfAMASSETTRFAAG-COMPANY → ATF-COMPANY, → ATF-ASSET, → ATF-PROCESS-SEQ

Programs

Updated by (274)

Referenced by (38)