Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             AMAUGROUP FILE

                        AM Accounting Unit Group

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.



REFERENCED BY

AM205     AM255     AM35.1    AM45.1

UPDATED BY

AM05.1    AM06.1    AM06.2    AM09.1    AM115     AM12.1
AM125     AM135     AM145     AM15.1    AM15.2    AM15.3
AM15.4    AM170     AM190     AM192     AM20.1    AM20.2
AM20.3    AM20.4    AM20.5    AM20.6    AM30.1    AM30.2
AM40.1    AM40.2    AM40.3    AM500     AM700     AM951
AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AAU-COMPANY          Numeric 4                                   AM05.1  AM06.1
Company              This is the general ledger company          AM06.2  AM09.1
                     number associated with the accounting       AM115   AM12.1
                     unit group.                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-AU-GROUP         Alpha 10                                    AM05.1  AM06.1
Accounting Unit      This is a user-defined accounting unit      AM06.2  AM09.1
Group                group, identifying the accounting units     AM115   AM12.1
                     to use when processing assets.              AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-DESCRIPTION      Alpha 30  (Lower Case)                      AM05.1  AM06.1
Acct Unit Group      This field displays the description of      AM06.2  AM09.1
Description          the accounting unit group.                  AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM951   AM96.1
                                                                 AM98.1

AAU-AST-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Asset Accounting     This is the accounting unit used to         AM06.2  AM09.1
Unit                 create journal entries for an asset. It     AM115   AM12.1
                     is a shorthand notation representing the    AM125   AM135
                     variable level number. The accounting       AM145   AM15.1
                     unit must be defined in the GL Names        AM15.2  AM15.3
                     file as a posting accounting unit.          AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-ACM-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Accumulated Depr     This is the accounting unit to which        AM06.2  AM09.1
Acct Unit            accumulated depreciation is posted.         AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-EXP-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Depr Expense         This is the accounting unit to which        AM06.2  AM09.1
Accounting Unit      depreciation expense is posted.             AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-CLR-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Clearing Accounting  This is the accounting unit posted to       AM06.2  AM09.1
Unit                 when adding an asset through other          AM115   AM12.1
                     applications (such as Activity              AM125   AM135
                     Management or Accounts Payable).            AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-PRO-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Proceeds Accounting  This is the accounting unit posted to       AM06.2  AM09.1
Unit                 when cash or items of value are realized    AM115   AM12.1
                     in the disposal of an asset.                AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-COS-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Expense Accounting   This is the expense accounting unit         AM06.2  AM09.1
Unit                 posted to when a cost is associated with    AM115   AM12.1
                     asset disposal.                             AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-GAN-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Gain Accounting Unit This is the accounting unit posted to       AM06.2  AM09.1
                     when a gain is realized in asset            AM115   AM12.1
                     disposal.                                   AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-LOS-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Loss Accounting Unit This is the accounting unit posted to       AM06.2  AM09.1
                     when a loss occurs in asset disposal.       AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-DGN-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Deferred Gain        This is the deferred gain accounting        AM06.2  AM09.1
Accounting Unit      unit posted to when a disposal is a         AM115   AM12.1
                     like-kind exchange.                         AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

AAU-DLS-ACCT-UNIT    Alpha 15                                    AM05.1  AM06.1
Deferred Loss        This is the deferred loss accounting        AM06.2  AM09.1
Accounting Unit      unit posted to when a disposal is a         AM115   AM12.1
                     like-kind exchange.                         AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 AM96.1  AM98.1

                         AMAUGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AAUSET1   COMPANY                                                AM05.1  AM06.1
          AU-GROUP                                               AM06.2  AM09.1
                                                                 AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM205   AM255
                                                                 AM30.1  AM30.2
                                                                 AM35.1  AM40.1
                                                                 AM40.2  AM40.3
                                                                 ...

                         AMAUGROUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcontrol      AMCONTROL    Not Required

                            AAU-COMPANY    -> CTL-COMPANY

Glsystem       GLSYSTEM     Required

                            AAU-COMPANY    -> GLS-COMPANY

                         AMAUGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset1       AMASSET

                            1              -> AST-STATUS
                            AAU-COMPANY    -> AST-COMPANY
                                              AST-DSP-ASSET
                                              AST-ASSET

Amasset2       AMASSET

                            2              -> AST-STATUS
                            AAU-COMPANY    -> AST-COMPANY
                                              AST-DSP-ASSET
                                              AST-ASSET

Amasset3       AMASSET

                            3              -> AST-STATUS
                            AAU-COMPANY    -> AST-COMPANY
                                              AST-DSP-ASSET
                                              AST-ASSET

Amassetadj     AMASSETADJ

                            AAU-COMPANY    -> ASA-COMPANY
                                              ASA-ASSET
                                              ASA-PROCESS-SEQ

Amassetdsp     AMASSET

                            9              -> AST-STATUS
                            AAU-COMPANY    -> AST-COMPANY
                                              AST-DSP-ASSET
                                              AST-ASSET

Amassettrf     AMASSETTRF

                            AAU-COMPANY    -> ATF-COMPANY
                                              ATF-ASSET
                                              ATF-PROCESS-SEQ