|
|
ACCATSUMX FILE
Account Category Summ Detail
This file contains all account categories assigned to the summary account
cateogries in the category structure. This file is maintained via AC08.3
(Account Category Detail).
REFERENCED BY
AC01.1 AC05.1 AC06.1 AC06.2 AC07.1 AC10.1
AC10.3 AC105 AC112 AC113 AC12.1 AC120
AC121 AC123 AC127 AC128 AC130 AC131
AC135 AC145 AC16.2 AC16.3 AC16.4 AC16.7
AC16.8 AC16.9 AC160 AC165 AC169 AC19.1
AC190 AC191 AC197 AC198 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC22.1 AC220 AC225 AC240 AC246 AC261
AC265 AC27.1 AC290 AC295 AC298 AC30.1
AC30.2 AC30.3 AC30.4 AC310 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC37.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC412
AC42.1 AC420 AC421 AC440 AC45.1 AC45.4
AC46.1 AC46.2 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC50.1 AC500
AC527 AC54.1 AC540 AC55.1 AC56.1 AC560
AC580 AC581 AC583 AC61.1 AC65.1 AC65.2
AC69.1 AC704 AC90.1 AC90.2 AC90.4 AC90.6
AC90.8 AC92.1 AC92.2 AC92.4 AC92.6 AC93.1
AC93.2 AC93.3 AC93.4 AC93.5 AC94.1 AC94.2
AC94.4 AC94.6 AC95.1 AC95.2 AC95.4 AC95.6
ACAC.1 ACBC.1 ACDL.1 ACDM.2 ACDM.3 ACDR.1
ACVW.1 ATVW.1 SE90.1 AP125 AP126 AP131
AP170 AP190 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP211 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP520 API1.1 API2.1 AR115 AR124 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR237 AR239
AR24.1 AR250 AR257 AR27.2 AR29.1 AR29.2
AR296 AR30.1 AR30.5 AR32.1 AR33.2 AR34.1
AR38.5 AR39.3 AR39.4 AR42.1 AR42.2 AR42.7
AR43.1 AR502 AR503 AR55.1 AR560 AR570
AR575 AR580 AR800 AR91.1 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN150
BN66.1 BR00.1 BR00.2 BR00.3 BR01.1 BR01.2
BR02.3 BR03.1 BR03.2 BR03.3 BR05.1 BR05.2
BR05.3 BR05.4 BR05.5 BR10.1 BR10.3 BR12.2
BR120 BR121 BR122 BR123 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR18.1
BR18.2 BR19.1 BR19.2 BR190 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.6 BR20.9 BR200
BR202 BR204 BR205 BR210 BR212 BR215
BR220 BR245 BR251 BR252 BR253 BR254
BR265 BR300 BR40.1 BR40.3 BR40.4 BR400
BR405 BR41.1 BR41.4 BR42.1 BR420 BR422
BR43.1 BR430 BR44.1 BR450 BR46.1 BR46.2
BR46.4 BR51.1 BR51.2 BR52.1 BR521 BR530
BR54.1 BR54.2 BR54.3 BR54.4 BR570 BR580
BR65.1 BR65.2 BR65.3 BR70.1 BR70.2 BRIP.1
CB10.1 CB15.1 CB15.2 CB150 CB180 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB80.1 CB82.1 CXCP.1
EE135 EE20.3 EE35.1 EE35.2 EE520 ET530
ET540 ET542 ET700 ETI2.1 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 IFGT.1 MX123
MX500 LP130 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PA182
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO135 PO150
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POCP.1 POD0.1 POI3.1 POID.1 POIF.1
POIG.1 POII.1 POIJ.1 PR128 PR130 PR131
PR132 PR134 PR136 PR137 PR140 PR189
PR195 PR197 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR37.1
PR38.1 PR45.1 PR529 PR530 PR560 PR80.1
PR82.1 PR85.1 PR89.1 UK102 UK330 UK560
PW110 PW510 RQ10.1 RQ10.2 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQD0.1 RQIF.1 SB15.1
SB515 SN02.1 TA147 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 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 AC208 MX202 MX223
UPDATED BY
AC08.2 AC08.3 AC08.4 AC08.5 AC08.7 AC108
AC558 AC708
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRX-STRUCTURE Alpha 15 AC08.3 AC08.4
Element: Structure The name of the category structure. AC08.5 AC558
SRX-SUM-ACCT-CAT Alpha 5 AC08.3 AC08.5
Element: Sum Acct Cat The name of the summary account AC08.7 AC108
category. AC558
SRX-ACCT-CATEGORY Alpha 5 AC08.3 AC08.5
Element: Acct Category Account categories are groupings of AC558
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
SRX-ACTIVE-STATUS Alpha 1 AC08.3 AC08.5
Element: Active Status The status of the detail account AC558
category. Valid values include:
A - Active
I - Inactive
A = Active
I = Inactive
SRX-BILLABLE-FLAG Alpha 1 AC08.3 AC08.5
Element: Billable This flag indicates whether an account AC558
category is billable. The default is No.
Y = Yes
N = No
SRX-CAPITAL-FLAG Alpha 1 AC08.3 AC08.5
Element: Capital Flag This flag indicates whether an account AC558
category is to be capitalized.
Y = Yes
N = No
SRX-REVENUE-FLAG Alpha 1 AC08.3 AC08.5
Element: Revenue Flag This flag identifies whether an account AC558
category is eligible for revenue
recognition.
Y = Yes
N = No
SRX-TM-FLAG Alpha 1 AC08.3 AC08.5
Element: Tm Flag This flag indicates whether this account AC558
category represents time (labor) or
materials for T&M processing.
M = Materials
T = Time
SRX-MARK-UP-PCT Signed 5.2 AC08.3 AC08.5
Element: Mark Up Pct This field indicates the percentage of AC558
markup for billing. If an account
category is billable, a markup
percentage can be established. A rate
scheudled is for labor transactions
only. Markup percentages will increase
teh cost amount by the percentage
entered.
SRX-NEW-SUM-CAT Alpha 5 AC08.7 AC108
Element: Sum Acct Cat The name of the summary account
category.
SRX-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC08.7 AC108
Element: Effective DateThe date a vendor's prices will be in
effect.
SRX-UPD-USR-ID Alpha 10 AC08.7 AC108
Element: Operator This field is used to store the login
id of the person who entered the record.
SRX-OBJ-ID Numeric 12 AC08.3 AC08.4
Element: Obj Id This is the object identifier. It is AC08.5 AC558
used to relate commitments or posted AC708
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
ACCATSUMX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRXSET1 STRUCTURE AC01.1 AC05.1
ACCT-CATEGORY AC06.1 AC06.2
AC07.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.7
AC10.1 AC10.3
AC105 AC108
AC112 AC113
AC12.1 AC120
AC121 AC123
AC127 AC128
AC130 AC131
AC135 AC145
AC16.2 AC16.3
AC16.4 AC16.7
...
SRXSET2 STRUCTURE KeyChange AC08.1 AC08.3
SUM-ACCT-CAT AC08.5 AC08.6
ACCT-CATEGORY AC08.7 AC108
AC208 AC400
AC410 AC494
AC708 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
ACBC.1 BR18.2
BR190 BR65.3
SRXSET3 OBJ-ID KeyChange AC01.1 AC105
STRUCTURE AC112 AC113
ACCT-CATEGORY AC120 AC121
AC123 AC128
AC135 AC145
AC16.3 AC16.4
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
SRXSET4 ACCT-CATEGORY KeyChange AC01.1 AC105
STRUCTURE AC112 AC113
SUM-ACCT-CAT AC120 AC121
AC123 AC128
AC135 AC145
AC16.3 AC16.8
AC16.9 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
...
ACCATSUMX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
SRX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Accatsum ACCATSUM Required
SRX-STRUCTURE -> SRS-STRUCTURE
SRX-SUM-ACCT-CAT -> SRS-SUM-ACCT-CAT
Structure STRUCTURE Required
SRX-STRUCTURE -> SRE-STRUCTURE
ACCATSUMX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
SRX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
AXX-ACTIVITY-GRP
AXX-ACTIVITY
Accatmxval ACCATMXVAL
SRX-OBJ-ID -> AJB-OBJ-ID
AJB-MATRIX-CAT
Accatmxvdt ACCATMXVDT
SRX-OBJ-ID -> MXB-OBJ-ID
MXB-MATRIX-CAT
MXB-EFFECTIVE-DATE
Mxlistmbr MXLISTMBR
"ACCAT" -> MLM-OBJ-TYPE
SRX-OBJ-ID -> MLM-OBJ-ID
MLM-MATRIX-LIST
Sum Act Detail ACCATSUM
SRX-STRUCTURE -> SRS-STRUCTURE
SRS-SUM-ACCT-CAT
|
