|
|
ACEMPEXPX FILE
UPDATED BY
AC105 AC110 AC120 AC300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEA-ACTIVITY-GRP Alpha 15 AC105 AC110
Element: Activity GroupThe activity group is the overall AC120
project.
AEA-ACTIVITY Alpha 15 AC105 AC110
Element: Activity Activities are the processes or AC120
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AEA-ACCT-CATEGORY Alpha 5 AC105
Element: Account CategoAccount 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
AEA-EXPENSE-CODE Alpha 20 AC105
Element: Expense Code
AEA-GL-CODE Alpha 4 AC105
Element: Gl Code
AEA-EXP-ACCT Numeric 6 AC105
Element: Exp Acct
AEA-EXP-SUB-ACCT Numeric 4 AC105
Element: Subaccount The general ledger distribution
subaccount number.
AEA-EXP-DEFAULT-FL Alpha 1 AC105
Element: Exp Default FlA = Activity Company Account Unit
E = Employee Comp Accounting Unit
ACEMPEXPX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEASET1 ACTIVITY-GRP AC105 AC110
ACTIVITY AC120 AC300
ACCT-CATEGORY
EXPENSE-CODE
AEASET5 EXPENSE-CODE
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
ACEMPEXPX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AEA-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
|
