AMAUGROUP – Asset Accounting Unit Group

System
Asset Management (AM)
Prefix
AAU
Primary key
COMPANY, AU-GROUP
Fields
15
Updated by
292 programs
Referenced by
31 programs

AMAUGROUP is the Asset Accounting Unit Group table in Lawson Asset Management (prefix AAU). It is indexed by COMPANY, AU-GROUP (AAUSET1); alternate indexes: AAUSET2. It is related 1:1 to AMCONTROL and GLSYSTEM and 1:M to AMASSET, AMASSETADJ, AMASSETTRF and AMAUGRPAU. It is updated by AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 and 284 more and referenced by AC10.1, AC10.3, AC56.1, AC560, AC71.1, AM08.1, AM08.2, AM152 and 23 more. The table has 15 fields, 2 indexes and 9 documented relations.

About AMAUGROUP

This file stores information from AM09.1 (Accounting Unit Group). Accounting unit groups identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
AAU-COMPANY PK
COMPANY		Numeric 4This is the general ledger company number associated with the accounting unit group.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-AU-GROUP PK
AU_GROUP		Alpha 10This is a user-defined accounting unit group, identifying the accounting units to use when processing assets.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description of the accounting unit group.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-AST-ACCT-UNIT
AST_ACCT_UNIT		Alpha 15This is the accounting unit used to create journal entries for an asset. It is a shorthand notation representing the variable level number. The accounting unit must be defined in the GL Names file as a posting accounting unit.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-ACM-ACCT-UNIT
ACM_ACCT_UNIT		Alpha 15This is the accounting unit to which accumulated depreciation is posted.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15This is the accounting unit to which depreciation expense is posted.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-CLR-ACCT-UNIT
CLR_ACCT_UNIT		Alpha 15This is the accounting unit posted to when adding an asset through other applications (such as Activity Management or Accounts Payable).AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-PRO-ACCT-UNIT
PRO_ACCT_UNIT		Alpha 15This is the accounting unit posted to when cash or items of value are realized in the disposal of an asset.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-COS-ACCT-UNIT
COS_ACCT_UNIT		Alpha 15This is the expense accounting unit posted to when a cost is associated with asset disposal.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-GAN-ACCT-UNIT
GAN_ACCT_UNIT		Alpha 15This is the accounting unit posted to when a gain is realized in asset disposal.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-LOS-ACCT-UNIT
LOS_ACCT_UNIT		Alpha 15This is the accounting unit posted to when a loss occurs in asset disposal.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-DGN-ACCT-UNIT
DGN_ACCT_UNIT		Alpha 15This is the deferred gain accounting unit posted to when a disposal is a like-kind exchange.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-DLS-ACCT-UNIT
DLS_ACCT_UNIT		Alpha 15This is the deferred loss accounting unit posted to when a disposal is a like-kind exchange.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-RVS-ACCT-UNIT
RVS_ACCT_UNIT		Alpha 15—AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
AAU-RVL-ACCT-UNIT
RVL_ACCT_UNIT		Alpha 15—AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +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
AAUSET1COMPANY, AU-GROUPPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)
AAUSET2AU-GROUP, 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 RequiredAAU-COMPANY → CTL-COMPANY
GlsystemGLSYSTEMRequiredAAU-COMPANY → GLS-COMPANY

One to many (7) — child tables

RelationTableRulesConditionField map
Amasset1AMASSET1 → AST-STATUS, AAU-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset2AMASSET2 → AST-STATUS, AAU-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset3AMASSET3 → AST-STATUS, AAU-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
AmassetadjAMASSETADJAAU-COMPANY → ASA-COMPANY, → ASA-ASSET, → ASA-PROCESS-SEQ
AmassetdspAMASSET9 → AST-STATUS, AAU-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
AmassettrfAMASSETTRFAAU-COMPANY → ATF-COMPANY, → ATF-ASSET, → ATF-PROCESS-SEQ
AmaugrpauAMAUGRPAUAAU-COMPANY → AUA-COMPANY, AAU-AU-GROUP → AUA-AU-GROUP, → AUA-ACTION, → AUA-DATE, → AUA-TIME, → AUA-UNIQUE-I-D

Programs

Updated by (292)

Referenced by (31)