Lawson Insight Technical Documentation |
|
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 AM258 AM260 AM267 AM278
AM280 AM287 AM35.2 AM45.1 AM45.2 AM70.4
AM90.3 AM91.3 AM95.3 AMDL.1
UPDATED BY
AC160 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
AM17.1 AM170 AM180 AM19.1 AM19.2 AM190
AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5
AM20.6 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM230 AM282 AM30.1 AM30.2 AM30.3
AM40.1 AM40.2 AM40.3 AM40.4 AM41.1 AM41.2
AM500 AM502 AM551 AM88.7 AM92.1 AM96.1
AM98.1 AP115 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 API1.1 API2.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAU-COMPANY Numeric 4 AC160 AM05.1
Element: Company This is the general ledger company AM06.1 AM06.2
number associated with the accounting AM06.3 AM06.5
unit group. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-AU-GROUP Alpha 10 AC160 AM05.1
Accounting Unit This is a user-defined accounting unit AM06.1 AM06.2
Group group, identifying the accounting units AM06.3 AM06.5
to use when processing assets. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-DESCRIPTION Alpha 30 (Lower Case) AC160 AM05.1
Acct Unit Group This field displays the description of AM06.1 AM06.2
Description the accounting unit group. AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-AST-ACCT-UNIT Alpha 15 AC160 AM05.1
Asset Accounting This is the accounting unit used to AM06.1 AM06.2
Unit create journal entries for an asset. It AM06.3 AM06.5
is a shorthand notation representing the AM09.1 AM115
variable level number. The accounting AM117 AM12.1
unit must be defined in the GL Names AM125 AM135
file as a posting accounting unit. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-ACM-ACCT-UNIT Alpha 15 AC160 AM05.1
Accumulated Depr This is the accounting unit to which AM06.1 AM06.2
Acct Unit accumulated depreciation is posted. AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-EXP-ACCT-UNIT Alpha 15 AC160 AM05.1
Depr Expense This is the accounting unit to which AM06.1 AM06.2
Accounting Unit depreciation expense is posted. AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-CLR-ACCT-UNIT Alpha 15 AC160 AM05.1
Clearing Accounting This is the accounting unit posted to AM06.1 AM06.2
Unit when adding an asset through other AM06.3 AM06.5
applications (such as Activity AM09.1 AM115
Management or Accounts Payable). AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-PRO-ACCT-UNIT Alpha 15 AC160 AM05.1
Proceeds Accounting This is the accounting unit posted to AM06.1 AM06.2
Unit when cash or items of value are realized AM06.3 AM06.5
in the disposal of an asset. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-COS-ACCT-UNIT Alpha 15 AC160 AM05.1
Expense Accounting This is the expense accounting unit AM06.1 AM06.2
Unit posted to when a cost is associated with AM06.3 AM06.5
asset disposal. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-GAN-ACCT-UNIT Alpha 15 AC160 AM05.1
Element: Gain AccountinThis is the accounting unit posted to AM06.1 AM06.2
when a gain is realized in asset AM06.3 AM06.5
disposal. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-LOS-ACCT-UNIT Alpha 15 AC160 AM05.1
Element: Loss AccountinThis is the accounting unit posted to AM06.1 AM06.2
when a loss occurs in asset disposal. AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-DGN-ACCT-UNIT Alpha 15 AC160 AM05.1
Deferred Gain This is the deferred gain accounting AM06.1 AM06.2
Accounting Unit unit posted to when a disposal is a AM06.3 AM06.5
like-kind exchange. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AAU-DLS-ACCT-UNIT Alpha 15 AC160 AM05.1
Deferred Loss This is the deferred loss accounting AM06.1 AM06.2
Accounting Unit unit posted to when a disposal is a AM06.3 AM06.5
like-kind exchange. AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
...
AMAUGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAUSET1 COMPANY AC160 AM05.1
AU-GROUP 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 AM152
AM154 AM17.1
AM170 AM180
AM19.1 AM19.2
AM19.4 AM190
AM192 AM20.1
AM20.2 AM20.3
...
AAUSET2 AU-GROUP KeyChange AC160 AM115
COMPANY AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM278
AM280 AM287
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
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
|