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 AM95.3 AM205 AM75.3 AM80.3 AM85.3
AM90.3 AM91.3 AM93.1


UPDATED BY
AC160 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 AM22.1 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 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC140 IC66.1 IC83.1 MA180 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
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 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 ZW130

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


AMACCTGRP FILE INDEX

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


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: Thu Jun 09 11:05:20 2016

Home
Contact Us



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