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 AM35.1 AM45.1
UPDATED BY
AM05.1 AM115 AM12.1 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM192
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM30.1 AM40.1 AM40.2 AM40.3 AM500 AM950
AM951 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 AM135 AM145
for posting journal entries when assets AM15.1 AM15.2
are processed. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM950
AM951 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 AM135 AM145
used to create journal entries when AM15.1 AM15.2
assets are processed (added, adjusted, AM15.3 AM15.4
transferred, or disposed of). AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM950
AM951 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. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM40.1
AM40.2 AM40.3
AM500 AM950
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
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM205 AM30.1
AM35.1 AM40.1
AM40.2 AM40.3
AM45.1 AM500
AM96.1 AM98.1
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
|