 |
Lawson Insight Technical Documentation |
|
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
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
AM05.1 AM115 AM12.1 AM125 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 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 AM551
AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAG-COMPANY Numeric 4 AM05.1 AM115
Company This is the general ledger company AM12.1 AM125
number for the account group. It is used AM145 AM15.1
for posting journal entries when assets AM15.2 AM15.3
are processed. AM15.4 AM154
AM170 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 AM551
AM96.1 AM98.1
AAG-ACCT-GRP Alpha 10 AM05.1 AM115
Account Group This is the user-defined account group, AM12.1 AM125
identifying the general ledger accounts AM145 AM15.1
used to create journal entries when AM15.2 AM15.3
assets are processed (added, adjusted, AM15.4 AM154
transferred, or disposed of). AM170 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 AM551
AM96.1 AM98.1
AAG-DESCRIPTION Alpha 30 (Lower Case) AM05.1 AM115
Description The user-defined description of the AM12.1 AM125
account group. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM551
AM96.1 AM98.1
AMACCTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAGSET1 COMPANY AM05.1 AM115
ACCT-GRP AM12.1 AM125
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM25.1
AM25.2 AM30.1
AM35.2 AM40.1
...
AAGSET2 ACCT-GRP KeyChange AM115 AM12.1
COMPANY AM15.1 AM15.2
AM15.3 AM15.4
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
|