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
ACAC.1 AP125 AP126 AP131 AP170 AP190
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP520 API1.1 API2.1
BN150 BN66.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 EE11.1 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 PR521 EX175 EX542 EX545 EXI2.1
EXI4.1 IFEB.1 IFGT.1 IFUC.1 LP130 LP140
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PA182
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POIF.1 POIG.1 POII.1 POIJ.1 PR128 PR130
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 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
PR89.1 UK102 UK330 UK560 TA147


UPDATED BY
AC10.1 AC200 AC210 ACVW.1 AP211 GL299
MX123 MX500 SN02.1 MX202 MX223

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRX-STRUCTURE
Element: Structure		Alpha 15
The name of the category structure.
SRX-SUM-ACCT-CAT
Element: Sum Acct Cat		Alpha 5
The name of the summary account category.
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
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
SRX-BILLABLE-FLAG
Element: Billable		Alpha 1
This flag indicates whether an account category is billable. The default is No.
Y = Yes
N = No
SRX-CAPITAL-FLAG
Element: Capital Flag		Alpha 1
This flag indicates whether an account category is to be capitalized.
Y = Yes
N = No
SRX-REVENUE-FLAG
Element: Revenue Flag		Alpha 1
This flag identifies whether an account category is eligible for revenue recognition.
Y = Yes
N = No
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
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.
SRX-NEW-SUM-CAT
Element: Sum Acct Cat		Alpha 5
The name of the summary account category.
SRX-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
SRX-UPD-USR-ID
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
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.


ACCATSUMX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRXSET1 STRUCTURE
ACCT-CATEGORY
...
AC10.1 AC10.3
AC200 AC210
ACAC.1 ACVW.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
SRXSET2 STRUCTURE
SUM-ACCT-CAT
ACCT-CATEGORY
KeyChange
SRXSET3 OBJ-ID
STRUCTURE
ACCT-CATEGORY
KeyChange
AC200 AC210
AP211 GL299
MX123 MX202
MX223 MX500
SN02.1
SRXSET4 ACCT-CATEGORY
STRUCTURE
SUM-ACCT-CAT
KeyChange
AC200 AC210
AP211 GL299
MX123 MX500
SN02.1


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
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: Wed Jun 08 20:46:54 2016

Home
Contact Us



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