|
|
ACCATGRPX FILE
Account Category Group Detail
The Account Category Group Detail file stores the specific account category
names that make up a group. If the All flag is set on the Account Category
Group Header file, there are no detail records. Account Category Groups are
defined on AC08.1
REFERENCED BY
AC08.5 AC105 AC121 AC123 AC130 AC145
AC165 AC190 AC197 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC205 AC240 AC246 AC256
AC290 AC295 AC298 AC30.1 AC32.1 AC34.1
AC346 AC37.1 AC40.1 AC40.4 AC401 AC41.1
AC41.4 AC410 AC42.1 AC440 AC46.1 AC460
AC471 AC480 AC490 AC494 AC55.1 AC65.1
AC65.2 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC94.1 AC94.2
AC94.4 AC94.6 AC95.1 AC95.2 AC95.4 AC95.6
ACAC.1 ACBC.1 ACDL.1 ACDM.3 ACVW.1 SE90.1
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP520 BR02.3 BR120 BR121 BR122
BR130 BR140 BR142 BR18.2 BR190 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR41.1 BR41.4
BR420 BR43.1 BR450 BR515 BR516 BR521
BR530 BR65.1 BR65.2 BRCC.1 CB10.1 CB15.1
CB15.2 CB191 CB20.1 CB30.1 CB500 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL199 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 MA65.1
UPDATED BY
AC05.2 AC05.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGX-CAT-GROUP Alpha 15 AC05.2 AC05.3
Element: Cat Group
CGX-ACCT-CATEGORY Alpha 5 AC05.2 AC05.3
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
ACCATGRPX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGXSET1 CAT-GROUP AC05.2 AC05.3
ACCT-CATEGORY AC08.5 AC105
AC121 AC123
AC130 AC145
AC165 AC190
AC197 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC205 AC240
AC246 AC256
AC290 AC295
AC298 AC30.1
AC32.1 AC34.1
AC346 AC37.1
AC40.1 AC40.4
...
ACCATGRPX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
CGX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Accatgrp ACCATGRP Required
CGX-CAT-GROUP -> CGP-CAT-GROUP
|
