ACEMPEXPX FILE
REFERENCED BY
AC258 AC550 AC750 AC54.2 AC542 AC57.1
UPDATED BY
AC58.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEA-ACTIVITY-GRP Alpha 15 AC58.1
Activity Group
AEA-ALL-ACT-FLAG Alpha 1 AC58.1
All Act Flag
AEA-ACTIVITY Alpha 15 AC58.1
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AEA-ACCT-CATEGORY Alpha 5 AC58.1
Account 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.
AEA-EXPENSE-CODE Alpha 20 AC58.1
Expense Code
AEA-GL-CODE Alpha 4 AC58.1
Gl Code
AEA-EXP-ACCT Numeric 6 AC58.1
Exp Acct
AEA-EXP-SUB-ACCT Numeric 4 AC58.1
Depr Expense The general ledger distribution
Subaccount subaccount number.
AEA-EXP-DEFAULT-FL Alpha 1 AC58.1
Exp Default Fl A = Activity Company Account Unit
E = Employee Comp Accounting Unit
ACEMPEXPX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEASET1 ACTIVITY-GRP AC258 AC550
ACTIVITY AC58.1 AC750
ACCT-CATEGORY
EXPENSE-CODE
AEASET2 ACTIVITY-GRP
ACCT-CATEGORY
ACTIVITY
EXPENSE-CODE
AEASET3 ACTIVITY-GRP Subset
ACCT-CATEGORY Where (ALL-ACT-FLAG = "Y" )
ACTIVITY
EXPENSE-CODE
AEASET4 ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
EXPENSE-CODE
AEASET5 EXPENSE-CODE AC54.2 AC542
ACTIVITY-GRP AC57.1
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
Acempexp ACEMPEXP Required
AEA-EXPENSE-CODE -> AEE-EXPENSE-CODE
|
