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
AC10.1 AC10.3 AC56.1 AC560 AC71.1 AM06.1
AM06.2 AM06.3 AM06.5 AM08.1 AM08.2 AM09.1
AM135 AM155 AM16.1 AM17.1 AM180 AM190
AM205 AM230 AM25.1 AM25.2 AM282 AM35.2
AM41.1 AM41.2 AM45.1 AM45.2 AM70.4 AM75.3
AM80.3 AM85.3 AM88.7 AM90.3 AM91.3 AM93.1
AM95.3 AP22.2


UPDATED BY
AC160 AM05.1 AM115 AM117 AM12.1 AM12.2
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 AM22.1
AM22.2 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 AP510 API1.1 API2.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 MA126 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830

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.
...
AC160 AM05.1
AM115 AM117
AM12.1 AM12.2
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 AM22.1
AM22.2 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
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).
...
AC160 AM05.1
AM115 AM117
AM12.1 AM12.2
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 AM22.1
AM22.2 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
AAG-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The user-defined description of the account group.
...
AC160 AM05.1
AM115 AM117
AM12.1 AM12.2
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 AM22.1
AM22.2 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


AMACCTGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAGSET1 COMPANY
ACCT-GRP
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM05.1 AM06.1
AM06.2 AM06.3
AM06.5 AM08.1
AM08.2 AM09.1
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 AM16.1
AM17.1 AM170
AAGSET2 ACCT-GRP
COMPANY
KeyChange
...
AC160 AM115
AM117 AM12.1
AM12.2 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


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
Amacctgpau AMACCTGPAU
AAG-COMPANY->AGD-COMPANY
AAG-ACCT-GRP->AGD-ACCT-GRP
  AGD-ACTION
  AGD-DATE
  AGD-TIME
  AGD-UNIQUE-I-D
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: Thu Jun 09 02:04:36 2016

Home
Contact Us



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