|
|
ACACCTCAT FILE
Activity Account Categories
This file contains information on account categories from AC05.1 (Account
Categories). In addition to the account category identifier and description,
this file includes the category type and status of the account category, as
well as an error suspense account category flag.
REFERENCED BY
AC06.1 AC07.1 AC08.1 AC10.1 AC10.3 AC115
AC120 AC121 AC123 AC127 AC130 AC14.1
AC15.1 AC15.4 AC160 AC165 AC170 AC176
AC190 AC191 AC196 AC20.1 AC20.2 AC20.3
AC20.4 AC205 AC206 AC207 AC208 AC21.2
AC21.3 AC214 AC215 AC216 AC22.1 AC220
AC240 AC256 AC265 AC27.1 AC290 AC295
AC297 AC30.1 AC30.2 AC30.3 AC30.4 AC32.1
AC40.1 AC400 AC401 AC41.1 AC410 AC415
AC416 AC42.1 AC420 AC421 AC440 AC45.1
AC450 AC460 AC470 AC471 AC473 AC480
AC490 AC50.1 AC500 AC530 AC54.1 AC540
AC55.1 AC580 AC65.1 AC65.2 AC70.1 AC70.3
AC70.4 AC90.1 AC90.2 AC94.1 AC94.3 AC94.5
AC95.1 AC95.2 AC96.1 AC97.1 AC97.2 AC980
ACAC.1 ACBC.1 ACDL.1 AM115 AM118 AM125
AM223 AM224 AM277 AM85.1 BL92.1 GL100
GL122 HAXX.1 HR11.1 HR511 GL00.1 GL00.3
GL160 GL20.2 GL60.1 IN20.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE510 OE810 OE920
PA02.1 PA100 PA102 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PO20.1
PO22.2 PO22.3 PO22.1 HS34.1 PR05.1 PR13.1
PR134 PR20.4 PR30.1 PR55.1 RQ20.1 RQ20.3
RQ20.4 WH20.2 WH20.7 AP125 AP126 AP170
AP193 AP225 AP226 AP25.1 AP25.2 AP26.1
AP30.2 AP30.4 AP32.2 AP520 AP952 AP960
AP961 AP981 AR115 AR124 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1
AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1
AR560 AR570 AR575 AR580 BL120 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL940 BN150 CB10.1 CB180
CB191 CB20.1 CB30.1 CB80.1 CB952 CB980
EE135 EE35.1 EE35.2 EE520 GL199 GL951
HCOP.2 DR100 IC130 IC141 IC142 IC83.1
IFGT.1 MA40.1 MA41.4 MA41.6 MA43.3 MA43.4
MA520 MA530 MA540 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830
OE950 PO100 PO135 PO180 PO21.1 PO21.2
PO21.3 PO21.5 PO21.6 PO25.1 PO25.2 PO25.4
PO26.1 PO28.6 PO30.1 PO31.1 PO32.1 PO33.1
PO34.1 PO35.1 PO530 PO821 PO990 PR128
PR131 PR132 PR136 PR137 PR140 PR150
PR195 PR199 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR37.1 PR38.1 PR45.1
PR530 PR80.1 PR82.1 PR85.1 PRSA.1 UK102
UK330 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ35.1 RQ500 RQ990 UK120 WH130
WH132 WH190 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140 AC210
UPDATED BY
AC05.1 AC730 AC952
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAX-ACCT-CATEGORY Alpha 5 AC05.1 AC730
Account Category Required. Account categories are AC952
groupings of costs, revenues, or
accruals 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.
AAX-DESCRIPTION Alpha 30 (Lower Case) AC05.1 AC730
Account Category This is the account category AC952
Description description.
AAX-CATEGORY-TYPE Alpha 1 AC05.1 AC730
Category Type Required. This field defines the AC952
account category type: revenue, cost, or
accrual.
R = Revenue
A = Accrual
C = Cost
AAX-ACTIVE-FLAG Alpha 1 AC05.1 AC730
Active Flag Required. This field tells whether an AC952
account category is active or inactive.
Only active account categories can be
assigned to activities in AC06.1
(Account Category Assignment).
The default is Active.
A = Active
I = Inactive
AAX-ES-ACCT-CAT-FL Alpha 1 AC05.1 AC730
Error Suspense Acct This is the error suspense account AC952
Category category flag. "Yes" identifies one
account category as the error suspense
account category.
Y = Yes
N = No
ACACCTCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAXSET1 ACCT-CATEGORY AC05.1 AC06.1
AC07.1 AC08.1
AC10.1 AC10.3
AC115 AC120
AC121 AC123
AC127 AC130
AC14.1 AC15.1
AC15.4 AC160
AC165 AC170
AC176 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC205 AC206
AC207 AC208
...
AAXSET2 ACCT-CATEGORY Subset AC05.1 AC06.1
Where (ES-ACCT-CAT-FL = "Y" ) AC190 AC191
AC196 AC40.1
AC530 ACAC.1
AP125 AP126
AP170 AP193
AP225 AP226
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP952
AP960 AP961
AP981 AR115
AR124 AR190
AR20.1 AR21.1
...
AAXSET4 ACCT-CATEGORY Subset AC160 AC210
Where (CATEGORY-TYPE = "C" )
ACACCTCAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
AAX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
AXX-ACTIVITY-GRP
AXX-ACTIVITY
|