|
ACIFCATX FILE
UPDATED BY
AC58.2 AC58.4 AC58.1 AC558
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CIX-STRUCTURE Alpha 15 AC58.2
Element: Structure The name of the category structure.
CIX-SUM-ACCT-CAT Alpha 5 AC58.2
Element: Sum Acct Cat The name of the summary account
category.
CIX-ACCT-CATEGORY Alpha 5 AC58.2
Element: Acct Category 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
CIX-DESCRIPTION Alpha 30 (Lower Case) AC58.2
Element: Description This field displays the description.
CIX-CATEGORY-TYPE Alpha 1
Element: Category Type This Field is used to set up the
default category type for the
Distribution File.
(EEDISTRIB)
R = Revenue
C = Cost
P = Pass Thru
A = Accrual
CIX-ACTIVE-STATUS Alpha 1 AC58.2
Element: Active Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
CIX-BILLABLE-FLAG Alpha 1 AC58.2
Element: Billable Y = Yes
N = No
CIX-CAPITAL-FLAG Alpha 1 AC58.2
Element: Capital Flag This field indicates whether an
activity/account category is to be
capitalized.
Y = Yes
N = No
CIX-REVENUE-FLAG Alpha 1 AC58.2
Element: Revenue Flag This flag identifies whether an
activity/account category is eligible
for revenue recognition.
Y = Yes
N = No
CIX-TM-FLAG Alpha 1 AC58.2
Element: Tm Flag This flag indicates whether this
account category represents time (labor)
or materials for T&M processing.
M = Materials
T = Time
CIX-MARK-UP-PCT Signed 5.2 AC58.2
Element: Mark Up Pct 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.
CIX-MATRIX-CAT Alpha 12 Occurs 11 Times AC58.4
Element: Matrix Cat Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
CIX-MX-VALUE Alpha 32 Occurs 11 Times AC58.4
Element: Mx Value The attribute value.
ACIFCATX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIXSET1 STRUCTURE AC558 AC58.1
ACCT-CATEGORY AC58.2 AC58.4
CIXSET2 STRUCTURE KeyChange AC558 AC58.1
SUM-ACCT-CAT AC58.2
ACCT-CATEGORY
ACIFCATX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
CIX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
ACIFCATX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acifcat ACIFCAT
CIX-STRUCTURE -> CIF-STRUCTURE
CIF-SUM-ACCT-CAT
|