ACEMPEXPX FILE
REFERENCED BY
AC258 AC550 AC54.2 AC542 AC57.1
UPDATED BY
AC105 AC110 AC120 AC300 AC58.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEA-ACTIVITY-GRP Alpha 15 AC105 AC110
Activity Group AC120 AC58.1
AEA-ALL-ACT-FLAG Alpha 1 AC105 AC110
All Act Flag AC120 AC58.1
AEA-ACTIVITY Alpha 15 AC105 AC110
Activity Activities are the processes or AC120 AC58.1
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 AC110
Account Category Account categories are groupings of AC120 AC58.1
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 AC105 AC110
Expense Code AC120 AC58.1
AEA-GL-CODE Alpha 4 AC105 AC110
Gl Code AC120 AC58.1
AEA-EXP-ACCT Numeric 6 AC105 AC110
Exp Acct AC120 AC58.1
AEA-EXP-SUB-ACCT Numeric 4 AC105 AC110
Depr Expense The general ledger distribution AC120 AC58.1
Subaccount subaccount number.
AEA-EXP-DEFAULT-FL Alpha 1 AC105 AC110
Exp Default Fl A = Activity Company Account Unit AC120 AC58.1
E = Employee Comp Accounting Unit
ACEMPEXPX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEASET1 ACTIVITY-GRP AC105 AC110
ACTIVITY AC120 AC258
ACCT-CATEGORY AC300 AC550
EXPENSE-CODE AC58.1
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 AC58.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
|
