Lawson Insight Technical Documentation |
|
AMACCTGRP
AMACCTGRP FILE
Asset Account Group
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.
REFERENCED BY
AM135 AM205 AM25.1 AM25.2 AM35.2 AM45.1
AM45.2 AM70.4 AM75.3 AM80.3 AM85.3 AM90.3
AM91.3 AM93.1 AM95.3
UPDATED BY
AC160 AM05.1 AM115 AM117 AM12.1 AM125
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM170 AM19.1 AM19.2 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 AM30.1 AM40.1
AM40.2 AM40.3 AM500 AM502 AM551 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
AAG-COMPANY Numeric 4 AC160 AM05.1
Element: Company This is the general ledger company AM115 AM117
number for the account group. It is used AM12.1 AM125
for posting journal entries when assets AM145 AM15.1
are processed. AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 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
...
AAG-ACCT-GRP Alpha 10 AC160 AM05.1
Element: Account Group This is the user-defined account group, AM115 AM117
identifying the general ledger accounts AM12.1 AM125
used to create journal entries when AM145 AM15.1
assets are processed (added, adjusted, AM15.2 AM15.3
transferred, or disposed of). AM15.4 AM154
AM170 AM19.1
AM19.2 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
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 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
...
AAG-DESCRIPTION Alpha 30 (Lower Case) AC160 AM05.1
Element: Description The user-defined description of the AM115 AM117
account group. AM12.1 AM125
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 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
...
AMACCTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAGSET1 COMPANY AC160 AM05.1
ACCT-GRP AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM205
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
...
AAGSET2 ACCT-GRP KeyChange AC160 AM115
COMPANY AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
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
...
AMACCTGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amcontrol AMCONTROL Not Required
AAG-COMPANY -> CTL-COMPANY
Glsystem GLSYSTEM Required
AAG-COMPANY -> GLS-COMPANY
AMACCTGRP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amaccount AMACCOUNT Delete Cascades
AAG-COMPANY -> AAC-COMPANY
AAG-ACCT-GRP -> AAC-ACCT-GRP
Spaces -> AAC-ASSET-TYPE
Spaces -> AAC-SUB-TYPE
AAC-ACCT-TYPE
Amasset1 AMASSET
1 -> AST-STATUS
AAG-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amasset2 AMASSET
2 -> AST-STATUS
AAG-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amasset3 AMASSET
3 -> AST-STATUS
AAG-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amassetadj AMASSETADJ
AAG-COMPANY -> ASA-COMPANY
ASA-ASSET
ASA-PROCESS-SEQ
Amassetdsp AMASSET
9 -> AST-STATUS
AAG-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amassettrf AMASSETTRF
AAG-COMPANY -> ATF-COMPANY
ATF-ASSET
ATF-PROCESS-SEQ
|