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