Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMAUGROUP


                             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

AM152     AM205     AM220     AM221     AM240     AM25.1
AM25.2    AM255     AM260     AM267     AM278     AM280
AM287     AM35.2    AM45.1    AM45.2    AM70.4    AM90.3
AM91.3    AM95.3    AMDL.1    AP30.2

UPDATED BY

AM05.1    AM06.1    AM06.2    AM06.3    AM06.5    AM09.1
AM115     AM117     AM12.1    AM125     AM135     AM145
AM15.1    AM15.2    AM15.3    AM15.4    AM154     AM170
AM180     AM190     AM192     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM206     AM21.1    AM21.2
AM21.3    AM21.4    AM21.5    AM21.6    AM211     AM230
AM282     AM30.1    AM30.2    AM40.1    AM40.2    AM40.3
AM500     AM502     AM551     AM88.7    AM92.1    AM96.1
AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AAU-COMPANY            Numeric 4                                 AM05.1  AM06.1
Element: Company       This is the general ledger company        AM06.2  AM06.3
                       number associated with the accounting     AM06.5  AM09.1
                       unit group.                               AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-AU-GROUP           Alpha 10                                  AM05.1  AM06.1
Accounting Unit        This is a user-defined accounting unit    AM06.2  AM06.3
Group                  group, identifying the accounting units   AM06.5  AM09.1
                       to use when processing assets.            AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Description            the accounting unit group.                AM06.5  AM09.1
                                                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Unit                   create journal entries for an asset. It   AM06.5  AM09.1
                       is a shorthand notation representing the  AM115   AM117
                       variable level number. The accounting     AM12.1  AM125
                       unit must be defined in the GL Names      AM135   AM145
                       file as a posting accounting unit.        AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Acct Unit              accumulated depreciation is posted.       AM06.5  AM09.1
                                                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Accounting Unit        depreciation expense is posted.           AM06.5  AM09.1
                                                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Unit                   when adding an asset through other        AM06.5  AM09.1
                       applications (such as Activity            AM115   AM117
                       Management or Accounts Payable).          AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
Unit                   when cash or items of value are realized  AM06.5  AM09.1
                       in the disposal of an asset.              AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-COS-ACCT-UNIT      Alpha 15                                  AM05.1  AM06.1
Expense Accounting     This is the expense accounting unit       AM06.2  AM06.3
Unit                   posted to when a cost is associated with  AM06.5  AM09.1
                       asset disposal.                           AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-GAN-ACCT-UNIT      Alpha 15                                  AM05.1  AM06.1
Element: Gain AccountinThis is the accounting unit posted to     AM06.2  AM06.3
                       when a gain is realized in asset          AM06.5  AM09.1
                       disposal.                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-LOS-ACCT-UNIT      Alpha 15                                  AM05.1  AM06.1
Element: Loss AccountinThis is the accounting unit posted to     AM06.2  AM06.3
                       when a loss occurs in asset disposal.     AM06.5  AM09.1
                                                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-DGN-ACCT-UNIT      Alpha 15                                  AM05.1  AM06.1
Deferred Gain          This is the deferred gain accounting      AM06.2  AM06.3
Accounting Unit        unit posted to when a disposal is a       AM06.5  AM09.1
                       like-kind exchange.                       AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

AAU-DLS-ACCT-UNIT      Alpha 15                                  AM05.1  AM06.1
Deferred Loss          This is the deferred loss accounting      AM06.2  AM06.3
Accounting Unit        unit posted to when a disposal is a       AM06.5  AM09.1
                       like-kind exchange.                       AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM206
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM211   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  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  AM06.3
                                                                 AM06.5  AM09.1
                                                                 AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM152   AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM205   AM206
                                                                 ...

AAUSET2   AU-GROUP      KeyChange                                AM115   AM117
          COMPANY                                                AM12.1  AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM220
                                                                 AM221   AM230
                                                                 AM240   AM255
                                                                 AM260   AM267
                                                                 AM278   AM280
                                                                 AM287

                         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