AMACCTGRP

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 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
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 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POII.1 POIJ.1
AM205

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAG-COMPANY
Element: Company
Numeric 4
This is the general ledger company number for the account group. It is used for posting journal entries when assets are processed.
...
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 MA41.1
AAG-ACCT-GRP
Element: Account Group
Alpha 10
This is the user-defined account group, identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).
...
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 MA41.1
AAG-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The user-defined description of the account group.
...
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 MA41.1


AMACCTGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAGSET1 COMPANY
ACCT-GRP
...
AM05.1 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 AM25.1
AAGSET2 ACCT-GRP
COMPANY
KeyChange
...
AM115 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 API1.1


AMACCTGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
  AAC-ASSET-EVENT
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


File created: Wed Jun 08 20:47:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.