ACCATSUMX

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
AC00.1 AC00.2 AC00.3 AC01.1 AC02.1 AC05.1
AC05.2 AC05.3 AC06.1 AC06.2 AC07.1 AC10.1
AC10.3 AC105 AC112 AC113 AC12.1 AC120
AC121 AC123 AC127 AC128 AC130 AC131
AC135 AC145 AC147 AC16.2 AC16.3 AC16.4
AC16.7 AC16.8 AC16.9 AC160 AC165 AC169
AC19.1 AC190 AC191 AC196 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC200 AC203 AC206 AC207 AC208
AC21.5 AC210 AC213 AC218 AC22.1 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC27.1 AC290 AC295 AC297 AC298
AC30.1 AC30.2 AC30.3 AC30.4 AC310 AC311
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 AC97.1 AC97.2 AC97.4 AC97.6
ACAC.1 ACBC.1 ACBD.2 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 AP510 AP520 API1.1 API2.1 ARLL.1
BN150 BN66.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 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 CB57.1 CB80.1 CB82.1 CX05.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL199 GL299 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 GL76.1
PR521 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 EX175 EX542 EX545 EXI2.1
EXI4.1 IFEB.1 IFGT.1 IFUC.1 MX123 MX500
LP130 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA65.1 MA66.2 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 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO135 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO18.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.2 PO26.3 PO26.4 PO26.5 PO26.6 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 POD0.1 POI3.1
POID.1 POIF.1 POIG.1 POII.1 POIJ.1 POIK.1
PR128 PR131 PR132 PR134 PR135 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 PR36.4 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 PR85.1 PR89.1 PRAT.1 UK102 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 RQD0.1 RQIB.1 RQIF.1 RQII.1 RQIJ.1
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 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 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
Element: Structure
Alpha 15
The name of the category structure.
AC08.3 AC08.4
AC08.5 AC558
SRX-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC08.3 AC08.5
AC08.7 AC108
AC558
SRX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account 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
AC00.1 AC00.2
AC00.3 AC02.1
AC05.2 AC05.3
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC10.1
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC558
SRX-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the detail account category. Valid values include: A - Active I - Inactive
A = Active
I = Inactive
AC08.3 AC08.5
AC558
SRX-BILLABLE-FLAG
Element: Billable
Alpha 1
This flag indicates whether an account category is billable. The default is No.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-CAPITAL-FLAG
Element: Capital Flag
Alpha 1
This flag indicates whether an account category is to be capitalized.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-REVENUE-FLAG
Element: Revenue Flag
Alpha 1
This flag identifies whether an account category is eligible for revenue recognition.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-TM-FLAG
Element: Tm Flag
Alpha 1
This flag indicates whether this account category represents time (labor) or materials for T&M processing.
M = Materials
T = Time
AC08.3 AC08.5
AC558
SRX-MARK-UP-PCT
Element: Mark Up Pct
Signed 5.2
This field indicates the percentage of 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.
AC08.3 AC08.5
AC558
SRX-NEW-SUM-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC08.5 AC08.7
AC108
SRX-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
AC08.5 AC08.7
AC108
SRX-UPD-USR-ID
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AC08.5 AC08.7
AC108
SRX-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted 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.
AC08.3 AC08.4
AC08.5 AC558
AC708


ACCATSUMX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRXSET1 STRUCTURE
ACCT-CATEGORY
...
AC00.1 AC00.2
AC00.3 AC01.1
AC02.1 AC05.1
AC05.2 AC05.3
AC06.1 AC06.2
AC07.1 AC08.1
AC08.2 AC08.3
AC08.4 AC08.5
AC08.6 AC08.7
AC10.1 AC10.3
AC105 AC108
AC112 AC113
AC12.1 AC120
AC121 AC123
AC127 AC128
SRXSET2 STRUCTURE
SUM-ACCT-CAT
ACCT-CATEGORY
KeyChange
...
AC08.1 AC08.3
AC08.5 AC08.6
AC08.7 AC108
AC208 AC295
AC297 AC400
AC410 AC420
AC480 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
AC97.2 ACBC.1
SRXSET3 OBJ-ID
STRUCTURE
ACCT-CATEGORY
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.4 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
SRXSET4 ACCT-CATEGORY
STRUCTURE
SUM-ACCT-CAT
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.8 AC16.9
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220


ACCATSUMX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Acctsmxbod ACCTSMXBOD Not Required, Delete Cascades
SRX-STRUCTURE->YAG-STRUCTURE
SRX-ACCT-CATEGORY->YAG-ACCT-CATEGORY
Structure STRUCTURE Required
SRX-STRUCTURE->SRE-STRUCTURE


ACCATSUMX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:02:55 2016

Home
Contact Us



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